[hibernate-issues] [Hibernate-JIRA] Assigned: (HHH-7263) Hibernate sequence generator not working when using multiple SQL nodes on MySQL 7.2 Cluster

Hibernate sequence generator not working when using multiple SQL nodes on MySQL 7.2 Cluster ------------------------------------------------------------------------------------------- Key: HHH-7263 URL: https://hibernate.onjira.com/browse/HHH-7263 Project: Hibernate ORM Issue Type: Sub-task Components: core Affects Versions: 4.1.1 Environment: MySQL 7.2 Cluster Reporter: Zbyněk Roubalík Assignee: Strong Liu Entity tables are created with proper storage engine - NDBCLUSTER (with support of new dialect MySQL5NDBDialect - HHH-1496). Problem is that internal table for sequences is created in default storage engine (not visible to all SQL nodes). * entity table creation: {{create table Country (id integer not null, name varchar(255), primary key (id)) ENGINE=NDBCLUSTER}} * hibernate_sequence table creation: {{create table hibernate_sequence ( next_val bigint )}} This issue could cause serious problems, when loadbalancing is enabled, hibernate_sequences table is created on one SQL node and then this table could be accessed on another SQL node, but is is not visible for this node. This issue is causing many test failures in Hibernate testsuite: https://hudson.qa.jboss.com/hudson/job/hibernate-core-master-matrix-mysql... MySQL Cluster Overview: http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-overview.html