On Thu, Sep 23, 2010 at 2:17 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Scott Marlowe <scott.marl...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
