AnsweredAssumed Answered

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

Question asked by norgan on Jan 19, 2009
Latest reply on Jan 21, 2009 by 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

Outcomes