Postgres Pro
Downloads
Home   >   mailing lists

PGSQL 7.4.8 : idle in transaction problem - Mailing list pgsql-admin

From FM
Subject PGSQL 7.4.8 : idle in transaction problem
Date
Msg-id 42DD5955.8000501@lexum.umontreal.ca
Whole thread Raw
Responses Re: PGSQL 7.4.8 : idle in transaction problem  (Peter Eisentraut <peter_e@gmx.net>)
Re: PGSQL 7.4.8 : idle in transaction problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PGSQL 7.4.8 : idle in transaction problem  (imi <linimi@gmail.com>)
Re: PGSQL 7.4.8 : idle in transaction problem  (imi <linimi@gmail.com>)
List pgsql-admin
Tree view 
Hello,

We are using JBOSS and postgresql on 1 database (DB1). From time to time
the JBOSS process  <idle in transaction>.

What is strange is that users on all DB (not only DB1) are affected by
the JBOSS <idle in transaction>.
I understand that it locked DB1 but why it also locked users on others DB ?

Thanks !

pgsql-admin by date:

Previous
From: Dirk Lutzebäck
Date:
Subject: Re: dump/restore needed when switching from 32bit to 64bit
Next
From: Peter Eisentraut
Date:
Subject: Re: dump/restore needed when switching from 32bit to 64bit