Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group