back-sql: postgres: idle in transaction

[Nikola Ivancevic <nikola@vtkom.net>]

Hi everybody,

I have installed openLDAP 2.2.6 with back-sql backend. Platform is 
redhat 9.0, sql server is postgresql-7.3.2, ODBC driver is iodbc-3.0.6.
In the first, everything was fine. Slapd has been initiated from initV 
script. After a half of a day or so, I have noticed that slapd is 
running no more. It had suddenlly stop working without leaving any 
'error' notice in the logs. I tried to increase loglevel (hoping to 
catch the reason of the crash) but without any success. Slapd still 
stops working without any visible reason after a few hours.
Only thing I have noticed that there are number of postgres threads in 
sleeping state.

ldap     15566  0.0  0.7 28496 4064 ?        S    18:23   0:24 
/usr/sbin/slapd -u ldap -h ldap:/// -l daemon
postgres 15616  0.0  0.6  8308 3496 ?        S    18:23   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 16120  0.0  0.6  8308 3496 ?        S    18:26   0:04 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 18325  0.0  0.6  8308 3504 ?        S    18:43   0:02 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 19449  0.0  0.6  8308 3492 ?        S    18:51   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 19451  0.0  0.6  8308 3492 ?        S    18:51   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 19452  0.0  0.6  8308 3496 ?        S    18:51   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 19453  0.0  0.6  8308 3496 ?        S    18:51   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 19458  0.0  0.6  8308 3496 ?        S    18:51   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 19459  0.0  0.6  8308 3496 ?        S    18:51   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 21007  0.0  0.6  8308 3500 ?        S    19:05   0:01 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 22660  0.0  0.6  8308 3500 ?        S    19:18   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 22661  0.0  0.6  8308 3496 ?        S    19:18   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres 30672  0.0  0.6  8308 3496 ?        S    19:53   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres  7322  0.0  0.6  8180 3392 ?        S    20:29   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
postgres  7323  0.0  0.6  8276 3456 ?        S    20:29   0:00 postgres: 
pgldap isp 10.193.0.3 idle in transaction
root     12728  0.0  0.2  5084 1472 pts/1    R    20:43   0:00 ps -aux
postgres 12731  0.0  0.6  8308 3484 ?        R    20:43   0:00 postgres: 
pgldap isp 10.193.0.3 SELECT

Who produces  this 'idle in transaction' processes? Any idea?
Thanks in advance

Nikola Ivancevic
nikola@vtkom.net