cancel
Showing results for 
Search instead for 
Did you mean: 

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

norgan
Champ in-the-making
Champ in-the-making
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
2 REPLIES 2

steve_tekell
Champ in-the-making
Champ in-the-making
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

norgan
Champ in-the-making
Champ in-the-making
Just received your update - Thanks a lot !