问题:Slave_SQL_Running: No
Could not execute Update_rows event on table intelligence_disposal_pro.qrtz_scheduler_state; Can’t find record in ‘qrtz_scheduler_state’, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event’s master log binlog.000047, end_log_pos 300002062
解决办法:
vim /etc/my.cnf
跳过指定error no类型的错误
slave-skip-errors=1032
跳过所有错误
slave-skip-errors=all
重启数据库
systemctl restart mysqld