[Erp5-dev] CMFActivity deadlock removal

[Pelletier Vincent]

Hi.

I recently identified a deadlock in CMFActivity which is caused by MySQL 
AUTO_INCREMENT lock.

It is fixed as of revision 13742 and requires an update of 
ERP5/Tools/IdTool.py which in turn requires an update of 
erp5_mysql_innodb_catalog. It also requires a re-creation of activity tables 
(portal_activities/manageAdvanced -> Clear activities) to be fully effective. 
All the re-creation changes is removal of the AUTO_INCREMENT behaviour of uid 
column on "message" table.

So update should be done as follows:

- first grab latest version of erp5_mysql_innodb_catalog
- install it (If you don't have any version of erp5_mysql_innodb_catalog 
installed, then follow an earlier mail I sent which describes the update path 
to install it)
- stop the zope instance (because updating CMFActivity product has immediate 
impact in the ZODB through external skin folder)
- update CMFActivity and ERP5/Tools/IdTools.py
- start zope
- recreate activity tables (as explained above)

For extra safety, you might want to prevent new activities from being 
generated during the update ad wait for all activities to be processed before 
stoping the zope. But this is not required.

-- 
Vincent Pelletier