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 8FC28D1B171 for ; Thu, 20 May 2004 07:22:06 -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 83828-07 for ; Thu, 20 May 2004 07:21:49 -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 34521D1B262 for ; Thu, 20 May 2004 07:21:43 -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 i4KALeq7020973; Thu, 20 May 2004 12:21:40 +0200 Message-ID: <40AC86B2.8040301@bitoek.uni-bayreuth.de> Date: Thu, 20 May 2004 12:21:38 +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: Tom Lane Cc: ADMIN Subject: Re: Servercrash References: <40AB87CC.8020500@bitoek.uni-bayreuth.de> <22443.1085010261@sss.pgh.pa.us> In-Reply-To: <22443.1085010261@sss.pgh.pa.us> 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/208 X-Sequence-Number: 13524 >=20 >>yesterday our database-server crashed (raid-error). After reparing the=20 >>filesystem (ext2) we have a problem with our lagest table in the database. >=20 >=20 >>vaccuum aborts with the following meassage (sorry it is in German): >=20 >=20 >>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 ...) >=20 >=20 >>All other operations using ctid 211540/73 give: >=20 >=20 >>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 =F6ffn= en: >>Datei oder Verzeichnis nicht gefunden >=20 >=20 >>Is there a way to repair the database? >=20 >=20 > You have at least two corrupted pages in that table: page 354500 has a > header problem, and in page 211540 there's a bogus transaction ID in a > tuple header. These are the *minimum* descriptions of the data lossage, > it's entirely likely that large parts of the pages involved are junk. >=20 > I would suggest proceeding by examining those pages with pg_filedump or > another tool. If you can make some sense of the damage it might be > possible to do a selective repair. If not, your best bet is to just > zero out the damaged pages --- this will lose the rows that are on those > pages, but at least you can get the rest of the table operational again. >=20 > You can find more about this by looking in the mail list archives. > Threads mentioning pg_filedump would be good places to start. >=20 > regards, tom lane >=20 >=20 We set zero_damaged_pages to on and get rid of page 354500. But the=20 error in page 211540 remains :-(... Any idea? Stefan --=20 ----------------------------- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth -----------------------------