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?
