This is a multi-part message in MIME format.
--------------000002020402020404080104
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
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 im****tant data on it. Losing the whole
database would rank no higher than annoying, and this would mean that
production, running on ****ny 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@[EMAIL PROTECTED]
) (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
--------------000002020402020404080104
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Hello all-<br>
<br>
I'm getting an error on a Postgres database when I access a table:<br>
<br>
<tt>
<blockquote type="cite">template0=# select * from pg_language;<br>
ERROR: could not access status of transaction 575<br>
DETAIL: could not open file "pg_clog/0000": No such file or
directory<br>
template0=#</blockquote>
<br>
</tt>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:<br>
<a class="moz-txt-link-freetext"
href="http://archives.postgresql.org/pgsql-bugs/2007-07/msg00152.php">http://archives.postgresql.org/pgsql-bugs/2007-07/msg00152.php</a><br>
<br>
I did find this:<br>
<a class="moz-txt-link-freetext"
href="http://archives.postgresql.org/pgsql-bugs/2007-07/msg00124.php">http://archives.postgresql.org/pgsql-bugs/2007-07/msg00124.php</a><br>
<br>
Which looks like the same problem. However, reindexing doesn't seem
to
help me.<br>
<br>
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 im****tant data on it. Losing the whole
database would rank no higher than annoying, and this would mean that
production, running on ****ny new hardware, isn't likely to be
affected.<br>
<br>
More information:<br>
<br>
<tt><>template0=# select version();<br>
version <br>
------------------------------------------------------------------------------------------------------------<br>
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)<br>
(1 row)<br>
<br>
template0=#<br>
<br>
-bash-3.1$ cat /proc/version<br>
Linux version 2.6.18-53.1.4.el5 (<a class="moz-txt-link-abbreviated"
href="mailto:mockbuild@[EMAIL PROTECTED]
">mockbuild@[EMAIL PROTECTED]
>)
(gcc
version 4.1.2 20070626 (Red Hat 4.1.2-14)) #1 SMP Fri Nov 30 00:45:55
EST 2007<br>
-bash-3.1$<br>
<br>
</></tt>Any and all help would be appreciated. Thanks.<br>
<br>
Brian<br>
<br>
</body>
</html>
--------------000002020402020404080104--
|
