Search Postgresql Archives

Re: pg 8.4 crashing.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux