On Wed, Apr 24, 2013 at 5:05 PM, Adarsh Sharma <eddy.adarsh@xxxxxxxxx> wrote: > 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 :- I am not sure that it is your situation but take a look at this thread: http://www.postgresql.org/message-id/CAL_0b1t=WuM6roO8dki=w8DhH8P8whhohbPjReymmQUrOcNT2A@xxxxxxxxxxxxxx There is a patch by Andres Freund in the end of the discussion. Three weeks have passed after I installed the patched version and it looks like the patch fixed my issue. > > 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 -- Kind regards, Sergey Konoplev Database and Software Consultant Profile: http://www.linkedin.com/in/grayhemp Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979 Skype: gray-hemp Jabber: gray.ru@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
