Received: from localhost (unknown [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 75F8E2E036D
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 27 Nov 2007 17:34:23 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 32053-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 27 Nov 2007 17:34:15 -0400 (AST)
Received: from mail.fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1])
	by postgresql.org (Postfix) with ESMTP id 5CA9D2E0073
	for <pgsql-sql@postgresql.org>; Tue, 27 Nov 2007 17:34:18 -0400 (AST)
Received: from [157.92.155.58] (mailbis [157.92.155.58])
	by mail.fmed.uba.ar (Postfix) with ESMTP id 6671111918E
	for <pgsql-sql@postgresql.org>; Tue, 27 Nov 2007 18:36:30 -0300 (ART)
Message-ID: <474C902D.4040104@fmed.uba.ar>
Date: Tue, 27 Nov 2007 18:46:21 -0300
From: Gerardo Herzig <gherzig@fmed.uba.ar>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: pg_clog (?) problem with VACUMM
References: <474C78E2.400@fmed.uba.ar> <87lk8ja1ey.fsf@oxford.xeocode.com>
In-Reply-To: <87lk8ja1ey.fsf@oxford.xeocode.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/135
X-Sequence-Number: 29663

Gregory Stark wrote:

>"Gerardo Herzig" <gherzig@fmed.uba.ar> writes:
>
>  
>
>>Hi all. Well, im having this problem for the first time.
>>When executing a VACUUM, i have this msg:
>>gse_new_version=# VACUUM ;
>>ERROR:  could not access status of transaction 118
>>DETAIL:  could not open file "pg_clog/0000": No existe el fichero o el
>>directorio
>>    
>>
>
>[]
>
>  
>
>>Ok, wtf, i will create the file. So touch pg_clog/0000 and VACUUM again....
>>ERROR:  could not access status of transaction 118
>>DETAIL:  could not read from file "pg_clog/0000" at offset 0: Conseguido
>>    
>>
>
>That's almost the right idea for a last ditch attempt to extract what data you
>can from a corrupted table. You have to fill the file with nul bytes though.
>Something like dd if=/dev/zero of=0000 bs=1k count=nnn where nnn is, uh, I'm
>not sure how large, it won't take much to cover transactionid 118 though.
>
>  
>

Mmmm, yeah, after dd'ing the 0000 file, VACUUM execute just fine!!
BTW, a previous atempt to build a CLUSTER gives me the same error as 
with VACUUM, so i dont think it was a VACUUM issue.

Thanks Gregor for your help!!

Gerardo