Hello all-
I'm getting an error on a Postgres database when I access a table:
template0=# select * from pg_language;
ERROR: could not access status of transaction 575
DETAIL: could not open file "pg_clog/0000": No such file or directory
template0=#
Unfortunately, as you can tell, this is causing problems, especially with creating new databases. I'm wondering if anyone knows what the problem could be. Doing some googling turns up a bug with 7.4 (this is 8.11), and this:
http://archives.postgresql.org/pgsql-bugs/2007-07/msg00152.php I did find this:
http://archives.postgresql.org/pgsql-bugs/2007-07/msg00124.php Which looks like the same problem. However, reindexing doesn't seem to help me.
Please, oh please, someone tell me that it's a hardware problem- this particular database is a development database running on dodgy second-hand hardware with no important data on it. Losing the whole database would rank no higher than annoying, and this would mean that production, running on shiny new hardware, isn't likely to be affected.
More information:
<>template0=# select version();
version
------------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.11 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-14)
(1 row)
template0=#
-bash-3.1$ cat /proc/version
Linux version 2.6.18-53.1.4.el5 (mockbuild@builder6.centos.org) (gcc version 4.1.2 20070626 (Red Hat 4.1.2-14)) #1 SMP Fri Nov 30 00:45:55 EST 2007
-bash-3.1$
Any and all help would be appreciated. Thanks.
Brian