topic Re: Error upgrading mysql from 5.2 to 5.3 in Alfresco Archive

Error upgrading mysql from 5.2 to 5.3

rilisema — Thu, 17 Mar 2011 16:52:33 GMT

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_'Afte

Re: Error upgrading mysql from 5.2 to 5.3

jbarrez — Mon, 21 Mar 2011 16:42:49 GMT

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

Re: Error upgrading mysql from 5.2 to 5.3

rilisema — Tue, 07 Jun 2011 12:47:53 GMT

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

Re: Error upgrading mysql from 5.2 to 5.3

frederikherema1 — Tue, 07 Jun 2011 13:04:01 GMT

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…