ERROR: could not access status of transaction 575

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

Responses

Browse pgsql-novice by date

  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