| From: | Adarsh Sharma <eddy(dot)adarsh(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Standby and replication terminated due to Server PANIC |
| Date: | 2013-04-25 00:00:53 |
| Message-ID: | CAGx-Qq+UCrr_xm2RX-iACatNydND=j8_rmUH9wu2=eAGRuUjEg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
I checked in global directory of master, the directory 14078 doesn't exist.
Anyone has faced below issue ?
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomaz Luiz Santos | 2013-04-25 14:21:41 | DBLink |
| Previous Message | David F. Skoll | 2013-04-24 15:34:16 | Re: Hot-standby and canceled queries |