The following bug has been logged online:
Bug reference: 2113
Logged by: Wojciech Sobczuk
Email address: wojtek@brandlay.com
PostgreSQL version: 8.0.3
Operating system: FreeBSD 5.4-RELEASE-p1
Description: PostgreSQL hangs after running for 2 days
Details:
I have a 16GB database which is very busy (100 requests per second). After
running for some time (sometimes 2 days sometimes longer sometimes shorter)
postgres hangs. Last time it happened I got the following error in the
log:
ERROR: could not access status of transaction 0
DETAIL: could not create file "/opt/pgdata/pg_subtrans/6E75": File
exists
STATEMENT: SET DATESTYLE TO 'ISO'
WARNING: StartTransaction while in START state
I'm running postgres on 3 RAID 1 arrays, with various tables scattered over
the arrays (using tablespaces) for more speed. The space usage for those
arrays is less than 16% so it is not a space issue. The machine never
reboots/hangs/etc. so it seems to be a postgres issue. If you have further
questions please let me know.
Regards