Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group