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
* [EMAIL PROTECTED]
* [EMAIL PROTECTED]
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )