Add unique index to process-definitions on KEY and VERSION

Description

Version-incremeting and process-definition deployment doesn't use the optimistic locking, because it insert new records.. So if we add a constraint on key and version, one of the duplicate inserts will have a failing transaction commit.

ALTER TABLE `ACT_RE_PROCDEF` ADD UNIQUE INDEX `KEY_VERSION` (`KEY_` ASC, `VERSION_` ASC) ;

See http://forums.activiti.org/en/viewtopic.php?f=6&t=1087&start=10.

Assignee

Frederik Heremans

Reporter

Frederik Heremans

Labels

None

Fix versions

Priority

Major
Configure