Hi All,
I'm having a lot of trouble with MySQL connection which I've setup between ZPT and a MySQL server in our DC. The MySQL server is working without any problems as it is service many other applications in our envirenment without a problem.
I've setup a ZPT with collect some data from the MySQL server. But very often I get this error when accessing the ZPT:
--------------------------------------------------------------------
Site Error
An error was encountered while publishing this resource.
_mysql_exceptions.OperationalError
Sorry, a site error occurred.
Traceback (innermost last):
* Module ZPublisher.Publish, line 202, in publish_module_standard
* Module ZPublisher.Publish, line 161, in publish
* Module Zope2.App.startup, line 241, in abort
* Module transaction._manager, line 107, in abort
* Module transaction._transaction, line 569, in abort
* Module Shared.DC.ZRDB.TM, line 64, in abort
* Module Products.ZMySQLDA.db, line 633, in _abort
* Module Products.ZMySQLDA.db, line 519, in _query
OperationalError: (2006, 'MySQL server has gone away')
------------------------------------------------------------
That's strange because the MySQL server is working just fine. When I go into the ZMI and "close" and "open" the Z MySQL connection manually the ZPT is working again for only a few times.
Can somebody please help me with this problem?
Kind regards,
Ron
Z MySQL unstable
