Postgres Pro
Downloads
Home   >   mailing lists

pg_clog corruption? - Mailing list pgsql-general

From A Palmblad
Subject pg_clog corruption?
Date
Msg-id 004001c42302$172eb420$97019696@AERS04
Whole thread Raw
Responses Re: pg_clog corruption?
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Sebastian Böck
Date:
Subject: Re: Problems with Triggers
Next
From: "Development - multi.art.studio"
Date:
Subject: Re: performance problem aftrer update from 7.1 to 7.4.2