mysql-python and mod_python bug?

Message

Shiner_Man · Post by **Shiner_Man** » Fri Apr 22, 2005 3:30 pm

From the mod_python FAQ:

If your mod_python scripts run for a while then you see:

[Wed Mar 09 17:44:22 2005] [error] [client 192.168.1.117] PythonHandler mod_python.publisher: OperationalError: (1040, 'Too many connections'), referer: ...

The problem may be in MySQLdb. A widely distributed version (ships with Fedora Core #3, probably others) has an error which causes python's garbage collector to not destroy old connections. This won't matter on a short-lived python process but mod_python is another story.

To see if this may be the problem run "mysqladmin processlist" before and after a few refreshes of your DB accessing pages. The # of connections _should_ stay stable. If it grows and grows, you could patch connections.py and burn a few hours.

Best to get the latest CVS version of MySQLdb from sourceforge. The error has been corrected but a fixed version has not been released.

I think I may be suffering from this bug.

I have the latest stable version of mysql-python installed(1.0.0). I didn't see anything in the bugs section or changelog dealing with this bug. Has this been fixed in any of the masked versions?

Shiner_Man · Post by **Shiner_Man** » Fri Apr 22, 2005 9:13 pm

After some testing, it seems the masked version of mysql-python(1.2.0) does not suffer from this bug but 1.0.0 does and will eventually cause mysql to crash. I'm filing a bug.