From: Jason DiCioccio <geniusj@...>
Date: 2002-11-29T00:34:29+09:00
Subject: ruby DBD::Pg disconnection

A pretty simple problem (to describe).  Basically what's happening is I 
made a SQLPool class to manage a pool of DBI connection handles.  I have a 
minimum amount of pool members and a maximum (similar to apache's MinSpare 
and MaxSpare)..  I am calling DBI::DatabaseHandle#disconnect on the handle 
if an attempt is made to push a handle back into the connection pool while 
there are more connections open than my minimum amount pool members.  The 
problem that I am having is that the connection doesn't seem to actually 
close.  I still see the postgres process in my process list.  It appears to 
just call PQFinish, but I'm not familiar enough with the postgresql apis to 
know if this is correct.  It appears correct, but the connections are not 
actually being disconnected, so I have to assume that there's something 
wrong :)..

Is anyone else having a similar problem?  A solution? :)

Thanks!
-JD-

--
Jason DiCioccio     - jd@bluenugget.net  - Useless .sig
Open Domain Service - geniusj@ods.org    - http://www.ods.org/
Ruby                - jd@ruby-lang.org   - http://www.ruby-lang.org/

PGP Fingerprint - C442 04E2 26B0 3809 8357  96AB D350 9596 0436 7C08