AnsweredAssumed Answered

Upgrade from 3.2 to 3.4b

Question asked by tcascarino on Sep 8, 2011

I am trying to upgrade my alfresco from 3.2 to 3.4b (and I need this specific version).
OS is RHEL 5.3
Current alfresco version is 3.2
Destination alfresco is alfresco-community-3.4.b-installer-linux-x64.bin

During the migration, I am facing the following issue in the log:

19:32:03,290  INFO  [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.b/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6135038573072484738.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-3.2-ContentTables2.sql).
19:32:03,632  INFO  [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.b/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1484357965441714172.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.2/org.hibernate.dialect.MySQLInnoDBDialect/child-assoc-qname-crc.sql).
19:32:11,896  INFO  [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.b/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1496165493123511728.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.3/org.hibernate.dialect.MySQLInnoDBDialect/modify-index-permission_id.sql).
19:32:12,873  ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: UPDATE alf_acl_member mem
   SET ace_id = (SELECT help.min FROM alf_access_control_entry ace
                     JOIN alf_tmp_min_ace help
                     ON         help.permission_id = ace.permission_id AND
                                help.authority_id = ace.authority_id AND
                                help.allowed = ace.allowed AND
                                help.applies = ace.applies
                     WHERE = mem.ace_id  )
   Error: Column 'ace_id' cannot be null
   File: /opt/alfresco-3.4.b/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1496165493123511728.sql
   Line: 49
19:32:12,876  ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'ace_id' cannot be null

If I comment out this query in the sql file, it looks like it's able to get through, however I'm then facing other issues which I think are related ..

Has anybody ever faced this issue? Or is anybody able to provide some advice?

Thanks a lot

PS : I should obviously add that google has never heard of this issue, and I've not been able to find any related post