|
Home > Archive > PostgreSQL JDBC > January 2006 > [IDLE in TRANSACTION] when I do TOP -c
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
[IDLE in TRANSACTION] when I do TOP -c
|
|
| Fabrice.Sznajderman@devoteam.com 2006-01-05, 9:23 am |
| 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
+---------------------------------------------------------------------+
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 Mantzios 2006-01-05, 9:23 am |
| 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
| |
| Fabrice.Sznajderman@devoteam.com 2006-01-05, 9:23 am |
| 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
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 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Achilleus Mantzios 2006-01-05, 11:24 am |
| 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 :
>
>
> 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.
>
>
>
--
-Achilleus
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Fabrice.Sznajderman@devoteam.com 2006-01-05, 11:24 am |
| 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
A
Fabrice. Sznajderman@devoteam
.com
cc
pgsql-jdbc@postgresql.org, <pgsql-jdbc-owner@postgresql.org>
Objet
Re: [JDBC] [IDLE in TRANSACTION] when I do TOP -c
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 :
>
Database.
[color=darkred]
>
> 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.
>
+---------------------------------------------------------------------+
[color=darkred]
Nexteconomy,
[color=darkred]
+---------------------------------------------------------------------+
[color=darkred]
>
>
--
-Achilleus
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Oliver Jowett 2006-01-05, 8:25 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
|
|
|
|