Comment 15 for bug 1251137

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

Tested 5.6 -> 5.5 replication (Galera 3.1), with the required compatibility configuration:

log_bin_use_v1_row_events=1
gtid_mode=0
binlog_checksum=NONE

And can see that 5.5 node crashes at slave applying for:

140109 15:42:46 [ERROR] Slave SQL: Column 5 of table 'test.comm00' cannot be converted from type '<unknown type>' to type 'timestamp', Error_code: 1677

This happens with sqlgen load, which updates table with timestamp datatype.

I tried the same load using MySQL replication from 5.6 to 5.5 node, and same error happens there as well. So we probably have a MySQL bug to deal with. However, this may not be worth fixing, if migration is the only target here.