2862 Mats Kindahl 2008-10-08
Slave stops for engine that only support row-based logging
Since the SQL slave thread is running under STATEMENT mode,
this prevents the slave from switching to row-based format
This patches solve the situation by always setting the SQL
thread in MIXED mode, regardless of what the default is.
=== modified file 'sql/slave.cc'
--- a/sql/slave.cc 2008-09-26 14:05:38 +0000
+++ b/sql/slave.cc 2008-10-08 19:41:49 +0000
@@ -1466,6 +1466,13 @@ static int init_slave_thread(THD* thd, S
+ The SQL thread has to run under mixed mode no matter what to allow
+ replication to switch to row-based format if required by the
+ storage engine. It is not necessary to set the I/O thread to use
+ MIXED mode, but it does not harm.
+ thd->variables.binlog_format= BINLOG_FORMAT_MIXED;
if (thd_type == SLAVE_THD_SQL)
thd_proc_info(thd, "Waiting for the next event in relay log");
|• bzr commit into mysql-6.0 branch (mats:2862) Bug#39934||Mats Kindahl||8 Oct|