Skip to content

got the error during the failover test "Applying all logs succeeded. But starting slave failed" #105

@GoogleCodeExporter

Description

@GoogleCodeExporter
**** What steps will reproduce the problem?
1. Configure the MHA with (master/master(read only)/slave(read only)) the 
details below in additional information section. Also attached the mha manager 
log output

2. run masterha_manager --conf=/etc/app1.cnf and confirmed OK with "[info] 
Ping(SELECT) succeeded, waiting until MySQL doesn't respond."

3. kill -9 the primary writable master. MHA manager kicks in to set the read 
only master writable as expect. But got the "Applying all logs succeeded. But 
starting slave failed" and the slave (read only) seems still points to the old 
failed master. is there a way that I can have MHA to change the slave (read 
only) points to the new writable master during the failover.  

**** What is the expected output? What do you see instead?
Hoping to see clean output shown failover completed.

**** What version of the product are you using? On what operating system?
OS:
Linux MHA1DBA 3.2.0-60-virtual #91-Ubuntu SMP Wed Feb 19 04:13:28 UTC 2014 
x86_64 x86_64 x86_64 GNU/Linux

MySql:
 5.6.17-log 

MHA manager:
0.55

MHA node:
0.54

**** Please provide any additional information below.
/etc/app1.cnf
[server default]
user=root
password=test

repl_user=repl
repl_password=repl

ping_interval=1
latest_priority=0
ignore_fail=1
ssh_user=root

master_pid_file=/db/mysql_binlog/mha/master_pid.pid
remote_workdir=/db/mysql_binlog/mha/
manager_workdir=/db/mysql_binlog/mha/
master_binlog_dir=/db/mysql_binlog/

init_conf_load_script=""
shutdown_script=""
master_ip_failover_script=""
master_ip_online_change_script=""
report_script=""
log_level=debug

[server1]
hostname=10.236.114.128
candidate_master=1

[server2]
hostname=10.236.70.129

[server3]
hostname=10.236.70.131
no_master=1

Original issue reported on code.google.com by [email protected] on 4 Feb 2015 at 6:23

Attachments:

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions