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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
|
###############################################################################
# Bug#21507981: REPLICATION POSITION LOST AFTER CRASH ON MTS CONFIGURED SLAVE
#
# Problem:
# ========
# Enable MTS along with crash-safe replication tables. Make sure that the server
# is busily inserting data with multiple threads in parallel. Shutdown mysqld
# uncleanly (kill -9 or power off server without notice).
#
# Now users are restarting the server with --relay-log-recovery=1 to recover the
# crashed slave.
#
# This results in following error:
# ================================
# 2015-06-24 13:49:03 3895 [ERROR] --relay-log-recovery cannot
# be executed when the slave was stopped with an error or
# killed in MTS mode; consider using RESET SLAVE or restart
# the server with --relay-log-recovery = 0 followed by
# START SLAVE UNTIL SQL_AFTER_MTS_GAPS.
#
# i.e relay-log-recovery will not work in MTS mode.
###############################################################################
# Following test demonstrates that when gaps are generated due to MTS crash
# but not due to an error then recovery should be successful with
# --relay-log-recovery=1 option.
#
# ==== Usage ====
# --let $skip_replica_start_var= BOOL [ TRUE / FALSE ]
# --source extra/rpl_tests/rpl_mts_relay_log_recovery.test
#
# Parameters:
#
# $skip_replica_start_var
# Boolean that specifies if 'skip_replica_start' server parameter should be
# TRUE or FALSE.
#
# Testing Method:
# ===============
# It first creates two databases (d1 and d2) and setup slave to use two parallel
# workers. The test case then insert on the slave a tuple that will block
# writes on d2 and generate gaps. Crash the slave server at this point and
# bring it back with --relay-log-recovery=1 and crash safe tables. Recovery
# should be successful.
--source extra/rpl_tests/rpl_generate_mts_gap.test
CALL mtr.add_suppression("Recovery from source pos");
--source include/rpl_connection_slave.inc
# Kill the slave server
--source include/kill_mysqld.inc
# Restart the slave server
--let $rpl_server_number= 2
--let $rpl_server_parameters= --skip_replica_start=$skip_replica_start_var --sync_source_info=1 --relay-log-recovery=1
--source include/rpl_start_server.inc
--exec echo "After restart gaps should be filled."
--let $assert_text= Table d1.t should contain 2 rows.
--let $assert_cond= [select count(*) from d1.t] = 2
--source include/assert.inc
--let $assert_text= Table d2.t should contain 3 rows.
--let $assert_cond= [select count(*) from d2.t] = 3
--source include/assert.inc
if ($skip_replica_start_var == TRUE)
{
--source include/start_slave.inc
}
# Check consistency
--source include/rpl_connection_master.inc
--source include/sync_slave_sql_with_master.inc
--let $diff_tables= master:d1.t, slave:d1.t
--source include/diff_tables.inc
--let $diff_tables= master:d2.t, slave:d2.t
--source include/diff_tables.inc
#
# Cleanup
#
--source include/rpl_connection_master.inc
DROP DATABASE d1;
DROP DATABASE d2;
|
