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 2C8CAD7BAF for ; Thu, 10 Nov 2005 12:36:47 -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 72463-10 for ; Thu, 10 Nov 2005 16:36:44 +0000 (GMT) X-Greylist: delayed 00:06:39.382042 by SQLgrey- Received: from web32505.mail.mud.yahoo.com (web32505.mail.mud.yahoo.com [68.142.207.215]) by svr1.postgresql.org (Postfix) with SMTP id B7655D70C0 for ; Thu, 10 Nov 2005 12:36:43 -0400 (AST) Received: (qmail 60725 invoked by uid 60001); 10 Nov 2005 16:30:03 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=AxFaLnfJNz/akcqsxiIufRWeKEqDaYm5cqkQUb9fO/BVez2u7eHR4Qwlt5pzuBkUa+Qk6UMuN6Nn53KBuk8cOhBzjJXzOQzmqdy9cuoyxF/4deYbHSSIqZsm2DdR948s92WKZLwbfbxGLsksFNED1A33JA3wFZVnjQz44C8jE3g= ; Message-ID: <20051110163003.60723.qmail@web32505.mail.mud.yahoo.com> Received: from [199.44.117.5] by web32505.mail.mud.yahoo.com via HTTP; Thu, 10 Nov 2005 08:30:02 PST Date: Thu, 10 Nov 2005 08:30:02 -0800 (PST) From: CG Reply-To: cgg007@yahoo.com Subject: ClusterDB error message To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200511/120 X-Sequence-Number: 19493 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