Thread: unexpected pageaddr

unexpected pageaddr

From
Glyn Astill
Date:
Hi Chaps,

I'm doing my usual pull-the-plug tests on some new servers, and I'm seeing this in the logs during redo. Is this in any
waynormal? I'm guessing it is because it's just under "LOG" rather than something like "WARNING", but I'm not taking
anychances. 

I've got disk caches off, fsync on and some new fangled Zero-Maintenance Cache Protection.

These machines are pretty much identical to our current machines, differences are 8.4 rather than 8.3 and ZMCP rather
thanstandard BBU. 

Logs below
Glyn

2009-12-01 14:19:48 GMT [3510]: [1-1]: [user=]: [host=]: [db=]:: LOG:  database system was interrupted; last known up
at2009-12-01 14:16:32 GMT 
2009-12-01 14:19:48 GMT [3510]: [2-1]: [user=]: [host=]: [db=]:: LOG:  database system was not properly shut down;
automaticrecovery in progress 
2009-12-01 14:19:48 GMT [3510]: [3-1]: [user=]: [host=]: [db=]:: LOG:  redo starts at 6/901B8B0
2009-12-01 14:19:56 GMT [3510]: [4-1]: [user=]: [host=]: [db=]:: LOG:  unexpected pageaddr 5/CC80C000 in log file 6,
segment52, offset 8437760 
2009-12-01 14:19:56 GMT [3510]: [5-1]: [user=]: [host=]: [db=]:: LOG:  redo done at 6/3480B148
2009-12-01 14:19:56 GMT [3510]: [6-1]: [user=]: [host=]: [db=]:: LOG:  last completed transaction was at log time
2009-12-0114:17:04.986986+00 
2009-12-01 14:20:07 GMT [3513]: [1-1]: [user=]: [host=]: [db=]:: LOG:  autovacuum launcher started
2009-12-01 14:20:07 GMT [3447]: [1-1]: [user=]: [host=]: [db=]:: LOG:  database system is ready to accept connections





Re: unexpected pageaddr

From
Tom Lane
Date:
Glyn Astill <glynastill@yahoo.co.uk> writes:
> I'm doing my usual pull-the-plug tests on some new servers, and I'm
> seeing this in the logs during redo. Is this in any way normal?

Quite, this is one of the expected ways to detect end-of-WAL.

            regards, tom lane

Re: unexpected pageaddr

From
Glyn Astill
Date:
--- On Tue, 1/12/09, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> > I'm doing my usual pull-the-plug tests on some new
> servers, and I'm
> > seeing this in the logs during redo. Is this in any
> way normal?
>
> Quite, this is one of the expected ways to detect
> end-of-WAL.
>
>

Excellent, thanks Tom.