Debian Codegraph @

mysql-test/suite/galera/t/galera_fk_cascade_delete_debug.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4
5 --echo #
6 --echo # test phase with foreign key of varchar type
7 --echo #
8 --connection node_1
9 CREATE TABLE parent (
10 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
11 PRIMARY KEY (`id`)
12 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
13
14
15 CREATE TABLE child (
16 `id` int NOT NULL,
17 `parent_id` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
18 PRIMARY KEY (`id`),
19 KEY `parent_id` (`parent_id`),
20 CONSTRAINT `ipallocations_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
22
23
24 INSERT INTO parent VALUES ('row one'), ('row two');
25 INSERT INTO child VALUES (1,'row one'), (2,'row two');
26
27 --connection node_2
28 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'parent'
29 --source include/wait_condition.inc
30 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'child'
31 --source include/wait_condition.inc
32 --let $wait_condition = SELECT COUNT(*) = 2 FROM parent;
33 --source include/wait_condition.inc
34 --let $wait_condition = SELECT COUNT(*) = 2 FROM child;
35 --source include/wait_condition.inc
36
37 DELETE FROM parent;
38
39 --connection node_1
40 --let $wait_condition = SELECT COUNT(*) = 0 FROM parent;
41 --source include/wait_condition.inc
42 --let $wait_condition = SELECT COUNT(*) = 0 FROM child;
43 --source include/wait_condition.inc
44
45 SELECT * FROM parent;
46 SELECT * FROM child;
47
48 DROP TABLE child;
49 DROP TABLE parent;
50
51 --echo #
52 --echo # test phase with MM conflict in FK cascade
53 --echo #
54
55 --connection node_1
56 set wsrep_retry_autocommit=0;
57 CREATE TABLE parent (
58 id INT NOT NULL PRIMARY KEY
59 ) ENGINE=InnoDB;
60
61 CREATE TABLE child (
62 id INT NOT NULL PRIMARY KEY,
63 j int default 0,
64 parent_id INT,
65 FOREIGN KEY (parent_id)
66 REFERENCES parent(id)
67 ON DELETE CASCADE
68 ) ENGINE=InnoDB;
69
70 INSERT INTO parent VALUES (1);
71 INSERT INTO child VALUES (1,0,1);
72
73 --connection node_2
74 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'parent'
75 --source include/wait_condition.inc
76 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'child'
77 --source include/wait_condition.inc
78 --let $wait_condition = SELECT COUNT(*) = 1 FROM parent;
79 --source include/wait_condition.inc
80 --let $wait_condition = SELECT COUNT(*) = 1 FROM child;
81 --source include/wait_condition.inc
82
83 # block applier before applying
84 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
85 SET GLOBAL debug_dbug = "d,sync.wsrep_apply_cb";
86
87 --connection node_2
88 DELETE FROM parent;
89
90 --connection node_1a
91 # wait until applier has reached the sync point
92 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
93
94 --connection node_1
95 # issue conflicting write to child table, it should fail in certification
96 --send update child set j=2;
97
98 --connection node_1a
99 # release the applier
100 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
101 SET GLOBAL debug_dbug = "";
102 SET DEBUG_SYNC = "RESET";
103
104 --connection node_1
105 --error 0,ER_LOCK_DEADLOCK, ER_LOCK_WAIT_TIMEOUT
106 --reap
107 --let $wait_condition = SELECT COUNT(*) = 0 FROM parent;
108 --source include/wait_condition.inc
109 --let $wait_condition = SELECT COUNT(*) = 0 FROM child;
110 --source include/wait_condition.inc
111
112 SELECT * FROM parent;
113 SELECT * FROM child;
114
115 DROP TABLE child;
116 DROP TABLE parent;