topic Unable to start activiti-app if MYSQL Innodb cluster is used in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/unable-to-start-activiti-app-if-mysql-innodb-cluster-is-used/m-p/26190#M11338 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I am&nbsp;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.</P><P></P><P>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'): <SPAN style="background: yellow;">The table does not comply with the requirements by an external plugin</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:61)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:106)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:96)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.StandardChangeLogHistoryService.setExecType(StandardChangeLogHistoryService.java:252)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.database.AbstractJdbcDatabase.markChangeSetExecStatus(AbstractJdbcDatabase.java:1052)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:47)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:64)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.Liquibase.update(Liquibase.java:202)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.Liquibase.update(Liquibase.java:181)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.form.engine.FormEngineConfiguration.initDbSchema(FormEngineConfiguration.java:575)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ... 120 more</P><P></P><P>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&nbsp; its not allowing insert statement to execute. Please help us in this. We are stuck into it for a long time.&nbsp;</P></BODY></HTML> Tue, 10 Jul 2018 06:57:53 GMT sumitdatta 2018-07-10T06:57:53Z Unable to start activiti-app if MYSQL Innodb cluster is used https://connect.hyland.com/t5/alfresco-forum/unable-to-start-activiti-app-if-mysql-innodb-cluster-is-used/m-p/26190#M11338 HelloI am&nbsp;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 execut Tue, 10 Jul 2018 06:57:53 GMT https://connect.hyland.com/t5/alfresco-forum/unable-to-start-activiti-app-if-mysql-innodb-cluster-is-used/m-p/26190#M11338 sumitdatta 2018-07-10T06:57:53Z Re: Unable to start activiti-app if MYSQL Innodb cluster is used https://connect.hyland.com/t5/alfresco-forum/unable-to-start-activiti-app-if-mysql-innodb-cluster-is-used/m-p/26191#M11339 <HTML><HEAD></HEAD><BODY><P>Seems a replication issue&nbsp;<A class="link-titled" href="https://bugs.mysql.com/bug.php?id=83165" title="https://bugs.mysql.com/bug.php?id=83165" rel="nofollow noopener noreferrer">MySQL Bugs: #83165: The table does not comply with the requirements by an external plugin</A>&nbsp;</P><P></P><P>Does this only happen for the form engine?</P></BODY></HTML> Wed, 11 Jul 2018 14:37:09 GMT https://connect.hyland.com/t5/alfresco-forum/unable-to-start-activiti-app-if-mysql-innodb-cluster-is-used/m-p/26191#M11339 bassam_al-saror 2018-07-11T14:37:09Z