On 07.05.2011 23:19, Tomasz Chmielewski wrote:
On 06.05.2011 10:42, Tomasz Chmielewski wrote:
bookstor=# SELECT 1 FROM core_wot_seq FOR UPDATE;
ERROR: could not access status of transaction 1573786613
DETAIL: Could not open file "pg_clog/05DC": No such file or directory.
How do I best recover from this? Stop postgres, create an empty, 256k
pg_clog/05DC file, start postgres?
Export table, drop table, import table? Anything else?
Nobody has a clue? :|
Just as a follow up, it turned out several sequences, and only sequences
were affected this way.
I used pg_dump to export these sequences, dropped the sequences, and
imported them again.
Unfortunately, the issue is back, and again, only affects sequences.
I'd be really grateful for any more ideas here (why it happens, how to
best recover from it)!
--
Tomasz Chmielewski
http://wpkg.org
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
