Re: ERROR: could not access status of transaction 210

From: Scott Cain <cain(at)cshl(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not access status of transaction 210
Date: 2004-11-29 18:01:54
Message-ID: 1101751315.3269.58.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Mon, 2004-11-29 at 12:57 -0500, Tom Lane wrote:
> Scott Cain <cain(at)cshl(dot)org> writes:
> > After dropping a database, recreating it and trying to add a table to
> > it, I am getting this message:
> > ERROR: could not access status of transaction 210
> > DETAIL: could not open file "/opt/postgres/data/pg_clog/0000": No such file or directory
> > There is a file call 0001 in pg_clog, but not 0000. This is a
> > relatively new install of PostgreSQL 7.4.6 built from source on a
> > similarly new install of Fedora Core 3.
> Hmm, are you sure it's 7.4.6 and has been 7.4.6 for the whole existence
> of the data directory? This looks like a hint-bit-drop problem, which
> I thought we had fixed the last of as of 7.4.6.

Yes--when I installed 7.4.6, I did a fresh install of Pg
at /opt/postgres, whereas the previous install was at /home/postgres.
> > So, what can I do to get rid of this? I already dropped the database
> > (which I can do successfully) and created an empty database in its
> > place, but I can't add any tables to it. Also, when I do a '\dt' in
> > that empty database, I get a similar message:
> Apparently you've got hint-bit corruption in template1. I'd recommend a
> fresh initdb. If you're desperate to avoid that because you have other
> databases that aren't broken, you could reconstruct template1 from
> template0 (see for the procedural details).

I'll do a fresh initdb--this is a development machine (thankfully), so
the databases on it are just for testing. If you don't hear back--all
went well.


> regards, tom lane
Scott Cain, Ph. D. cain(at)cshl(dot)org
GMOD Coordinator ( 216-392-3087
Cold Spring Harbor Laboratory

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joachim Zobel 2004-11-29 18:10:35 Triggers and INHERITS
Previous Message Tom Lane 2004-11-29 17:57:06 Re: ERROR: could not access status of transaction 210