Re: PANIC: right sibling 2019 of block 2018 is not next child of 1937 in index "sl_log_2_idx1" - Mailing list pgsql-general

From John R Pierce
Subject Re: PANIC: right sibling 2019 of block 2018 is not next child of 1937 in index "sl_log_2_idx1"
Date
Msg-id 4B3BF8ED.3090309@hogranch.com
Whole thread Raw
In response to Re: PANIC: right sibling 2019 of block 2018 is not next child of 1937 in index "sl_log_2_idx1"  (Jeff Amiel <becauseimjeff@yahoo.com>)
Responses Re: PANIC: right sibling 2019 of block 2018 is not next child of 1937 in index "sl_log_2_idx1"  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Jeff Amiel wrote:
> --- On Wed, 12/30/09, Jeff Amiel <becauseimjeff@yahoo.com> wrote:
>
>> Subject: PANIC:  right sibling 2019 of block 2018 is not next child of 1937 in index "sl_log_2_idx1"
>>
>
>
> I am assuming a re-index for that particular index will rebuild/fix the index (if it happens again).  Any other
thoughts? 
>
>

It appears you have at least one corrupt block.   Where there's one,
there's often more.

I think i'd do a reindex all.   and Imight even do a pg_dumpall,
re-initdb, and restore said dumpall to be safeest.   to be really safe,
stop pg, and take a file system backup first, incase more serious
problems show up during the reindex or dump process

pgsql-general by date:

Previous
From: Dmitry Koterov
Date:
Subject: Visual DATA editor for PostgreSQL?
Next
From: Greg Smith
Date:
Subject: Re: PANIC: right sibling 2019 of block 2018 is not next child of 1937 in index "sl_log_2_idx1"