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

[Zbyněk Roubalík (JIRA)]

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


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-mysql72/40/testReport/


MySQL Cluster Overview:
http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-overview.html

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira