Analyze table failed after the data loaded through Lightning replicated to TiFlash

[birdstorm]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use tidb-lightning to load ontime data to TiDB

Set TiFlash replica to 2:

mysql> alter table `ontime` set tiflash replica 2;

Analyze table after the tiflash replica is ready.

2. What did you expect to see? (Required)

analyzed table

3. What did you see instead (Required)

[2021/04/15 17:44:22.748 +08:00] [ERROR] [analyze.go:131] ["analyze failed"] [conn=5] [error="other error: encoding failed"]
[2021/04/15 17:44:22.748 +08:00] [INFO] [tidb.go:237] ["rollbackTxn for ddl/autocommit failed"]
[2021/04/15 17:44:22.749 +08:00] [WARN] [session.go:1428] ["run statement failed"] [conn=5] [schemaVersion=28] [error="other error: encoding failed"] [session="{\n  \"currDBName\": \"\",\n  \"id\": 5,\n  \"status\": 2,\n  \"strictMode\": false,\n  \"user\": {\n    \"Username\": \"root\",\n    \"Hostname\": \"172.16.5.59\",\n    \"CurrentUser\": false,\n    \"AuthUsername\": \"root\",\n    \"AuthHostname\": \"%\"\n  }\n}"]
[2021/04/15 17:44:22.749 +08:00] [INFO] [conn.go:812] ["command dispatched failed"] [conn=5] [connInfo="id:5, addr:172.16.5.59:36516 status:10, collation:utf8mb4_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="ANALYZE TABLE `ontime`.`ontime`"] [txn_mode=PESSIMISTIC] [err="other error: encoding failed\ngithub.com/pingcap/tidb/store/copr.(*copIteratorWorker).handleCopResponse\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/copr/coprocessor.go:881\ngithub.com/pingcap/tidb/store/copr.(*copIteratorWorker).handleTaskOnce\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/copr/coprocessor.go:735\ngithub.com/pingcap/tidb/store/copr.(*copIteratorWorker).handleTask\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/copr/coprocessor.go:630\ngithub.com/pingcap/tidb/store/copr.(*copIteratorWorker).run\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/copr/coprocessor.go:367\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1357"]
[2021/04/15 17:44:26.199 +08:00] [INFO] [coprocessor.go:794] ["[TIME_COP_PROCESS] resp_time:447.457013ms txnStartTS:18446744073709551615 region_id:124 store_addr:172.16.5.82:20560 kv_process_ms:446 kv_wait_ms:0 processed_versions:4096 total_versions:4097 rocksdb_delete_skipped_count:0 rocksdb_key_skipped_count:8191 rocksdb_cache_hit_count:4 rocksdb_read_count:35 rocksdb_read_byte:349932"]
[2021/04/15 17:44:26.199 +08:00] [WARN] [coprocessor.go:882] ["other error"] [txnStartTS=18446744073709551615] [regionID=124] [storeAddr=172.16.5.82:20560] [error="other error: encoding failed"]
[2021/04/15 17:44:27.267 +08:00] [INFO] [coprocessor.go:794] ["[TIME_COP_PROCESS] resp_time:1.516235516s txnStartTS:18446744073709551615 region_id:148 store_addr:172.16.5.59:20560 kv_process_ms:1513 kv_wait_ms:1 processed_versions:12288 total_versions:12289 rocksdb_delete_skipped_count:0 rocksdb_key_skipped_count:24575 rocksdb_cache_hit_count:3 rocksdb_read_count:109 rocksdb_read_byte:1118586"]

4. What is your TiDB version? (Required)

mysql> select tidb_version();
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                                                     |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v5.0.0
Edition: Community
Git Commit Hash: bdac0885cd11bdf571aad9353bfc24e13554b91c
Git Branch: heads/refs/tags/v5.0.0
UTC Build Time: 2021-04-06 16:36:29
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

[winoros]

Cannot reproduce, waiting to reproduce again. Move down the severity.

[winoros]

Still not reproduced. Closed first.

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.