[Zope] ZODB performance issues

VanL vlindberg@verio.net
Tue, 13 Aug 2002 15:34:23 -0600


Thanks to everyone who replied on my earlier question, I think we have 
it mostly worked out.  However, we have turned up another ZODB problem.

After running through several hundred records, the process stops with 
the following error message:

  Site Error
  An error was encountered while publishing this resource.
  
  ZODB.POSException.ConflictError
  
  Sorry, a site error occurred.

Traceback (innermost last):
  File /usr/zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module
  File /usr/zope/lib/python/ZPublisher/Publish.py, line 127, in publish
  File /usr/zope/lib/python/ZPublisher/Publish.py, line 127, in publish
  File /usr/zope/lib/python/ZPublisher/Publish.py, line 127, in publish
  File /usr/zope/lib/python/ZPublisher/Publish.py, line 122, in publish
  File /usr/zope/lib/python/Zope/__init__.py, line 126, in zpublisher_exception_hook
  File /usr/zope/lib/python/ZPublisher/Publish.py, line 98, in publish
  File /usr/zope/lib/python/ZPublisher/mapply.py, line 88, in mapply
  File /usr/zope/lib/python/ZPublisher/Publish.py, line 39, in call_object
  File /usr/zope/lib/python/Shared/DC/Scripts/Bindings.py, line 252, in __call__
  File /usr/zope/lib/python/Shared/DC/Scripts/Bindings.py, line 283, in _bindAndExec
  File /usr/zope/lib/python/Products/PythonScripts/PythonScript.py, line 302, in _exec
    (Info: ({'traverse_subpath': [], 'container': <Folder instance at 8b86280>, 'context': <Folder instance at 8b7ea20>, 'script': <PythonScript instance at 8b8c9e0>}, ('/usr/home/pjl/test.cdf', 'blah'), {}, None))
  File Script (Python), line 91, in ImportCDF
  File /usr/local/Zope-2.5.1/Extensions/ReadCDF.py, line 96, in ReadCDF
  File /usr/zope/lib/python/ZODB/Transaction.py, line 234, in commit
  File /usr/zope/lib/python/ZODB/Connection.py, line 348, in commit
    (Info: (('BTrees.IIBTree', 'IIBucket'), '\x00\x00\x00\x00\x00\x00\xa7\xbf', ''))
  File /usr/zope/lib/python/ZODB/FileStorage.py, line 668, in store
    (Object: /usr/local/Zope-2.5.1/var/Data.fs)
ConflictError: database conflict error (oid 000000000000a7bf, serial was 0346c82026402fe6, now 0346c81d4506b211)


I'm not sure how to tackle this error.  Any ideas?

Thanks,

VanL