From: | "Logan Bowers" <logan(at)zillow(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Clog/Transaction problems |
Date: | 2005-08-05 20:52:29 |
Message-ID: | 85CE4E3FD2EC2C4E8AAE39916AC1A38306BE6AF4@ms07.mse2.exchange.ms |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Yudie Pg | 2005-08-05 20:58:15 | Re: How to join function with a table? |
Previous Message | Pascual De Ruvo | 2005-08-05 20:06:17 | Re: How to join function with a table? |