Re: [ZODB-Dev] RelStorage: Unable to acquire commit lock
> On 9. Mai 2008, at 18:31, Shane Hathaway wrote: >> Perhaps the scope of the commit lock in MySQL is the entire >> database server rather than just the database, which would explain >> this. We should make sure each database has its own commit lock >> and pack lock. Stefan H. Holek wrote: yeas and yes ;-) Ok, I've changed the MySQL code to use database-specific locks. It will be in the next beta release. 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
Re: [ZODB-Dev] RelStorage: Unable to acquire commit lock
yeas and yes ;-) Srefan On 9. Mai 2008, at 18:31, Shane Hathaway wrote: StorageError: Unable to acquire commit lock It takes a few moments for that error to appear, doesn't it? Perhaps the scope of the commit lock in MySQL is the entire database server rather than just the database, which would explain this. We should make sure each database has its own commit lock and pack lock. -- Anything that, in happening, causes itself to happen again, happens again. --Douglas Adams ___ 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: Unable to acquire commit lock
Stefan H. Holek wrote: I try to use two relstorages, roughly following Evan's ZopeLabs recipe [1]. This is how my zope.conf looks like: [...] However, when I want to mount the /sessions_folder I get this: 2008-05-08 21:13:15 ERROR Zope.SiteErrorLog http://localhost:8080/manage_addProduct/ZODBMountPoint/manage_addMounts Traceback (innermost last): Module ZPublisher.Publish, line 125, in publish Module Zope2.App.startup, line 238, in commit Module transaction._manager, line 96, in commit Module transaction._transaction, line 395, in commit Module transaction._transaction, line 498, in _commitResources Module ZODB.Connection, line 730, in tpc_vote Module relstorage.relstorage, line 529, in tpc_vote Module relstorage.relstorage, line 513, in _vote Module relstorage.relstorage, line 420, in _prepare_tid Module relstorage.adapters.mysql, line 406, in start_commit StorageError: Unable to acquire commit lock It takes a few moments for that error to appear, doesn't it? Perhaps the scope of the commit lock in MySQL is the entire database server rather than just the database, which would explain this. We should make sure each database has its own commit lock and pack lock. 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: Unable to acquire commit lock
I try to use two relstorages, roughly following Evan's ZopeLabs recipe [1]. This is how my zope.conf looks like: %import relstorage db test_zodb host localhost mount-point / %import relstorage db test_sessions host localhost mount-point /sessions_folder However, when I want to mount the /sessions_folder I get this: 2008-05-08 21:13:15 ERROR Zope.SiteErrorLog http://localhost:8080/manage_addProduct/ZODBMountPoint/manage_addMounts Traceback (innermost last): Module ZPublisher.Publish, line 125, in publish Module Zope2.App.startup, line 238, in commit Module transaction._manager, line 96, in commit Module transaction._transaction, line 395, in commit Module transaction._transaction, line 498, in _commitResources Module ZODB.Connection, line 730, in tpc_vote Module relstorage.relstorage, line 529, in tpc_vote Module relstorage.relstorage, line 513, in _vote Module relstorage.relstorage, line 420, in _prepare_tid Module relstorage.adapters.mysql, line 406, in start_commit StorageError: Unable to acquire commit lock Thanks, Stefan [1] http://www.zopelabs.com/cookbook/1061234337 ___ 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