Debian Codegraph @

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

raw
1 #
2 # Test that applying a DDL plays well with FLUSH TABLE table_name WITH READ LOCK. The applier
3 # thread should block until UNLOCK TABLEs.
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 --connection node_1
10 SET SESSION wsrep_sync_wait = 0;
11
12 # Those values are valid only for connection node_1. The global values from the -master.opt file apply to applier threads.
13 SET SESSION lock_wait_timeout = 60;
14 SET SESSION innodb_lock_wait_timeout=60;
15 SET SESSION wait_timeout=60;
16
17 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
18
19 FLUSH TABLE t1 WITH READ LOCK;
20
21 --connection node_2
22 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'
23 --source include/wait_condition.inc
24
25 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
26
27 --connection node_1
28 SELECT 1 FROM DUAL;
29 # Wait
30 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
31 --source include/wait_condition.inc
32
33 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
34
35 UNLOCK TABLES;
36
37 SET SESSION wsrep_sync_wait = 15;
38
39 SHOW CREATE TABLE t1;
40 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
41
42 DROP TABLE t1;