Discussion:
pg_clog error after crash
(too old to reply)
Sandro Dentella
2004-06-30 15:59:19 UTC
Permalink
After a crash of the (frozen) system, postgreSQL issues a message:

2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia
2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129
DETAIL: could not open file "/var/lib/postgres/data/pg_clog/0EF1": No such file or directory


when trying to acces a db.

I'm really clueless as I didn't find anything usefull with google to fix
it. The db is very little, and I'm the only one that writes on it, so I know
there shouldn't be real problems ignoring the transaction, but I don't know
what to say postgreSQL to ingore it.

Should I recreate an empty file?

TYA

sandro
*:-)


PS: can you cc to me too, I'm not on this list. Thanks
--
Sandro Dentella *:-)
e-mail: ***@e-den.it
http://www.tksql.org TkSQL Home page - My GPL work

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)
Tom Lane
2004-07-01 22:05:17 UTC
Permalink
Post by Sandro Dentella
2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia
2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129
DETAIL: could not open file "/var/lib/postgres/data/pg_clog/0EF1": No such file or directory
It looks like you've got data corruption in one of the system catalogs
that is accessed during backend startup. This is not good :-(.
Do you get the same no matter which of the databases in your
installation you try to connect to? (Not that it will matter much,
if all your important data is in this database...)

You may have little choice but to restore from your last backup.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Scott Marlowe
2004-07-01 22:14:09 UTC
Permalink
Post by Sandro Dentella
2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia
2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129
DETAIL: could not open file "/var/lib/postgres/data/pg_clog/0EF1": No such file or directory
when trying to acces a db.
I'm really clueless as I didn't find anything usefull with google to fix
it. The db is very little, and I'm the only one that writes on it, so I know
there shouldn't be real problems ignoring the transaction, but I don't know
what to say postgreSQL to ingore it.
Should I recreate an empty file?
What version are you running?


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

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

Loading...