|
Hello, I have a really weird problem; queries against a very large
table are failing against a very large table with a strange error. Case
in point: dqfull=# vacuum freeze mytable; ERROR: could not access status of transaction
538989714 DETAIL: could not open file
"/srv/db/postgresql/pg_clog/0202": No such file or directory WTF? The only activity this table has seen is a
massive data import of around ~40M rows. Is there a way to fix clog info
and make it think all transactions on it have committed? (Note: I tried a
VACUUM FREEZE after other commands were failing) What’s a good
strategy to fix this table. I’d prefer to not have to reload it since
that will take over 1 day. Logan Bowers |
