[Zope] ZMySQLDB problems

[Dennis Allison]

I am seeing occasional errors like those below.  Any have any idea what my
problem here is?

Zope 2.7.6
MySQL-server-4.0.20-0 
MySQLDB aka MySQL-python-1.2.tc3
ZMySQL 2.0.9
Python 2.4.1

Typically the errors occur at initial login when the database is consulted 
to populate various session variables, etc.

The my.cnf file is, in part: 

# change timeouts to close rather than wait
# interactive == 1 hour, programs == 5 mins
set-variable=interactive_timeout=3600
set-variable=wait_timeout=300
# uncomment to not log connection problems
#set-variable=log-warnings=off


------------------------------------------------------------------------


2005-06-26T23:11:06 ERROR(200) ZMySQLDA exception during _begin
Traceback (most recent call last):
  File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 349, in _begin
    self.db.ping()
OperationalError: (2013, 'Lost connection to MySQL server during query')
------
2005-06-26T23:11:06 PANIC(300) ZODB A storage error occurred in the last 
phase of a two-phase commit.  This shouldn't happen. The application will 
not be allowed to commit until the site/storage is reset by a restart.
Traceback (most recent call last):
  File "/usr/local/src/zope/Zope2.7/lib/python/ZODB/Transaction.py", line 
377, in _finish_many
    jar.tpc_finish(self)
  File "/usr/local/src/zope/Zope2.7/lib/python/Shared/DC/ZRDB/TM.py", line 
59, in tpc_finish
    try: self._finish()
  File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 376, in _finish
    self._tlock.release()
error: release unlocked lock
------
2005-06-26T23:11:06 ERROR(200) ZODB A storage error occured during object 
abort. This shouldn't happen.
Traceback (most recent call last):
  File "/usr/local/src/zope/Zope2.7/lib/python/ZODB/Transaction.py", line 
412, in _commit_error
    j.tpc_abort(self) # This should never fail
  File "/usr/local/src/zope/Zope2.7/lib/python/Shared/DC/ZRDB/TM.py", line 
63, in abort
    try: self._abort()
  File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 389, in _abort
    self._tlock.release()
error: release unlocked lock
------
2005-06-26T23:11:06 ERROR(200) SiteError 
http://dev.agilemind.com/logged_in
Traceback (most recent call last):
  File "/usr/local/src/zope/Zope2.7/lib/python/ZPublisher/Publish.py", 
line 107, in publish
    transactions_manager.commit()
  File "/usr/local/src/zope/Zope2.7/lib/python/Zope/App/startup.py", line 
222, in commit
    get_transaction().commit()
  File "/usr/local/src/zope/Zope2.7/lib/python/ZODB/Transaction.py", line 
260, in commit
    self._finish_many(jars)
  File "/usr/local/src/zope/Zope2.7/lib/python/ZODB/Transaction.py", line 
377, in _finish_many
    jar.tpc_finish(self)
  File "/usr/local/src/zope/Zope2.7/lib/python/Shared/DC/ZRDB/TM.py", line 
59, in tpc_finish
    try: self._finish()
  File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 376, in _finish
    self._tlock.release()
error: release unlocked lock
------


-- 
Dennis Allison * Computer Systems Laboratory * Gates 227
               * Stanford University *  Stanford CA  94305
	       * (650) 723-9213 * (650) 723-0033 fax
	       * allison at shasta.stanford.edu
	       * allison at sumeru.stanford.edu