From: | Brian Hurt <bhurt(at)janestcapital(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | ERROR: could not access status of transaction 575 |
Date: | 2008-06-17 16:11:31 |
Message-ID: | 4857E233.7010509@janestcapital.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)builder6(dot)centos(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma | 2008-06-17 16:13:42 | Re: Step 1 with Visual Basic |
Previous Message | Gabriele Messineo | 2008-06-17 15:12:26 | Re: PostgreSQL 8.3 temporary tables & stored functions |