Debian Codegraph @

mysql-test/suite/galera/r/lp1376747-4.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
5 INSERT INTO t1 VALUES (1);
6 connection node_2;
7 SET session wsrep_sync_wait=0;
8 FLUSH TABLES WITH READ LOCK;
9 connection node_1;
10 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
11 INSERT INTO t1 VALUES (2,3);
12 connection node_2a;
13 SET session wsrep_sync_wait=0;
14 SHOW CREATE TABLE t1;
15 Table Create Table
16 t1 CREATE TABLE `t1` (
17 `id` int(11) NOT NULL,
18 PRIMARY KEY (`id`)
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
20 SET debug_sync='flush_tables_with_read_lock_after_acquire_locks SIGNAL parked2 WAIT_FOR go2';
21 FLUSH TABLES t1 WITH READ LOCK;;
22 connection node_2;
23 SET debug_sync='now WAIT_FOR parked2';
24 SET debug_sync='now SIGNAL go2';
25 UNLOCK TABLES;
26 SHOW CREATE TABLE t1;
27 Table Create Table
28 t1 CREATE TABLE `t1` (
29 `id` int(11) NOT NULL,
30 PRIMARY KEY (`id`)
31 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
32 connection node_2a;
33 set debug_sync= 'RESET';
34 UNLOCK TABLES;
35 SET SESSION wsrep_sync_wait = DEFAULT;
36 SHOW CREATE TABLE t1;
37 Table Create Table
38 t1 CREATE TABLE `t1` (
39 `id` int(11) NOT NULL,
40 `f2` int(11) DEFAULT NULL,
41 PRIMARY KEY (`id`)
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
43 SELECT * from t1;
44 id f2
45 1 NULL
46 2 3
47 connection node_1;
48 DROP TABLE t1;