Process instance ID is reused in BPM Suite with MySQL
Issue
- We found out that after restarting MySQL, the AUTO_INCREMENT value of the ProcessInstanceInfo id column got reset. The next process that was created, got the processInstanceId = 1. That id was already used by a finished process. Because of this duplication, many of the operations that assume the id is unique, fail. eg. findById.
Environment
- Red Hat JBoss BPM Suite
- 6.4.5
- MySQL
- 5.7
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.