We are using Apache mod_perl, DBI and DBD::Sybase to connect to our Sybase
db.
Even though we are opening connections and then closing connections the
TCP/IP connections are staying in an ESTABLISHED state for a long unknown
period of time.
>From looking at the DBD::Sybase disconnect code, it appears that the
disconnect is not implemented (please correct me if I am wrong about this).
i.e. we simply lose the handle to the connection. This causes the problem
that once the maximum number of user connections has been reached we can
longer connect to the Sybase server until these connections timeout.
We have tried to implement DB pooling, but since Apache spawns and kills
threads quite regularly, we still hit the same problem.
Has anyone heard of or know about this? If so does anyone have a solution?
Cheers
Jules
