ERROR: could not access status of transaction 210
От | Scott Cain |
---|---|
Тема | ERROR: could not access status of transaction 210 |
Дата | |
Msg-id | 1101747603.3269.42.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: ERROR: could not access status of transaction 210
|
Список | pgsql-general |
Hello, After dropping a database, recreating it and trying to add a table to it, I am getting this message: NOTICE: CREATE TABLE will create implicit sequence "tableinfo_tableinfo_id_seq" for "serial" column "tableinfo.tableinfo_id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tableinfo_pkey" for table "tableinfo" NOTICE: CREATE TABLE / UNIQUE will create implicit index "tableinfo_c1" for table "tableinfo" ERROR: could not access status of transaction 210 DETAIL: could not open file "/opt/postgres/data/pg_clog/0000": No such file or directory ERROR: relation "tableinfo" does not exist 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. It is entirely possible that the database was not shut down properly a few times as I have been working out the kinks in this system. 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: chado=# \dt ERROR: could not access status of transaction 45 DETAIL: could not open file "/opt/postgres/data/pg_clog/0000": No such file or directory Thanks much, Scott -- ------------------------------------------------------------------------ Scott Cain, Ph. D. cain@cshl.org GMOD Coordinator (http://www.gmod.org/) 216-392-3087 Cold Spring Harbor Laboratory
В списке pgsql-general по дате отправления: