flaky test raise ```pessimistic lock retry limit reached``` in the mysql test

[hawkingrei]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

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

3. What did you see instead (Required)

time="2025-10-21T13:39:10+08:00" level=error msg="1 tests failed\n"

time="2025-10-21T13:39:10+08:00" level=error msg="run test [with_non_recursive_bugs] err: sql:ANALYZE TABLE a,d,bb,cc,dd;: run \"ANALYZE TABLE a,d,bb,cc,dd;\" at line 752 err Error 1105 (HY000): pessimistic lock retry limit reached"

tidb-server(PID: 1689) stopped

https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Fghpr_mysql_test/detail/ghpr_mysql_test/41225/pipeline

4. What is your TiDB version? (Required)

[zimulala]

Reproduced: https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Fghpr_mysql_test/detail/ghpr_mysql_test/41469/pipeline