"failed to re-find parent key" question

From: "Roger Pan" <roger(dot)pan(at)nexustelecom(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: "failed to re-find parent key" question
Date: 2007-03-05 17:53:45
Message-ID: A0DDA6A336884346B764323F595452052D3522@nosferatu.nexus-ag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

We use postgreSQL 8.1.2 in Solaris 9 platform to maintain very important business data. The postgresql DB was interrupted now:

> more postgresql-2007-03-05_210154.log
LOG: could not bind socket for statistics collector: Cannot assign requested address
LOG: database system was interrupted while in recovery at 2007-03-05 20:26:30 CST
HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
LOG: checkpoint record is at 114/FDB86500
LOG: redo record is at 114/FDB2B0F8; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 8817742; next OID: 106734149
LOG: next MultiXactId: 60550; next MultiXactOffset: 14674685
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 114/FDB2B0F8
LOG: record with zero length at 115/249891E8
LOG: redo done at 115/249891B8
PANIC: failed to re-find parent key in "1560660"
LOG: startup process (PID 14266) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I know the problem " failed to re-find parent key" has been fixed in the newer release. My question is how we can recover the data in this case? The difficult is the disk with postgres data system is full.

Many thanks!

Roger

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Levy 2007-03-05 21:53:52 Cleaning up directory pgsql_tmp ?
Previous Message Josef Springer 2007-03-05 12:02:05 Can not restore a dumped database