From f2dcae6d817b2d3288fe8220875ad14dd79e6e71 Mon Sep 17 00:00:00 2001 From: Josh Soref Date: Sun, 10 Jan 2021 15:51:18 -0500 Subject: [PATCH] Add SEO for BINLOG_FORMAT = STATEMENT error Lead users who see errors about READ COMMITTED or READ UNCOMMITTED / BINLOG_FORMAT = STATEMENT to this section of the docs. --- docs/backends/generic-mysql.rst | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/docs/backends/generic-mysql.rst b/docs/backends/generic-mysql.rst index 2e955f81d0..ef89f6d6f6 100644 --- a/docs/backends/generic-mysql.rst +++ b/docs/backends/generic-mysql.rst @@ -53,6 +53,13 @@ The Binary Log Format" `__ for more information. +Otherwise, you will probably see: + +:: + + Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. + InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. + Settings -------- -- 2.47.2