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: (view raw or whole 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:

I did find this:

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();
 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)


-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

Any and all help would be appreciated.  Thanks.



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-2015 The PostgreSQL Global Development Group