1
Test case 1 - failover to localhost:PORT2 with errant transactions.
3
# Checking privileges on candidates.
4
# ERROR: Errant transaction(s) found on slave(s).
5
# - For slave 'localhost@PORT2': XXXXXXXXX:1
6
# - For slave 'localhost@PORT4': XXXXXXXXX:1
7
ERROR: Errant transaction(s) found on slave(s). Note: If you want to ignore this issue, although not advised, please use the utility with the --force option.
8
Test case 2 - failover to localhost:PORT2 with errant transactions using --force option.
10
# Checking privileges on candidates.
11
# ERROR: Errant transaction(s) found on slave(s).
12
# - For slave 'localhost@PORT2': XXXXXXXXX:1
13
# - For slave 'localhost@PORT4': XXXXXXXXX:1
14
# Performing failover.
15
# Checking eligibility of slave localhost:PORT2 for candidate.
17
# Replication user exists ... Ok
18
# Candidate slave localhost:PORT2 will become the new master.
19
# Checking slaves status (before failover).
20
# Preparing candidate for failover.
21
# Reading events in relay log for slave localhost:PORT2
22
# Reading events in relay log for slave localhost:PORT3
23
# No missing transactions found on localhost:PORT3. Skipping connection of candidate as slave.
24
# Reading events in relay log for slave localhost:PORT4
25
# Missing transactions found on localhost:PORT4. SELECT gtid_subset() = 0
26
# LOCK STRING: FLUSH TABLES WITH READ LOCK
27
# Connecting candidate to localhost:PORT4 as a temporary slave to retrieve unprocessed GTIDs.
28
# Change master command for localhost:PORT2
29
# CHANGE MASTER TO MASTER_HOST = 'localhost', MASTER_USER = 'rpl', MASTER_PASSWORD = 'rpl', MASTER_PORT = PORT4, MASTER_AUTO_POSITION=1
30
# UNLOCK STRING: UNLOCK TABLES
31
# Waiting for candidate to catch up to slave localhost:PORT4.
32
# Slave localhost:PORT2:
33
# QUERY = SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(XXXXXXXXX)
35
# Slave localhost:PORT2:
36
# QUERY = SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(XXXXXXXXX)
38
# Creating replication user if it does not exist.
40
# Performing STOP on all slaves.
41
# Executing stop on slave localhost:PORT2 WARN - slave is not configured with this master
42
# Executing stop on slave localhost:PORT2 Ok
43
# Executing stop on slave localhost:PORT3 WARN - slave is not configured with this master
44
# Executing stop on slave localhost:PORT3 Ok
45
# Executing stop on slave localhost:PORT4 WARN - slave is not configured with this master
46
# Executing stop on slave localhost:PORT4 Ok
47
# Switching slaves to new master.
48
# Change master command for localhost:PORT2
49
# CHANGE MASTER TO MASTER_HOST = 'localhost', MASTER_USER = 'rpl', MASTER_PASSWORD = 'rpl', MASTER_PORT = PORT2, MASTER_AUTO_POSITION=1
50
# Change master command for localhost:PORT3
51
# CHANGE MASTER TO MASTER_HOST = 'localhost', MASTER_USER = 'rpl', MASTER_PASSWORD = 'rpl', MASTER_PORT = PORT2, MASTER_AUTO_POSITION=1
52
# Change master command for localhost:PORT4
53
# CHANGE MASTER TO MASTER_HOST = 'localhost', MASTER_USER = 'rpl', MASTER_PASSWORD = 'rpl', MASTER_PORT = PORT2, MASTER_AUTO_POSITION=1
55
# Performing START on all slaves.
56
# Executing start on slave localhost:PORT3 Ok
57
# Executing start on slave localhost:PORT4 Ok
58
# Checking slaves for errors.
59
# localhost:PORT3 status: Ok
60
# localhost:PORT4 status: Ok
62
# Attempting to contact localhost ... Success
63
# Attempting to contact localhost ... Success
64
# Attempting to contact localhost ... Success
66
# Replication Topology Health: