I am having trouble with MySQL connections not be closed.
Background:
Suse Linux 7.3
Zope 2.6.0
MySQL 4.0.12
Mysqldb 0.9.2
Starting a connection with connect(db='xxx',user='root') there is no trouble (max_connections in MySQL: 100).
When I start the connection with connect(db='xxx',host='xxxxx',user='root') the connection will not be closed and the connections seems to be persistent.
In our testfunction this results in "Error 1040: Too many connections" (max_connections in MySQL: 1000).
Is there any chance to use the host - parameter and connect non-persistent?
Any other ideas? Thanks in advance.
Susanne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I am having trouble with MySQL connections not be closed.
Background:
Suse Linux 7.3
Zope 2.6.0
MySQL 4.0.12
Mysqldb 0.9.2
Starting a connection with connect(db='xxx',user='root') there is no trouble (max_connections in MySQL: 100).
When I start the connection with connect(db='xxx',host='xxxxx',user='root') the connection will not be closed and the connections seems to be persistent.
In our testfunction this results in "Error 1040: Too many connections" (max_connections in MySQL: 1000).
Is there any chance to use the host - parameter and connect non-persistent?
Any other ideas? Thanks in advance.
Susanne
I don't have a direct answer for you, but have you tried just explicitly closing the connection in your code when you're done with it?
Greg
We fixed the problem:
In a special case in dependence from the host variable we forgott to close a connection...
Now everything works fine :-)