From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Alexander Kukushkin <cyberdemn(at)gmail(dot)com> |
Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15346: Replica fails to start after the crash |
Date: | 2018-08-22 15:08:38 |
Message-ID: | 20180822150838.ffdszn4wz57owd3c@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
On 2018-Aug-22, Alexander Kukushkin wrote:
> 2018-08-22 16:44 GMT+02:00 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>:
>
> >
> > Sounds likely. I suggest to have a look at what's going on inside the
> > postmaster process when it gets stuck.
>
> Well, it doesn't get stuck, it aborts start with the message:
> 2018-08-22 14:26:42.073 UTC,,,28485,,5b7d7282.6f45,23,,2018-08-22
> 14:26:10 UTC,1/0,0,WARNING,01000,"page 179503104 of relation
> base/18055/212875 does not exist",,,,,"xlog redo at AB3/50323E78 for
> Btree/DELETE: 182 items",,,,""
> 2018-08-22 14:26:42.073 UTC,,,28485,,5b7d7282.6f45,24,,2018-08-22
> 14:26:10 UTC,1/0,0,PANIC,XX000,"WAL contains references to invalid
> pages",,,,,"xlog redo at AB3/50323E78 for Btree/DELETE: 182
> items",,,,""
> 2018-08-22 14:26:42.214 UTC,,,28483,,5b7d7282.6f43,3,,2018-08-22
> 14:26:10 UTC,,0,LOG,00000,"startup process (PID 28485) was terminated
> by signal 6: Aborted",,,,,,,,,""
Oh, that's weird ... sounds like the fact that the bgworker starts
somehow manages to corrupt the list of invalid pages in the startup
process. That doesn't make any sense ...
ENOTIME for a closer look ATM, though, sorry. Maybe you could try
running under valgrind?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Dolgov | 2018-08-22 15:42:16 | Re: BUG #15346: Replica fails to start after the crash |
Previous Message | PG Bug reporting form | 2018-08-22 15:08:09 | BUG #15347: Unaccent for greek characters does not work |
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Dolgov | 2018-08-22 15:42:16 | Re: BUG #15346: Replica fails to start after the crash |
Previous Message | Alexander Kukushkin | 2018-08-22 15:01:56 | Re: BUG #15346: Replica fails to start after the crash |