Feng Chen wrote:
> We also have the same exact problem - every 5 to 10 days when the data
> get to some size, PostgreSQL complains about missing pg_clog files, and
> invalid page headers during either vacuum or reindex operations.
>
> The problem happens on different customer sites with Linux 2.6.11.
>
> There is one particular table that is much more heavily used - 99%
> inserts, some selects. And this table turns to be the one having
> problems.
>
> If this happens at different companies so frequently, I'd doubt it's a
> hardware problem. And we did check the hardware but did not find any
> problems.
>
[...]
> 2007-08-13T10:12:07+00:00 ERROR: invalid page header in block 4018 of
> relation "calllegstart_sessionid"
> 2007-08-13T10:12:15+00:00 ERROR: could not access status of
> transaction 0
> 2007-08-13T10:12:15+00:00 DETAIL: could not create file
> "pg_subtrans/0201": File exists
what version of postgresql is this exactly ? there is a problem in older
8.1 versions that could cause this error under high transaction rates.
Stefan