| From: | Lonni J Friedman <netllama(at)gmail(dot)com> |
|---|---|
| To: | Alex Turner <armtuk(at)gmail(dot)com> |
| Cc: | PgSQL General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Data Recovery |
| Date: | 2005-03-16 21:10:59 |
| Message-ID: | 7c1574a9050316131035857d4e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 16 Mar 2005 16:05:16 -0500, Alex Turner <armtuk(at)gmail(dot)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(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Turner | 2005-03-16 21:15:20 | Re: Data Recovery |
| Previous Message | Lonni J Friedman | 2005-03-16 21:05:37 | Re: Data Recovery |