[Zope-DB] ZMySQLDA reconnecting

Frank Tegtmeyer fte-sub-zope-db@fte.to
08 May 2002 13:19:59 +0200


Hi,

I have three MySQL connections defined that are used for different
purposes. To track down some Zope crashes I enabled debugging mode. In
the logs I saw that the connections are closed and reopened very
often.

Does anybody know why this happens?

Here some details:
ZMySQLDA-2.0.9b2
MySQL-python-0.9.2b2
no transactions enabled
Zope 2.4.3
Python 2.1.1
MySQL 3.23.41

the log:
2002-05-08T11:03:15 INFO(0) ZMySQLDA Opened new connection <open connection to 'xxxxx.xxxxxx.de' at 40db6218>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd
------
2002-05-08T11:04:08 INFO(0) ZMySQLDA Closing connection <open connection to 'xxxxx.xxxxxx.de' at 8f239f8>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd
------
2002-05-08T11:04:17 INFO(0) ZMySQLDA Opened new connection <open connection to 'xxxxx.xxxxxx.de' at 8f239f8>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd
------
2002-05-08T11:05:01 INFO(0) ZMySQLDA Closing connection <open connection to 'xxxxx.xxxxxx.de' at 927e610>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd
------
2002-05-08T11:05:01 INFO(0) ZMySQLDA Opened new connection <open connection to 'xxxxx.xxxxxx.de' at 927e610>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd
------
2002-05-08T11:07:25 INFO(0) ZMySQLDA Closing connection <open connection to 'xxxxx.xxxxxx.de' at 945af48>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd
------
2002-05-08T11:07:40 INFO(0) ZMySQLDA Opened new connection <open connection to 'xxxxx.xxxxxx.de' at 8ee6078>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd
------
2002-05-08T11:07:47 INFO(0) ZMySQLDA Opened new connection <open connection to 'xxxxx.xxxxxx.de' at 8f1dfd8>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd
------
2002-05-08T11:07:48 INFO(0) ZMySQLDA Closing connection <open connection to 'xxxxx.xxxxxx.de' at 90760d8>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd
------
2002-05-08T11:08:08 INFO(0) ZMySQLDA Opened new connection <open connection to 'xxxxx.xxxxxx.de' at 9afe470>: -xxxxx@xxxxx.xxxxxx.de dbuser dbpasswd