Mha报错Checking slave status failed on
2023-09-14 09:15:20 时间
报错信息如下:
error][/usr/share/perl5/vendor_perl/MHA/Server.pm, ln265] Checking slave status failed on 192.168.31.18(192.168.31.18:3306). err=Got error when executing SHOW SLAVE STATUS. Access denied; you need (at least one of) the SUPER, REPLICATION CLIENT privilege(s) for this operation
Tue Sep 7 00:31:39 2021 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 315.
Tue Sep 7 00:31:39 2021 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Tue Sep 7 00:31:39 2021 - [info] Got exit code 1 (Not master dead).
原因:
/etc/mastermha/app1.cnf文件中
user=mhauser
在做此用户授权时出错.造成无法连接数据库检查状态
解决方法
此用户需要UPER, REPLICATION CLIENT 权限.最简单的方法就是赋予所有权限,次方法生产环境下需要谨慎.
grant all on *.* to repluser@'192.168.31.%';
结果:
相关文章
- Calling LoadLibraryEx on ISAPI filter failed「建议收藏」
- docker:Cannot start service nacos: driver failed programming external connectivity on endpoint
- ORA-27604: Cell storage ioctl error, ioctl failed on disk string ORACLE 报错 故障修复 远程处理
- ORA-29919: failed in the execution of the ODCIINDEXUPDPARTMETADATA routine ORACLE 报错 故障修复 远程处理
- ORA-38760: This database instance failed to turn on flashback database ORACLE 报错 故障修复 远程处理
- ORA-54036: cannot define referential constraint with ON DELETE SET NULL clause on virtual column ORACLE 报错 故障修复 远程处理
- ORA-01327: failed to exclusively lock system dictionary as required by build ORACLE 报错 故障修复 远程处理
- ORA-02777: Stat failed on log directory ORACLE 报错 故障修复 远程处理
- ORA-02779: Stat failed on core dump directory ORACLE 报错 故障修复 远程处理
- ORA-02832: Segment deallocation failed – segment not on list ORACLE 报错 故障修复 远程处理
- MySQL Error number: MY-011161; Symbol: ER_SEMISYNC_MASTER_FAILED_ON_NET_FLUSH; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-011183; Symbol: ER_SEMISYNC_EXECUTION_FAILED_ON_MASTER; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-011506; Symbol: ER_GRP_RPL_SESSION_OPEN_FAILED; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-011652; Symbol: ER_GRP_RPL_FAILED_TO_ENABLE_READ_ONLY_MODE_ON_SHUTDOWN; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-013891; Symbol: ER_IB_MSG_LOG_FILE_RENAME_ON_CREATE_FAILED; SQLSTATE: HY000 报错 故障修复 远程处理
- 的区别MySQL中ON与IN的区别探讨(mysql中on与in)
- delete cascadeMySQL:探索ON DELETE CASCADE功能(mysql支持on)
- Oracle内连接ON极大提高数据查询性能(oracle内连接on)