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
|
# === HITTING CRASH WHEN USING SEMISYNC MODE WITH SSL OPTIONS ===
#
# With the bug, semisync did not compile with SSL.
# The following CREATE TABLE as written below crashed with
# invalid memory access.
--source include/not_group_replication_plugin.inc
--source include/master-slave.inc
--source include/have_semisync_plugin.inc
--source include/install_semisync.inc
call mtr.add_suppression(".*Semi-sync source failed on net_flush.*before waiting for replica reply.*");
call mtr.add_suppression(".*Timeout waiting for reply of binlog .* semi-sync up to file .*");
--source include/sync_slave_sql_with_master.inc
--source include/rpl_connection_slave.inc
--source include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_SSL = 1;
--source include/start_slave.inc
--echo
--echo # Try replicating CREATE TABLE and verify that everything is fine.
--echo
--source include/rpl_connection_master.inc
USE test;
CREATE TABLE table1 (a INT);
--source include/sync_slave_sql_with_master.inc
--echo
--echo # STOP SLAVE and verify that replication works fine when slave resumes.
--echo
--source include/stop_slave_io.inc
--source include/rpl_connection_master.inc
INSERT INTO table1 VALUES(1);
--source include/rpl_connection_slave.inc
--source include/start_slave_io.inc
--echo
--echo # RE-START SLAVE and execute on master, verify that replication works fine.
--echo
--source include/rpl_connection_master.inc
INSERT INTO table1 VALUES(2);
--source include/sync_slave_sql_with_master.inc
--let $assert_text= Slave should have 2 rows(1,2)
--let $assert_cond= `SELECT COUNT(*)=2 from table1`
--source include/assert.inc
--echo
--echo # Clean-up
--echo
--source include/rpl_connection_master.inc
DROP TABLE table1;
--source include/sync_slave_sql_with_master.inc
--source include/uninstall_semisync.inc
--source include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_SSL = 0;
--let $rpl_only_running_threads= 1
--source include/rpl_end.inc
|
