cancel
Showing results for 
Search instead for 
Did you mean: 

Problems with schema update

mdond
Champ in-the-making
Champ in-the-making
I have updated from activiti 5.5 to 5.7 resulting in the following entry in act_ge_property:

"schema.history","create(5.5) upgrade(5.5->5.7)"

I connected with this database with an older version of my application resulting in the following entry in act_ge_property:
"schema.history", "create(5.5) upgrade(5.5->5.7) upgrade(5.7->5.5)"

and the schema is 5.5 again:
"schema.version", "5.5"

Now if I connect to the same database again with the 5.7 version, I get the following error:
Caused by: org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_HI_PROCINST add SUPER_PROCESS_INSTANCE_ID_ varchar(64)
       at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:826)

Probably nothing happened when "upgrading" from 5.7 to 5.5 and I can simply edit "schema.version" to "5.7" again to work with 5.7. But is this the intended behaviour or should I create a JIRA-entry?
1 REPLY 1

jbarrez
Star Contributor
Star Contributor
This is surely NOT the intended behavior. Afail, nothing changed during these releases… but it sure is strange you get some sql being updated then …