Обсуждение: Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success
Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success
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
Michael Harris <michael.harris@ericsson.com> writes: > I have been asked to help recover a database that seems to have been corrupted after a power failure. What PG version is this exactly? > Also what does it mean by "Success" in the FATAL message? It's probably a read-past-EOF case. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Hi Tom, Postgres is 8.2.3. The owners of this database have now decided to rebuild it from scratch so please don't spend much more time on answeringthis. Although, I'd like to know how to proceed in cases like this in case it ever happens again. Regards // Mike -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, 10 November 2009 12:04 PM To: Michael Harris Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success Michael Harris <michael.harris@ericsson.com> writes: > I have been asked to help recover a database that seems to have been corrupted after a power failure. What PG version is this exactly? > Also what does it mean by "Success" in the FATAL message? It's probably a read-past-EOF case. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Michael Harris <michael.harris@ericsson.com> writes: > Postgres is 8.2.3. 8.2.something-recent might have coped with this better; I notice a couple of WAL replay bug fixes in the later release notes. You should encourage an update ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Michael Harris <michael.harris@ericsson.com> writes: > I have been asked to help recover a database that seems to have been corrupted after a power failure. What PG version is this exactly? > Also what does it mean by "Success" in the FATAL message? It's probably a read-past-EOF case. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Michael Harris <michael.harris@ericsson.com> writes: > Postgres is 8.2.3. 8.2.something-recent might have coped with this better; I notice a couple of WAL replay bug fixes in the later release notes. You should encourage an update ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Hi Tom, Postgres is 8.2.3. The owners of this database have now decided to rebuild it from scratch so please don't spend much more time on answeringthis. Although, I'd like to know how to proceed in cases like this in case it ever happens again. Regards // Mike -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, 10 November 2009 12:04 PM To: Michael Harris Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Database Startup Failure: FATAL: could not read block 6 of relation 16390/16391/5153282: Success Michael Harris <michael.harris@ericsson.com> writes: > I have been asked to help recover a database that seems to have been corrupted after a power failure. What PG version is this exactly? > Also what does it mean by "Success" in the FATAL message? It's probably a read-past-EOF case. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general