Bug #121320 Cluster failure on NDB cluster

• Submitted: 19 Sep 15:09
• Reporter: Jiyuan Li
• Status: Open
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 26.7.1-cluster
• OS: Ubuntu (24.04)
• CPU Architecture: Any

[19 Sep 15:09] Jiyuan Li

Description:
I use docker container to deploly a cluster with one management node and two data node, and after executing following statements, any statement will report error. 

How to repeat:
CREATE TABLE t0(c0 BIGINT(184)   STORAGE MEMORY, PRIMARY KEY (c0)) ENGINE = NDBCLUSTER partition by hash(c0) partitions 13;
REPLACE INTO t0 VALUES (-869), (-868), (-867), (-866), (-865), (-864), (-863), (-862), (-861), (-860), (-859), (-858), (-857), (-856), (-855), (-854), (-853), (-852), (-851), (-850);
CREATE TABLE IF NOT EXISTS t1(c0 FLOAT  UNIQUE KEY, PRIMARY KEY (c0)) ENGINE = NDBCLUSTER partition by range(c0)(partition p0 values less than(4257),partition p1 values less than(8561),partition p2 values less than(12823),partition p3 values less than(17175),partition p4 values less than(21434),partition p5 values less than(25782),partition p6 values less than(30057),partition p7 values less than(34329),partition p8 values less than(38586),partition p9 values less than(42870),partition p10 values less than(47128),partition p11 values less than(51398),partition p12 values less than(55681),partition p13 values less than(59980),partition p14 values less than maxvalue);
CREATE TABLE IF NOT EXISTS t1 LIKE t0;
alter table t1 partition by key(c0) partitions 18;
set global ndb_fully_replicated = 0;
check table t1 ;
create table t0_oracle(c0 bigint(184)   storage memory, primary key (c0)) engine = ndbcluster;
set global schema_definition_cache = 397701;
alter table t1_oracle pack_keys default, checksum 0;
alter table t0_oracle force, algorithm copy, compression 'zlib', stats_persistent 1, delay_key_write 0, disable keys, checksum 1, pack_keys default, insert_method last;
analyze local table t1_oracle drop histogram on c0;
analyze  table t1_oracle update histogram on c0;
alter table t0_oracle row_format fixed, compression 'zlib', delay_key_write 0, pack_keys 1, checksum 0, stats_persistent 1;
alter table t0_oracle partition by key(c0) partitions 12;
show tables;
insert into t2_oracle(c0) values("-1776569524");

mysql> select * from t0;
ERROR 1296 (HY000): Got error 4009 'Cluster Failure' from NDBCLUSTER