Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby
Date: 2010-10-28 20:46:38
Message-ID: 4CC9E12E.30904@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-10-28 21:27:47 Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby
Previous Message Alexia Lau 2010-10-28 16:13:34 Re: BUG