System crash - invalid page header messages in log

From: "Jim Buttafuoco" <jim(at)contactbda(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: System crash - invalid page header messages in log
Date: 2004-09-28 20:18:44
Message-ID: 20040928201605.M82288@contactbda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

One of my systems crashed today and when Postgres started it gave the following warnings. Is this OK? I am going to
find which database has these relations and do some checking. It would be nice if the startup wal code gave the
database oid also and database version.

Thanks
Jim

select version();
version
------------------------------------------------------------------------------------------
PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 (Debian 20040401)

2004-09-28 16:10:47 [979] LOG: database system was interrupted at 2004-09-28 16:04:49 EDT
2004-09-28 16:10:47 [979] LOG: checkpoint record is at F4/FE424
2004-09-28 16:10:47 [979] LOG: redo record is at F4/4A94; undo record is at 0/0; shutdown FALSE
2004-09-28 16:10:47 [979] LOG: next transaction ID: 1332030; next OID: 920402645
2004-09-28 16:10:47 [979] LOG: database system was not properly shut down; automatic recovery in progress
2004-09-28 16:10:47 [979] LOG: redo starts at F4/4A94
2004-09-28 16:10:50 [979] WARNING: invalid page header in block 75660 of relation "743151645"; zeroing out page
2004-09-28 16:10:50 [979] WARNING: invalid page header in block 75672 of relation "743151645"; zeroing out page
2004-09-28 16:10:50 [979] WARNING: invalid page header in block 75698 of relation "743151645"; zeroing out page
2004-09-28 16:10:50 [979] WARNING: invalid page header in block 75786 of relation "743151645"; zeroing out page
2004-09-28 16:10:51 [979] WARNING: invalid page header in block 11193 of relation "743151650"; zeroing out page
2004-09-28 16:10:51 [979] WARNING: invalid page header in block 78348 of relation "743151645"; zeroing out page
2004-09-28 16:10:51 [979] WARNING: invalid page header in block 78452 of relation "743151645"; zeroing out page
2004-09-28 16:10:51 [979] WARNING: invalid page header in block 11279 of relation "743151650"; zeroing out page
2004-09-28 16:10:51 [979] WARNING: invalid page header in block 11283 of relation "743151651"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79467 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79479 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79493 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 11425 of relation "743151650"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79529 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79547 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79597 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79647 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79789 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 11466 of relation "743151650"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79815 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79865 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79885 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79897 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 11481 of relation "743151650"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79923 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79935 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 79947 of relation "743151645"; zeroing out page
2004-09-28 16:10:52 [979] WARNING: invalid page header in block 11478 of relation "743151651"; zeroing out page
2004-09-28 16:10:52 [979] LOG: incorrect resource manager data checksum in record at F4/72BEFA0
2004-09-28 16:10:52 [979] LOG: redo done at F4/72BEF3C
2004-09-28 16:11:02 [979] LOG: recycled transaction log file "000000F3000000F9"
2004-09-28 16:11:02 [979] LOG: recycled transaction log file "000000F3000000FA"
2004-09-28 16:11:02 [979] LOG: recycled transaction log file "000000F3000000FB"
2004-09-28 16:11:02 [979] LOG: recycled transaction log file "000000F3000000FC"
2004-09-28 16:11:02 [979] LOG: recycled transaction log file "000000F3000000FD"
2004-09-28 16:11:02 [979] LOG: recycled transaction log file "000000F3000000FE"
2004-09-28 16:11:02 [979] LOG: database system is ready

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2004-09-28 20:24:59 Re: shared memory release following failed lock acquirement.
Previous Message Shachar Shemesh 2004-09-28 20:17:01 Re: type unknown - how important is it?