On Fri, Sep 24, 2010 at 5:06 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Thu, Sep 23, 2010 at 8:57 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: >> On Thu, Sep 23, 2010 at 2:17 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >>> Scott Marlowe <scott.marlowe@xxxxxxxxx> 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. > > OK, got an error on it today. Looks like a corrupted index. Note > that this is on a machine that was very well tested, but who knows, a > single bit error could have occurred. pg_filedump attached. P.s. I reindexed it to get rid of the error. I'll keep an eye for it coming back. -- To understand recursion, one must first understand recursion. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
