Gentoo Postgres V 7.4.3 Freshly recompiled postgres and compiler Thanks
Andrew ----- Original Message ----- From: Bruce Momjian <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] | (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