Debian Codegraph @

mysql-test/suite/binlog/r/binlog_set_trans_dependency_deadlock.result

raw
1 #
2 # Bug 92108: Deadlock by concurrent SHOW BINLOGS,
3 # performance_schema.session_variables query, and binlog purge
4 #
5 RESET MASTER;
6 FLUSH LOGS;
7 connect con1,localhost,root,,;
8 SET DEBUG_SYNC="purge_logs_after_lock_index_before_thread_count SIGNAL purge_ready WAIT_FOR finish_purge";
9 PURGE BINARY LOGS BEFORE '2038-01-19';
10 connect con2,localhost,root,,;
11 SET DEBUG_SYNC="materialize_session_variable_array_THD_locked SIGNAL pfs_ready WAIT_FOR finish_pfs";
12 SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME LIKE 'binlog_transaction_dependency_tracking';;
13 connect con3,localhost,root,,;
14 SET DEBUG_SYNC="show_binlogs_after_lock_log_before_lock_index SIGNAL show_ready WAIT_FOR finish_show";
15 SHOW BINARY LOGS;
16 connection default;
17 SET DEBUG_SYNC="now WAIT_FOR purge_ready";
18 SET DEBUG_SYNC="now WAIT_FOR pfs_ready";
19 SET DEBUG_SYNC="now WAIT_FOR show_ready";
20 SET DEBUG_SYNC="now SIGNAL finish_purge";
21 SET DEBUG_SYNC="now SIGNAL finish_pfs";
22 SET DEBUG_SYNC="now SIGNAL finish_show";
23 connection con1;
24 Warnings:
25 Warning 1868 file binlog.000002 was not purged because it is the active log file.
26 disconnect con1;
27 connection con2;
28 VARIABLE_NAME VARIABLE_VALUE
29 binlog_transaction_dependency_tracking COMMIT_ORDER
30 disconnect con2;
31 connection con3;
32 disconnect con3;
33 connection default;
34 SET DEBUG_SYNC= 'RESET';