Debian Codegraph @

mysql-test/suite/innodb_fts/t/sync_block.test

raw
1 #
2 # BUG#22516559 MYSQL INSTANCE STALLS WHEN SYNCING FTS INDEX
3 #
4
5 --source include/have_innodb.inc
6 --source include/have_debug.inc
7 --source include/have_debug_sync.inc
8 --source include/have_log_bin.inc
9 --source include/count_sessions.inc
10
11 SET @old_log_output = @@global.log_output;
12 SET @old_slow_query_log = @@global.slow_query_log;
13 SET @old_general_log = @@global.general_log;
14 SET @old_long_query_time = @@global.long_query_time;
15 SET @old_debug = @@global.debug_dbug;
16
17 SET GLOBAL log_output = 'TABLE';
18 SET GLOBAL general_log = 1;
19 SET GLOBAL slow_query_log = 1;
20 SET GLOBAL long_query_time = 1;
21
22 connect (con1,localhost,root,,);
23 connect (con2,localhost,root,,);
24 connection default;
25
26 --echo # Case 1: Sync blocks DML(insert) on the same table.
27 CREATE TABLE t1 (
28 FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
29 title VARCHAR(200),
30 FULLTEXT(title)
31 ) ENGINE = InnoDB;
32
33 connection con1;
34
35 SET GLOBAL debug_dbug='+d,fts_instrument_sync_debug,fts_instrument_sync_sleep';
36
37 SET DEBUG_SYNC= 'fts_sync_begin SIGNAL begin WAIT_FOR continue';
38
39 send INSERT INTO t1(title) VALUES('mysql database');
40
41 connection con2;
42
43 SET DEBUG_SYNC= 'now WAIT_FOR begin';
44
45 send SELECT * FROM t1 WHERE MATCH(title) AGAINST('mysql database');
46
47 connection default;
48 SET DEBUG_SYNC= 'now SIGNAL continue';
49
50 connection con1;
51 --echo /* connection con1 */ INSERT INTO t1(title) VALUES('mysql database');
52 --reap
53
54 connection con2;
55 --echo /* conneciton con2 */ SELECT * FROM t1 WHERE MATCH(title) AGAINST('mysql database');
56 --reap
57
58 connection default;
59 -- echo # make con1 & con2 show up in mysql.slow_log
60 SELECT SLEEP(2);
61 -- echo # slow log results should only contain INSERT INTO t1.
62 SELECT sql_text FROM mysql.slow_log WHERE query_time >= '00:00:02';
63
64 SET GLOBAL debug_dbug = @old_debug;
65 TRUNCATE TABLE mysql.slow_log;
66
67 DROP TABLE t1;
68
69 --echo # Case 2: Sync blocks DML(insert) on other tables.
70 CREATE TABLE t1 (
71 FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
72 title VARCHAR(200),
73 FULLTEXT(title)
74 ) ENGINE = InnoDB;
75
76 CREATE TABLE t2(id INT);
77
78 connection con1;
79
80 SET GLOBAL debug_dbug='+d,fts_instrument_sync_request,fts_instrument_sync_sleep';
81
82 SET DEBUG_SYNC= 'fts_instrument_sync_request SIGNAL begin WAIT_FOR continue';
83
84 send INSERT INTO t1(title) VALUES('mysql database');
85
86 connection con2;
87
88 SET DEBUG_SYNC= 'now WAIT_FOR begin';
89
90 send INSERT INTO t2 VALUES(1);
91
92 connection default;
93 SET DEBUG_SYNC= 'now SIGNAL continue';
94
95 connection con1;
96 --echo /* connection con1 */ INSERT INTO t1(title) VALUES('mysql database');
97 --reap
98
99 connection con2;
100 --echo /* conneciton con2 */ INSERT INTO t2 VALUES(1);
101 --reap
102
103 connection default;
104 SET DEBUG_SYNC = 'RESET';
105 -- echo # make con1 & con2 show up in mysql.slow_log
106 SELECT SLEEP(2);
107 -- echo # slow log results should be empty here.
108 SELECT sql_text FROM mysql.slow_log WHERE query_time >= '00:00:02';
109
110 SET GLOBAL debug_dbug = @old_debug;
111 TRUNCATE TABLE mysql.slow_log;
112
113 DROP TABLE t1,t2;
114
115 disconnect con1;
116 disconnect con2;
117
118 --source include/wait_until_count_sessions.inc
119
120 -- echo # Restore slow log settings.
121 SET GLOBAL log_output = @old_log_output;
122 SET GLOBAL general_log = @old_general_log;
123 SET GLOBAL slow_query_log = @old_slow_query_log;
124 SET GLOBAL long_query_time = @old_long_query_time;