X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 40BE5DADBC for ; Fri, 11 Nov 2005 15:30:53 -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 08858-06 for ; Fri, 11 Nov 2005 19:30:49 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id C643AD9E54 for ; Fri, 11 Nov 2005 15:30:49 -0400 (AST) Received: by flake.decibel.org (Postfix, from userid 1001) id C3D2F15257; Fri, 11 Nov 2005 13:30:50 -0600 (CST) Date: Fri, 11 Nov 2005 13:30:50 -0600 From: "Jim C. Nasby" To: pgsql-docs@postgresql.org Subject: [tgl@sss.pgh.pa.us: Re: [ADMIN] ClusterDB error message] Message-ID: <20051111193050.GS54605@pervasive.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.145 required=5 tests=[AWL=-0.131, MAILTO_TO_SPAM_ADDR=0.276] X-Spam-Score: 0.145 X-Spam-Level: X-Archive-Number: 200511/14 X-Sequence-Number: 3324 Should this info be put into the docs? Or maybe the FAQ? It seems bad to me to point people at the archives for something like this... ----- Forwarded message from Tom Lane ----- 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster ----- End forwarded message ----- -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461