[Erp5-dev] refactoring the uid generation

Yoshinori Okuji yo at nexedi.com
Wed May 18 19:56:08 CEST 2005


I have investigated some potential problems in uid generation, and solved them 
mostly. Since this change is significant, be careful about making a backup 
when you update your products.

Here is an upgrade path:

1. Make a backup. You should make a backup of all products and data for 
safety. If this upgrade fails, your system will stop working.

2. Update all ERP5-related products. At least, ERP5Catalog and ZSQLCatalog 
must be updated.

3. Recreate erp5_mysql in portal_catalog. The easiest way is 1) to rename 
erp5_mysql to something else (e.g. erp5_mysql_backup) for safety, 2) to call 
addDefaultSQLMethods from portal_catalog by just going to the URL 
http://.../portal_catalog/addDefaultSQLMethods. This does not return 
anything, but you should get a new erp5_mysql.

4. If you need to change the catalog methods or properties, do it now.

5. Clear the catalog.

6. Run ERP5Site_reindexAll.  If you use portal_activities, make sure that 
indexing is finished, before proceeding.

7. Again, clear the catalog.

8. Run ERP5Site_reindexAll. Likewise, make sure that all activities are 
finished, before proceeding.

9. Check if everything looks good.

Double-reindexing is required, because uids might be reassigned in the first 
indexing process.

If anything goes wrong, go back to the copy, and send a bug report to me.

YO
-- 
Yoshinori Okuji, Nexedi Research Director
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com
ERP5: Free / Open Source ERP Software for small and medium companies
http://www.erp5.org
Storever: OpenBrick, WiFi infrastructure, notebooks and servers
http://www.storever.com



More information about the Erp5-dev mailing list