Error upgrading mysql from 5.2 to 5.3

[rilisema]

Hi,

when I upgrade my database from version 5.2 to 5.3 the following error occurs:


     [java] SEVERE: problem during schema upgrade, statement 'alter table ACT_HI_TASKINST add PRIORITY_ integer
     [java] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'PRIORITY_'

After this error I dropped the activiti database tables (ant db.drop) and tried to create the tables again.
To my surprise, the same error occurs!

This was in my development environment.
In my production environment I don't want to drop the activiti tables, I don't want to loose my process data!

greetings,
Richard

[jbarrez]

Are you sure the tables were correctly dropped? Because we have QA testing on MySQL which will surely execute the DDL scripts.

[rilisema]

Hi sorry for my late reaction,
I didn't see your comment earlier.

It looks like a bug in Mysql somewhere. When i drop the activiti tables and rerun the script i get errors.
Stopping and starting mysql on my mac solves the problem.

thanks,
Richard

[frederikherema1]

Thats has been a known bug in mySQL on MacOSX for a long time (http://bugs.mysql.com/bug.php?id=30513#c174255 and others).

I'm using MySQL 5.5.8 on my MBP now and it seems to be gone…