Replication terminated due to PANIC

From: Adarsh Sharma <eddy(dot)adarsh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Replication terminated due to PANIC
Date: 2013-04-25 00:05:08
Message-ID: CAGx-QqJx0eNZRGqb3-6W23kH8T-xZ+zLp20c9MUY5vkMOT9Kxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

I checked in global directory of master, the directory 14078 doesn't exist.

Anyone has faced above issue ?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Hammers 2013-04-25 00:07:26 Re: custom session variables?
Previous Message Darren Duncan 2013-04-24 23:17:58 custom session variables?