Hi,
it means that a transaction isn't finished (commit/rollback). check your
application for long running operations or programmming errors.
tm
Mateus Interciso schrieb:
Hello, it's been a while that I'm seeing that our servers running JBoss
with PostgreSQL, after some hours of work, have at least 70 or more
"<IDLE> in transaction" status for transactions, and this is bogging down
our servers.
Is this normal behaviour? If not, is there anything I can do to prevent
it? Why is it happening? What's a transaction that is "<IDLE> in
transaction" actually really means?
Thanks a lot.
Mateus.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
begin:vcard
fn:Thomas Markus
n:Markus;Thomas
org:proventis GmbH
adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany
email;internet:t.markus@xxxxxxxxxxxxx
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 2: Don't 'kill -9' the postmaster
