【 TiDB 使用环境】
5.7.25-TiDB-v5.0.1-1-g35276ad
dm-2.0.3
【概述】 场景 + 问题概述
订阅腾讯云 mysql8 实例中的某库的业务表的update event 出现 Column ‘id’ cannot be null
【现象】 业务和数据库现象
以下是dm-work日志（敏感内容替换成了xxxx）
[2021/09/08 10:10:31.627 +08:00] [ERROR] [db.go:277] [“execute statements failed after retry”] [task=task-prod-qiqiao-plus2] [unit=“binlog replication”] [queries=“[UPDATE `bxxxx-rxxxx-xxxx`.`f_危机_714b7a2054b3c1b0_ad340` SET `author_name` = ?, `last_modifier_name` = ?, `last_modify_date` = ?, `author` = ?, `process_instance_id` = ?, `id` = ?, `version` = ?, `last_modifier` = ?, `createDate` = ?, `相关附件` = ?, `关联客户` = ?, `corpid` = ?, `盘点时间` = ?, `危机类型` = ?, `访谈情况` = ?, `攻坚建议` = ?, `反馈时间` = ?, `挽回难度` = ?, `回访情况反馈` = ?, `负责人` = ?, `所属区域` = ?, `负责人_pretty_value` = ?, `测试` = ?, `组长_pretty_value` = ?, `组长` = ?, `危机后果` = ?, `需要什么攻坚支持` = ? WHERE `id` = ? LIMIT 1 UPDATE `bpms-runtime-plus2`.`f_危机_714b7a2054b3c1b0_ad340` SET `author_name` = ?, `last_modifier_name` = ?, `last_modify_date` = ?, `author` = ?, `process_instance_id` = ?, `id` = ?, `version` = ?, `last_modifier` = ?, `createDate` = ?, `相关附件` = ?, `关联客户` = ?, `corpid` = ?, `盘点时间` = ?, `危机类型` = ?, `访谈情况` = ?, `攻坚建议` = ?, `反馈时间…”] [arguments=“[[ xxxx 2021-09-08 10:10:31 4 b084e787d2c35cb4e7640383d2daf203 c00c0ca756d8405abe4cd39e014cf743 xxxx 2021-08-26 7 [231 155 174 229 137 141 228 189 191 231 148 168 233 163 158 228 185 166] [230 178 159 233 128 154 228 184 139 232 180 185 230 142 167 230 138 165 233 148 128] 2021-09-10 1 [] 8dfd2e9f1f6214da72962fd65ef82db8 2 [233 152 179 231 186 162 232 137 179] 4 [229 189 173 230 179 189 231 186 175] cc23220dda26fad3271275c6bbc1a8e2 0086af21dd40400b91f30b9d0bf379b9] [ xxxx 2021-09-08 10:10:31 4 b084e787d2c35cb4e7640383d2daf203 13f8b15ec8ec4563b3cada9bff67838f xxxx 2021-08-18 6 [230 181 183 229 164 150 229 184 130 229 156 186 230 181 183 232 158 186 228 188 129 228 184 154 239 188 140 49 57 229 185 180 231 187 173 231 186 166 229 144 142 229 174 162 230 136 183 229 143 141 233 166 136 229 183 178 231 187 143 228 189 191 231 148 168 232 135 170 231 160 148 231 179 187 231 187 159 227 128 130] […”] [error=“[code=10006:class=database:scope=not-set:level=high], Message: execute statement failed: UPDATE `bpms-runtime-plus2`.`f_危机_714b7a2054b3c1b0_ad340` SET `author_name` = ?, `last_modifier_name` = ?, `last_modify_date` = ?, `author` = ?, `process_instance_id` = ?, `id` = ?, `version` = ?, `last_modifier` = ?, `createDate` = ?, `相关附件` = ?, `关联客户` = ?, `corpid` = ?, `盘点时间` = ?, `危机类型` = ?, `访谈情况` = ?, `攻坚建议` = ?, `反馈时间` = ?, `挽回难度` = ?, `回访情况反馈` = ?, `负责人` = ?, `所属区域` = ?, `负责人_pretty_value` = ?, `测试` = ?, `组长_pretty_value` = ?, `组长` = ?, `危机后果` = ?, `需要什么攻坚支持` = ? WHERE `id` = ? LIMIT 1, RawCause: Error 1048: Column ‘id’ cannot be null”]
对比上游库，并未发现id字段有null值， id字段为主键。且整行数据为null字段只有4个。
上下游表结构对比
