PANIC: could not locate a valid checkpoint record

From: "Elton Borssoi" <eltonbor(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: PANIC: could not locate a valid checkpoint record
Date: 2007-06-04 21:28:38
Message-ID: 79fd95aa0706041428k108421cane949c4a3a7e6630a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Fellows, Im installing a system with High Availability using Postgres and
making some tests.

I have one machine running 2 postgres one in 5432 and other in 6543 with
everything apart.

The test I made and got this message (PANIC: could not locate a valid
checkpoint record) is

1) everything is stoped
2) start pg1
3) restore dump on pg1
4) stop pg1
5) configure pg1 for archiving on /home/postgres/archives
4) copy data dir to pg2
5) start pg1 and create some tables to generate data volume
6) configure pg2 for recovery mode coping from /home/postgres/archives
7) start pg2 (this start is fine, everything was recovered)
8) stop pg2
9) generate more data on pg1 (there are more 2 or 3 archives file)
10) start pg2 on recovery mode again and got this message
PANIC: could not locate a valid checkpoint record

I try many config combinations and always got this error.

Is there anyone who could help-me???

some logs to help

FIRST RESTORE
[postgres(at)localhost ~]$ /usr/local/recovery_pgsql/bin/postgres -D
/usr/local/recovery_pgsql/data
LOG: database system was shut down at 2007-06-04 16:50:59 EDT
LOG: starting archive recovery
LOG: restore_command = "cp /home/postgres/archives/%f %p"
cp: cannot stat `/home/postgres/archives/00000001.history': No such file or
directory
LOG: restored log file "000000010000000000000005" from archive
LOG: checkpoint record is at 0/59D38E0
LOG: redo record is at 0/59D38E0; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/1341; next OID: 17045
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: automatic recovery in progress
LOG: redo starts at 0/59D3928
LOG: restored log file "000000010000000000000006" from archive
LOG: restored log file "000000010000000000000007" from archive
cp: cannot stat `/home/postgres/archives/000000010000000000000008': No such
file or directory
LOG: unexpected pageaddr 0/1000000 in log file 0, segment 8, offset 0
LOG: redo done at 0/7FFFE50
LOG: restored log file "000000010000000000000007" from archive
LOG: archive recovery complete
LOG: database system is ready
LOG: received smart shutdown request
LOG: shutting down
LOG: database system is shut down

SECOND RESTORE
[postgres(at)localhost ~]$ /usr/local/recovery_pgsql/bin/postgres -D
/usr/local/recovery_pgsql/data
LOG: database system was shut down at 2007-06-04 17:07:45 EDT
LOG: starting archive recovery
LOG: restore_command = "cp /home/postgres/archives/%f %p"
cp: cannot stat `/home/postgres/archives/00000001.history': No such file or
directory
LOG: restored log file "000000010000000000000008" from archive
LOG: contrecord is requested by 0/8000020
LOG: invalid primary checkpoint record
LOG: restored log file "000000010000000000000007" from archive
LOG: invalid record length at 0/7FFFFB4
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 30004) was terminated by signal 6
LOG: aborting startup due to startup process failure

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-06-05 01:30:54 Re: PANIC: could not locate a valid checkpoint record
Previous Message Magnus Hagander 2007-06-04 18:46:56 Re: BUG #3343: Passwords not working