MySQL Binlogging Fails With Writing One Row To The Row-based Binary Log Failed

APPLIES TO:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

GOAL

Explain why binlog can't be written and error reported is:
ERROR 1534 (HY000): Writing one row to the row-based binary log failed

SOLUTION

max_binlog_cache_size has been configured to a small value and binlog caching is not possible on a huge transaction.
Increasing max_binlog_cache_size or setting it back to the default value will help sort the issue out.
The behavior has been reported by:
Bug 11750233: 40672: 'WRITING ONE ROW TO THE ROW-BASED BINARY LOG FAILED' AND MAX_BINLOG_CACHE

REFERENCES

BUG:11750233 - 40672: 'WRITING ONE ROW TO THE ROW-BASED BINARY LOG FAILED' AND MAX_BINLOG_CACHE
Didn't find what you are looking for?