Upgrade problem from 3.2 to 3.2r2

[mattia_rambelli]

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 again, and same thing succeded, alfresco cant upgrade the DB schema.
is there a workaround?

i'm on SLES10sp2 as operating system

Thank in advance for your help,

Mattia Rambelli - Twinergy S.p.A.

[neozone]

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

[mattia_rambelli]

Up

[neozone]

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

[mattia_rambelli]

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?