HA_ERR_RBR_LOGGING_FAILED with Error_code: 1534
Posted by: Dillon Dillon
Date: December 04, 2015 12:47AM

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?

Options: ReplyQuote

Written By
HA_ERR_RBR_LOGGING_FAILED with Error_code: 1534
December 04, 2015 12:47AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.