MySQL Error number: 3001; Symbol: ER_ERROR_ON_MASTER; SQLSTATE: HY000 报错 故障修复 远程处理

文档解释

Error number: 3001; Symbol: ER_ERROR_ON_MASTER; SQLSTATE: HY000

Message: Query partially completed on the master (error on master: %d) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_REPLICA_SKIP_COUNTER=1; START SLAVE;. Query:’%s’

：

错误描述： ER_ERROR_ON_MASTER 错误代号为3001，表示一个错误发生在Master上。

常见案例

解决方法： 从Error Numaer = 3001，SQLSTATE = HY000可以确认是主节点的问题，因此要检查主节点的设置是否正确，如果存在ssl证书请重新安装或更新，再重新启动主节点。