Re: PANIC: btree_split_redo: lost left sibling?

Gentoo
Postgres V 7.4.3
Freshly recompiled postgres and compiler

Thanks

Andrew

----- Original Message -----
From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square,
> Pennsylvania 19073
>