AnsweredAssumed Answered

Unable to start activiti-app if MYSQL Innodb cluster is used

Question asked by sumitdatta on Jul 10, 2018
Latest reply on Jul 11, 2018 by bassam.al-sarori

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. 

Outcomes