Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 313BF9F9A0B for ; Tue, 11 Sep 2007 08:37:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 67846-03 for ; Tue, 11 Sep 2007 08:37:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from p15105778.pureserver.info (p15105778.pureserver.info [217.160.133.184]) by postgresql.org (Postfix) with ESMTP id 3000F9F99CC for ; Tue, 11 Sep 2007 08:37:13 -0300 (ADT) Received: by p15105778.pureserver.info (Postfix, from userid 65534) id A6101440D5; Tue, 11 Sep 2007 13:37:36 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by server1.proventis.net (Postfix) with ESMTP id 91966C44292 for ; Tue, 11 Sep 2007 13:37:09 +0200 (CEST) Received: from server1.proventis.net ([127.0.0.1]) by localhost (server1.proventis.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28828-07 for ; Tue, 11 Sep 2007 13:37:09 +0200 (CEST) Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130]) by server1.proventis.net (Postfix) with ESMTP id 3F868C44291 for ; Tue, 11 Sep 2007 13:37:09 +0200 (CEST) Message-ID: <46E67DE5.4080506@proventis.net> Date: Tue, 11 Sep 2007 13:37:09 +0200 From: Thomas Markus Organization: proventis GmbH User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Idle transactions References: In-Reply-To: Content-Type: multipart/mixed; boundary="------------010207090400010406040906" X-Virus-Scanned: by amavisd-new at proventis.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/59 X-Sequence-Number: 26820 This is a multi-part message in MIME format. --------------010207090400010406040906 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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 > " 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 " 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@postgresql.org so that your > message can get through to the mailing list cleanly > --------------010207090400010406040906 Content-Type: text/x-vcard; charset=utf-8; name="t.markus.vcf" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="t.markus.vcf" YmVnaW46dmNhcmQNCmZuOlRob21hcyBNYXJrdXMNCm46TWFya3VzO1Rob21hcw0Kb3JnOnBy b3ZlbnRpcyBHbWJIDQphZHI6OztaaW1tZXJzdHIuIDc5LTgwO0JlcmxpbjtCZXJsaW47MTAx MTc7R2VybWFueQ0KZW1haWw7aW50ZXJuZXQ6dC5tYXJrdXNAcHJvdmVudGlzLm5ldA0KdGVs O3dvcms6KzQ5IDMwIDI5IDM2IDM5OSAyMg0KeC1tb3ppbGxhLWh0bWw6RkFMU0UNCnVybDpo dHRwOi8vd3d3LnByb3ZlbnRpcy5uZXQNCnZlcnNpb246Mi4xDQplbmQ6dmNhcmQNCg0K --------------010207090400010406040906--