pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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