unexpected pageaddr

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: unexpected pageaddr
Date: 2009-12-01 14:54:28
Message-ID: 450105.45493.qm@web23601.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 way normal? I'm guessing it is because it's just under "LOG" rather than something like "WARNING", but I'm not taking any chances.

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 than standard 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 at 2009-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; automatic recovery 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, segment 52, 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-01 14: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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-12-01 15:14:18 Re: unexpected pageaddr
Previous Message Gauthier, Dave 2009-12-01 14:36:31 Re: limiting resources to users