postgresql recovery (PANIC: btree_split_redo: lost left sibling)

From: "Sipos Ferenc" <sipos(dot)ferenc(at)telefor(dot)hu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: postgresql recovery (PANIC: btree_split_redo: lost left sibling)
Date: 2007-05-31 16:14:05
Message-ID: 0E1D39D78C8CE14A96A6B6EF2192E463D3046D@telefor-server.int.telefor-new.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I have a problem with postgresql recovery. I want to make a test
recovery from our production server to a test machine. On the production
server runs PostgreSQL 8.0.3. On the test machine the PostgreSQL version
is 8.0.4 (installed from binary rpm).
I issued pg_start_backup and make a file system backup and issued
pg_stop_backup. I unpacked the file system backup to the test machine I
copied the new WAL logs to a directory. When I want to start the server
on the test machine I got an error: PANIC: btree_split_redo: lost left
sibling
This is the full log:
2007-05-31 17:53:49 CEST () (15606): LOG: database system was
interrupted at 2007-05-31 12:35:04 CEST
2007-05-31 17:53:49 CEST () (15606): LOG: starting archive recovery
2007-05-31 17:53:49 CEST () (15606): LOG: restore_command = "cp
/var/lib/pgsql/old_wal_logs/%f "%p""
2007-05-31 17:53:49 CEST () (15606): LOG: recovery_target_timeline =
latest
cp: cannot stat `/var/lib/pgsql/old_wal_logs/00000002.history': No such
file or directory
cp: cannot stat `/var/lib/pgsql/old_wal_logs/00000001.history': No such
file or directory
2007-05-31 17:53:49 CEST () (15606): LOG: restored log file
"0000000100000041000000A1.00CD7CF0.backup" from archive
2007-05-31 17:53:49 CEST () (15606): LOG: restored log file
"0000000100000041000000A1" from archive
2007-05-31 17:53:49 CEST () (15606): LOG: checkpoint record is at
41/A1CEA2BC
2007-05-31 17:53:49 CEST () (15606): LOG: redo record is at
41/A1CD7CF0; undo record is at 0/0; shutdown FALSE
2007-05-31 17:53:49 CEST () (15606): LOG: next transaction ID:
598101301; next OID: 22784393
2007-05-31 17:53:49 CEST () (15606): LOG: automatic recovery in
progress
2007-05-31 17:53:49 CEST () (15606): LOG: redo starts at 41/A1CD7CF0
2007-05-31 17:55:08 CEST () (15606): PANIC: btree_split_redo: lost left
sibling
2007-05-31 17:55:08 CEST () (15603): LOG: startup process (PID 15606)
was terminated by signal 6
2007-05-31 17:55:08 CEST () (15603): LOG: aborting startup due to
startup process failure
2007-05-31 17:55:09 CEST () (15605): LOG: logger shutting down

I try to made a test recovery following the instructions I read on this
page: http://www.postgresql.org/docs/8.0/interactive/backup-online.html
How can I start the server?

Thank you your help.

Best Regards,
Ferenc Sipos

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jim Nasby 2007-05-31 16:14:22 Deletes hurt
Previous Message Tom Lane 2007-05-31 15:44:30 Re: Fwd: Out of Memory on Reindex