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

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
sumitdatta
Member II

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

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. 

1 Reply
bassam_al-saror
Senior Member

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

Seems a replication issue MySQL Bugs: #83165: The table does not comply with the requirements by an external plugin 

Does this only happen for the form engine?