myslq主从不同步报错如下:
Query partially completed on the master (error on master: 1053) 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_SLAVE_SKIP_COUNTER=1;
START SLAVE;
报错原因:
因为查询在主机上部分完成(主机上的错误:1053),已中止,需要自行确认下主库的sql语句是否真的未执行成功,才可进行以下操作
处理办法:
以下操作均在从库上执行
处理过程为:
1) 从库上先停止slave
mysql>stop slave;
2)从库上跳过slave上的1个错误
mysql>set global sql_slave_skip_counter=1;
3)从库山启动slave
mysql>start slave;
4)过了一段时间,待从库上Seconds_Behind_Master为0后
mysql>show slave status\G
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Seconds_Behind_Master: 0
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
1 row in set (0.00 sec)