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