Hello, We tried to replicate the scenario without our patch(exiting postmaster) and still we were able to see the issue.
Same error was seen this time as well. node-0 postgres[8243]: [1-2] HINT: Is another postmaster already running on port 5433? If not, wait a few seconds and retry. node-1 postgres[8650]: [18-1] PANIC: btree_xlog_delete_get_latestRemovedXid: cannot operate with inconsistent data Crash was not seen in 9.3.9 without the patch but it was reproduced in 9.3.11. So something specifically changed between 9.3.9 and 9.3.11 is causing the issue. Thanks in advance!!! Sandhya -----Original Message----- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, September 06, 2016 5:04 PM To: K S, Sandhya (Nokia - IN/Bangalore) <sandhya....@nokia.com> Cc: pgsql-hackers@postgresql.org; Itnal, Prakash (Nokia - IN/Bangalore) <prakash.it...@nokia.com> Subject: Re: [HACKERS] Postgres abort found in 9.3.11 "K S, Sandhya (Nokia - IN/Bangalore)" <sandhya....@nokia.com> writes: > I was able to find a patch file where there is a call to ExitPostmaster() in > postmaster.c . > @@ -3081,6 +3081,11 @@ > shmem_exit(1); > reset_shared(PostPortNumber); > + /* recovery termination */ > + ereport(FATAL, > + (errmsg("recovery termination due to process crash"))); > + ExitPostmaster(99); > + > StartupPID = StartupDataBase(); > Assert(StartupPID != 0); > pmState = PM_STARTUP; There's no such code in the community sources, and I can't say that such a patch looks like a bright idea to me. It would disable any restart after a crash (not only during recovery). If you're running a version with assorted random non-community patches, we can't really offer much support for that. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
