pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
ClusterDB error message 2+ messages / 2 participants [nested] [flat]
* ClusterDB error message @ 2005-11-10 16:30 CG <cgg007@yahoo.com> 0 siblings, 1 reply; 2+ messages in thread From: CG @ 2005-11-10 16:30 UTC (permalink / raw) To: pgsql-admin PostgreSQL 7.4 : 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 CONTEXT: SQL function "letter_owner" statement 1 It happens when I try to cluster on any index created for the table, both column-based indexes and function-based indexes. I've tried re-indexing the table. It yielded no change. Please advise! __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ClusterDB error message @ 2005-11-10 16:51 Tom Lane <tgl@sss.pgh.pa.us> parent: CG <cgg007@yahoo.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2005-11-10 16:51 UTC (permalink / raw) To: cgg007@yahoo.com; +Cc: pgsql-admin CG <cgg007@yahoo.com> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-11-10 16:51 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-11-10 16:30 ClusterDB error message CG <cgg007@yahoo.com> 2005-11-10 16:51 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox