Hello
I am using activiti-app and activiti-admin to visualize task, process-instance from activiti databases. We are using Mysql INNODB cluster for our production. Activiti-app and Activiti-admin is working fine in Simple Mysql(without INNODB cluster) but its throwing exception in INNODB.
Error executing SQL INSERT INTO activititest1.ACT_FO_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, LIQUIBASE) VALUES ('1', 'activiti', 'org/activiti/form/db/liquibase/activiti-form-db-changelog.xml', NOW(), 2, '7:913aee6a78e577fe455efed1d40980f1', 'createTable (x4)', '', 'EXECUTED', '3.1.0'): The table does not comply with the requirements by an external plugin.
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:61)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:106)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:96)
at liquibase.changelog.StandardChangeLogHistoryService.setExecType(StandardChangeLogHistoryService.java:252)
at liquibase.database.AbstractJdbcDatabase.markChangeSetExecStatus(AbstractJdbcDatabase.java:1052)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:47)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:64)
at liquibase.Liquibase.update(Liquibase.java:202)
at liquibase.Liquibase.update(Liquibase.java:181)
at org.activiti.form.engine.FormEngineConfiguration.initDbSchema(FormEngineConfiguration.java:575)
... 120 more
Its quit clear from the exception that its unable to insert into some table as there is no primary key in those tables. As INNODB cluster needs primary key in each table for its group replication its not allowing insert statement to execute. Please help us in this. We are stuck into it for a long time.
