`make ut` failed when running locally on x64 or arm64 machine

[AkiraXie]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. make ut

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

success

3. What did you see instead (Required)

some cases failed 7 cases failed on x64 linux machine

cat ~/master-on-x64-ubuntu-ut.log | grep FAIL]
[FAIL]  pkg/executor TestContextCancelWhenReadFromCopIterator
[FAIL]  pkg/executor/join TestShuffleMergeJoinInDisk
[FAIL]  pkg/statistics/handle/cache/internal/lfu TestMemoryControlWithUpdate
[FAIL]  pkg/plugin TestLoadStaticRegisteredPlugin
[FAIL]  pkg/planner/core/casetest/planstats TestPlanStatsLoad
[FAIL]  pkg/infoschema/test/clustertablestest TestMDLViewIDConflict
[FAIL]  pkg/session/bootstraptest TestUpgradeVersionForPausedJob

6 cases failed on arm mac machine

 cat ~/master-on-darwin-ut.log | grep FAIL]
[FAIL]  pkg/statistics/handle/storage TestGCExtendedStats
[FAIL]  pkg/statistics/handle/cache/internal/lfu TestMemoryControlWithUpdate
[FAIL]  pkg/session/bootstraptest TestUpgradeVersionForPausedJob
[FAIL]  pkg/infoschema/test/clustertablestest TestMDLViewIDConflict
[FAIL]  pkg/ddl/tests/partition TestPartitionErrorCode
[FAIL]  pkg/executor/join TestShuffleMergeJoinInDisk

there are logs for run ut master-on-x64-ubuntu-ut.log master-on-darwin-ut.log

4. What is your TiDB version? (Required)

master

[zanmato1984]

Are these tests also failing in our CI jobs? @AkiraXie

[AkiraXie]

CI jobs did not test these cases in fact

[zanmato1984]

@hawkingrei Do you know why these cases do not run in CI?

cc @bb7133

[bb7133]

We have those cases run in CI of course, but by Bazel(https://github.com/pingcap/tidb/issues/34083)

They are all flaky tests, when they run by Bazel, most of the time they will success because of 'auto retry' and 'remote cache'.

In other words, the flaky tests are covered by Bazel but not for make ut.

I will assign this issue to me and work on them to make ut stable enough.