5.0.2 upgrade to 5.1.0, "sql analyze" in dashboard keep running, no result reported

[seiya-annie]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

check in tidb.log, can find:
[2021/06/15 15:12:24.327 +08:00] [ERROR] [select_result.go:389] ["invalid cop task execution summaries length"] [conn=35] [expected=2] [received=0]
[2021/06/15 15:12:32.258 +08:00] [INFO] [grpclogger.go:77] ["ccResolverWrapper: sending new addresses to cc: [{http://172.16.5.101:2379 0 }]"] [system=grpc] [grpc_log=true]
[2021/06/15 15:12:32.264 +08:00] [ERROR] [select_result.go:389] ["invalid cop task execution summaries length"] [conn=51] [expected=2] [received=0]
[2021/06/15 15:12:32.691 +08:00] [INFO] [grpclogger.go:77] ["ccResolverWrapper: sending new addresses to cc: [{http://172.16.5.101:2379 0 }]"] [system=grpc] [grpc_log=true]

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

| Release Version: v5.1.0-20210611
Edition: Community
Git Commit Hash: 29bfbb2
Git Branch: heads/refs/tags/v5.1.0-20210611
UTC Build Time: 2021-06-11 07:52:09
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[crazycs520]

The cause is the TiDB config tikv-client.grpc-compression-type = "gzip".

When set TiDB config to tikv-client.grpc-compression-type = "gzip", query some cluster_xxx table will both return empty result set, The affected system tables include:

• CLUSTER_PROCESSLIST
• CLUSTER_SLOW_QUERY
• CLUSTER_STATEMENTS_SUMMARY
• CLUSTER_STATEMENTS_SUMMARY_HISTORY

tikv-client.grpc-compression-type default value is none, and is imported in PR #20438. So v5.0.0 will also have this problem.

@cfzjywxk PTAL

[cfzjywxk]

Fixed by tikv/client-go#88 and related cherry-picks.

[github-actions]

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