Unstable test testPessimisticSuite.TestAmendForUniqueIndex and testStatsSuite.TestAnalyzeGlobalStatsWithOpts2

[mengxin9014]

Bug Report

Please answer these questions before submitting your issue. Thanks!

[2021-07-06T05:27:13.697Z] ----------------------------------------------------------------------
[2021-07-06T05:27:13.697Z] FAIL: pessimistic_test.go:2212: testPessimisticSuite.TestAmendForUniqueIndex
[2021-07-06T05:27:13.697Z] 
[2021-07-06T05:27:13.697Z] pessimistic_test.go:2276:
[2021-07-06T05:27:13.697Z]     tk.MustExec("commit")
[2021-07-06T05:32:10.544Z] 
[2021-07-06T05:32:10.544Z] ----------------------------------------------------------------------
[2021-07-06T05:32:10.544Z] FAIL: handle_test.go:938: testStatsSuite.TestAnalyzeGlobalStatsWithOpts2
[2021-07-06T05:32:10.544Z] 
[2021-07-06T05:32:10.544Z] handle_test.go:949:

1. Minimal reproduce step (Required)

in ci https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_check_2/detail/tidb_ghpr_check_2/14699/pipeline

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

[zhouqiang-cl]

https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_check_2/detail/tidb_ghpr_check_2/17153/pipeline

[zhouqiang-cl]

[2021-08-09T02:22:10.335Z] FAIL: handle_test.go:955: testStatsSuite.TestAnalyzeGlobalStatsWithOpts2

[2021-08-09T02:22:10.335Z] 

[2021-08-09T02:22:10.335Z] handle_test.go:966:

[2021-08-09T02:22:10.335Z]     s.checkForGlobalStatsWithOpts(c, tk, "test_gstats_opt2", "p1", 1, 50)

[2021-08-09T02:22:10.335Z] handle_test.go:911:

[2021-08-09T02:22:10.335Z]     // since the hist-building algorithm doesn't stipulate the final bucket number to be equal to the expected number exactly,

[2021-08-09T02:22:10.335Z]     // we have to check the results by a range here.

[2021-08-09T02:22:10.335Z]     c.Assert(numBuckets >= buckets-delta, IsTrue)

[2021-08-09T02:22:10.335Z] ... obtained bool = false

in ci https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_check_2/detail/tidb_ghpr_check_2/23995/pipeline

[lysu]

@qw4990 PTAL if free, it seems caused by #23169

[tisonkun]

@zhouqiang-cl is it duplicated with #24679? At least for the Opts2 part.

[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.

[tisonkun]

@mengxin9014 why do you close this issue? If it is a duplicate, please confirm. And the next time please action with reason instead of changing silently but let other contributors guess what you want to do.