Zope hands when database takes too long to respond
Hello, We wrote an application (on Zope v2.7.6-final) that queries a MySQL database via ZMySQLDA v2.0.8. Whenever the MySQL server experiences heavy load, Zope seems to hang, such that we can't even access the ZMI. Is this a bug in version 2.7.6 or ZMySQLDA ? Or are there some settings I can tweak to adjust some database connection timeout value ? Regards, Danny
Whenever the MySQL server experiences heavy load, Zope seems to hang, such that we can't even access the ZMI.
Is this a bug in version 2.7.6 or ZMySQLDA ?
Seems that all your Zope threads are busy (they're waiting for database response). There is no more threads to serve next requests so they're waiting (you may say that zope hangs in this situation, but in fact all it's threads are waiting for DB). You may install DeadlockDebugger product and you'll be able to see what your's Zope threads are really doing.
Or are there some settings I can tweak to adjust some database connection timeout value ?
AFAIK not in Zope. Take a look at ZMySQLDA or rather the python MySQL library it uses. Maybe there is something like that. You may ask this question on Zope-DB list. -- Maciej Wisniowski
Sinang, Danny wrote:
Hello,
We wrote an application (on Zope v2.7.6-final) that queries a MySQL database via ZMySQLDA v2.0.8.
Whenever the MySQL server experiences heavy load, Zope seems to hang, such that we can't even access the ZMI.
DeadlockDebugger can confirm what your problem actually is.
Is this a bug in version 2.7.6 or ZMySQLDA ?
Likely neither.
Or are there some settings I can tweak to adjust some database connection timeout value ?
You might wanna ask on a MySQL list. Also follow others' advice to find out why you MySQL server isn't responding. cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk
participants (3)
-
Chris Withers -
Maciej Wisniowski -
Sinang, Danny