didi
Deadlock found when trying to get lock
后台日志频繁出现死锁 mysql version: mysql Ver 14.14 Distrib 5.7.38
2022-09-15 10:42:27.057 WARN 1 --- [l-13-thread-429] o.m.jdbc.message.server.ErrorPacket : Error: 1213-40001: Deadlock found when trying to get lock; try restarting transaction 2022-09-15 10:42:27.058 ERROR 1 --- [l-13-thread-429] errorLogger : method=updateGroupMembersTask||clusterPhyId=1||groupName=szmsg_supply_label_bigdata_shiftCycle_20211215||errMsg=
Error updating database. Cause: java.sql.SQLTransactionRollbackException: (conn=13746) Deadlock found when trying to get lock; try restarting transaction
The error may exist in URL [jar:file:/km-rest.jar!/BOOT-INF/lib/km-persistence-3.0.0-beta.1.jar!/mybatis/GroupMemberMapper.xml]
The error may involve com.xiaojukeji.know.streaming.km.persistence.mysql.group.GroupMemberDAO.replace-Inline
The error occurred while setting parameters
SQL: REPLACE ks_km_group_member (cluster_phy_id, topic_name, group_name, state, member_count, update_time) VALUES (?, ?, ?, ?, ?, ?)
Cause: java.sql.SQLTransactionRollbackException: (conn=13746) Deadlock found when trying to get lock; try restarting transaction
; (conn=13746) Deadlock found when trying to get lock; try restarting transaction; nested exception is java.sql.SQLTransactionRollbackException: (conn=13746) Deadlock found when trying to get lock; try restarting transaction 2022-09-15 10:42:27.058 ERROR 1 --- [l-13-thread-429] c.x.k.s.k.t.metadata.SyncKafkaGroupTask : method=updateGroupMembersTask||clusterPhyId=1||groupName=szmsg_supply_label_bigdata_shiftCycle_20211215||errMsg=
Error updating database. Cause: java.sql.SQLTransactionRollbackException: (conn=13746) Deadlock found when trying to get lock; try restarting transaction
The error may exist in URL [jar:file:/km-rest.jar!/BOOT-INF/lib/km-persistence-3.0.0-beta.1.jar!/mybatis/GroupMemberMapper.xml]
The error may involve com.xiaojukeji.know.streaming.km.persistence.mysql.group.GroupMemberDAO.replace-Inline
The error occurred while setting parameters
SQL: REPLACE ks_km_group_member (cluster_phy_id, topic_name, group_name, state, member_count, update_time) VALUES (?, ?, ?, ?, ?, ?)
Cause: java.sql.SQLTransactionRollbackException: (conn=13746) Deadlock found when trying to get lock; try restarting transaction
; (conn=13746) Deadlock found when trying to get lock; try restarting transaction; nested exception is java.sql.SQLTransactionRollbackException: (conn=13746) Deadlock found when trying to get lock; try restarting transaction
