执行upate提示 Data Too Long, field len 255, data len 298

执行的sql如下:
UPDATE seeyii_assets_database.sy_cd_me_buss_ip_patn a,seeyii_assets_database.sy_cd_ms_base_comp_geo b
SET a.provinceCode = b.provinceCode ,a.cityCode = b.cityCode,a.countyCode = b.districtCode , a.province = b.provinceName,a.city = b.cityName,a.county = b.district
WHERE a.applicantName = b.compName AND a.id BETWEEN 5757769 AND 5757780;

tidb日志如下:
[2020/12/29 10:59:13.686 +08:00] [INFO] [set.go:207] [“set session var”] [conn=138875] [name=profiling] [val=1]
[2020/12/29 10:59:13.688 +08:00] [INFO] [set.go:207] [“set session var”] [conn=138875] [name=profiling_history_size] [val=0]
[2020/12/29 10:59:13.691 +08:00] [INFO] [set.go:207] [“set session var”] [conn=138875] [name=profiling_history_size] [val=15]
[2020/12/29 10:59:13.716 +08:00] [INFO] [tidb.go:199] [“rollbackTxn for ddl/autocommit failed”]
[2020/12/29 10:59:13.716 +08:00] [WARN] [session.go:1040] [“run statement failed”] [conn=138875] [schemaVersion=3315] [error="[types:1406]Data Too Long, field len 255, data len 298"] [session="{\n “currDBName”: “seeyii_assets_database”,\n “id”: 138875,\n “status”: 2,\n “strictMode”: true,\n “user”: {\n “Username”: “root”,\n “Hostname”: “172.17.0.143”,\n “CurrentUser”: false,\n “AuthUsername”: “root”,\n “AuthHostname”: “%”\n }\n}"]
[2020/12/29 10:59:13.716 +08:00] [ERROR] [conn.go:728] [“command dispatched failed”] [conn=138875] [connInfo=“id:138875, addr:172.17.0.143:1801 status:10, collation:utf8_general_ci, user:root”] [command=Query] [status=“inTxn:0, autocommit:1”] [sql=“UPDATE seeyii_assets_database.sy_cd_me_buss_ip_patn a,seeyii_assets_database.sy_cd_ms_base_comp_geo b \nSET a.provinceCode = b.provinceCode ,a.cityCode = b.cityCode,a.countyCode = b.districtCode , a.province = b.provinceName,a.city = b.cityName,a.county = b.district \nWHERE a.applicantName = b.compName AND a.id BETWEEN 5757769 AND 5757780”] [txn_mode=OPTIMISTIC] [err="[types:1406]Data Too Long, field len 255, data len 298\ngithub.com/pingcap/errors.AddStack\n\t/home/jenkins/agent/workspace/tidb_v4.0.0/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/errors.go:174\ngithub.com/pingcap/parser/terror.(*Error).GenWithStack\n\t/home/jenkins/agent/workspace/tidb_v4.0.0/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20200525110646-f45c2cee1dca/terror/terror.go:236\ngithub.com/pingcap/tidb/types.ProduceStrWithSpecifiedTp\n\t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/types/datum.go:952\ngithub.com/pingcap/tidb/types.(*Datum).convertToString\n\t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/types/datum.go:919\ngithub.com/pingcap/tidb/types.(*Datum).ConvertTo\n\t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/types/datum.go:798\ngithub.com/pingcap/tidb/executor.(*innerMergeWorker).constructDatumLookupKey\n\t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/executor/index_lookup_merge_join.go:630\ngithub.com/pingcap/tidb/executor.(*innerMergeWorker).constructDatumLookupKeys\n\t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/executor/index_lookup_merge_join.go:603\ngithub.com/pingcap/tidb/executor.(*innerMergeWorker).handleTask\n\t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/executor/index_lookup_merge_join.go:453\ngithub.com/pingcap/tidb/executor.(*innerMergeWorker).run\n\t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/executor/index_lookup_merge_join.go:400\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1357"]
[2020/12/29 10:59:16.172 +08:00] [INFO] [region_cache.go:772] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=815129] [currIdx=2] [leaderStoreID=7]
[2020/12/29 10:59:20.099 +08:00] [INFO] [region_cache.go:772] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=815133] [currIdx=0] [leaderStoreID=880374]
[2020/12/29 10:59:21.303 +08:00] [INFO] [region_cache.go:772] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=815113] [currIdx=1] [leaderStoreID=7]
[2020/12/29 10:59:25.345 +08:00] [INFO] [region_cache.go:772] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=478121] [currIdx=2] [leaderStoreID=7]
[2020/12/29 10:59:25.751 +08:00] [INFO] [server.go:391] [“connection closed”] [conn=148556]
[2020/12/29 10:59:25.751 +08:00] [INFO] [server.go:391] [“connection closed”] [conn=148557]
[2020/12/29 10:59:25.761 +08:00] [INFO] [server.go:388] [“new connection”] [conn=148573] [remoteAddr=172.17.23.159:48819]
[2020/12/29 10:59:25.761 +08:00] [INFO] [server.go:388] [“new connection”] [conn=148572] [remoteAddr=172.17.23.159:48818]
[2020/12/29 10:59:25.778 +08:00] [INFO] [set.go:207] [“set session var”] [conn=148573] [name=character_set_results] [val=NULL]
[2020/12/29 10:59:25.778 +08:00] [INFO] [set.go:207] [“set session var”] [conn=148572] [name=character_set_results] [val=NULL]
[2020/12/29 10:59:31.519 +08:00] [INFO] [region_cache.go:772] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=453025] [currIdx=2] [leaderStoreID=880374]
[2020/12/29 10:59:37.903 +08:00] [INFO] [region_cache.go:772] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=444953] [currIdx=0] [leaderStoreID=880374]
[2020/12/29 10:59:37.903 +08:00] [INFO] [region_cache.go:772] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=444953] [currIdx=0] [leaderStoreID=880374]

  1. TiDB 的版本是多少?
  2. update 语句的 explain 结果是怎么样的
  3. 对应的表结构方便提供么

:sweat_smile:这个提示不明显么,字段超长了吧