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

From: Jie Liang <jliang(at)ipinc(dot)com>
To: Michael Miyabara-McCaskey <mykarz(at)miyabara(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [SQL] FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)
Date: 2001-02-07 23:52:50
Message-ID: Pine.BSF.4.10.10102071548390.17745-100000@tidal.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.ipinc.com

On Wed, 7 Feb 2001, Michael Miyabara-McCaskey wrote:
*************************
if it occurs everytime you run the uc, then you 'd better check your
script or run it in debug mode to figure out the problem.

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

**************************
following message seems to me that your postgres master dead!

> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
>
>
> Anyone have any ideas?
>
> I was running a script that calls "uc" from Perl... It runs for a while then
> I get this error.
>
> PGSQL 7.0.3, Linux RH 6.2 (2.2.17-RAID), 1GB MEM (gets to about 300MB of RAM
> used then dies).
>
> Michael Miyabara-McCaskey
> Email: mykarz(at)miyabara(dot)com
> Web: http://www.miyabara.com/mykarz/
> Mobile: +1 408 504 9014
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Yasuo Ohgaki 2001-02-08 00:25:22 Re: Create index problem ( _bt_sort )
Previous Message Michael Miyabara-McCaskey 2001-02-07 22:41:41 FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-02-08 00:41:31 Re: FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)
Previous Message Michael Miyabara-McCaskey 2001-02-07 22:41:41 FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)