Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 84C7E9FA292 for ; Tue, 11 Sep 2007 10:44:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 64921-06 for ; Tue, 11 Sep 2007 10:44:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 2312F9FA2DB for ; Tue, 11 Sep 2007 10:44:17 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1IV62D-0000TI-Un for pgsql-admin@postgresql.org; Tue, 11 Sep 2007 15:44:10 +0200 Received: from c906d7f2.virtua.com.br ([201.6.215.242]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 11 Sep 2007 15:44:09 +0200 Received: from p.zarnick by c906d7f2.virtua.com.br with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 11 Sep 2007 15:44:09 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Mateus Interciso Subject: Re: Idle transactions Date: Tue, 11 Sep 2007 13:43:59 +0000 (UTC) Lines: 41 Message-ID: References: <20070911113928.GB26986@easy2.in-chemnitz.de> <46E68B13.4060404@proventis.net> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: c906d7f2.virtua.com.br User-Agent: Pan/0.132 (Waxed in Black) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/63 X-Sequence-Number: 26824 On Tue, 11 Sep 2007 14:33:23 +0200, Thomas Markus wrote: > 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 >> >> > begin:vcard > fn:Thomas Markus > n:Markus;Thomas > org:proventis GmbH > adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany > email;internet:t.markus@proventis.net tel;work:+49 30 29 36 399 22 > x-mozilla-html:FALSE > url:http://www.proventis.net > version:2.1 > end:vcard > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq There's no way to do it on PostgreSQL instead?