X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 58332DADB5 for ; Thu, 10 Nov 2005 12:51:46 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75770-02 for ; Thu, 10 Nov 2005 16:51:45 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 42B5BDAD1C for ; Thu, 10 Nov 2005 12:51:42 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jAAGpgDf009864; Thu, 10 Nov 2005 11:51:42 -0500 (EST) To: cgg007@yahoo.com Cc: pgsql-admin@postgresql.org Subject: Re: ClusterDB error message In-reply-to: <20051110163003.60723.qmail@web32505.mail.mud.yahoo.com> References: <20051110163003.60723.qmail@web32505.mail.mud.yahoo.com> Comments: In-reply-to CG message dated "Thu, 10 Nov 2005 08:30:02 -0800" Date: Thu, 10 Nov 2005 11:51:42 -0500 Message-ID: <9863.1131641502@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.144 required=5 tests=[AWL=-0.132, MAILTO_TO_SPAM_ADDR=0.276] X-Spam-Score: 0.144 X-Spam-Level: X-Archive-Number: 200511/121 X-Sequence-Number: 19494 CG writes: > Can anyone surmise what this message is really saying? > clusterdb: clustering of table "letter" in database "addata" failed: ERROR: > could not access status of transaction 1696665057 > DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0652": No such file or directory This is a corrupt-data problem: the xmin or xmax field of a row header has been overwritten with garbage. (Very likely, more than that has been overwritten, but xmin/xmax is usually the first thing looked at so this is the typical symptom.) See the PG list archives for prior discussions of how to isolate and get rid of corrupted rows. regards, tom lane