BUG #2113: PostgreSQL hangs after running for 2 days - Mailing list pgsql-bugs

From Wojciech Sobczuk
Subject BUG #2113: PostgreSQL hangs after running for 2 days
Date
Msg-id 20051214161710.1C861F0B08@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #2113: PostgreSQL hangs after running for 2 days
Re: BUG #2113: PostgreSQL hangs after running for 2 days
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2112: query kills db thread
Next
From: "David S. Edwards"
Date:
Subject: BUG #2115: If we CLOSE a Closed Cursor subsequent OPENs fail.