mysql主库修改PROCEDURE存储导致主从不同步,从库存的 SLAVE_SQL进程停止
2015-08-01 18:36:15 1537 [ERROR] Slave SQL: Error 'PROCEDURE Info.p_RankSignPrize does not exist' on query. Default database: Info'. Query: 'drop procedure p_RankSignPrize', Error_code: 1305
2015-08-01 18:36:15 1537 [Warning] Slave: PROCEDURE Info.p_RankSignPrize does not exist Error_code: 1305
2015-08-01 18:36:15 1537 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000005' position 8275915
修改方法:跳转此错误
stop slave;
set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
start slave;
show slave status\G;
为避免再发现可以设置跳过 1305 错
在my.cfg 中添加
slave-skip-errors = 1305