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

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

pgsql-bugs by date

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

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