Re: vacuum error

--On Wednesday, March 12, 2003 11:40:39 -0500 Tom Lane <tgl@sss.pgh.pa.us>
wrote:

> Eric Cholet <cholet@logilune.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