seata全局事务出现超时异常

[lindengyu]

• I have searched the issues of this repository and believe that this is not a duplicate.

Ⅰ. Issue Description

Ⅱ. Describe what happened

If there is an exception, please attach the exception trace:

seata全局事务下对自增ID为30的数据进行删除、修改会出现Cause: io.seata.rm.datasource.exec.LockWaitTimeoutException: Global lock wait timeout的报错，查看seata服务打印日志如下：

![Image](https://github.com/user-attachments/assets/f778216f-99d2-4619-9261-b35f96dcc2b2)

Ⅲ. Describe what you expected to happen

Ⅳ. How to reproduce it (as minimally and precisely as possible)

1. xxx
2. xxx
3. xxx

Minimal yet complete reproducer code (or URL to code):

Ⅴ. Anything else we need to know?

Ⅵ. Environment:

• JDK version(e.g. java -version):1.8
• Seata client/server version: 1.7.0
• Database version: 8.0
• OS(e.g. uname -a):
• Others:

[funky-eyes]

说明存在锁争抢问题，请通过调优锁争抢周期来优化该情况。
This indicates a lock contention issue. Please optimize the situation by tuning the lock contention period.