topic Re: Correct DB Update for MySQL 5.5.29 and Activiti 5.15.1 in Alfresco Archive

Correct DB Update for MySQL 5.5.29 and Activiti 5.15.1

lpkchri1 — Fri, 09 May 2014 17:35:24 GMT

We are running MySQL 5.5.29 and Activiti 5.14 currently.From looking at the upgrade scripts, I would assume the following would need to be run, in order:activiti.mysql55.upgradestep.514.to.515.engine.sqlactiviti.mysql55.upgradestep.514.to.515.history.sqlactiviti.mysql55.upgradestep.515.to.5151.engin

Re: Correct DB Update for MySQL 5.5.29 and Activiti 5.15.1

trademak — Mon, 12 May 2014 07:02:15 GMT

Hi,

Yes, that's a correct assumption. The 514.to.515 scripts need to be executed before 515.to.5151.
If you upgrade to MySQL 5.6.x afterwards you can run the parts of the 514.to.515 script that change the date/time columns. MySQL 5.6 is able to handle precision in time values better than 5.5.x and earlier.

Best regards,

Re: Correct DB Update for MySQL 5.5.29 and Activiti 5.15.1

lpkchri1 — Mon, 12 May 2014 22:22:27 GMT

Thanks for the reply!

I do not have control over the database that we use and it appears that this change will fork the MySQL scripts going forward. Do you plan on continuing to support the pre-5.6 database creation / update scripts for the foreseeable future in Activiti updates?

Thanks again,

Kent

Re: Correct DB Update for MySQL 5.5.29 and Activiti 5.15.1

trademak — Wed, 14 May 2014 19:28:40 GMT

Hi Kent,

We will keep supporting pre 5.6 as well. We just added better time precision for 5.6 (which is not available in pre 5.6), that's it.

Best regards,