From: | Eric Cholet <cholet(at)logilune(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: vacuum error |
Date: | 2003-03-12 18:18:09 |
Message-ID: | 212600000.1047493088@shambala.logilune.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--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
From | Date | Subject | |
---|---|---|---|
Next Message | Muhammad Shariq Muzaffar | 2003-03-12 18:19:03 | Re: create function pl/pgsql c langauge |
Previous Message | Dennis Gearon | 2003-03-12 17:53:29 | Re: updated at a single element in a array using pl/pgsql |