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

[Zbyněk Roubalík (JIRA)]

     [ https://hibernate.onjira.com/browse/HHH-7263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zbyněk Roubalík reassigned HHH-7263:
------------------------------------

    Assignee: Strong Liu

> 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-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