topic Database upgrade from 4.1.10 to 5.1.1 fails in Alfresco Archive

Database upgrade from 4.1.10 to 5.1.1 fails

pcharsle — Sun, 21 Aug 2016 21:28:11 GMT

We are following the instructions at http://docs.alfresco.com/5.1/tasks/upgrade-process.html to upgrade from 4.1.10 to 5.1.1. We are using AWS RDS MySQL 5.6 with tomcat7 as supported by Alfresco. We successfully install and run Alfresco 5.1.1 with all our extensions. We then do the following:1) Stop

Re: Database upgrade from 4.1.10 to 5.1.1 fails

angelborroy — Wed, 24 Aug 2016 06:41:06 GMT

According to this http://docs.alfresco.com/5.1/concepts/upgrade-path.html you need an intermediate migration to 5.0 and then to 5.1

Re: Database upgrade from 4.1.10 to 5.1.1 fails

ianw — Wed, 24 Aug 2016 10:11:48 GMT

I've have been testing an upgrade from 4.2 to 5.1 and migrate-activiti-workflows.sql patch has been taking many, many, many hours, but it does eventually complete. I do not, however suffer from a timeout exception. I suspect the slow patch may be due to the use of nested queries, which MySQL is known to have speed issues with. I am, however, far from being a MySQL DB expert.

I am using mariadb-java-client-1.1.9.jar instead of mysql-connector-java.jar which maybe different to your setup.

BTW, I read the direct upgrade path from 4.1.x to 5.1 as being supported.

Re: Database upgrade from 4.1.10 to 5.1.1 fails

pcharsle — Mon, 29 Aug 2016 23:30:41 GMT

This is a known issue which has been around for a while. See https://issues.alfresco.com/jira/browse/MNT-16716 . We are now doing the following to upgrade from 4.1.x to 5.1.1:

1) Follow Alfresco instructions and perform the upgrade process up to the point when the script migrate-activiti-workflows.sql hangs/takes a VERY long time
2) Reboot the database
3) Stop Alfresco
4) Drop the table alf_bootstrap_lock
5) Manually ran each sql command in the script migrate-activiti-workflows.sql (the problematic statement only takes a few seconds to run)
6) Start Alfresco
7) The rest of the upgrade then continues without a problem

Re: Database upgrade from 4.1.10 to 5.1.1 fails

ianw — Fri, 23 Sep 2016 08:19:53 GMT

Thank you for posting this back, however it did not work for me. Running the query manually took just as long.

The solution for me was to upgrade the database. I was using MariaDB 5.5 as supplied as standard with Centos 7, but, Alfresco requires a Mysql 5.6. I believe that MariaDB 10 is also supported. I upgraded to MariaDB 10.1 and the migrate-activiti-workflows.sql took about 3 seconds without any work-arounds being required.

Re: Database upgrade from 4.1.10 to 5.1.1 fails

darkredd — Fri, 23 Sep 2016 13:39:26 GMT

Hi,

We were able to migrate from 4.2.2 to 5.1.f two months ago. We also had an issue initially, only to realize that we had not give the "alfresco" db user enough privileges. So give full access to the user that connects to the DB from Alfresco; it will enable the user to alter, update or drop tables as required by the upgrade scripts.