HA_ERR_RBR_LOGGING_FAILED with Error_code: 1534

[Dillon Dillon]

Hi All,

I have a problem with Master/slave sync. The error message is :

2015-12-04 01:15:43 15411 [ERROR] Slave SQL: Could not execute Write_rows event on table yjbview.wc_fund_dailyinfo; 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 on.002621, end_log_pos 566028890, Error_code: 1534

In recently, we had a hardware problem and revoered/restored this database. And then, when we loaded data in middle-night, we had above error.

Does anyone have the problem? I searched this error code by google. Someone says to increase the max_binlog_cache_size. But, why I don't see the error message like "Multi-statement transaction required more than 'max_binlog_cache_size' bytes ofstorage"?

To fix this problem, should I increase max_binlog_cache_size?