Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-16716

Upgrade to 4.2.6 gets stuck on patch migrate-activiti-workflows.sql

    Details

    • Type: Hot Fix Request
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 4.2.6
    • Fix Version/s: 4.2.6.5
    • Component/s: Upgrades, Workflow
    • Labels:
      None
    • Environment:
      Ubuntu 12.04 LTS X64 | MySQL 5.6 | Tomcat 7.0.59

      Description

      SVN and MVN please
      Summary
      On upgrade to 4.2.6, patch migrate-activiti-workflows.sql takes over 24 hours to complete.
      OOTB repo with 4000 started workflows, it took about 40 minutes

      Steps to reproduce

      1. On a 4.2.5 instance
      2. Start 4000 workflows so to create some data on act_hi* tables
      3. Upgrade to 4.2.6.

      Actual result

      Startup gets stuck here:

      2016-08-22 15:58:15,594 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /home/rvellozo/alf_home/alf_installs/a4.2.6/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-8551686488114356909.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.2/org.hibernate.dialect.PostgreSQLDialect/migrate-activiti-workflows.sql).

      Expected result
      Patch not to take more than 24 hours to complete.
      SVN and MVN please

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs (Inactive)
                  Reporter:
                  rvellozo Ricardo Vellozo
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  9 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Time Spent - 1 week, 1 day, 6 hours, 40 minutes Remaining Estimate - 3 days, 2 hours, 20 minutes
                    3d 2h 20m
                    Logged:
                    Time Spent - 1 week, 1 day, 6 hours, 40 minutes Remaining Estimate - 3 days, 2 hours, 20 minutes
                    1w 1d 6h 40m

                      Structure Helper Panel