当前位置:   article > 正文

MHA中的报错问题!_this operation cannot be performed with a running

this operation cannot be performed with a running replica io thread; run sto

MHA重新授权报错

问题:
ERROR 3021 (HY000): This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR CHANNEL ‘’ first.
  ## 错误3021 (HY000):这个操作不能在运行的io线程上执行;首先为通道运行STOP SLAVE IO_THREAD。

解决办法:
1、这时候需要在两台从服务器先关闭线程

mysql> stop slave;
  • 1

2、在 mysql1 主机上查看新的二进制文件和同步点

show master status;
+-------------------+----------+--------------+------------------+-------------------+
| File              | Positi
  • 1
  • 2
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/小小林熬夜学编程/article/detail/160428
推荐阅读
相关标签
  

闽ICP备14008679号