public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jim C. Nasby <[email protected]>
To: [email protected]
Subject: [[email protected]: Re: [ADMIN] ClusterDB error message]
Date: Fri, 11 Nov 2005 13:30:50 -0600
Message-ID: <[email protected]> (raw)
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 <[email protected]> -----
CG <[email protected]> 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 [email protected]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: [[email protected]: Re: [ADMIN] ClusterDB error message]
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox