469,628 Members | 1,200 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,628 developers. It's quick & easy.

Removed and then missing pg_clog file

Hi,
We about a week ago installed a clean version of postgres
7.4.5 for testing purposes. For the last couple of days
for any transaction it has been complaining about: Thu Sep
23 09:36:24 2004: ERROR: could not access status of
transaction 941262
Thu Sep 23 10:10:01 2004: DETAIL: could not open file
"/nw/data/pgdata/pg_clog/0000": No such file or directory
Thu Sep 23 10:10:01 2004: ERROR: could not access status
of transaction 941355
Thu Sep 23 10:10:06 2004: DETAIL: could not open file
"/nw/data/pgdata/pg_clog/0000": No such file or directory

Now looking at the postgres logfile it also says (meaning
that it removed the log file thinking it was safe to
remove it):

Thu Sep 23 07:40:02 2004: LOG: removing file
"/nw/data/pgdata/pg_clog/0000"
What might be causing this error to occur?

Thanks..
Amin

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #1
1 3439
Note

1) the clog file was automatically removed.
2) There are multiple databases with only one database
specific vacuums
3) The other database does table specific vacuums.

Amin

On Fri, 24 Sep 2004 11:20:49 -0400
Amin Abdulghani <am**@quantiva.com> wrote:
Hi,
We about a week ago installed a clean version of postgres
7.4.5 for testing purposes. For the last couple of days
for any transaction it has been complaining about: Thu
Sep 23 09:36:24 2004: ERROR: could not access status of
transaction 941262
Thu Sep 23 10:10:01 2004: DETAIL: could not open file
"/nw/data/pgdata/pg_clog/0000": No such file or directory
Thu Sep 23 10:10:01 2004: ERROR: could not access status
of transaction 941355
Thu Sep 23 10:10:06 2004: DETAIL: could not open file
"/nw/data/pgdata/pg_clog/0000": No such file or directory

Now looking at the postgres logfile it also says (meaning
that it removed the log file thinking it was safe to
remove it):

Thu Sep 23 07:40:02 2004: LOG: removing file
"/nw/data/pgdata/pg_clog/0000"
What might be causing this error to occur?

Thanks..
Amin

---------------------------(end of
broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Adam Haberlach | last post: by
1 post views Thread by A Palmblad | last post: by
1 post views Thread by Steve Wolfe | last post: by
reply views Thread by Steve Wolfe | last post: by
reply views Thread by abhamani | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.