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

PostgreSQL: Upgrade to 4.2.6.9 gets stuck on patch migrate-activiti-workflows.sql

    Details

      Description

      Steps to reproduce

      1. Install 4.2.5 instance
      2. Generate 14 million of workflow history (activiti)
      3. Upgrade the above instance to 4.2.6.9

      Actual result

      Upgrade won't complete with:

       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

      Upgrade to complete

      Notes

      • This is only reproducible with large amount nodes on act_hi* tables.

        Attachments

          Issue Links

            Structure

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 2 days, 6 hours, 10 minutes
                    2d 6h 10m

                      Structure Helper Panel