Re: ERROR: could not access status of transaction 575

Brian Hurt wrote:

>
> Hello all-
>
> I'm getting an error on a Postgres database when I access a table:
>
>> template0=# select * from pg_language;
>> ERROR: could not access status of transaction 575
>> DETAIL: could not open file "pg_clog/0000": No such file or directory
>> template0=#
>

More information: I did (as postgres):

dd bs=49152 count=1 if=/dev/zero of=/database/postgres/pg_clog/0000

to create the clog file (49152 is the size of
/database/postgres/pg_clog/0001), then fixed the permissions (chmod 0600
/database/postgres/pg_clog/0000). This seems to have fixed the problem.

The partition is on a Areca raid control, and some playing with the
areca cli didn't turn up any HD errors. We're running bonnie++ on the
partition to see if it detects any errors.

Brian