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

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby
Дата
Msg-id 4CC9E12E.30904@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby
Список 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 по дате отправления:

Предыдущее
От: Alexia Lau
Дата:
Сообщение: Re: BUG
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby