Re: [GENERAL] pg 8.4 crashing.

2010-09-25 Thread Tom Lane
Scott Marlowe writes: >> On Thu, Sep 23, 2010 at 2:17 PM, Tom Lane wrote: >>> 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

Re: [GENERAL] pg 8.4 crashing.

2010-09-24 Thread Scott Marlowe
On Fri, Sep 24, 2010 at 5:06 PM, Scott Marlowe wrote: > On Thu, Sep 23, 2010 at 8:57 PM, Scott Marlowe > wrote: >> On Thu, Sep 23, 2010 at 2:17 PM, Tom Lane wrote: >>> Scott Marlowe 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

Re: [GENERAL] pg 8.4 crashing.

2010-09-23 Thread Scott Marlowe
On Thu, Sep 23, 2010 at 2:17 PM, Tom Lane wrote: > Scott Marlowe 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" >> S

Re: [GENERAL] pg 8.4 crashing.

2010-09-23 Thread Tom Lane
Scott Marlowe 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 th

Re: [GENERAL] pg 8.4 crashing.

2010-09-23 Thread Merlin Moncure
On Thu, Sep 23, 2010 at 2:28 PM, Scott Marlowe 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 l

[GENERAL] pg 8.4 crashing.

2010-09-23 Thread Scott Marlowe
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 th