From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
Subject: | Re: ERROR: left link changed unexpectedly |
Date: | 2004-10-05 00:07:01 |
Message-ID: | 4161E5A5.6070508@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Edwin Grubbs | 2004-10-05 00:24:17 | Re: [HACKERS] OT moving from MS SQL to PostgreSQL |
Previous Message | Tom Lane | 2004-10-04 23:06:01 | Re: -HEAD build failure on OpenBSD 3.6-current/Sparc64 +patch |