Uploaded image for project: 'Alfresco One Platform'
  1. Alfresco One Platform
  2. ACE-3360

SQL script patches should fail more gracefully during upgrade from unsupported versions

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 5.0
    • Fix Version/s: None
    • Component/s: Upgrades
    • Labels:
      None
    • Environment:
      Alfresco Enterprise v5.0.0 (r89209-b251) schema 8,009.
      Server: QALAB Stack 1 - RHEL 6.5 X64, MySQL v5.6.17, mysql-connector-java-5.1.32-bin.jar, Apache Tomcat 7.0.53, JDK 7 U67 X64.
      Client: Windows 7 SP1 x64, FF v33.0.1.

      Description

      Raised in accordance with this comment to ACE-2030.

      Unsupported upgrade (e.g. from 3.4.14 to 5.0.0) fails during the DB bootstrap with the following error:

       2014-10-29 13:59:45,125  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /data/upgrade/500-251/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2672487249228835207.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.0/org.hibernate.dialect.MySQLInnoDBDialect/AclChangeSet-Tracking2.sql).
       2014-10-29 13:59:45,139  ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Statement execution failed:
         SQL: UPDATE alf_acl_change_set
         SET
            commit_time_ms = 1412946263716 + id
         WHERE
            id >= 0 AND id <= 9999
            AND  commit_time_ms < 1412946263716
      
         Error: Unknown column 'commit_time_ms' in 'where clause'
         File: /data/upgrade/500-251/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2672487249228835207.sql
         Line: 22
      

      SQL script patches should fail more gracefully during upgrade from unsupported versions.


      ChristinaSh

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedissues Closed Issues
                  Reporter:
                  alfrescoqa Alfresco QA Team
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel