pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Unfamiliar recovery message afer server crash 2+ messages / 2 participants [nested] [flat]
* Unfamiliar recovery message afer server crash @ 2004-04-20 16:34 Arthur Ward <award@dominionsciences.com> 0 siblings, 1 reply; 2+ messages in thread From: Arthur Ward @ 2004-04-20 16:34 UTC (permalink / raw) To: pgsql-admin For unknown reasons, our PG server died overnight. (PG 7.4.2, RedHat 8, ext3 ordered data mode, and battery backed RAID5) When it came back up, I saw an unfamiliar line in the recovery output from Postgres: Apr 20 11:28:14 postgres: [6203] LOG: database system was interrupted at 2004-04-20 05:50:59 CDT Apr 20 11:28:14 postgres: [6203] LOG: checkpoint record is at 7C/CF55FB6C Apr 20 11:28:14 postgres: [6203] LOG: redo record is at 7C/CF55FB6C; undo record is at 0/0; shutdown FALSE Apr 20 11:28:14 postgres: [6203] LOG: next transaction ID: 9374951; next OID: 158516389 Apr 20 11:28:14 postgres: [6203] LOG: database system was not properly shut down; automatic recovery in progress Apr 20 11:28:14 postgres: [6203] LOG: redo starts at 7C/CF55FBAC Apr 20 11:28:17 postgres: [6203] LOG: unexpected pageaddr 7C/C7A0A000 in log file 124, segment 207, offset 10526720 Apr 20 11:28:17 postgres: [6203] LOG: redo done at 7C/CFA09F7C Apr 20 11:28:20 postgres: [6203] LOG: database system is ready What's the significance of the "unexpected pageaddr" item? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Unfamiliar recovery message afer server crash @ 2004-04-21 03:07 Tom Lane <tgl@sss.pgh.pa.us> parent: Arthur Ward <award@dominionsciences.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2004-04-21 03:07 UTC (permalink / raw) To: Arthur Ward <award@dominionsciences.com>; +Cc: pgsql-admin "Arthur Ward" <award@dominionsciences.com> writes: > Apr 20 11:28:14 postgres: [6203] LOG: database system was not properly > shut down; automatic recovery in progress > Apr 20 11:28:14 postgres: [6203] LOG: redo starts at 7C/CF55FBAC > Apr 20 11:28:17 postgres: [6203] LOG: unexpected pageaddr 7C/C7A0A000 in > log file 124, segment 207, offset 10526720 > Apr 20 11:28:17 postgres: [6203] LOG: redo done at 7C/CFA09F7C > Apr 20 11:28:20 postgres: [6203] LOG: database system is ready > What's the significance of the "unexpected pageaddr" item? Just that the first indication of end-of-XLOG was finding a stale page header in a recycled XLOG file. The above looks fine to me. (The XLOG recovery code tends to err on the side of verboseness... there are a lot of messages it can print that might boggle a novice but are not really indicative of problems.) regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-04-21 03:07 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-04-20 16:34 Unfamiliar recovery message afer server crash Arthur Ward <award@dominionsciences.com> 2004-04-21 03:07 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox