I'm a Linux and Postgres newbie that need to figure out why I suddenly get this error message on my website:
Query failed: ERROR: could not access status of transaction 1935960436 DETAIL: Could not open file "pg_clog/0736": No such file or directory.
I have searched Google but failed to find anything useful. Is 0736 a special code error og actually a missing file?
In my postgres directory: var/lib/postgresql/8.2/main/pg_clog
I have the following files:
0000 0001 0002 0003 0004 0005 0006 0007 0008 0009 000a 000b 000c
It is only the forum page that fails to run in table debatforum.
On that table I can't run:
select * from debatforum - I get the above error
But I can run this:
select * from debatforum limit 1
So there must be some corrupt data I need to get rid of.
When trying to help then please tell me where to run any commands, e.g. vacuum in phpPgAdmin tool, or directly on the Linux prompt (I use puTTy to connect as root)