Search Postgresql Archives

Odd corruption issue reported on dba.stackexchange.com, need advice

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all

I've been following a strange issue on dba.stackexchange.com and I could use opinions from those more clueful than I on the log files posted there.

http://dba.stackexchange.com/questions/20959/recover-postgresql-database-from-wal-errors-on-startup/20961#comment34356_20961

The short version is that the person did a bulk-load of some PostGIS data using the osm2pgsql data-loader tool ( http://wiki.openstreetmap.org/wiki/Osm2pgsql) to populate a Pg 9.1 database. This appeared to succeed, but when the server was restarted it failed to come up, complaining that "WAL contains references to invalid pages" and "page 1493172 of relation base/16385/477861 was uninitialized" (for many different pages).

The logs of the shutdown suggest that a backend probably crashed, but that shouldn't cause the WAL and heap corruption observed by the OP.

It's interesting to observe the presence of both a fast and an immediate shutdown request in the log.

A trimmed log follows, original linked to in the article above:

LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  received immediate shutdown request
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
LOG:  could not send data to client: Broken pipe
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
LOG:  could not send data to client: Broken pipe

[Note: The posted log of the shutdown ends here. The poster asserts that this is the complete log and that the following statement is the next one in their log. Very strange.]

LOG:  database system was interrupted; last known up at 2012-07-13 00:15:20 UTC
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 4D/A25FE548
LOG:  unexpected pageaddr 4D/6F5C6000 in log file 77, segment 196, offset 6053888
LOG:  redo done at 4D/C45C5278
WARNING:  page 1493172 of relation base/16385/477861 was uninitialized
WARNING:  page 2247965 of relation base/16385/477861 was uninitialized
WARNING:  page 1493172 of relation base/16385/477861 was uninitialized
PANIC:  WAL contains references to invalid pages
LOG:  startup process (PID 21574) was terminated by signal 6: Aborted
LOG:  aborting startup due to startup process failure

--
Craig Ringer



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux