Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id BF5FE2E2E5A
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 27 Nov 2007 15:55:01 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 56866-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 27 Nov 2007 15:54:58 -0400 (AST)
Received: from mail.fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1])
	by postgresql.org (Postfix) with ESMTP id 0891F2E2E50
	for <pgsql-sql@postgresql.org>; Tue, 27 Nov 2007 15:54:57 -0400 (AST)
Received: from [157.92.155.58] (mailbis [157.92.155.58])
	by mail.fmed.uba.ar (Postfix) with ESMTP id E6D3B11A470
	for <pgsql-sql@postgresql.org>; Tue, 27 Nov 2007 16:57:07 -0300 (ART)
Message-ID: <474C78E2.400@fmed.uba.ar>
Date: Tue, 27 Nov 2007 17:06:58 -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" <pgsql-sql@postgresql.org>
Subject: pg_clog (?) problem with VACUMM
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/133
X-Sequence-Number: 29661

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

I hope the error will still be clear due to the word "Conseguido", wich 
will be something like 'acomplished', or 'obtained'

The database was created making a "with template=gse" modifiers. 
Vacuuming the 'gse' database gives me no errors at all.

Here is the final lines from strace when triyng to vacuum...
lseek(20, 0, SEEK_SET)                  = 0
read(20, "", 8192)                      = 0
close(20)                               = 0
rt_sigprocmask(SIG_SETMASK, ~[QUIT ILL TRAP ABRT BUS FPE KILL SEGV CONT 
STOP SYS RTMIN RT_1], NULL, 8) = 0
stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=377, ...}) = 0
stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=377, ...}) = 0
stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=377, ...}) = 0
write(2, "<2007-11-27 16:54:23 ART, gse_ne"..., 346) = 346
sendto(8, "E\0\0\0\240SERROR\0CXX000\0Mcould not ac"..., 161, 0, NULL, 
0) = 161
munmap(0x2aaabffa9000, 839680)          = 0
munmap(0x2aaabdfa8000, 33558528)        = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
sendto(7, "\4\0\0\0\310\3\0\0\1\0\0\0\2731\0\0 S\255\0\r\0\0\0+\0"..., 
968, 0, NULL, 0) = 968
sendto(7, "\4\0\0\0\310\3\0\0\1\0\0\0\2731\0\0 S\255\0\r\0\0\0\0\0"..., 
968, 0, NULL, 0) = 968
sendto(7, "\4\0\0\0\310\3\0\0\1\0\0\0\2731\0\0 S\255\0\r\0\0\0\0\0"..., 
968, 0, NULL, 0) = 968
sendto(7, "\4\0\0\0\310\3\0\0\1\0\0\0\2731\0\0 S\255\0\r\0\0\0\0\0"..., 
968, 0, NULL, 0) = 968
sendto(7, "\4\0\0\0\370\0\0\0\1\0\0\0\2731\0\0 S\255\0\3\0\0\0\0\0"..., 
248, 0, NULL, 0) = 248
sendto(7, "\4\0\0\0008\3\0\0\1\0\0\0\2731\0\0\0\0\0\0\v\0\0\0\0\0"..., 
824, 0, NULL, 0) = 824
sendto(7, "\3\0\0\0\27\0\0\0\1\0\0\0\2731\0\0<IDLE>\0", 23, 0, NULL, 0) = 23
sendto(8, "Z\0\0\0\5I", 6, 0, NULL, 0)  = 6
recvfrom(8,   

Dont know what to do now.
Wait...i have some more.
When vacuuming a table at a time, i got the table making vacuum crash. 
It's this one:
gse_new_version=# \d words
             Table "public.words"
    Column     |       Type        | Modifiers
---------------+-------------------+-----------
 page_id       | integer           |
 word          | character varying |
 word_position | integer           |
 original_word | character varying |
Indexes:
    "words_idx" btree (upper(word::text))
    "words_page_id_idx" btree (page_id)
    "words_page_id_word_position_id" btree (page_id, word_position) CLUSTER
    "words_upper_idx" btree (upper(word::text) varchar_pattern_ops)

Im souspiciuos about the CLUSTER (dont ask why :-). Meanwhile im looking 
for 'unclustering' tables and triyng again.

Server version: 8.1.2
On SuSE 9.1

Some other ideas will be apreciated.
Thanks!!

Gerardo.