1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
# ==== Purpose ====
# The purpose of this test is to make sure binlog file is re-stored
# when client session running RESET MASTER is killed.
#
# ==== Requirements ====
# RESET MASTER should exit leaving binlog files in consistent state.
#
# ==== Implementation ====
# 1. Create table t1
# 2. Run RESET MASTER from client connection master_tmp
# 3. Kill the master_tmp connection
# 4. Now DROP TABLE t1(any DDL)
#
# ==== References ====
# Bug#29125121: ASSERTION `M_PIPELINE_HEAD != __NULL' IN MYSQL_BIN_LOG::BINLOG_OFILE::WRITE
# 1. Create table t1
--source include/have_debug_sync.inc
--let $debug_point= wait_for_kill_gtid_state_clear
--source include/add_debug_point.inc
CALL mtr.add_suppression('The transaction owned GTID is already in the gtid_executed table, which is caused by an explicit modifying from user client.');
CREATE TABLE t1(c1 int);
--connect(master_tmp,127.0.0.1,root,,test,$MASTER_MYPORT,)
--let $thread_id= `SELECT CONNECTION_ID()`
# 2. Run RESET MASTER from client connection master_tmp
--send RESET MASTER
# 3. Kill the master_tmp connection
--connection default
--disable_query_log
--eval KILL $thread_id
SET DEBUG_SYNC='now SIGNAL kill_gtid_state_clear';
--enable_query_log
--connection master_tmp
--error CR_SERVER_LOST
--reap
# 4. Now DROP TABLE t1(any DDL)
--connection default
DROP TABLE t1;
--source include/remove_debug_point.inc
--disconnect master_tmp
|
