Re: ERROR: left link changed unexpectedly

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