[Zope] Re: session variables in the presence of conflicts

[Dennis Allison]

Florent,
There were, of course, tracebacks.  Any assist you can provide would be 
appreciated.   -D

------
2005-11-18T12:50:16 ERROR txn.3075 Error in tpc_abort() on manager <MultiObjectResourceAdapter for <Products.ZMySQLDA.db.DB instance at 0x450431cc> at 1190763820>
Traceback (most recent call last):
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 462, in _cleanup
    rm.tpc_abort(self)
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 548, in tpc_abort
    self.manager.tpc_abort(txn)
  File "/usr/local/src/zope/Zope2.8/lib/python/Shared/DC/ZRDB/TM.py", line 64, 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-11-18T12:50:16 ERROR txn.3075 Error in tpc_abort() on manager <MultiObjectResourceAdapter for <Products.ZMySQLDA.db.DB instance at 0x41487acc> at 1190774252>
Traceback (most recent call last):
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 462, in _cleanup
    rm.tpc_abort(self)
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 548, in tpc_abort
    self.manager.tpc_abort(txn)
  File "/usr/local/src/zope/Zope2.8/lib/python/Shared/DC/ZRDB/TM.py", line 64, 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-11-18T12:50:16 INFO ZODB conflict error at /courses/topics/navigation_box (55 conflicts since startup at 2005-11-18T12:13:38) 
------
2005-11-18T12:50:16 ERROR txn.3075 Failed to abort object: Surrogate oid=<object object at 0x4009d470>
Traceback (most recent call last):
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 562, in abort
    self.manager.abort(o, txn)
  File "/usr/local/src/zope/Zope2.8/lib/python/Shared/DC/ZRDB/TM.py", line 64, 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-11-18T12:50:16 ERROR txn.3075 Failed to abort resource manager: <MultiObjectResourceAdapter for <Products.ZMySQLDA.db.DB instance at 0x450431cc> at 1190763820>
Traceback (most recent call last):
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 489, in abort
    rm.abort(self)
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 562, in abort
    self.manager.abort(o, txn)
  File "/usr/local/src/zope/Zope2.8/lib/python/Shared/DC/ZRDB/TM.py", line 64, 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-11-18T12:50:16 ERROR txn.3075 Failed to abort object: Surrogate oid=<object object at 0x4009d470>
Traceback (most recent call last):
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 562, in abort
    self.manager.abort(o, txn)
  File "/usr/local/src/zope/Zope2.8/lib/python/Shared/DC/ZRDB/TM.py", line 64, 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-11-18T12:50:16 ERROR txn.3075 Failed to abort resource manager: <MultiObjectResourceAdapter for <Products.ZMySQLDA.db.DB instance at 0x41487acc> at 1190774252>
Traceback (most recent call last):
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 489, in abort
    rm.abort(self)
  File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 562, in abort
    self.manager.abort(o, txn)
  File "/usr/local/src/zope/Zope2.8/lib/python/Shared/DC/ZRDB/TM.py", line 64, in abort
    try: self._abort()
  File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 389, in _abort
    self._tlock.release()
error: release unlocked lock
------


On Sat, 19 Nov 2005, Florent Guillaume wrote:

> Dennis Allison wrote:
> > We are using MySQL but are fully transactional using innodb.
> > 
> > The sort of problems we are seeing are (cruft removed) are things like:
> > 
> > 2005-11-18T12:50:16 ERROR txn.3075 Error in tpc_abort() on manager 
> > <MultiObjectResourceAdapter for <Products.ZMySQLDA.db.DB instance at 
> > 0x450431cc> at 1190763820>
> 
> There should be a traceback here, or if there's none you should patch 
> _transaction.py to make it produced. Seeing that traceback is important 
> and would point to an error somewhere in MySQLDA's code I expect.
> 
> > 2005-11-18T12:50:16 ERROR txn.3075 Failed to abort resource manager: 
> > <MultiObjectResourceAdapter for <Products.ZMySQLDA.db.DB instance at 
> > 0x450431cc> at 1190763820>
> > 2005-11-18T12:50:16 ERROR txn.3075 Failed to abort object: Surrogate 
> > oid=<object object at 0x4009d470>
> > 2005-11-18T12:50:16 ERROR txn.3075 Failed to abort resource manager: 
> > <MultiObjectResourceAdapter for <Products.ZMySQLDA.db.DB instance at 
> > 0x41487acc> at 1190774252>
> 
> Same here, the traceback is important.
> 
> Florent
> 
> 

--