Bug #76856 mysqlfailover not fail over to slave for continue master failing
| Submitted: | 27 Apr 2015 17:02 | Modified: | 2 Jan 2017 9:55 |
|---|---|---|---|
| Reporter: | Benjamin Lin | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Utilities | Severity: | S3 (Non-critical) |
| Version: | MySQL 5.6.23 Enterprise | OS: | Linux (CentOS 6) |
| Assigned to: | CPU Architecture: | Any |
[27 Apr 2015 17:02]
Benjamin Lin
[5 Jun 2015 19:05]
Justin Reock
I have observed similar behavior. In my case, if I specify "auto" mode with a candidates list, the node will not failover at all when the master is shut down. It registers the master going down, but it never picks another candidate. If I remove the list of candidates, "auto" failover will select a slave from the detected slave registry and fail over to one successfully. The candidates list does function properly in "elect" mode, but not in "auto" mode.
[17 Aug 2016 18:03]
Onno Steenbergen
I have the same problem but I am using the discover slaves login: mysqlfailover --master=manager:password@acs-sql-101 --discover-slaves-login=manager:password --daemon=start --log=/var/log/mysql-failover --rpl-user=repl:password --verbose Version: MySQL Utilities mysqlfailover version 1.5.6 The log output: Before the service mysql stop 2016-08-17 19:52:01 PM INFO Discovering slaves for master at acs-sql-101:3306 2016-08-17 19:52:01 PM INFO Discovering slave at acs-sql-201:3306 2016-08-17 19:52:01 PM INFO Discovering slave at acs-sql-202:3306 2016-08-17 19:52:01 PM INFO Master Information 2016-08-17 19:52:01 PM INFO Binary Log File: acs-sql-101.000003, Position: 3783556, Binlog_Do_DB: N/A, Binlog_Ignore_DB: N/A 2016-08-17 19:52:01 PM INFO GTID Executed Set: b4ef9624-0627-11e6-bd65-daea6468c513:1-744906 2016-08-17 19:52:01 PM INFO Getting health for master: acs-sql-101:3306. 2016-08-17 19:52:01 PM INFO Health Status: 2016-08-17 19:52:01 PM INFO host: acs-sql-101, port: 3306, role: MASTER, state: UP, gtid_mode: ON, health: OK, version: 5.7.14-log, master_log_file: acs-sql-101.000003, master_log_pos: 3783556, IO_Thread: , SQL_Thread: , Secs_Behind: , Remaining_Delay: , IO_Error_Num: , IO_Error: , SQL_Error_Num: , SQL_Error: , Trans_Behind: 2016-08-17 19:52:01 PM INFO host: acs-sql-201, port: 3306, role: SLAVE, state: UP, gtid_mode: ON, health: OK, version: 5.7.14-log, master_log_file: acs-sql-101.000003, master_log_pos: 3783556, IO_Thread: Yes, SQL_Thread: Yes, Secs_Behind: 0, Remaining_Delay: No, IO_Error_Num: 0, IO_Error: , SQL_Error_Num: 0, SQL_Error: , Trans_Behind: 0 2016-08-17 19:52:01 PM INFO host: acs-sql-202, port: 3306, role: SLAVE, state: UP, gtid_mode: ON, health: OK, version: 5.7.14-log, master_log_file: acs-sql-101.000003, master_log_pos: 3783556, IO_Thread: Yes, SQL_Thread: Yes, Secs_Behind: 0, Remaining_Delay: No, IO_Error_Num: 0, IO_Error: , SQL_Error_Num: 0, SQL_Error: , Trans_Behind: 0 After the stop command 2016-08-17 19:52:25 PM INFO Master may be down. Waiting for 3 seconds. 2016-08-17 19:52:40 PM INFO Failed to reconnect to the master after 3 attemps. 2016-08-17 19:52:40 PM CRITICAL Master is confirmed to be down or unreachable. 2016-08-17 19:52:40 PM INFO Failover starting in 'auto' mode... 2016-08-17 19:52:40 PM INFO Checking eligibility of slave acs-sql-201:3306 for candidate. 2016-08-17 19:52:40 PM INFO GTID_MODE=ON ... Ok 2016-08-17 19:52:40 PM INFO Replication user exists ... Ok 2016-08-17 19:52:40 PM INFO Unregistering instance on master. Before this test i had the same test without the rpl-user information which showed: 2016-08-17 19:12:30 PM INFO Failover starting in 'auto' mode... 2016-08-17 19:12:30 PM INFO Unregistering instance on master.
[2 Dec 2016 9:55]
Chiranjeevi Battula
Hello Benjamin, Thank you for the bug report. Could you please try with C/Python 2.1.3 (not 2.1.4), Utilities 1.6.4, MySQL 5.7 GA and let us know if you are still having the issue with complete repeatable steps(sample test case and configuration file , etc. - please make it as private if you prefer) to confirm this issue at our end? Thanks, Chiranjeevi.
[3 Jan 2017 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.