1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
#
# Test client abort of schema operation
#
# Setup to trigger the client to detect that schema
# distribution is no longer ready
set GLOBAL debug="+d,ndb_schema_dist_client_not_ready";
# Do schema operation which will cause the client to abort its
# schema operation
CREATE TABLE t1(
a int primary key
) engine = NDB;
Warnings:
Warning 1296 Node <nodeid> 'Schema distribution is not ready'
set GLOBAL debug="-d,ndb_schema_dist_client_not_ready";
# Verify that there are no leftover entries in
# mysql.ndb_schema_result table
nodeid schema_op_id participant_nodeid result message
0 rows returned
# Cleanup
DROP TABLE t1;
#
# Bug#30684839 SCHEMA DISTRIBUTION ABORT IS NOT HANDLED PROPERLY SOMETIMES
#
# Setup
CREATE TABLE t1 (
a int primary key
) engine NDB;
# Setup to trigger the client to detect that it was killed before
# starting the schema distribution
set GLOBAL debug="+d,ndb_schema_dist_client_killed_before_write";
# CREATE TABLE should abort the distribution and fail
CREATE TABLE t2 (
a int primary key
) engine NDB;
ERROR HY000: Can't create table 't2' (use SHOW WARNINGS for more info).
# ALTER TABLE should abort the distribution but succeed with warnings
ALTER TABLE t1 ADD COLUMN b int, algorithm = COPY;
Warnings:
Warning 1296 Schema distribution failed
# Remove debug setup
set GLOBAL debug="-d,ndb_schema_dist_client_killed_before_write";
DROP TABLE t1;
# Setup to trigger the client to detect that it was killed while
# waiting for schema distribuiton to complete
set GLOBAL debug="+d,ndb_schema_dist_client_killed_after_write";
# Do schema operation which will cause the client to detect it
# has been killed but will proceed to completion nevertheless
CREATE TABLE t1(
a int primary key
) engine = NDB;
set GLOBAL debug="-d,ndb_schema_dist_client_killed_after_write";
DROP TABLE t1;
# Shutdown the MySQL Server when the coordinator is waiting on the
# participants and verify that they are handled smoothly
# Skip sending ack from participant mysqld2 to make the coordinator wait
set GLOBAL debug="+d,ndb_skip_participant_ack";
# Send the CREATE TABLE query to mysqld1
CREATE TABLE t1 (
a INT PRIMARY KEY
) ENGINE = NDB;
# Wait for the DDL to be logged in ndb_schema table
# The coordinator is now waiting for the participants
# Restart it and verify that it shuts down without any issues
# restart
set GLOBAL debug="-d,ndb_skip_participant_ack";
# Verify that there are no leftover entries in
# mysql.ndb_schema_result table
nodeid schema_op_id participant_nodeid result message
0 rows returned
# Verify table exists
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` int NOT NULL,
PRIMARY KEY (`a`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
# Cleanup
DROP TABLE t1;
|
