search

dbourget / mysql-master-ha

Automatically exported from code.google.com/p/mysql-master-ha
0 stars 0 forks source link

masterha_master_switch fails with error #78

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
1 have 2 slaves and a master 

m3 (master) , m2 and m4 (slaves)

I am trying masterha_master_switch --conf=/etc/mha.cnf --master_state=alive 
--new_master_host=m4 --orig_master_is_new_slave

but it fails with 
ri Feb 21 14:51:29 2014 - [info] Checking MHA is not monitoring or doing 
failover..
Fri Feb 21 14:51:29 2014 - 
[error][/usr/share/perl5/vendor_perl/MHA/MasterRotate.pm, ln142] Getting 
advisory lock failed on the current master. MHA Monitor runs on the current 
master. Stop MHA Manager/Monitor and try again.
Fri Feb 21 14:51:29 2014 - 
[error][/usr/share/perl5/vendor_perl/MHA/ManagerUtil.pm, ln178] Got ERROR:  at 
/usr/bin/masterha_master_switch line 53

Original issue reported on code.google.com by vdb...@gmail.com on 21 Feb 2014 at 10:53

GoogleCodeExporter commented 9 years ago 
I am using percona's 5.6 version  . nd I think this might be related to 5.6 . 
Please confirm and what is the solution around it

Original comment by vdb...@gmail.com on 23 Feb 2014 at 9:24

GoogleCodeExporter commented 9 years ago 
I switched to Percona 5.5 and the problem was resolved

Original comment by vdb...@gmail.com on 25 Feb 2014 at 4:29

GoogleCodeExporter commented 9 years ago 
Is there a solution for this? I am using MySQL 5.6 and running into the sane 
problem.

Original comment by m...@michaelmarx.net on 11 Apr 2015 at 4:14

GoogleCodeExporter commented 9 years ago 
i met the problem too , can you share the solution ?

Original comment by ruiay...@gmail.com on 24 Jun 2015 at 7:32