Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/binlog/r/

View File Name : binlog_set_trans_dependency_deadlock.result

#
# Bug 92108: Deadlock by concurrent SHOW BINLOGS,
# performance_schema.session_variables query, and binlog purge
#
RESET MASTER;
FLUSH LOGS;
connect con1,localhost,root,,;
SET DEBUG_SYNC="purge_logs_after_lock_index_before_thread_count SIGNAL purge_ready WAIT_FOR finish_purge";
PURGE BINARY LOGS BEFORE '2038-01-19';
connect con2,localhost,root,,;
SET DEBUG_SYNC="materialize_session_variable_array_THD_locked SIGNAL pfs_ready WAIT_FOR finish_pfs";
SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME LIKE 'binlog_transaction_dependency_tracking';;
connect con3,localhost,root,,;
SET DEBUG_SYNC="show_binlogs_after_lock_log_before_lock_index SIGNAL show_ready WAIT_FOR finish_show";
SHOW BINARY LOGS;
connection default;
SET DEBUG_SYNC="now WAIT_FOR purge_ready";
SET DEBUG_SYNC="now WAIT_FOR pfs_ready";
SET DEBUG_SYNC="now WAIT_FOR show_ready";
SET DEBUG_SYNC="now SIGNAL finish_purge";
SET DEBUG_SYNC="now SIGNAL finish_pfs";
SET DEBUG_SYNC="now SIGNAL finish_show";
connection con1;
Warnings:
Warning	1868	file master-bin.000002 was not purged because it is the active log file.
disconnect con1;
connection con2;
VARIABLE_NAME	VARIABLE_VALUE
binlog_transaction_dependency_tracking	COMMIT_ORDER
disconnect con2;
connection con3;
disconnect con3;
connection default;
SET DEBUG_SYNC= 'RESET';