Re: pg 8.4 crashing.

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg 8.4 crashing.
Date: 2010-09-23 19:19:57
Message-ID: AANLkTikRCWzAx7gedHnScirnY3mqE0tx0MF3=pDXyOO0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 23, 2010 at 2:28 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> 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.

Hm, is this repeatable? Have you ruled out corruption?

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2010-09-23 19:40:37 Re: Index on points
Previous Message Andrew Hunter 2010-09-23 18:30:06 Re: Visualize GiST Index