Skip site navigation (1) Skip section navigation (2)

BUG #2113: PostgreSQL hangs after running for 2 days

From: "Wojciech Sobczuk" <wojtek(at)brandlay(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2113: PostgreSQL hangs after running for 2 days
Date: 2005-12-14 16:17:10
Message-ID: 20051214161710.1C861F0B08@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2113
Logged by:          Wojciech Sobczuk
Email address:      wojtek(at)brandlay(dot)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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-12-14 16:32:08
Subject: Re: BUG #2112: query kills db thread
Previous:From: Tom LaneDate: 2005-12-14 04:15:10
Subject: Re: BUG #2112: query kills db thread

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group