AnsweredAssumed Answered

Problems with schema update

Question asked by mdond on Sep 14, 2011
Latest reply on Sep 15, 2011 by jbarrez
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?

Outcomes