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
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 |