Skip site navigation (1) Skip section navigation (2)

BUG #6736: Hot-standby replica crashed after failover:

From: maxim(dot)boguk(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6736: Hot-standby replica crashed after failover:
Date: 2012-07-13 13:38:47
Message-ID: E1Spg51-0005q3-CO@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6736
Logged by:          Maksym Boguk
Email address:      maxim(dot)boguk(at)gmail(dot)com
PostgreSQL version: 9.0.4
Operating system:   FreeBSD
Description:        

Hi,

May be it was fixed in more recent releases, but I can not find related
things in release notices.

The next sequence leads to the standby crash after failover:

1)stop master (wait untill full stop)
2)initiate failover
hot-standby crashed during failover,
however successfully started after manual start (and seems work without any
future errors).

In hot-standby logs:
2012-07-13 17:06:08.199 MSK 58208 @ from  [vxid: txid:0] []FATAL: 
replication terminated by primary server
2012-07-13 17:06:08.788 MSK 67891 @ from  [vxid: txid:0] []FATAL:  could not
connect to the primary server: server closed the connection unexpectedly
2012-07-13 17:06:19.521 MSK 67912 @ from  [vxid: txid:0] []FATAL: 
terminating walreceiver process due to administrator command
2012-07-13 17:06:19.732 MSK 79724 @ from  [vxid:1/0 txid:0] []WARNING:  page
2026 of relation base/14482918/32905335 was uninitialized
2012-07-13 17:06:19.732 MSK 79724 @ from  [vxid:1/0 txid:0] []WARNING:  page
7327 of relation base/14482918/32905343 was uninitialized
2012-07-13 17:06:19.732 MSK 79724 @ from  [vxid:1/0 txid:0] []WARNING:  page
7299 of relation base/14482918/32905343 was uninitialized
2012-07-13 17:06:19.732 MSK 79724 @ from  [vxid:1/0 txid:0] []WARNING:  page
2040 of relation base/14482918/32905335 was uninitialized
2012-07-13 17:06:19.732 MSK 79724 @ from  [vxid:1/0 txid:0] []WARNING:  page
1761 of relation base/16424/33266809 was uninitialized
2012-07-13 17:06:19.732 MSK 79724 @ from  [vxid:1/0 txid:0] []WARNING:  page
1750 of relation base/16424/33266809 was uninitialized
2012-07-13 17:06:19.732 MSK 79724 @ from  [vxid:1/0 txid:0] []PANIC:  WAL
contains references to invalid pages
2012-07-13 17:06:19.895 MSK 67435 pgsql(at)pgsql from [local] [vxid:2/0 txid:0]
[]WARNING:  terminating connection because of crash of another server
process
2012-07-13 17:06:19.895 MSK 67435 pgsql(at)pgsql from [local] [vxid:2/0 txid:0]
[]DETAIL:  The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
2012-07-13 17:06:19.895 MSK 67435 pgsql(at)pgsql from [local] [vxid:2/0 txid:0]
[]HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
2012-07-13 17:07:27.072 MSK 68607 @ from  [vxid: txid:0] []HINT:  If this
has occurred more than once some data might be corrupted and you might need
to choose an earlier recovery target.


Is that something which was fixed 
already?

PS: update to 9.0.8 planned on next week.




Responses

pgsql-bugs by date

Next:From: Daniele VarrazzoDate: 2012-07-13 14:52:59
Subject: Re: BUG #6734: create table (like ...) fails if an index has a comment
Previous:From: Ryan KellyDate: 2012-07-13 13:24:19
Subject: Re: BUG #6734: create table (like ...) fails if an index has a comment

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group