| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: "Idle in Transaction" revisited. |
| Date: | 2004-09-18 00:55:39 |
| Message-ID: | 414B878B.1060801@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Tom Lane wrote:
> "John R Pierce" <pierce(at)hogranch(dot)com> writes:
>
>>We've been running into a *lot* of problems with "Idle in Transaction"
>>threads causing long term blockage of VACUUM's ability to free up dead rows.
>
>
> Yeah, that's from prematurely issuing BEGIN. I believe there's a
> solution for this in the most recent JDBC driver versions --- but
> I dunno if it's in any official releases yet.
The "development driver" versions on jdbc.postgresql.org have this fixed
as part of the V3 overhaul. I'm not sure about the driver that's in the
7.4 tree.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-09-18 07:24:28 | Re: "Idle in Transaction" revisited. |
| Previous Message | John R Pierce | 2004-09-18 00:53:27 | Re: "Idle in Transaction" revisited. |