FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3 failed: No such file or directory

From: Dmitry Tkach <dmitry(at)openratings(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3 failed: No such file or directory
Date: 2003-07-18 15:50:29
Message-ID: 3F181745.7070207@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, everybody!

I was getting these errors (see subject) from time to time on 7.2.1 when
trying to analyze tables... trying to repeat the statament would usually
work....
I then saw somebody else post in the list, mentioning the same problem,
and Tom Lane's reply to it suggesting to upgrade to 7.2.4, where that
was supposedly fixed.

I have upgraded recently, and got the same problem again yesterday... It
seems to have become even worse, as it was happenning consistently, even
when I tried to repeat the query (with 7.2.1, the second time always
used to work, as far as I remember)... it seems to have went away after
I have restarted the server manually...

Was I wrong deducing the assumption that it should be fixed in 7.2.4
from that Tom's message?
Or is this news to you guys too?

Any idea what is causing this, and/or how it can be avoided?

Thanks a lot!

Dima

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-07-18 15:53:28 Re: Urgent: 10K or more connections
Previous Message Dennis Gearon 2003-07-18 15:20:28 Re: How to set the background color of the JPanel in Java