Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Richard BroersmaDate: 2008-06-17 16:13:42
Subject: Re: Step 1 with Visual Basic
Previous:From: Gabriele MessineoDate: 2008-06-17 15:12:26
Subject: Re: PostgreSQL 8.3 temporary tables & stored functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group