Re: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dmitry Tkach <dmitry(at)openratings(dot)com>
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 21:54:13
Message-ID: 5969.1058565253@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Tkach 2003-07-18 22:02:25 Re: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3
Previous Message Maksim Likharev 2003-07-18 21:50:58 Re: ODBC query problem AGAIN