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 A1A5DD1B1C7 for ; Wed, 19 May 2004 13:14:34 -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 80576-08 for ; Wed, 19 May 2004 13:14:13 -0300 (ADT) Received: from bitoek.uni-bayreuth.de (bti0x1.bitoek.uni-bayreuth.de [132.180.112.2]) by svr1.postgresql.org (Postfix) with ESMTP id B9747D1B193 for ; Wed, 19 May 2004 13:14:11 -0300 (ADT) Received: from bitoek.uni-bayreuth.de (bti0x027.bitoek.uni-bayreuth.de [132.180.112.27]) by bitoek.uni-bayreuth.de (8.12.7/8.12.7) with ESMTP id i4JGE5q7004065 for ; Wed, 19 May 2004 18:14:06 +0200 Message-ID: <40AB87CC.8020500@bitoek.uni-bayreuth.de> Date: Wed, 19 May 2004 18:14:04 +0200 From: Stefan Holzheu User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.6) Gecko/20040113 X-Accept-Language: de-at, de, en-us, en MIME-Version: 1.0 To: ADMIN Subject: Servercrash Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS - amavis-milter (http://www.amavis.org/) X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/193 X-Sequence-Number: 13509 Hallo Lists, yesterday our database-server crashed (raid-error). After reparing the=20 filesystem (ext2) we have a problem with our lagest table in the database. vaccuum aborts with the following meassage (sorry it is in German): DEBUG: vacuume =BBmessungen.massendaten=AB HINWEIS: Relation =BBmassendaten=AB TID 211540/73:=20 DeleteTransactionInProgress 16785658 --- kann Relation nicht verkleinern=20 (cannot shrink relation) DEBUG: AbortCurrentTransaction FEHLER: ung=FCltiger Seitenkopf in Block 354500 von Relation=20 =BBmassendaten=AB (unvalid pagehead in block ...) All other operations using ctid 211540/73 give: FEHLER: konnte auf den Status von Transaktion 16785658 nicht zugreifen (could not get status of transaction ...) DETAIL: konnte Datei =BB/var/lib/pgsql/data/pg_clog/0010=AB nicht =F6ffnen: Datei oder Verzeichnis nicht gefunden Is there a way to repair the database? Help welcome! Regards Stefan --=20 ----------------------------- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth -----------------------------