Postgres Pro
Downloads
Home   >   mailing lists

Re: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2) - Mailing list pgsql-admin

From Tom Lane
Subject Re: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)
Date
Msg-id 9840.981592891@sss.pgh.pa.us
Whole thread Raw
In response to FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)  ("Michael Miyabara-McCaskey" <mykarz@miyabara.com>)
Responses RE: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)  ("Michael Miyabara-McCaskey" <mykarz@miyabara.com>)
List pgsql-admin
Tree view 
"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 by date:

Previous
From: "Yasuo Ohgaki"
Date:
Subject: Re: Create index problem ( _bt_sort )
Next
From: "Michael Miyabara-McCaskey"
Date:
Subject: RE: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)