Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 86A769FA0D2 for ; Tue, 11 Sep 2007 09:33:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17233-09 for ; Tue, 11 Sep 2007 09:33:31 -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 173939FA075 for ; Tue, 11 Sep 2007 09:33:30 -0300 (ADT) Received: by p15105778.pureserver.info (Postfix, from userid 65534) id EC0BC440D8; Tue, 11 Sep 2007 14:33:52 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by server1.proventis.net (Postfix) with ESMTP id 340E4C44295; Tue, 11 Sep 2007 14:33:25 +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 29533-01; Tue, 11 Sep 2007 14:33:23 +0200 (CEST) Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130]) by server1.proventis.net (Postfix) with ESMTP id 30638C44291; Tue, 11 Sep 2007 14:33:23 +0200 (CEST) Message-ID: <46E68B13.4060404@proventis.net> Date: Tue, 11 Sep 2007 14:33:23 +0200 From: Thomas Markus Organization: proventis GmbH User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: Mateus Interciso Cc: pgsql-admin@postgresql.org Subject: Re: Idle transactions References: <20070911113928.GB26986@easy2.in-chemnitz.de> In-Reply-To: Content-Type: multipart/mixed; boundary="------------000002060304060403050606" X-Virus-Scanned: by amavisd-new at proventis.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/62 X-Sequence-Number: 26823 This is a multi-part message in MIME format. --------------000002060304060403050606 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit check your jboss log for stack traces. Mateus Interciso schrieb: > Thanks for your reply. > Is there any way on PostgreSQL that I can see the transaction that > haven't been commited? > > This would simplify the debugging. > > Thanks a lot. > > Mateus. > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > --------------000002060304060403050606 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 --------------000002060304060403050606--