Thread: [IDLE in TRANSACTION] when I do TOP -c
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?
Thanks in advance for your help,
Fabrice
O Fabrice.Sznajderman@devoteam.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
Thanks for your help!
I using WebSphere Portal Server to acces postgres database.
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@matrix.gatewaynet.com> Envoyé par : pgsql-jdbc-owner@postgresql.org 05/01/2006 17:15 |
|
O Fabrice.Sznajderman@devoteam.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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
O Fabrice.Sznajderman@devoteam.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@matrix.gatewaynet.com> > EnvoyΓ© par : pgsql-jdbc-owner@postgresql.org > 05/01/2006 17:15 > > A > Fabrice.Sznajderman@devoteam.com > cc > pgsql-jdbc@postgresql.org > Objet > Re: [JDBC] [IDLE in TRANSACTION] when I do TOP -c > > > > > > > O Fabrice.Sznajderman@devoteam.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
I can't stop Websphere cause it is in production mode.. :-(
Achilleus Mantzios <achill@matrix.gatewaynet.com> Envoyé par : pgsql-jdbc-owner@postgresql.org 05/01/2006 18:18 |
|
O Fabrice.Sznajderman@devoteam.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@matrix.gatewaynet.com>
> EnvoyΓ© par : pgsql-jdbc-owner@postgresql.org
> 05/01/2006 17:15
>
> A
> Fabrice.Sznajderman@devoteam.com
> cc
> pgsql-jdbc@postgresql.org
> Objet
> Re: [JDBC] [IDLE in TRANSACTION] when I do TOP -c
>
>
>
>
>
>
> O Fabrice.Sznajderman@devoteam.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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Fabrice.Sznajderman@devoteam.com wrote: > 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? Each process corresponds to a single client connection to the database. "idle in transaction" means that connection has a transaction open but is not currently doing any work. If I had to guess at the cause of this I'd say that you are using a connection pool and a 7.4 driver. The JDBC driver would cause these idle transactions itself (mostly harmlessly) in 7.4 and earlier releases when autocommit was off: a commit or rollback would automatically start a new transaction even before any queries had been run. With 8.0 and later drivers a new transaction is only started when the first query after a commit or rollback is done, so if you are using these drivers it probably indicates an application bug where it is not correctly closing transactions it begins. -O