From: Chavdar Kopoev <chavdar@kopoev.com>
To: pgsql-admin@postgresql.org
Subject: PANIC: heap_update_redo: invalid lp
Date: Mon, 07 Feb 2011 20:54:55 +0200
Message-ID: <4D503FFF.3080704@kopoev.com> (raw)
Hello,
My production database cannot start:
* Starting PostgreSQL 8.4 database server
* The PostgreSQL server failed to start. Please check the log output.
Log file as follow:
2011-02-07 19:39:52 EET 891LOG: database system was interrupted while
in recovery at 2011-02-07 19:33:25 EET
2011-02-07 19:39:52 EET 891HINT: This probably means that some data
is corrupted and you will have to use the last backup for recovery.
2011-02-07 19:39:52 EET 891LOG: database system was not properly shut
down; automatic recovery in progress
2011-02-07 19:39:52 EET 891LOG: redo starts at 88/37705758
2011-02-07 19:39:52 EET [unknown] [unknown][local] 892LOG: incomplete
startup packet
2011-02-07 19:39:52 EET 891PANIC: heap_update_redo: invalid lp
2011-02-07 19:39:52 EET 891CONTEXT: xlog redo hot_update: rel
1663/16388/16677; tid 562/9; new 562/10
2011-02-07 19:39:52 EET 889LOG: startup process (PID 891) was
terminated by signal 6: Aborted
2011-02-07 19:39:52 EET 889LOG: aborting startup due to startup
process failure
My target are a few tables from the database to be restored. Other
information is not critical, can be restored from recent backup.
Any help with restoring the database will be very much appreciated.
Regards,
Chavdar Kopoev
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: chavdar@kopoev.com
Subject: Re: PANIC: heap_update_redo: invalid lp
In-Reply-To: <4D503FFF.3080704@kopoev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox