Unstable integration mysql test

[zhouqiang-cl]

Bug Report

Please answer these questions before submitting your issue. Thanks!

[2021-07-12T08:09:43.712Z] time="2021-07-12T16:09:43+08:00" level=fatal msg="run test [analyze] err: sql:select md5(CONVERT(value using utf8)) as md5hash, count from mysql.stats_top_n order by md5hash;: failed to run query \n\"select md5(CONVERT(value using utf8)) as md5hash, count from mysql.stats_top_n order by md5hash;\" \n around line 8, \nwe need(812):\nselect md5(CONVERT(value using utf8)) as md5hash, count from mysql.stats_top_n order by md5hash;\nmd5hash\tcount\n043c0bad4225699366815222ee87b267\t4\n10d3c8efaefb9e35d4eb6567f16fab5e\t4\n1902c33db45fc1226712fd5eb797c294\t4\n61bbc46d3b84089a5576238304164327\t4\n7bba882cbdcd9fe0be840f2929675d7e\t4\n91e505a8c01ace5cda32d35d703bc2d7\t12\n9a7b56b2290f9b0c7f0f04a3a37f2a40\t4\nac78d4218f964c76ff4d02ff0089ff97\t4\ndc8de1bb4f382c00eb1b7d66b17215ba\t4\nf9ae50badad44702ada7d9525e7ff4a0\t4\nshow stats_topn;\nDb_name\tTable_name\tPartition_name\tColumn_name\tIs_index\tValue\tCount\nanalyze\tt\t\ta\t0\t1\t4\nanalyze\tt\t\ta\t0\t2\t4\nanalyze\tt\t\ta\t0\t3\t4\nanalyze\tt\t\tb\t0\t1.100000023841858\t4\nanalyze\tt\t\tb\t0\t2.200000047683716\t4\nanalyze\tt\t\tb\t0\t3.299999952316284\t4\nanalyze\tt\t\tc\t0\t11.1000000000\t4\nanalyze\tt\t\tc\t0\t22.2000000000\t4\nanalyze\tt\t\tc\t0\t33.3000000000\t4\nanalyze\tt\t\t\nbut got(812):\nselect md5(CONVERT(value using utf8)) as md5hash, count from mysql.stats_top_n order by md5hash;\nmd5hash\tcount\n043c0bad4225699366815222ee87b267\t4\n10d3c8efaefb9e35d4eb6567f16fab5e\t4\n1902c33db45fc1226712fd5eb797c294\t2\n1902c33db45fc1226712fd5eb797c294\t1\n1902c33db45fc1226712fd5eb797c294\t2\n1902c33db45fc1226712fd5eb797c294\t4\n24773e0f3f157f03b91110cbfa350b4b\t1\n61bbc46d3b84089a5576238304164327\t4\n7bba882cbdcd9fe0be840f2929675d7e\t1\n7bba882cbdcd9fe0be840f2929675d7e\t1\n7bba882cbdcd9fe0be840f2929675d7e\t1\n7bba882cbdcd9fe0be840f2929675d7e\t4\n91e505a8c01ace5cda32d35d703bc2d7\t12\n9a7b56b2290f9b0c7f0f04a3a37f2a40\t4\nac78d4218f964c76ff4d02ff0089ff97\t4\nac78d4218f964c76ff4d02ff0089ff97\t1\nac78d4218f964c76ff4d02ff0089ff97\t1\nac78d4218f964c76ff4d02ff0089ff97\t1\ndc8de1bb4f382c00eb1b7d66b17215ba\t4\nf9ae50badad44702ada7d9525e7ff4a0\t4\n\n"

1. Minimal reproduce step (Required)

in ci https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_integration_common_test/detail/tidb_ghpr_integration_common_test/5558/pipeline/

replay is ok for this test

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

master

[winoros]

closed via https://github.com/pingcap/tidb-test/pull/1249

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions