| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | mykarz(at)miyabara(dot)com |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2) |
| Date: | 2001-02-08 00:41:31 |
| Message-ID: | 9840.981592891@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
"Michael Miyabara-McCaskey" <mykarz(at)miyabara(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Miyabara-McCaskey | 2001-02-08 06:22:17 | RE: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2) |
| Previous Message | Yasuo Ohgaki | 2001-02-08 00:25:22 | Re: Create index problem ( _bt_sort ) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-02-08 03:15:02 | PL/pgsql EXECUTE 'SELECT INTO ...' |
| Previous Message | Jie Liang | 2001-02-07 23:52:50 | Re: [SQL] FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2) |