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-2512Regards, Norgan
