Incremental rebuild fails with database error

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

gronfelt

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?

dough

Hi gronfelt,

I am attempting to upgrade from CE 3.2 to CE 3.2r.  A needed upgrade to fix an issue with CIFS.  I am seeing this same error message on startup.  Did you end up resolving this issue.

Thanks,
Doug