PGSQL 7.4.8 : idle in transaction problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Mailing List Postgres-Admin <pgsql-admin@xxxxxxxxxxxxxx>
Subject: PGSQL 7.4.8 : idle in transaction problem
From: FM <dist-list@xxxxxxxxxxxxxxxxxx>
Date: Tue, 19 Jul 2005 15:49:41 -0400
User-agent: Mozilla Thunderbird 1.0.2 (X11/20050328)

Hello,

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

What is strange is that users on all DB (not only DB1) are affected bythe JBOSS <idle in transaction>.

I understand that it locked DB1 but why it also locked users on others DB ?

Thanks !

Follow-Ups:
- Re: PGSQL 7.4.8 : idle in transaction problem
  - From: imi
- Re: PGSQL 7.4.8 : idle in transaction problem
  - From: Tom Lane
- Re: PGSQL 7.4.8 : idle in transaction problem
  - From: Peter Eisentraut

Prev by Date: Re: dump/restore needed when switching from 32bit to 64bit
Next by Date: Re: dump/restore needed when switching from 32bit to 64bit
Previous by thread: how to load a .backup file
Next by thread: Re: PGSQL 7.4.8 : idle in transaction problem
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux