Postgres Pro
Downloads
Home   >   mailing lists

Thread: unexpected pageaddr on startup/recovery

unexpected pageaddr on startup/recovery

From
"Jim Buttafuoco"
Date:
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

Re: unexpected pageaddr on startup/recovery

From
Tom Lane
Date:
"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

Re: unexpected pageaddr on startup/recovery

From
"Jim Buttafuoco"
Date:
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/ABBF978C
> 
> > Should 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?
> 
>                http://archives.postgresql.org
------- End of Original Message -------