将处理主从故障的过程记录在此:故障1,Error_code: 1197 (max_binlog_cache_size)
数据库版本:5.7.9
报错信息:[ERROR] Slave SQL for channel ‘‘:
Worker 1 failed executing transaction ‘bea4612c-4828-11e7-90b3-a0423f31cad6:716212‘ at master log mysql.135371, end_log_pos 103016490;
Could not execute Write_rows event on table ******;
Multi-statement transaction required more than ‘max_binlog_cache_size‘ bytes of storage;
increase this mysqld variable and try again, Error_code: 1197;
Writing one row to the row-based binary log failed, Error_code: 1534;
handler error HA_ERR_RBR_LOGGING_FAILED;
the event‘s master log FIRST, end_log_pos 103016490, Error_code: 1197
处理过程:
根据报错信息,知道是max_binlog_cache_size小了,
解决办法:临时增加该值后restart slave即可以继续复制线程。stop slave;
set global max_binlog_cache_size= 201326592;
start slave;