Received: from neptune.he.net (neptune.he.net [216.218.166.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f186Lxx47426; Thu, 8 Feb 2001 01:21:59 -0500 (EST) (envelope-from mykarz@miyabara.com) Received: from ncc1701e (64-32-200-99.sfo3.phoenixdsl.net [64.32.200.99]) by neptune.he.net (8.8.6/8.8.2) with SMTP id WAA09781; Wed, 7 Feb 2001 22:21:47 -0800 Reply-To: From: "Michael Miyabara-McCaskey" To: "'Tom Lane'" Cc: , Subject: RE: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2) Date: Wed, 7 Feb 2001 22:22:17 -0800 Message-ID: <000201c09197$7ca12a40$c700a8c0@ncc1701e> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) In-reply-to: <9840.981592891@sss.pgh.pa.us> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200102/60 X-Sequence-Number: 660 Tom, Once again you are a lifesaver. Thank you. I ended up just dropping all the indexes on the table in question, and life is now good. -Michael > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Wednesday, February 07, 2001 4:42 PM > To: mykarz@miyabara.com > Cc: pgsql-sql@postgresql.org; pgsql-admin@postgresql.org > Subject: Re: [ADMIN] FATAL 1: btree: items are out of order > (leftmost 0, > stack 48, update 2) > > > "Michael Miyabara-McCaskey" 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 >