BUG #6736: Hot-standby replica crashed after failover:
От | maxim.boguk@gmail.com |
---|---|
Тема | BUG #6736: Hot-standby replica crashed after failover: |
Дата | |
Msg-id | E1Spg51-0005q3-CO@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #6736: Hot-standby replica crashed after failover:
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 6736 Logged by: Maksym Boguk Email address: maxim.boguk@gmail.com PostgreSQL version: 9.0.4 Operating system: FreeBSD Description:=20=20=20=20=20=20=20=20 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:=20 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:=20 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@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@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@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=20 already? PS: update to 9.0.8 planned on next week.
В списке pgsql-bugs по дате отправления: