为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
-
【TiDB 版本】:DM v1.0.6
-
【问题描述】:昨天上游mysql新增了一个字段,现在看tidb里面也新增了字段,同时我检查了上游所有分片的表结构,都增加了该字段,但是在check-task的时候报字段不一致,不清楚为何还会报这个错,麻烦帮忙看看,谢谢。
"errorMsg": "column length mismatch (16 vs 15)\ table `hdb_broker_24`.`client_building_zygw`\ columns r_build_id bigint(20)\ id varchar(60)\ recommend_id varchar(60)\ zygw_name varchar(125)\ zygw_phone varchar(20)\ is_call_client char(1)\ create_time timestamp\ create_time_old varchar(20)\ update_time timestamp\ update_time_old varchar(20)\ zygw_guid varchar(60)\ broker_id varchar(40)\ recommend_rb_id bigint(20)\ guid bigint(20)\ sync_time timestamp\ from_sys varchar(35)\ \ table`hdb_broker_32`.`client_building_zygw`\ columns r_build_id bigint(20)\ id varchar(60)\ recommend_id varchar(60)\ zygw_name varchar(125)\ zygw_phone varchar(20)\ is_call_client char(1)\ create_time timestamp\ create_time_old varchar(20)\ update_time timestamp\ update_time_old varchar(20)\ zygw_guid varchar(60)\ broker_id varchar(40)\ recommend_rb_id bigint(20)\ guid bigint(20)\ sync_time timestamp\ ", "instruction": "please set same table structure for sharding tables", "extra": "instance mysql-replica-06 on sharding `hdb_broker`.`client_building_zygw`"