Hey guys, I'm burning in some new hardware and just reached the
pull-the-plug phase of testing. On restart, I see this:
2007-06-06 12:04:00 PDT LOG:  database system was interrupted at 2007-06-06 11:53:56 PDT
2007-06-06 12:04:00 PDT LOG:  checkpoint record is at 24/C29ED068
2007-06-06 12:04:00 PDT LOG:  redo record is at 24/BEF3C3A8; undo record is at 0/0; shutdown FALSE
2007-06-06 12:04:00 PDT LOG:  next transaction ID: 0/11773980; next OID: 24576
2007-06-06 12:04:00 PDT LOG:  next MultiXactId: 1; next MultiXactOffset: 0
2007-06-06 12:04:00 PDT LOG:  database system was not properly shut down; automatic recovery in progress
2007-06-06 12:04:00 PDT LOG:  redo starts at 24/BEF3C3A8
2007-06-06 12:18:03 PDT LOG:  unexpected pageaddr 24/9D6DC000 in log file 36, segment 224, offset 7192576
2007-06-06 12:18:03 PDT LOG:  redo done at 24/E06DB210
2007-06-06 12:20:21 PDT LOG:  database system is ready
That "unexpected pageaddr" line seems bad to me, especially seeing as how
this is on a battery-backed hardware raid with drive write caches
supposedly disabled. Should I expect to see such lines anyway after a
sudden power loss?