Migratiing from Labs 2.9 to Labs 3.0C - Bug in Schema Update

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

norgan

Good Evening,
I have a "production" system running under Suse Enterprise Linux with the last Alfresco Labs 2.9 and a "new" system with Alfresco Labs 3.0C installed.

I wanted to migrate the data, categories, rights, users, etc to the new system, so I followed the wiki procedure

• shutdown alfresco
• mysqldump
• erase mysqldb and alf_data on new system after successfull testruns
• copy alf_data
• import dump.sql
• startup alfresco
• watch anxiously

And here it is …

16:46:44,007 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
16:47:42,421 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from c
lass path resource [alfresco/file-servers.properties]
16:48:02,657 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hib
ernate.dialect.MySQLInnoDBDialect.
16:48:02,741 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/to
mcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-20016.sql (Copied from classpa
th:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.2-ACL.sql).
16:48:03,421 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/to
mcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-20017.sql (Copied from classpa
th:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-0-create-missing-tables.sql)
.
16:48:03,534 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/to
mcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-20018.sql (Copied from classpa
th:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-from-2.1.sql).
16:48:13,723 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: INSERT INTO t_alf_usage_delta
   (
      id, version,
      node_id,
      delta_size
   )
   SELECT
      ud.id, 1,
      ud.node_id,
      ud.delta_size
   FROM
      alf_usage_delta ud

   Error: Table 'alfresco.alf_usage_delta' doesn't exist
   File: /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-20018
.sql
   Line: 441
16:48:13,725 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_usage_delta' doesn't exist
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

prior to this message, now error message is shown. Is this a bug or did I miss something ?

Added as bug under https://issues.alfresco.com/jira/browse/ALFCOM-2512

Regards, Norgan

steve_tekell

This is fixed in 3Stable (formerly 3D)

Here's the original bug I raised
https://issues.alfresco.com/jira/browse/ALFCOM-2268

and the post I made with a workaround if you need to stick with 3C
http://forums.alfresco.com/en/viewtopic.php?f=8&t=16047

However, I recommend you skip 3C and go to 3Stable.  I had other problems with 3C that are now fixed in 3Stable.

Steve