search

zodb / relstorage

A backend for ZODB that stores pickles in a relational database.
Other
54 stars 46 forks source link

error during two phase commit using Oracle #365

Closed mamico closed 4 years ago

mamico commented 4 years ago

I'm testing latest fix for Oracle support #363 I have errors during locking release two phase commit

2019-10-21 16:10:07,369 CRITICA [txn.140628118046464:434][MainThread] A storage error occurred during the second phase of the two-phase commit.  Resources may be in an inconsistent state.
2019-10-21 16:10:07,683 ERROR   [Zope.SiteErrorLog:251][MainThread] 1571667007.68160490.898651162754552 https://.....
Traceback (innermost last):
  Module ZPublisher.WSGIPublisher, line 161, in transaction_pubevents
  Module transaction._manager, line 252, in commit
  Module transaction._manager, line 131, in commit
  Module transaction._transaction, line 311, in commit
  Module transaction._compat, line 50, in reraise
  Module transaction._transaction, line 302, in commit
  Module transaction._transaction, line 447, in _commitResources
  Module transaction._compat, line 50, in reraise
  Module transaction._transaction, line 429, in _commitResources
  Module ZODB.Connection, line 709, in tpc_finish
  Module perfmetrics._metric, line 72, in perfmetrics._metric._AbstractMetricImpl.__call__
  Module relstorage.storage, line 497, in tpc_finish
  Module relstorage._util, line 233, in f
  Module relstorage.storage.tpc.vote, line 483, in tpc_finish
  Module relstorage._util, line 233, in f
  Module relstorage.storage.tpc.vote, line 453, in _lock_and_move
  Module perfmetrics._metric, line 66, in perfmetrics._metric._AbstractMetricImpl.__call__
  Module relstorage.adapters.adapter, line 143, in lock_database_and_move
  Module perfmetrics._metric, line 66, in perfmetrics._metric._AbstractMetricImpl.__call__
  Module relstorage.adapters.adapter, line 102, in lock_database_and_choose_next_tid
  Module perfmetrics._metric, line 72, in perfmetrics._metric._AbstractMetricImpl.__call__
  Module relstorage.adapters.locker, line 306, in hold_commit_lock
relstorage.adapters.interfaces.UnableToAcquireCommitLockError: No row returned from commit_row_lock
mamico commented 4 years ago

my fault. I've reused a previously populated schema.