| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Wojciech Sobczuk" <wojtek(at)brandlay(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #2113: PostgreSQL hangs after running for 2 days |
| Date: | 2006-01-21 05:47:18 |
| Message-ID: | 13577.1137822438@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Wojciech Sobczuk" <wojtek(at)brandlay(dot)com> writes:
> 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 think we've identified the reason for this:
http://archives.postgresql.org/pgsql-committers/2006-01/msg00287.php
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shawn Dong | 2006-01-21 11:31:14 | BUG #2194: Start Script in the package doesn't work |
| Previous Message | Andras Got | 2006-01-21 00:53:37 | BUG #2193: INITCAP and LOWER/UPPER string conversion error |