unexpected pageaddr on startup/recovery
Hackers,
I had a system crash today. When Postgresql started I had the following in my pg.log file.
2005-08-06 14:14:26 [3352] LOG: database system was interrupted at 2005-08-06 11:57:28 EDT
2005-08-06 14:14:26 [3352] LOG: checkpoint record is at 5E5/9CAEA594
2005-08-06 14:14:26 [3352] LOG: redo record is at 5E5/9C6796A0; undo record is at 0/0; shutdown FALSE
2005-08-06 14:14:26 [3352] LOG: next transaction ID: 6273726; next OID: 4274112431
2005-08-06 14:14:26 [3352] LOG: database system was not properly shut down; automatic recovery in progress
2005-08-06 14:14:26 [3352] LOG: redo starts at 5E5/9C6796A0
2005-08-06 14:17:17 [3352] LOG: unexpected pageaddr 5E3/A7BFA000 in log file 1509, segment 171, offset 12558336
2005-08-06 14:17:17 [3352] LOG: redo done at 5E5/ABBF978C
Should I worry about the unexpected pageaddr message? and if so, what do I need to do
select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-6sarge1)
Thanks
Jim
"Jim Buttafuoco" <jim@contactbda.com> writes:
2005-08-06 14:14:26 [3352] LOG: database system was not properly shut down; automatic recovery in progress
2005-08-06 14:14:26 [3352] LOG: redo starts at 5E5/9C6796A0
2005-08-06 14:17:17 [3352] LOG: unexpected pageaddr 5E3/A7BFA000 in log file 1509, segment 171, offset 12558336
2005-08-06 14:17:17 [3352] LOG: redo done at 5E5/ABBF978C
Should I worry about the unexpected pageaddr message?
No, that looks perfectly normal.
regards, tom lane
thanks
---------- Original Message -----------
From: Tom Lane <tgl@sss.pgh.pa.us>
To: jim@contactbda.com
Cc: "pgsql-hackers" <pgsql-hackers@postgresql.org>
Sent: Sat, 06 Aug 2005 17:24:46 -0400
Subject: Re: [HACKERS] unexpected pageaddr on startup/recovery
"Jim Buttafuoco" <jim@contactbda.com> writes:
2005-08-06 14:14:26 [3352] LOG: database system was not properly shut down; automatic recovery in progress
2005-08-06 14:14:26 [3352] LOG: redo starts at 5E5/9C6796A0
2005-08-06 14:17:17 [3352] LOG: unexpected pageaddr 5E3/A7BFA000 in log file 1509, segment 171, offset 12558336
2005-08-06 14:17:17 [3352] LOG: redo done at 5E5/ABBF978CShould I worry about the unexpected pageaddr message?
No, that looks perfectly normal.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
------- End of Original Message -------