After trying a vacuum of a table, the following error has been occurring:
aers=# vacuum XXXXXX;
ERROR: could not access status of transaction 4290052110
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0FFB": No such file or directory
This error will be repeated every time the vacuum is run. We have some suspicions about the RAID controller in the server, but at the moment I'm wondering how to get around this error and complete the vacuum. Zero_damaged_pages is on.
- Adam Palmblad