执行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="{\ “currDBName”: “seeyii_assets_database”,\ “id”: 138875,\ “status”: 2,\ “strictMode”: true,\ “user”: {\ “Username”: “root”,\ “Hostname”: “172.17.0.143”,\ “CurrentUser”: false,\ “AuthUsername”: “root”,\ “AuthHostname”: “%”\ }\ }"]
[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 \ 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”] [txn_mode=OPTIMISTIC] [err="[types:1406]Data Too Long, field len 255, data len 298\ngithub.com/pingcap/errors.AddStack\ \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\ github.com/pingcap/parser/terror.(*Error).GenWithStack\ \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\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/types/datum.go:952\ github.com/pingcap/tidb/types.(*Datum).convertToString\ \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\ \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\ \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\ \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\ \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\ \t/home/jenkins/agent/workspace/tidb_v4.0.0/go/src/github.com/pingcap/tidb/executor/index_lookup_merge_join.go:400\ runtime.goexit\ \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:这个提示不明显么,字段超长了吧