Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success

From: Michael Harris <michael(dot)harris(at)ericsson(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success
Date: 2009-11-10 00:08:18
Message-ID: B0F87A6BC671B249AD1C6F7DF8ACA86C28971B2DC6@ESGSCCMS0001.eapac.ericsson.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have been asked to help recover a database that seems to have been corrupted after a power failure.

This is what we see when psql tries to start up:

[2009-11-10 10:39:17 EST] LOG: checkpoint record is at 41E/BF2D5DC0
[2009-11-10 10:39:17 EST] LOG: redo record is at 41E/BF008F28; undo record is at 0/0; shutdown FALSE
[2009-11-10 10:39:17 EST] LOG: next transaction ID: 0/143406361; next OID: 5219759
[2009-11-10 10:39:17 EST] LOG: next MultiXactId: 178368; next MultiXactOffset: 356812
[2009-11-10 10:39:17 EST] LOG: database system was not properly shut down; automatic recovery in progress
[2009-11-10 10:39:17 EST] LOG: redo starts at 41E/BF008F28
[2009-11-10 10:39:17 EST] WARNING: invalid page header in block 3 of relation "5166570"; zeroing out page
[2009-11-10 10:39:17 EST] CONTEXT: xlog redo newroot: rel 16390/16391/5166570; root 3 lev 1
[2009-11-10 10:39:17 EST] WARNING: invalid page header in block 84 of relation "5152721"; zeroing out page
[2009-11-10 10:39:17 EST] CONTEXT: xlog redo insert(init): rel 16390/16391/5152721; tid 84/1
... repeated a lot of times with various blocks and relations ...
[2009-11-10 10:39:17 EST] FATAL: could not read block 6 of relation 16390/16391/5153282: Success
[2009-11-10 10:39:17 EST] CONTEXT: xlog redo insert(init): rel 16390/16391/5153282; tid 6/1
[2009-11-10 10:39:17 EST] LOG: startup process (PID 14643) exited with exit code 1
[2009-11-10 10:39:17 EST] LOG: aborting startup due to startup process failure
[2009-11-10 10:39:17 EST] LOG: logger shutting down

Does anyone have any clues how we might recover this database?

Also what does it mean by "Success" in the FATAL message? Seems a strange fatal error...

Thanks in advance,
Regards // Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-11-10 01:03:45 Re: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success
Previous Message Gordon Callan 2009-11-09 23:48:55 Re: Tsearch2 with Japanese