Debian Codegraph @

mysql-test/suite/innodb/r/innodb_stats_drop_locked.result

raw
1 CREATE DATABASE unlocked;
2 CREATE TABLE unlocked.t1(a INT PRIMARY KEY) ENGINE=INNODB STATS_PERSISTENT=0;
3 CREATE DATABASE locked;
4 CREATE TABLE locked.t1(a INT PRIMARY KEY) ENGINE=INNODB STATS_PERSISTENT=1;
5 CREATE TABLE innodb_stats_drop_locked (c INT, KEY c_key (c))
6 ENGINE=INNODB STATS_PERSISTENT=1;
7 ANALYZE TABLE innodb_stats_drop_locked;
8 Table Op Msg_type Msg_text
9 test.innodb_stats_drop_locked analyze status Engine-independent statistics collected
10 test.innodb_stats_drop_locked analyze status OK
11 BEGIN;
12 SELECT table_name FROM mysql.innodb_table_stats
13 WHERE table_name='innodb_stats_drop_locked'
14 FOR UPDATE;
15 table_name
16 innodb_stats_drop_locked
17 SELECT table_name FROM mysql.innodb_index_stats
18 WHERE table_name='innodb_stats_drop_locked'
19 FOR UPDATE;
20 table_name
21 innodb_stats_drop_locked
22 innodb_stats_drop_locked
23 innodb_stats_drop_locked
24 innodb_stats_drop_locked
25 innodb_stats_drop_locked
26 innodb_stats_drop_locked
27 innodb_stats_drop_locked
28 connect con1,localhost,root,,;
29 SET innodb_lock_wait_timeout=1;
30 ALTER TABLE innodb_stats_drop_locked DROP INDEX c_key;
31 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
32 SHOW CREATE TABLE innodb_stats_drop_locked;
33 Table Create Table
34 innodb_stats_drop_locked CREATE TABLE `innodb_stats_drop_locked` (
35 `c` int(11) DEFAULT NULL,
36 KEY `c_key` (`c`)
37 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci STATS_PERSISTENT=1
38 DROP TABLE innodb_stats_drop_locked;
39 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
40 DROP DATABASE unlocked;
41 DROP DATABASE locked;
42 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
43 disconnect con1;
44 connection default;
45 COMMIT;
46 DROP DATABASE locked;
47 SELECT table_name FROM mysql.innodb_table_stats
48 WHERE table_name='innodb_stats_drop_locked';
49 table_name
50 innodb_stats_drop_locked
51 SELECT table_name FROM mysql.innodb_index_stats
52 WHERE table_name='innodb_stats_drop_locked';
53 table_name
54 innodb_stats_drop_locked
55 innodb_stats_drop_locked
56 innodb_stats_drop_locked
57 innodb_stats_drop_locked
58 innodb_stats_drop_locked
59 innodb_stats_drop_locked
60 innodb_stats_drop_locked
61 ALTER TABLE innodb_stats_drop_locked DROP INDEX c_key;
62 SELECT table_name FROM mysql.innodb_index_stats
63 WHERE table_name='innodb_stats_drop_locked';
64 table_name
65 innodb_stats_drop_locked
66 innodb_stats_drop_locked
67 innodb_stats_drop_locked
68 DROP TABLE innodb_stats_drop_locked;
69 SELECT table_name FROM mysql.innodb_table_stats
70 WHERE table_name='innodb_stats_drop_locked';
71 table_name
72 SELECT table_name FROM mysql.innodb_index_stats
73 WHERE table_name='innodb_stats_drop_locked';
74 table_name