Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
5.5, 10.2.13
-
None
-
Linux
Description
When executing the below on a 10.2 master, a 5.5 slave will fail:
DROP TABLE IF EXISTS _repfailuretest4;
CREATE TABLE _repfailuretest4 (
dt1 DATETIME,
dt2 DATETIME
)ENGINE=INNODB ROW_FORMAT=COMPACT;
INSERT INTO _repfailuretest4 VALUES ('2018-03-27 00:00:00', '2018-03-28 00:00:00');
180327 14:54:01 [ERROR] Slave SQL: Column 0 of table 'entdata_utf8._repfailuretest4' cannot be converted from type '<unknown type>' to type 'datetime', Error_code: 1677
180327 14:54:01 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.004139' position 730736627
xref https://bugs.mysql.com/bug.php?id=70124 where it is discussed that something like this symptom is resolvable under MySQL 5.6.20 using certain slave_type_conversions values, but I am unable to determine if/how this applies to MariaDB versions, and/or if a particular slave_type_conversions value would help my case.