database connections not closing

[webdzine]

my host has sent me an email saying that the software i am using is not closing the connection to the database.
what can i do?

[rfuess]

What software language are you using? That will help use answer in a more meaningful way. I normally program in C# and we have try/catch blocks (like php has). Most who use MySql are programming in php.

When I put the database connection I put it in the "try" part. If there is an error - it falls to the "catch" section. You can optionally use a "finally" clause that is ALWAYS run. Here in the finally section is where I put my database close events. EVEN if there is an ERROR - the connection gets closed.

[webdzine]

we use mysql with php

[danlefree]

Is it possible that your application is configured to use Persistent Database Connections? Check the application manual and configuration (or search the codebase for calls to mysql_pconnect()).

[webdzine]

we made sure they are off

[williamc]

Originally Posted by danlefree

search the codebase for calls to mysql_pconnect()

If you have verified that persistant connections are off in the config, what danlefree suggested, quoted above, is the next step. If your code is using mysql_pconnect() rather than mysql_connect() it could cause you problems like you are seeing. The other options would be 1) catching/trapping errors as rfuess suggested, or optionally 2) making sure you manually close the db connection after running in every call in your scripts. PHP is self cleaning when it comes to this, so it may be that the call is not being finished and the script execution is timing out or just dying before php can clean up, in which case trapping may be the most viable solution for debugging.

[netroact]

Did your host offer any assistance? They should have been all over this.

[nickoran]

Are you using a CMS like Joomla?, and have you recently installed anynew scripts? I had the same problem with a certain module in Joomla and just installed a different version of the module to get rid of the problem.