Upgrade problem from 3.2 to 3.2r2

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.

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