Debian Codegraph @

mysql-test/suite/innodb/t/innodb-index-online-purge.test

raw
1
2 --source include/have_debug_sync.inc
3 # This test fails sporadically on valgrind, hence skipping
4 --source include/not_valgrind.inc
5
6 # Save the initial number of concurrent sessions.
7 --source include/count_sessions.inc
8
9 connect (con1,localhost,root,,);
10
11 connect (con2,localhost,root,,);
12 connection default;
13
14 CREATE TABLE t (a INT PRIMARY KEY, c TEXT) ENGINE=InnoDB;
15 CREATE TABLE u (a INT PRIMARY KEY, b INT, c INT NOT NULL) ENGINE=InnoDB;
16
17 INSERT INTO t VALUES (1,'aa');
18 BEGIN;
19 INSERT INTO u SET a=1, c=1;
20 INSERT INTO u SELECT a+1,NULL,a+1 FROM u;
21 INSERT INTO u SELECT a+2,NULL,a+2 FROM u;
22 INSERT INTO u SELECT a+4,NULL,a+4 FROM u;
23 INSERT INTO u SELECT a+8,NULL,a+8 FROM u;
24 INSERT INTO u SELECT a+16,NULL,a+16 FROM u;
25 INSERT INTO u SELECT a+32,NULL,a+32 FROM u;
26 INSERT INTO u SELECT a+64,NULL,a+64 FROM u;
27 INSERT INTO u SELECT a+128,NULL,a+64 FROM u;
28 INSERT INTO u SELECT a+256,NULL,a+64 FROM u;
29 COMMIT;
30
31 BEGIN;
32 DELETE FROM u;
33
34 connection con2;
35 SET DEBUG_SYNC='row_log_apply_before SIGNAL created_u WAIT_FOR dml_done_u';
36 --send
37 ALTER TABLE u ADD INDEX (c);
38
39 connection default;
40 # Check that the above SELECT is blocked
41 let $wait_condition=
42 SELECT COUNT(*) = 1 from information_schema.processlist
43 WHERE state = 'Waiting for table metadata lock' AND
44 info = 'ALTER TABLE u ADD INDEX (c)';
45 --source include/wait_condition.inc
46
47 COMMIT;
48 SET DEBUG_SYNC='now WAIT_FOR created_u';
49 SELECT state FROM information_schema.processlist
50 WHERE info='ALTER TABLE u ADD INDEX (c)';
51
52 connection con1;
53 SET DEBUG_SYNC='row_log_apply_before SIGNAL created_t WAIT_FOR dml_done_t';
54 --send
55 CREATE INDEX c1 ON t (c(1));
56 connection default;
57 SET DEBUG_SYNC='now WAIT_FOR created_t';
58 UPDATE t SET c='ab';
59
60 --source include/wait_innodb_all_purged.inc
61
62 SET DEBUG_SYNC='now SIGNAL dml_done_u';
63 connection con2;
64 reap;
65 SET DEBUG_SYNC='now SIGNAL dml_done_t';
66 disconnect con2;
67 connection con1;
68 reap;
69 disconnect con1;
70 connection default;
71 SET DEBUG_SYNC='RESET';
72 DROP TABLE t,u;
73
74 # Check that all connections opened by test cases in this file are really
75 # gone so execution of other tests won't be affected by their presence.
76 --source include/wait_until_count_sessions.inc