同一张表，并发更新不同数据，竟然事务超时

原创已于 2025-12-28 10:34:48 修改 · 108 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java

于 2025-12-28 10:34:12 首次发布

某周日早上

客户报三条数据的飞书审批一直在审批中

查看数据，三条数据飞书回调处理失败

失败：
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
### The error may exist in fz/scm/java/garment/mapper/IScmGarmentReceivingOrderMapper.java (best guess)
### The error may involve fz.scm.java.garment.mapper.IScmGarmentReceivingOrderMapper.update-Inline
### The error occurred while setting parameters
### SQL: UPDATE xxxxorder SET quality_result = ? WHERE  (xxxx_no = ?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
; Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction

再一查发现短时间内，飞书回调了四条数据，第一条数据处理成功

原因：回调处理时间挺长，更新又是按单号更新，单号没有加索引，导致第一次回调锁表

还没处理完，后面回调发生，只能阻塞等待导致后续超时

解决方案给单号加一个索引避免锁表

幸亏之前背过面试题，立即找到原因