Re: [GENERAL] PANIC: btree_split_redo: lost left sibling?

[Gavin M. Roy]

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 <[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
 


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org