DTS MySQL日志Reader日志binlog_row_image校验失败

DTS-1051007 In binary log offset filename@offset(timestamp: unix_timestmap), found table db_name.table_name not full mode event..

DTS报错信息

DTS-1051007 In binary log offset filename@offset(timestamp: unix_timestmap), found table db_name.table_name not full mode event.

其中, DTS 报错code为: DTS-1051007

DTS的报错语句格式为: DTS-1051007 In binary log offset filename@offset(timestamp: unix_timestmap), found table db_name.table_name not full mode event. 其中:offset filename@offset(timestamp: unix_timestmap)为对应报错的binlog物理位置和时间戳,db_name.table_name 为对应的表名.

失败原因

1. DTS MySQL 只支持binlog_row_image='FULL' 模式的日志

解决方案

1. 设置binlog_row_image格式: 执行SQL: set global binlog_row_image='FULL';

2. kill 已经存在的session: 执行SQL show processlist; 将已有的session kill掉: 执行SQL: kill id;