On Wed, 16 Mar 2005 16:05:16 -0500, Alex Turner <armtuk@gmail.com> wrote:
> Ok - I found the log messages:
>
> ERROR: duplicate key violates unique constraint "features_pkey"
> STATEMENT: insert into features
> (propid,dtmodified,proptype,groupid,featid,group_desc,feat_desc)
> values (449356005,'3/9/2005 12:03:59 AM',1,26,1,'Water','PublicWater')
> PANIC: right sibling's left-link doesn't match
See
http://groups-beta.google.com/group/comp.databases.postgresql.hackers/browse_thread/thread/115e69a0e5a66bb5/ed3bf8b7de3a6cc0?q=%22right+sibling%27s+left-link+doesn%27t+match%22#ed3bf8b7de3a6cc0
In short, you need to drop and rebuild the index to address that
error. But this assumes that you've already successfully run
xfs_repair on the filesystem. If your FS is hosed, all the recovery
in the world isn't going to help the DB.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org
