Re: Fwd: index corruption in PG 8.3.13 - Mailing list pgsql-hackers

From Nikhil Sontakke
Subject Re: Fwd: index corruption in PG 8.3.13
Date
Msg-id AANLkTikEkMxO6XSVc9j8=E3JWhU=FCDtJwWeruOwhhDd@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: index corruption in PG 8.3.13  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Fwd: index corruption in PG 8.3.13
Re: Fwd: index corruption in PG 8.3.13
List pgsql-hackers
>> Re-sending without the attachments. Can someone please allow my
>> attachments through from the previous email?
>
> They are not in the moderation queue, so presumably they got eaten by
> the antispam grue.

Ouch. Attempting to attach the dotty image again..

>
>
>> Blocks 519 to 521 are DELETED. They do not have the LEAF flag set,
>> meaning they could be internal pages, but that is strange since ROOT
>> page is at level 1. Also importantly their next XID is set FrozenXid,
>> meaning VACUUM FULL was at play. Maybe due to deletes, we reduced the
>> hierarchy level or something?
>
> Hierarchy level is never reduced.
>
> I'll send you a perl program we wrote for a customer to check for
> strange issues in btrees.  Please give it a spin; it may give you more
> clues.  If you find additional checks to add, please let me know!
>

Ok, thanks a lot!

Regards,
Nikhils

Attachment

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Sync Rep and shutdown Re: Sync Rep v19
Next
From: Alvaro Herrera
Date:
Subject: Re: Fwd: index corruption in PG 8.3.13