Debian Codegraph @

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

raw
1 #
2 # Bug #33135425 RACE CONDITION LEADING TO ASSERTION ON UNINITIALIZED STATS
3 #
4 set global table_open_cache = 16;
5 create table t (i int, j int, primary key(i), key(j));
6 create table u (i int, j int, primary key(i), key(j));
7 select * from t;
8 i j
9 select * from u;
10 i j
11 select * from t;
12 i j
13 select * from u;
14 i j
15 select * from t;
16 i j
17 SET DEBUG_SYNC = 'after_open_tables SIGNAL c0 WAIT_FOR c1';
18 SET DEBUG_SYNC = 'innodb.after_init_check SIGNAL c2 WAIT_FOR c3';
19 show keys in t;
20 SET DEBUG_SYNC = 'now WAIT_FOR c0';
21 SET DEBUG_SYNC = 'innodb.before_stats_deinit SIGNAL c1 WAIT_FOR c2 TIMEOUT 5 ';
22 select * from u;
23 i j
24 Warnings:
25 Warning 1639 debug sync point wait timed out
26 SET DEBUG_SYNC = 'now SIGNAL c3';
27 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
28 t 0 PRIMARY 1 i A 0 NULL NULL BTREE YES NULL
29 t 1 j 1 j A 0 NULL NULL YES BTREE YES NULL
30 SET DEBUG_SYNC ='RESET';
31 drop table t,u;
32 set global table_open_cache = default;