Re: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)
Дата
Msg-id 9840.981592891@sss.pgh.pa.us
обсуждение исходный текст
Ответ на FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)  ("Michael Miyabara-McCaskey" <mykarz@miyabara.com>)
Ответы RE: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)
Список pgsql-admin
Дерево обсуждения 
"Michael Miyabara-McCaskey" <mykarz@miyabara.com> writes:
> FATAL 1:  btree: items are out of order (leftmost 0, stack 48, update 2)

This appears to indicate that you've got a corrupted index, possibly due
to carelessness about starting the postmaster always in the same locale
(see past discussions about effects of locale on index sort order).

If you can determine which index is broken, dropping and rebuilding it
should get you out of trouble.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Yasuo Ohgaki"
Дата:
Сообщение: Re: Create index problem ( _bt_sort )
Следующее
От: "Michael Miyabara-McCaskey"
Дата:
Сообщение: RE: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)