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

Re: [IDLE in TRANSACTION] when I do TOP -c

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Fabrice(dot)Sznajderman(at)devoteam(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org, <pgsql-jdbc-owner(at)postgresql(dot)org>
Subject: Re: [IDLE in TRANSACTION] when I do TOP -c
Date: 2006-01-05 17:18:47
Message-ID: Pine.LNX.4.44.0601051917480.8588-100000@matrix.gatewaynet.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
O Fabrice(dot)Sznajderman(at)devoteam(dot)com έγραψε στις Jan 5, 2006 :

> Thanks for  your help!
> 
>  I using WebSphere Portal Server to acces postgres database. 

May its the Websphere.

Shutdown Websphere, and then do:
psql,
begin;

then from another window do top.
You see an idle in transaction again right?


> 
> the Postgres Database is fill up by Redhat CCM - CMS.
> 
> So you think this message is not important for the database Performance?
> 
> Fabrice SZNAJDERMAN
> 
> DSI : Application Rendez-Vous - CCM
> tel : 01 41 49 60 77
> 
> 
> 
> Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> 
> EnvoyΓ© par : pgsql-jdbc-owner(at)postgresql(dot)org
> 05/01/2006 17:15
> 
> A
> Fabrice(dot)Sznajderman(at)devoteam(dot)com
> cc
> pgsql-jdbc(at)postgresql(dot)org
> Objet
> Re: [JDBC] [IDLE in TRANSACTION] when I do TOP -c
> 
> 
> 
> 
> 
> 
> O Fabrice(dot)Sznajderman(at)devoteam(dot)com έγραψΡ στις Jan 5, 2006 :
> 
> > Hello,
> > 
> > 
> > I look the processes on my server where was installed Postgres Database.
> > I can saw, when I do top command, many process named : idle in 
> > transaction.
> > 
> > What happend with this process? what is the cause of this message?
> 
> Maybe its some connection pool that causes this.
> Have you installed and running jboss?? I know 3.x is behaving like that.
> Generally its not a bad thing to worry about.
> 
> > 
> > Thanks in advance for your help,
> > 
> > Fabrice
> > 
> > 
> > +---------------------------------------------------------------------+
> > About Devoteam:
> > 
> > Devoteam is an IT consulting group.
> > Combining consulting and technology solutions offers enables
> > Devoteam to provide its customers with independent advice and
> > effective solutions to align their information system's technical
> > infrastructure with their operational objectives.
> > The group achieved a turnover of 150 million euros in 2004
> > an operating margin of 5.8% and counts 1,800 employees through
> > ten European countries and the Middle East.
> > Listed on the Euronext Paris Nouveau Marche and part of the Nexteconomy,
> > IT CAC, IT CAC 50, SBF 250 index of Euronext Paris.
> > www.devoteam.com
> > +---------------------------------------------------------------------+
> > 
> 
> 

-- 
-Achilleus


In response to

Responses

pgsql-jdbc by date

Next:From: Markus PoppDate: 2006-01-05 21:49:44
Subject: Fw: Re: GROUP_CONCAT in PostgreSQL
Previous:From: Fabrice.SznajdermanDate: 2006-01-05 16:19:04
Subject: Re: [IDLE in TRANSACTION] when I do TOP -c

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