Re: vacuum error

--On Wednesday, March 12, 2003 11:40:39 -0500 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:

> Eric Cholet <cholet(at)logilune(dot)com> writes:
>> I get this error when vacuuming a table:
>> PANIC: open of /usr/local/pgsql/data/pg_clog/0005 failed: No such file
>> or directory
>> using 7.3.2.
>>>
>>> What file names are actually present in pg_clog/ ?
>
>> 0000 0001 0002 0003 0004
>
> Hm, interesting. You had any crashes recently?

Yes, I've had many crashes. Always when vacuuming a largish (500 Mb) table.
I suspected faulty hardware, so I dropped and recreated the tables
several times.

> Could you show us an
> "ls -l" listing of those clog files (I want to know their sizes and
> mod dates...)

-rw------- 1 postgres wheel 262144 Dec 30 03:49 0000
-rw------- 1 postgres wheel 262144 Jan 2 19:12 0001
-rw------- 1 postgres wheel 262144 Feb 12 12:30 0002
-rw------- 1 postgres wheel 262144 Mar 10 06:51 0003
-rw------- 1 postgres wheel 253952 Mar 12 17:53 0004

Thanks,

--
Eric Cholet