Skip site navigation (1) Skip section navigation (2)

PANIC: right sibling's left-link doesn't match

From: Henry <henry(at)zen(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: PANIC: right sibling's left-link doesn't match
Date: 2009-04-30 10:03:21
Message-ID: 20090430120321.10987187ljoeuv8k@zenmail.co.za (view raw or flat)
Thread:
Lists: pgsql-general
Greets,

I've recently completed a lengthy repartitioning exercise on half a  
dozen tables, restoring data, etc.

Something strange must have happened at some point (unrelated to the  
partitioning exercise - a crash related to file descriptors if I  
recall [not Pg's fault, mine]), because when I tried to modify a  
parent table (which is partitioned):

ALTER TABLE tab ADD COLUMN col INT DEFAULT 0;

I get:

PANIC:  right sibling's left-link doesn't match: block 35 links to 227  
instead of expected 223 in index "pg_depend_depender_index"
server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.

-----

I also had some 'damage' in another partitioned table, which I  
resolved with REINDEX TABLE on all the partitions (it failed on INSERT  
with an error about block 0 read problem or something).

I then restarted Pg in single-user mode and reindexed all the system tables.

The aforementioned ALTER TABLE now completes without error.  My  
question is:  can I trust the state/stability of the DB now, or should  
I dump, re-initdb and restore from scratch?  Only problem is the DB is  
large and takes 24*n hours to restore, so this is a last resort.

Thanks
Henry

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

pgsql-general by date

Next:From: Grzegorz BuśDate: 2009-04-30 11:57:12
Subject: could not bind IPv4 socket
Previous:From: Dimitri FontaineDate: 2009-04-30 10:03:10
Subject: Re: triggers and execute...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group