Re: PANIC: btree_split_redo: lost left sibling?

Note that I have had a few segfaults on gentoo, pg v7.4.3, amd64, kernel
2.6.5-gentoo-r1 as well.

Gavin

Andrew Sukow wrote:

>Gentoo
>Postgres V 7.4.3
>Freshly recompiled postgres and compiler
>
>Thanks
>
>Andrew
>
>----- Original Message -----
>From: Bruce Momjian <pgman@candle.pha.pa.us>
>Date: Tuesday, August 17, 2004 10:09 am
>Subject: Re: [GENERAL] PANIC: btree_split_redo: lost left sibling?
>
>
>
>>Please provide a PostgreSQL version and operating system information.
>>
>>-------------------------------------------------------------------
>>--------
>>
>>Andrew Sukow wrote:
>>
>>
>>>Greetings,
>>>
>>>Our postgres system crashed and upon restarting it our database
>>>
>>>
>>had the following errors.  The error log was 4.5 gigs which is
>>much larger than usual.  We looked online for information about
>>lost left siblings and how to fix the data and not lose the 400
>>million records we have.  Anyone have an idea what's the matter
>>and what the fix is?
>>
>>
>>>LOG:  database system was interrupted while in recovery at 2004-
>>>
>>>
>>08-17 08:59:41 PDT
>>
>>
>>>HINT:  This probably means that some data is corrupted and you
>>>
>>>
>>will have to use the last backup for recovery.
>>
>>
>>>LOG:  checkpoint record is at 326/C007B778
>>>LOG:  redo record is at 326/BD899570; undo record is at 0/0;
>>>
>>>
>>shutdown FALSE
>>
>>
>>>LOG:  next transaction ID: 46922114; next OID: 133662911
>>>LOG:  database system was not properly shut down; automatic
>>>
>>>
>>recovery in progress
>>
>>
>>>LOG:  redo starts at 326/BD899570
>>>PANIC:  btree_split_redo: lost left sibling
>>>LOG:  startup process (PID 9038) was terminated by signal 6
>>>LOG:  aborting startup due to startup process failure
>>>
>>>Thanks,
>>>
>>>Andrew
>>>
>>>
>>>
>>>---------------------------(end of broadcast)--------------------
>>>
>>>
>>-------
>>
>>
>>>TIP 4: Don't 'kill -9' the postmaster
>>>
>>>
>>>
>>--
>> Bruce Momjian                        |  http://candle.pha.pa.us
>> pgman@candle.pha.pa.us               |  (610) 359-1001
>> +  If your life is a hard drive,     |  13 Roberts Road
>> +  Christ can be your backup.        |  Newtown Square,
>>Pennsylvania 19073
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>