Comment 2 for bug 487076

Have a couple questions for you that may resolve the problem.

Not sure what your default connection timeout is on your server but have you tried setting

>> PySQLPool.PySQLConnection.connection_timeout = datetime.timedelta(seconds=20)

By default this is set to 20secs, and may be whats causing the connection loss. This var is the check interval that PySQLPool uses to figure out when to validate the connections to see if they may be dead. From the looks of your code this might not be it bases on the number of queries you are performing per sec.

Also what version are you using. Is it the current downloaded tar/zip or the latest trunk check out. If its the latest download we do have a bunch of threading issues that have just recently been resolved that may be the cause to this error. They are currently sitting in the trunk as of last night. I will push out the actual release in for form of a Download and PyPi install sometime tonight.

I will also continue to investigate this from my side as well.