AnsweredAssumed Answered

upgrading to 3.2r

Question asked by iantopanto on Oct 14, 2009
Latest reply on Nov 3, 2009 by bbukvic
Im having difficulties in upgrading to community edition 3.2r.  When I start the alfresco server it complains that it cannot create a table.
From catalina logs:
11:39:39,452  INFO  [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-4834466208350250858.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-3.2-AuditTables.sql).
11:39:39,470  ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: CREATE TABLE alf_audit_app
(
   id BIGINT NOT NULL AUTO_INCREMENT,
   version SMALLINT NOT NULL,
   app_name_id BIGINT NOT NULL,
   audit_model_id BIGINT NOT NULL,
   disabled_paths_id BIGINT NOT NULL,
   CONSTRAINT fk_alf_audit_app_app FOREIGN KEY (app_name_id) REFERENCES alf_prop_value (id),
   CONSTRAINT UNIQUE idx_alf_audit_app_app (app_name_id),
   CONSTRAINT fk_alf_audit_app_model FOREIGN KEY (audit_model_id) REFERENCES alf_audit_model (id) ON DELETE CASCADE,
   CONSTRAINT fk_alf_audit_app_dis FOREIGN KEY (disabled_paths_id) REFERENCES alf_prop_root (id),
   PRIMARY KEY (id)
) ENGINE=InnoDB
   Error: Can't create table './alfresco/alf_audit_app.frm' (errno: 150)
   File: /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-4834466208350250858.sql
   Line: 32

Table alf_prop_root does not exist therefor it cannot create the foreign key.

Has anyone else experienced this.

Versions before upgrade:
Installed Schema   3001
Installed Version   3.3.0 (2132)
Server Schema   3001
Server Version   3.3.0 (2132)

I was on the community version from Aug 11th before the upgrade and not the 3.2 stable.

Ian

Outcomes