Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby - Mailing list pgsql-bugs

From Mark Kirkwood
Subject Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby
Date
Msg-id 4CC9E12E.30904@catalyst.net.nz
Whole thread Raw
In response to Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 29/10/10 04:32, Alvaro Herrera wrote:
> Excerpts from Mark Kirkwood's message of jue oct 28 02:20:56 -0300 2010:
>
>> I'm guessing the index error is due to the uninitialized table pages
>> (the index "content_node_node_type_id_inserted_idx" is on the "node"
>> table).
>>
> Not necessarily ... You still have the index in that state, right?
> We could try some diagnostics on it.
>
>
>

Doing some more digging - there was an out of memory incident on the
master the previous day, so I guess both of these observations could
well be caused by leftover partially completed operations.

Mark

pgsql-bugs by date:

Previous
From: Alexia Lau
Date:
Subject: Re: BUG
Next
From: Tom Lane
Date:
Subject: Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby