Обсуждение: postgresql recovery (PANIC: btree_split_redo: lost left sibling)
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
You may want to give the latest version of 8.0 a try 8.0.13. Ken On Thu, May 31, 2007 at 06:14:05PM +0200, Sipos Ferenc wrote: > 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).
Hello, Thank you very much, its solved my problem. :) From log file: [...] 2007-05-31 19:39:49 CEST () (29313): LOG: redo done at 41/B0FFDB68 2007-05-31 19:39:49 CEST () (29313): LOG: restored log file "0000000100000041000000B0" from archive 2007-05-31 19:39:49 CEST () (29313): LOG: archive recovery complete 2007-05-31 19:39:57 CEST () (29313): LOG: database system is ready Best Regards, Ferenc Sipos -----Original Message----- From: Kenneth Marshall [mailto:ktm@rice.edu] Sent: Thursday, May 31, 2007 7:19 PM To: Sipos Ferenc Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] postgresql recovery (PANIC: btree_split_redo: lost left sibling) You may want to give the latest version of 8.0 a try 8.0.13. Ken On Thu, May 31, 2007 at 06:14:05PM +0200, Sipos Ferenc wrote: > 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).
"Sipos Ferenc" <sipos.ferenc@telefor.hu> writes:
> 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 a known bug repaired in 8.0.8 and up.
regards, tom lane