X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7FDD1D1F1AA for ; Tue, 20 Apr 2004 20:01:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 31880-09 for ; Tue, 20 Apr 2004 20:01:41 -0300 (ADT) Received: from award.gotdns.org (pcp01097251pcs.tsclos01.al.comcast.net [68.62.129.152]) by svr1.postgresql.org (Postfix) with ESMTP id 5BA78D1F20A for ; Tue, 20 Apr 2004 13:34:54 -0300 (ADT) Received: (qmail 30635 invoked by uid 81); 20 Apr 2004 11:34:53 -0500 Received: from 68.62.129.152 (SquirrelMail authenticated user award) by award.gotdns.org with HTTP; Tue, 20 Apr 2004 11:34:53 -0500 (CDT) Message-ID: <33720.68.62.129.152.1082478893.squirrel@award.gotdns.org> Date: Tue, 20 Apr 2004 11:34:53 -0500 (CDT) Subject: Unfamiliar recovery message afer server crash From: "Arthur Ward" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=3.5 tagged_above=0.0 required=5.0 tests=PRIORITY_NO_NAME, RCVD_IN_DYNABLOCK, RCVD_IN_SORBS X-Spam-Level: *** X-Archive-Number: 200404/267 X-Sequence-Number: 13240 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?