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

Поиск
Список
Период
Сортировка
От Achilleus Mantzios
Тема Re: [IDLE in TRANSACTION] when I do TOP -c
Дата
Msg-id Pine.LNX.4.44.0601051813430.8588-100000@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на [IDLE in TRANSACTION] when I do TOP -c  (Fabrice.Sznajderman@devoteam.com)
Ответы Re: [IDLE in TRANSACTION] when I do TOP -c  (Fabrice.Sznajderman@devoteam.com)
Список pgsql-jdbc
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


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kyle R Morse/Eden
Дата:
Сообщение: Out Parameter Support
Следующее
От: Fabrice.Sznajderman@devoteam.com
Дата:
Сообщение: Re: [IDLE in TRANSACTION] when I do TOP -c