Re: ERROR: left link changed unexpectedly - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: ERROR: left link changed unexpectedly
Date
Msg-id 4161E5A5.6070508@bigfoot.com
Whole thread Raw
In response to Re: ERROR: left link changed unexpectedly  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Alvaro Herrera wrote:
> On Tue, Oct 05, 2004 at 12:08:26AM +0200, Gaetano Mendola wrote:
> 
>>Anyone interested ?
> 
> 
> I saw the code involved, and I think the only way this can happen is if
> the index file itself was corrupted by previous operation.  How could
> that happen elludes me; maybe a previous VACUUM changed a sibling's side
> pointer but not the page itself's.  This is hard to believe however.
> Maybe a partial write of some kind; but WAL should save whole-page
> snapshots of the four pages involved, so I don't think the corruption
> would survive WAL replay (that part of the code I didn't read however).
> 
> Not sure what to do about it.  I assume that if you reindex, the problem
> disappears and you can't reproduce it again?  In any case, please save a
> copy of the corrupted index file(s).  Would you send it to me?
> 

If you need the file for the index exp_card then I'm going to send you
the file.



Regards
Gaetano Mendola


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: -HEAD build failure on OpenBSD 3.6-current/Sparc64 +patch
Next
From: David Garamond
Date:
Subject: pg_dump and blobs