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