From: | Dmitry Tkach <dmitry(at)openratings(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3 |
Date: | 2003-07-18 22:02:25 |
Message-ID: | 3F186E71.6040706@openratings.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
>Dmitry Tkach <dmitry(at)openratings(dot)com> writes:
>
>
>>Well ... *today* there seem to be files between 0000 and 00EC
>>Is that range supposed to stay the same or does it vary?
>>
>>
>
>It will vary, but not quickly --- each file represents 1 million
>transactions.
>
>If the problem is erratic with VACUUM or SELECT COUNT(*), then the
>only speculation I have is flaky hardware: you must be reading different
>xids from the table at different times.
>
>
Oops... I just got it again - right after doing that select count (*),
that *worked*, I tried analyze the same table, and got:
FATAL 2: open of /var/lib/pgsql/data/pg_clog/0980 failed: No such file
or directory
I tried it again, right away, and got the same error, complaining about
02B0 this time
I tried select count (*) again, and it worked.
I restarted the server, did analyze, and it worked too...
Any ideas?
From | Date | Subject | |
---|---|---|---|
Next Message | Luis Magaña | 2003-07-18 22:42:26 | Re: [GENERAL] ODBC query problem AGAIN |
Previous Message | Tom Lane | 2003-07-18 21:54:13 | Re: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3 |