topic Re: Upgrade problem from 3.2 to 3.2r2 in Alfresco Archive

Upgrade problem from 3.2 to 3.2r2

mattia_rambelli — Mon, 14 Dec 2009 18:26:28 GMT

Hi, i have a problem using the general upgrade process when trying to upgrade from 3.2 to 3.2r2.I have an error in catalina.out that is ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed and if i read more ther is written that a table already eixists.anyway i deleted the table and tried

Re: Upgrade problem from 3.2 to 3.2r2

neozone — Tue, 15 Dec 2009 02:45:33 GMT

Yes, I have the same problem.
Have anyone know the solution?

This is my logfile

10:15:18,734 ERROR [org.alfresco.repo.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.2r2/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6706750847016287137.sql
   Line: 19
10:15:18,736 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alf_prop_class' already exists‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Is something we have to do with 'alf_prop_class' ?

And this issue is kinda same as this topic
http://forums.alfresco.com/en/viewtopic.php?f=48&p=70042
http://forums.alfresco.com/en/viewtopic.php?f=8&p=70283
http://forums.alfresco.com/en/viewtopic.php?f=8&p=78044

Re: Upgrade problem from 3.2 to 3.2r2

mattia_rambelli — Tue, 22 Dec 2009 14:36:16 GMT

Re: Upgrade problem from 3.2 to 3.2r2

neozone — Mon, 28 Dec 2009 03:33:58 GMT

my problem is solved by
http://wiki.alfresco.com/wiki/General_Upgrade_Process#The_Upgrade_Process
skip step 5 or remove alf_data and rebuild alfresco database.
and in alfresco-global.properties
#
# Index Recovery Mode
#————-
index.recovery.mode=FULL

Re: Upgrade problem from 3.2 to 3.2r2

mattia_rambelli — Fri, 08 Jan 2010 08:32:58 GMT

hmmm that's strange, if i rebuild the database, so i have to do another restore of the DB, and so the tables are different (if there are upgrades), and my upgrade crashes anyway cause of the upgrade scripts i think
any suggestions?