20201016-MYSQL死锁问题分析Deadlock found when trying to get lock; try restarting transaction问题描述:原因分析:解决方案:巨人的肩膀:
问题描述:测试环境中财务服务对RabbitMQ消息进行消费时,出现异常Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction原因分析:从上面截图可以看出是发现了mysql的死锁问题到测试库上执行如下脚本show engine innodb status;找到事务1,事