On Wed, 16 Mar 2005 16:05:16 -0500, Alex Turner <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
