ITPub博客

首页 > 数据库 > MySQL > MySQL Binlogging Fails With Writing One Row To The Row-based Binary Log Failed

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

原创 MySQL 作者:你好我是李白 时间:2020-07-25 13:26:08 0 删除 编辑

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?


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31439444/viewspace-2706898/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
我们不比前人聪明,但是我们会在量变到质变的过程中有些机会重新访问前人没有机会解决的问题。

注册时间:2017-02-28

  • 博文量
    111
  • 访问量
    69367