Debian Codegraph @

mysql-test/suite/innodb/t/i_s_innodb_tables.test

raw
1 --source include/have_debug_sync.inc
2
3 --echo #
4 --echo # Bug#30591967 BACKUP FAILS WITH "CANNOT STORE RESULT" ERROR
5 --echo # WHEN DDL EXECUTED IN PARALLEL
6 --echo #
7
8 --echo #
9 --echo # Case 1 : Using non-partitioned table.
10 --echo #
11
12 CREATE DATABASE db1;
13 CREATE TABLE db1.t1 (f1 INT) ENGINE='InnoDB';
14 --replace_column 1 # 5 #
15 SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE name like 'db1/t1';
16
17
18 --echo # Evict db1.t1 from innodb cache by restarting the server.
19 --source include/restart_mysqld.inc
20
21 connect (con1,localhost,root,,);
22
23 --echo # Wait after acquiring table object, but before schema object is acquired.
24 SET GLOBAL DEBUG= '+d,before_acquire_schema_by_private_id';
25 SET DEBUG_SYNC="wait_before_acquire_schema_by_private_id SIGNAL cond1 WAIT_FOR cond2";
26 --send SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE name = 'db1/t1';
27
28 --echo # Drop the schema db1 in other session.
29 connection default;
30 SET DEBUG_SYNC= 'now WAIT_FOR cond1';
31 DROP DATABASE db1;
32 SET DEBUG_SYNC= 'now SIGNAL cond2';
33
34 --echo # Continue acquiring db1. reap results
35 --echo # in a error ER_BAD_DB_ERROR without fix.
36 connection con1;
37 --reap
38
39 --echo # Cleanup
40 connection default;
41 SET DEBUG_SYNC= 'RESET';
42 SET GLOBAL DEBUG= DEFAULT;
43 disconnect con1;
44
45 --echo #
46 --echo # Case 2 : Using partitioned table.
47 --echo #
48
49 CREATE DATABASE db1;
50 CREATE TABLE db1.t1 (a INT NOT NULL, b INT NOT NULL)
51 PARTITION BY KEY (a) PARTITIONS 1;
52 --replace_column 1 # 5 #
53 SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE name like 'db1/t1#p#p0';
54
55
56 --echo # Evict db1.t1 from innodb cache by restarting the server.
57 --source include/restart_mysqld.inc
58
59 connect (con1,localhost,root,,);
60
61 --echo # Wait after acquiring table object, but before schema object is acquired.
62 SET GLOBAL DEBUG= '+d,before_acquire_schema_by_private_id';
63 SET DEBUG_SYNC="wait_before_acquire_schema_by_private_id SIGNAL cond1 WAIT_FOR cond2";
64 --send SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE name = 'db1/t1#p#p0';
65
66 --echo # Drop the schema db1 in other session.
67 connection default;
68 SET DEBUG_SYNC= 'now WAIT_FOR cond1';
69 DROP DATABASE db1;
70 SET DEBUG_SYNC= 'now SIGNAL cond2';
71
72 --echo # Continue acquiring db1. reap results
73 --echo # in a error ER_BAD_DB_ERROR without fix.
74 connection con1;
75 --reap
76
77 --echo # Cleanup
78 connection default;
79 SET DEBUG_SYNC= 'RESET';
80 SET GLOBAL DEBUG= DEFAULT;
81 disconnect con1;