[Zope] ZODB performance issues

Chris McDonough chrism@zope.com
13 Aug 2002 17:30:14 -0400


Are there other connections to the same database while your import
script is running?  Conflict errors are normal ZODB behavior.  See
http://www.zope.org/Documentation/Books/ZDG/current/Persistence.stx  for
more information.

On Tue, 2002-08-13 at 17:34, VanL wrote:
> 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
>