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

Re: Idle transactions

From: Thomas Markus <t(dot)markus(at)proventis(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Idle transactions
Date: 2007-09-11 11:37:09
Message-ID: 46E67DE5.4080506@proventis.net (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

it means that a transaction isn't finished (commit/rollback). check your 
application for long running operations or programmming errors.

tm

Mateus Interciso schrieb:
> Hello, it's been a while that I'm seeing that our servers running JBoss 
> with PostgreSQL, after some hours of work, have at least 70 or more 
> "<IDLE> in transaction" status for transactions, and this is bogging down 
> our servers.
> Is this normal behaviour? If not, is there anything I can do to prevent 
> it? Why is it happening? What's a transaction that is "<IDLE> in 
> transaction" actually really means?
>
> Thanks a lot.
>
> Mateus.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly
>   



Attachment: t.markus.vcf
Description: text/x-vcard (266 bytes)

In response to

pgsql-admin by date

Next:From: Tino SchwarzeDate: 2007-09-11 11:39:28
Subject: Re: Idle transactions
Previous:From: Mateus IntercisoDate: 2007-09-11 11:15:54
Subject: Idle transactions

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