I have a table with two columns col1, col2 which are composite primary keys. Will, that table supports group replication in MySQL InnoDB clustering?
Error message:
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [/* insert collection row com.domain.BatchClass.documentTypes */ insert into batch_class_document_type (batch_class_id, document_type_id) values (?, ?)]; SQL state [HY000]; error code [3098]; The table does not comply with the requirements by an external plugin.; nested exception is
SHOW CREATE TABLE:
CREATE TABLE `batch_class_document_type` (
`batch_class_id` bigint(20) NOT NULL,
`document_type_id` bigint(20) NOT NULL,
PRIMARY KEY (`batch_class_id`,`document_type_id`),
KEY `FKB72AFCD2997AC796` (`document_type_id`),
KEY `FKB72AFCD2C473EFCA` (`batch_class_id`),
CONSTRAINT `FKB72AFCD2997AC796` FOREIGN KEY (`document_type_id`)
REFERENCES `document_type` (`id`),
CONSTRAINT `FKB72AFCD2C473EFCA` FOREIGN KEY (`batch_class_id`)
REFERENCES `batch_class` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8