[ZODB-Dev] Couldn't load state for xxx after using undo feature
Hi we started receiving the errors below after we used the zope 2 undo tab to undo an accidental delete of an item in Plone. We have 2 Zope instances and the error only occurred in one (many times until I restarted the server). I'm wondering if this is a known relstorage bug? yours Anthony 2014-06-17T16:19:41 ERROR ZODB.Connection Couldn't load state for 0xed95a1 Traceback (most recent call last): File "/home/zopecms/home/eggs/ZODB3-3.10.5-py2.7-linux-i686.egg/ZODB/Connection.py", line 860, in setstate self._setstate(obj) File "/home/zopecms/home/eggs/ZODB3-3.10.5-py2.7-linux-i686.egg/ZODB/Connection.py", line 901, in _setstate p, serial = self._storage.load(obj._p_oid, '') File "/home/zopecms/home/eggs/RelStorage-1.5.1-py2.7.egg/relstorage/storage.py", line 457, in load state, tid_int = cache.load(cursor, oid_int) File "/home/zopecms/home/eggs/RelStorage-1.5.1-py2.7.egg/relstorage/cache.py", line 234, in load self._check_tid_after_load(oid_int, actual_tid_int, tid_int) File "/home/zopecms/home/eggs/RelStorage-1.5.1-py2.7.egg/relstorage/cache.py", line 187, in _check_tid_after_load 'thread_ident': thread.get_ident(), AssertionError: Detected an inconsistency between the RelStorage cache and the database while loading an object using the delta_after0 dict. Please verify the database is configured for ACID compliance and that all clients are using the same commit lock. (oid_int=15570337, expect_tid_int=263344272409910101L, actual_tid_int=263344508671329280L, current_tid=263344510277377826L, cp0=263342914987325781L, cp1=263337834610124202L, len(delta_after0)=6576, len(delta_after1)=10003, pid=29051, thread_ident=-1223988336) ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
[ZODB-Dev] Packing much improved with Relstorage 1.5
Some results I thought some people might be interested following our upgrade from Relstorage 1.4.1 to 1.5. I've only upgraded our test system but that is a clone of live with a db size of 6631MB running Plone 3.3. Before the upgrade the pack was taking 2 hours 15 minutes. After the pack 8 minutes. Fantastic work. Thanks! Anthony ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
[ZODB-Dev] Advice on whether to run relstorage database and Zope on different servers
Hi, We've been successfully running Plone 3.3 + Zope 2.10 + Relstorage + MySql for a couple of years now. We're running low on memory on our existing server (which has numerous other services on it) and will soon need to deploy an additional Plone 4.1 + Zope 2.13 + Relstorage + Mysql environment. We've been using virtual environments since September. For the purposes of this discussion please assume we don't have the option of increasing the memory on our existing server and so need to add a new one.Some questions I'd really appreciate your help with please: * I'm familiar with enterprise environments where you would have an "app server" and a "database server" but are there any advantages to putting Zope and MySQL on different servers? * I'd expect a performance hit if we run Zope + MySQL on separate servers but is this hit manageable? * Can we put anything in place to mitigate this? * Would you simply recommend having the existing mysql + zope on one server and the new mysql + zope on the other? Thanks in advance Anthony ___ Anthony Gerrard Email: anthonygerr...@gmail.com http://www.sponsorachild.org.uk ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
[ZODB-Dev] Version of mysql to use with Relstorage
Hi, The Relstorage pypi site recommends against using version 5.1.23 of MySQL because of "major bugs". As it doesn't state explicitly what these bugs are I can't tell whether they're fixed in the latest version (5.1.32). Does anyone know whether it's safe to use this latest version of MySQL 5.1 with relstorage or whether I should be using the latest 5.0 version (5.0.77). thanks in advance Anthony ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Relstorage and ZEO
OK thanks. To confirm you can have a cluster of Zope instances all using relstorage to connect to the same database. This negates the need for ZEO as the database handles the multi-threaded data access. +-+ +-+ |Zope Server 1| |Zope Server 2| +-+ +-+ | Relstorage | | Relstorage | +-+ +-+ `-..-' `. _.-' `-..-' ++ |Database| ++ Shane Hathaway wrote: > Alan Runyan wrote: >> Ask this question on either Zope/Plone mailing list. >> >> My understanding about relstorage is that each Zope application client >> uses relstorage. >> There is no ZEO server in the mix. >> >> Is that correct Shane/others? > > Yes. ZEO is not needed when you use RelStorage. > > Shane > > ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev
[ZODB-Dev] Relstorage and ZEO
Hi, I'm working on a project to migrate a number of sites to a content management system. We finished our evaluation period and chosen Zope / Plone. I'm new to both products and would like some advice about our initial deployment. The impression I get is that using both ZEO and Relstorage are recommended. My question is whether you'd recommend using them together or not. The sites get up to half a million requests a day (not page impressions) and we're planning on using Apache (mod_cache) and CacheFu for caching. Anthony ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev
