pg 8.4 crashing. - Mailing list pgsql-general

From Scott Marlowe
Subject pg 8.4 crashing.
Date
Msg-id AANLkTimMYwVjRO+y3i824N1LYtZpZ=+DQUs4YfVWZF88@mail.gmail.com
Whole thread Raw
Responses Re: pg 8.4 crashing.  (Merlin Moncure <mmoncure@gmail.com>)
Re: pg 8.4 crashing.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I've got a problem with pg 8.4.4 crashing with a sig 6 abort due to a
panic on failing to add a right sibling in an index.  Log output:

PANIC:  failed to add item to the right sibling in index "logged_in_uid"
STATEMENT:  INSERT INTO logged_in ...

Now, the column that's failing here is a serial that isn't referenced
in the SQL statement, i.e. it gets the default nextval.

OS: Ubuntu 8.04,
Pg: 8.4.4  The only arg to ./configure was to change the prefix dir to ~/pg84

I've had this problem before, but didn't have the time to track it
down.  Now I do, and it's on a server I can play on a bit if I need
to.

--
To understand recursion, one must first understand recursion.

pgsql-general by date:

Previous
From: Jan Otto
Date:
Subject: Re: update from 9.0rc1 to 9.0
Next
From: Andrew Hunter
Date:
Subject: Re: Visualize GiST Index