Debian Codegraph @

mysql-test/suite/innodb_fts/r/concurrent_insert.result

raw
1 CREATE TABLE t1(a VARCHAR(5),FULLTEXT KEY(a)) ENGINE=InnoDB;
2 SET DEBUG_SYNC = 'get_next_FTS_DOC_ID SIGNAL prepared WAIT_FOR race';
3 REPLACE INTO t1(a) values('aaa');
4 connect dml, localhost, root, ,;
5 SET DEBUG_SYNC = 'now WAIT_FOR prepared';
6 REPLACE INTO t1(a) VALUES('aaa');
7 SET DEBUG_SYNC = 'now SIGNAL race';
8 disconnect dml;
9 connection default;
10 SET DEBUG_SYNC = 'RESET';
11 DROP TABLE t1;
12 #
13 # MDEV-19529 InnoDB hang on DROP FULLTEXT INDEX
14 #
15 CREATE TABLE t1(f1 CHAR(100), FULLTEXT(f1))ENGINE=InnoDB;
16 INSERT INTO t1 VALUES('test');
17 CREATE TABLE t2 (f1 char(100), FULLTEXT idx1(f1))ENGINE=InnoDB;
18 INSERT INTO t2 VALUES('mariadb');
19 connection default;
20 SET @saved_dbug = @@GLOBAL.debug_dbug;
21 SET GLOBAL debug_dbug ='+d,fts_instrument_sync_request,ib_optimize_wq_hang';
22 SET DEBUG_SYNC= 'fts_instrument_sync_request
23 SIGNAL drop_index_start WAIT_FOR sync_op';
24 INSERT INTO t1 VALUES('Keyword');
25 connect con1,localhost,root,,,;
26 SET DEBUG_SYNC='now WAIT_FOR drop_index_start';
27 SET DEBUG_SYNC= 'norebuild_fts_drop SIGNAL sync_op WAIT_FOR fts_drop_index';
28 ALTER TABLE t2 drop index idx1;
29 connection default;
30 set DEBUG_SYNC= 'now SIGNAL fts_drop_index';
31 connection con1;
32 drop table t1, t2;
33 connection default;
34 SET @@GLOBAL.debug_dbug = @saved_dbug;
35 disconnect con1;
36 #
37 # MDEV-25984 Assertion `max_doc_id > 0' failed in fts_init_doc_id()
38 #
39 call mtr.add_suppression("InnoDB: \\(Lock wait timeout\\) while getting next doc id for table `test`.`t1`");
40 CREATE TABLE t1(f1 CHAR(100), f2 INT, fulltext(f1))ENGINE=InnoDB;
41 INSERT INTO t1 VALUES("mariadb", 1), ("innodb", 1);
42 # restart
43 SET DEBUG_SYNC='innodb_rollback_after_fts_lock SIGNAL insert_dml WAIT_FOR ddl_continue';
44 ALTER TABLE t1 ADD UNIQUE INDEX(f2);
45 connect con1,localhost,root,,,;
46 SET DEBUG_SYNC='now WAIT_FOR insert_dml';
47 SET DEBUG_SYNC='fts_cmp_set_sync_doc_id_retry SIGNAL ddl_continue WAIT_FOR dml_finish';
48 INSERT INTO t1 VALUES("index", 2);
49 connection default;
50 ERROR 23000: Duplicate entry '1' for key 'f2'
51 SET DEBUG_SYNC="now SIGNAL dml_finish";
52 connection con1;
53 SHOW CREATE TABLE t1;
54 Table Create Table
55 t1 CREATE TABLE `t1` (
56 `f1` char(100) DEFAULT NULL,
57 `f2` int(11) DEFAULT NULL,
58 FULLTEXT KEY `f1` (`f1`)
59 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
60 connection default;
61 disconnect con1;
62 DROP TABLE t1;
63 set DEBUG_SYNC=RESET;