topic Incremental rebuild fails with database error in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/incremental-rebuild-fails-with-database-error/m-p/244791#M197921 <HTML><HEAD></HEAD><BODY><SPAN>I have&nbsp; 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:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>08:01:11,261&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.<BR />08:01:12,090&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco3.2/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-U<BR />pdate-6914763529106898612.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-3.2-Prop<BR />ertyValueTables.sql).<BR />08:01:12,111&nbsp; ERROR [domain.schema.SchemaBootstrap] Statement execution failed:<BR />&nbsp;&nbsp; SQL: CREATE TABLE alf_prop_class<BR />(<BR />&nbsp;&nbsp; id BIGINT NOT NULL AUTO_INCREMENT,<BR />&nbsp;&nbsp; java_class_name VARCHAR(255) NOT NULL,<BR />&nbsp;&nbsp; java_class_name_short VARCHAR(32) NOT NULL,<BR />&nbsp;&nbsp; java_class_name_crc BIGINT NOT NULL,<BR />&nbsp;&nbsp; UNIQUE INDEX idx_alf_prop_class_crc (java_class_name_crc, java_class_name_short),<BR />&nbsp;&nbsp; INDEX idx_alf_prop_class_class (java_class_name),<BR />&nbsp;&nbsp; PRIMARY KEY (id)<BR />) ENGINE=InnoDB<BR />&nbsp;&nbsp; Error: Table 'alf_prop_class' already exists<BR />&nbsp;&nbsp; File: /opt/Alfresco3.2/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6914763529106898612.sql<BR />&nbsp;&nbsp; Line: 19<BR />08:01:12,112&nbsp; ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed<BR />com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alf_prop_class' already exists<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Any ideas on how to work around this?</SPAN></BODY></HTML> Sun, 30 Aug 2009 08:38:42 GMT gronfelt 2009-08-30T08:38:42Z Incremental rebuild fails with database error https://connect.hyland.com/t5/alfresco-archive/incremental-rebuild-fails-with-database-error/m-p/244791#M197921 I have&nbsp; 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&nbsp; INFO&nbsp; [domain.schema.SchemaBoot Sun, 30 Aug 2009 08:38:42 GMT https://connect.hyland.com/t5/alfresco-archive/incremental-rebuild-fails-with-database-error/m-p/244791#M197921 gronfelt 2009-08-30T08:38:42Z Re: Incremental rebuild fails with database error https://connect.hyland.com/t5/alfresco-archive/incremental-rebuild-fails-with-database-error/m-p/244792#M197922 <HTML><HEAD></HEAD><BODY><SPAN>Hi gronfelt,</SPAN><BR /><BR /><SPAN>I am attempting to upgrade from CE 3.2 to CE 3.2r.&nbsp; A needed upgrade to fix an issue with CIFS.&nbsp; I am seeing this same error message on startup.&nbsp; Did you end up resolving this issue.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Doug</SPAN></BODY></HTML> Wed, 21 Oct 2009 00:49:52 GMT https://connect.hyland.com/t5/alfresco-archive/incremental-rebuild-fails-with-database-error/m-p/244792#M197922 dough 2009-10-21T00:49:52Z