Replication terminated due to PANIC
| От | Adarsh Sharma |
|---|---|
| Тема | Replication terminated due to PANIC |
| Дата | |
| Msg-id | CAGx-QqJx0eNZRGqb3-6W23kH8T-xZ+zLp20c9MUY5vkMOT9Kxw@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Replication terminated due to PANIC
|
| Список | pgsql-general |
Hi all,
I have a Postgresql 9.2 instance running on a CentOS6.3 box.Yesterday i setup a hot standby by using pgbasebackup. Today i got the below alert from standby box :[1] (from line 412,723) 2013-04-24 23:07:18 UTC [13445]: [6-1] user= db= host= PANIC: _bt_restore_page: cannot add item to page
When i check, the replication is terminated due to slave DB shutdown. From the logs i can see below messages :-
2013-04-24 23:17:16 UTC [26989]: [5360083-1] user= db= host= ERROR: could not open file "global/14078": No such file or directory
2013-04-24 23:17:16 UTC [26989]: [5360084-1] user= db= host= CONTEXT: writing block 0 of relation global/14078
2013-04-24 23:17:16 UTC [26989]: [5360085-1] user= db= host= WARNING: could not write block 0 of global/14078
2013-04-24 23:17:16 UTC [26989]: [5360086-1] user= db= host= DETAIL: Multiple failures --- write error might be permanent.
2013-04-24 23:17:16 UTC [26989]: [5360083-1] user= db= host= ERROR: could not open file "global/14078": No such file or directory
2013-04-24 23:17:16 UTC [26989]: [5360084-1] user= db= host= CONTEXT: writing block 0 of relation global/14078
2013-04-24 23:17:16 UTC [26989]: [5360085-1] user= db= host= WARNING: could not write block 0 of global/14078
2013-04-24 23:17:16 UTC [26989]: [5360086-1] user= db= host= DETAIL: Multiple failures --- write error might be permanent.
I checked in global directory of master, the directory 14078 doesn't exist.
Anyone has faced above issue ?В списке pgsql-general по дате отправления: