Debian Codegraph @

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

raw
1 # Bug #28523042
2 # INNODB: ASSERTION FAILURE: LOCK0LOCK.CC:7034 IN DEADLOCKCHECKER::SEARCH*
3 SET @innodb_lock_wait_timeout_saved = @@global.innodb_lock_wait_timeout;
4 SET @@global.innodb_lock_wait_timeout = 100000;
5 CREATE TABLE t1(f1 INT KEY,f2 INT);
6 INSERT INTO t1 VALUES(2,2);
7 SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
8 BEGIN;
9 SELECT COUNT(1) FROM mysql.innodb_table_stats
10 WHERE database_name='test' AND table_name='t1' FOR SHARE;
11 COUNT(1)
12 1
13 INSERT INTO t1 VALUES(1,2);
14 SELECT count(1) FROM mysql.innodb_table_stats
15 WHERE database_name='test' AND table_name='t1' FOR UPDATE;
16 count(1)
17 1
18 call mtr.add_suppression(
19 "Cannot save table statistics for table `test`.`t1`: Deadlock"
20 );
21 COMMIT;
22 DROP TABLE t1;
23 CREATE TABLE t1 (
24 id INT PRIMARY KEY AUTO_INCREMENT,
25 name TEXT
26 ) ENGINE=InnoDB
27 SELECT table_name AS name
28 FROM information_schema.tables
29 WHERE table_schema="mysql" AND engine="InnoDB"
30 AND table_name NOT IN (
31 "ndb_binlog_index", "user", "db", "tables_priv", "columns_priv",
32 "procs_priv", "proxies_priv", "role_edges", "default_roles",
33 "global_grants", "password_history",
34 "replication_asynchronous_connection_failover_managed"
35 )
36 ORDER BY table_name;
37 Preparing deadlock scenario for mysql.component
38 ROLLBACK;
39 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
40 ROLLBACK;
41 Preparing deadlock scenario for mysql.engine_cost
42 ROLLBACK;
43 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
44 ROLLBACK;
45 Preparing deadlock scenario for mysql.func
46 ROLLBACK;
47 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
48 ROLLBACK;
49 Preparing deadlock scenario for mysql.gtid_executed
50 ROLLBACK;
51 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
52 ROLLBACK;
53 Preparing deadlock scenario for mysql.help_category
54 ROLLBACK;
55 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
56 ROLLBACK;
57 Preparing deadlock scenario for mysql.help_keyword
58 ROLLBACK;
59 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
60 ROLLBACK;
61 Preparing deadlock scenario for mysql.help_relation
62 ROLLBACK;
63 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
64 ROLLBACK;
65 Preparing deadlock scenario for mysql.help_topic
66 ROLLBACK;
67 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
68 ROLLBACK;
69 Preparing deadlock scenario for mysql.innodb_index_stats
70 ROLLBACK;
71 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
72 ROLLBACK;
73 Preparing deadlock scenario for mysql.innodb_table_stats
74 ROLLBACK;
75 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
76 ROLLBACK;
77 Preparing deadlock scenario for mysql.plugin
78 ROLLBACK;
79 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
80 ROLLBACK;
81 Preparing deadlock scenario for mysql.replication_asynchronous_connection_failover
82 ROLLBACK;
83 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
84 ROLLBACK;
85 Preparing deadlock scenario for mysql.replication_group_configuration_version
86 ROLLBACK;
87 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
88 ROLLBACK;
89 Preparing deadlock scenario for mysql.replication_group_member_actions
90 ROLLBACK;
91 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
92 ROLLBACK;
93 Preparing deadlock scenario for mysql.server_cost
94 ROLLBACK;
95 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
96 ROLLBACK;
97 Preparing deadlock scenario for mysql.servers
98 ROLLBACK;
99 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
100 ROLLBACK;
101 Preparing deadlock scenario for mysql.slave_master_info
102 ROLLBACK;
103 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
104 ROLLBACK;
105 Preparing deadlock scenario for mysql.slave_relay_log_info
106 ROLLBACK;
107 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
108 ROLLBACK;
109 Preparing deadlock scenario for mysql.slave_worker_info
110 ROLLBACK;
111 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
112 ROLLBACK;
113 Preparing deadlock scenario for mysql.time_zone
114 ROLLBACK;
115 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
116 ROLLBACK;
117 Preparing deadlock scenario for mysql.time_zone_leap_second
118 ROLLBACK;
119 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
120 ROLLBACK;
121 Preparing deadlock scenario for mysql.time_zone_name
122 ROLLBACK;
123 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
124 ROLLBACK;
125 Preparing deadlock scenario for mysql.time_zone_transition
126 ROLLBACK;
127 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
128 ROLLBACK;
129 Preparing deadlock scenario for mysql.time_zone_transition_type
130 ROLLBACK;
131 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
132 ROLLBACK;
133 DROP TABLE t1;
134 SET @@global.innodb_lock_wait_timeout = @innodb_lock_wait_timeout_saved;