Postgresql process aborted on shutdown of filesystem holding the database

From: "Sangeeth Keeriyadath" <k(dot)sangeeth(at)in(dot)ibm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql process aborted on shutdown of filesystem holding the database
Date: 2018-05-23 10:39:15
Message-ID: OFEF1EBCED.E04E0CA6-ON00258296.00371605-00258296.003A86CC@notes.na.collabserv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div dir="ltr" >Hello,</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >I have the Postgresql 10.2 database running on AIX Operating System and the database is created and stored on a distributed file-system.</div>
<div dir="ltr" >There was a test operation which shuts down the file-system.</div>
<div dir="ltr" >Soon after that, a coredump (abort) of Postgresql process was seen with the following stack :</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" ><pre style="white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; white-space: pre-wrap; word-wrap: break-word;" >IOT/Abort trap in raise at 0x90000000290e2ac
0x90000000290e2ac (raise+0x6c) e8410028 ld r2,0x28(r1)
(dbx) t
raise(??) at 0x90000000290e2ac
abort() at 0x90000000292cc38
errfinish() at 0x10000b848
XLogWrite() at 0x1000d7170
XLogBackgroundFlush() at 0x1000e4aa4
WalWriterMain() at 0x100500fc8
AuxiliaryProcessMain() at 0x1004ce0ec
StartChildProcess() at 0x1000b7000
reaper() at 0x1000bbc6c
__fd_select(??, ??, ??, ??, ??) at 0x900000002a3400c
postmaster.do_start_bgworker.ServerLoop() at 0x1000b9220
PostmasterMain() at 0x1000bdb6c
main() at 0x1000006bc
(dbx)
</pre></div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >From what i understand from the stack/code it indicates that a possible failure to write to the file-system caused Postgresql process to abort itself.</div>
<div dir="ltr" >Could you please let me know if this kind of abort of Postgresql is expected when the file-system goes down ?</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >Or if i need to provide more information, let me know.</div>
<div dir="ltr" >Thanks for the help in advance!</div>
<div dir="ltr" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div dir="ltr" >&nbsp;</div>
<div dir="ltr" >Regards,<br>Sangeeth Keeriyadath</div></div></div></div></div></div><BR>

Attachment Content-Type Size
unknown_filename text/html 2.2 KB

Browse pgsql-general by date

  From Date Subject
Next Message Deepti Sharma S 2018-05-23 10:59:15 RE: [GENERAL] Postgre compatible version with RHEL 7.5
Previous Message Steven Winfield 2018-05-23 10:09:14 RE: Insert data if it is not existing