On 2013-04-05 07:22:08 -0700, Sergey Konoplev wrote: > On Fri, Apr 5, 2013 at 7:15 AM, Andres Freund <and...@2ndquadrant.com> wrote: > > Cool. It would be very helpful if you could apply the patch and verify > > that it works, it has been written somewhat blindly. Also I am afraid > > that at least last time there was a second bug involved. > > Okay, I will try to talk to admins but I am afraid it could take long.
Ok. > > Could you show the log? > > 2013-04-05 17:26:31 MSK 2113 @ from [vxid: txid:0] [] LOG: database > system was shut down in recovery at 2013-04-05 17:18:02 MSK > 2013-04-05 17:26:32 MSK 2113 @ from [vxid: txid:0] [] LOG: entering > standby mode > 2013-04-05 17:26:32 MSK 2113 @ from [vxid:1/0 txid:0] [] LOG: redo > starts at 25BD/907338F8 > 2013-04-05 17:26:32 MSK 2113 @ from [vxid:1/0 txid:0] [] LOG: file > "pg_subtrans/28E5" doesn't exist, reading as zeroes Looks like it could be fixed by the patch. But that seems to imply that you restarted not long before that? Could you check if theres a different error before those? Greetings, Andres Freund PS: The tander.ru addresses seem to bounce all mail I send them... -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
