AnsweredAssumed Answered

Incremental rebuild fails with database error

Question asked by gronfelt on Aug 30, 2009
Latest reply on Oct 21, 2009 by dough
I have  an installation that was originally the 3.2 Community release, later I have rebuilt this from source with revision 15634. Now I want to rebuild it again to the current revision, but when doing so the server startup fails with the following errors:

08:01:11,261  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
08:01:12,090  INFO  [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco3.2/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-U
pdate-6914763529106898612.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-3.2-Prop
ertyValueTables.sql).
08:01:12,111  ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: CREATE TABLE alf_prop_class
(
   id BIGINT NOT NULL AUTO_INCREMENT,
   java_class_name VARCHAR(255) NOT NULL,
   java_class_name_short VARCHAR(32) NOT NULL,
   java_class_name_crc BIGINT NOT NULL,
   UNIQUE INDEX idx_alf_prop_class_crc (java_class_name_crc, java_class_name_short),
   INDEX idx_alf_prop_class_class (java_class_name),
   PRIMARY KEY (id)
) ENGINE=InnoDB
   Error: Table 'alf_prop_class' already exists
   File: /opt/Alfresco3.2/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6914763529106898612.sql
   Line: 19
08:01:12,112  ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alf_prop_class' already exists

This corrupts the database so that it is not possible to revert to a prior revision without restoring a backup of the database. I've tried rebuilding with a couple of different revisions, but the result i always the same, so i suspect that the problem lies within the revision I'm currently using.

Any ideas on how to work around this?

Outcomes