Re: pg 8.4 crashing.

On Thu, Sep 23, 2010 at 2:17 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Scott Marlowe <scott.marlowe@gmail.com> writes:
>> 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 ...
>
> If you can apply this patch:
> http://archives.postgresql.org/pgsql-committers/2010-08/msg00365.php
> it should tell you which index page is causing the problem.  Then
> please dump that page with pg_filedump and send it in.

Patch applied.  This crash happens on average about once a day.
Happened twice yesterday, but hasn't happened today.  I'll report back
when / if it does it again.

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