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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Daniele Varrazzo | 2012-07-13 14:52:59 | Re: BUG #6734: create table (like ...) fails if an index has a comment |
Previous Message | Ryan Kelly | 2012-07-13 13:24:19 | Re: BUG #6734: create table (like ...) fails if an index has a comment |