Debian Codegraph @

mysql-test/suite/innodb_fts/t/sync.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_sync.inc
7 --source include/not_valgrind.inc
8 --source include/not_embedded.inc
9 --source include/not_crashrep.inc
10 --source include/maybe_versioning.inc
11
12 connect (con1,localhost,root,,);
13 connection default;
14
15 --echo # Case 1: Test select and insert(row in both disk and cache)
16 CREATE TABLE t1 (
17 FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
18 title VARCHAR(200),
19 FULLTEXT(title)
20 ) ENGINE = InnoDB;
21
22 INSERT INTO t1(title) VALUES('mysql');
23 INSERT INTO t1(title) VALUES('database');
24
25 connection con1;
26
27 SET @old_dbug = @@SESSION.debug_dbug;
28 SET debug_dbug = '+d,fts_instrument_sync_debug';
29
30 SET DEBUG_SYNC= 'fts_write_node SIGNAL written WAIT_FOR selected';
31
32 send INSERT INTO t1(title) VALUES('mysql database');
33
34 connection default;
35
36 SET DEBUG_SYNC= 'now WAIT_FOR written';
37
38 SET GLOBAL innodb_ft_aux_table="test/t1";
39 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
40 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
41 SET GLOBAL innodb_ft_aux_table=default;
42
43 SELECT * FROM t1 WHERE MATCH(title) AGAINST('mysql database');
44
45 SET DEBUG_SYNC= 'now SIGNAL selected';
46
47 connection con1;
48 --reap
49
50 SET @old_dbug = @@SESSION.debug_dbug;
51
52 SET GLOBAL innodb_ft_aux_table="test/t1";
53 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
54 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
55 SET GLOBAL innodb_ft_aux_table=default;
56
57 SELECT * FROM t1 WHERE MATCH(title) AGAINST('mysql database');
58
59 connection default;
60
61 DROP TABLE t1;
62
63 --echo # Case 2: Test insert and insert(sync)
64 CREATE TABLE t1 (
65 FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
66 title VARCHAR(200),
67 FULLTEXT(title)
68 ) ENGINE = InnoDB;
69
70 INSERT INTO t1(title) VALUES('mysql');
71 INSERT INTO t1(title) VALUES('database');
72
73 connection con1;
74
75 SET debug_dbug = '+d,fts_instrument_sync_debug';
76
77 SET DEBUG_SYNC= 'fts_write_node SIGNAL written WAIT_FOR inserted';
78
79 send INSERT INTO t1(title) VALUES('mysql database');
80
81 connection default;
82
83 SET DEBUG_SYNC= 'now WAIT_FOR written';
84
85 INSERT INTO t1(title) VALUES('mysql database');
86
87 SET DEBUG_SYNC= 'now SIGNAL inserted';
88
89 connection con1;
90 --reap
91
92 SET debug_dbug = @old_dbug;
93
94 SET GLOBAL innodb_ft_aux_table="test/t1";
95 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
96 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
97 SET GLOBAL innodb_ft_aux_table=default;
98
99 SELECT * FROM t1 WHERE MATCH(title) AGAINST('mysql database');
100
101 connection default;
102 disconnect con1;
103
104 DROP TABLE t1;
105
106 --echo # Case 3: Test insert crash recovery
107 --let $_expect_file_name= `select regexp_replace(@@tmpdir, '^.*/','')`
108 --let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/$_expect_file_name.expect
109
110 CREATE TABLE t1 (
111 FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
112 title VARCHAR(200),
113 FULLTEXT(title)
114 ) ENGINE = InnoDB;
115
116 INSERT INTO t1(title) VALUES('database');
117
118 --write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
119
120 SET debug_dbug = '+d,fts_instrument_sync_debug,fts_write_node_crash';
121
122 --error 2013
123 INSERT INTO t1(title) VALUES('mysql');
124
125 --source include/start_mysqld.inc
126
127 -- echo After restart
128 # PAGE_ROOT_AUTO_INC could contain last failed autoinc value. Avoid
129 # doing show the result of auto increment field
130 SELECT title FROM t1 WHERE MATCH(title) AGAINST ('mysql database');
131
132 SET @old_dbug = @@SESSION.debug_dbug;
133
134 SET debug_dbug = '+d,fts_instrument_sync_debug';
135
136 INSERT INTO t1(title) VALUES('mysql');
137
138 SET debug_dbug = @old_dbug;
139
140 SELECT title FROM t1 WHERE MATCH(title) AGAINST ('mysql database');
141
142 DROP TABLE t1;
143
144 --echo # Case 4: Test sync commit & rollback in background
145 CREATE TABLE t1(
146 id INT AUTO_INCREMENT,
147 title VARCHAR(100),
148 FULLTEXT(title),
149 PRIMARY KEY(id)) ENGINE=InnoDB;
150
151 SET debug_dbug = '+d,fts_instrument_sync';
152 INSERT INTO t1(title) VALUES('mysql');
153 SET debug_dbug = @old_dbug;
154
155 --source include/restart_mysqld.inc
156
157 SET @old_global_dbug = @@GLOBAL.debug_dbug;
158 SET @old_dbug = @@SESSION.debug_dbug;
159 SET GLOBAL debug_dbug='+d,fts_instrument_sync,fts_instrument_sync_interrupted';
160 INSERT INTO t1(title) VALUES('database');
161 SET GLOBAL debug_dbug = @old_global_dbug;
162
163 SET debug_dbug = '+d,fts_instrument_sync_debug';
164 INSERT INTO t1(title) VALUES('good');
165 SET debug_dbug = @old_dbug;
166
167 SET GLOBAL innodb_ft_aux_table="test/t1";
168 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
169 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
170 SET GLOBAL innodb_ft_aux_table=default;
171
172 SELECT * FROM t1 WHERE MATCH(title) AGAINST ('mysql database good');
173
174 DROP TABLE t1;
175
176 --echo #
177 --echo # MDEV-26273 InnoDB fts DDL fails when
178 --echo # innodb_force_recovery is set to 2
179 --echo #
180
181 let $restart_parameters=--innodb_force_recovery=2;
182 --source include/restart_mysqld.inc
183 CREATE TABLE t1 (FTS_DOC_ID BIGINT UNSIGNED KEY,
184 f1 CHAR(200)) ENGINE=InnoDB;
185 ALTER TABLE t1 ADD FULLTEXT INDEX(f1);
186 DROP TABLE t1;
187 let $restart_parameters=;
188 --source include/restart_mysqld.inc