錯誤日志

Error updating database.  Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction### The error may involve com.zhonghe.userim.dao.mysql.CrmRoleDao.updateById-Inline### SQL: UPDATE crm_role  SET content_permission=?, name=?, `description`=?, self_apply_status=?,  updated_at=?  WHERE id=?; Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transactionat org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:262)at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)

遇到事務(wù)等待問題時，我們首先要做的是找到正在執(zhí)行的事務(wù)。 ??information_schema.INNODB_TRX?? 表中包含了當(dāng)前innodb內(nèi)部正在運(yùn)行的事務(wù)信息，這個表中給出了事務(wù)的開始時間

查看事務(wù)

-- 當(dāng)前運(yùn)行的所有事務(wù)
SELECT * from information_schema.innodb_trx;

sql

/*PROXY:10.0.6.249,d2fd98510040000*/ DELETE 
FROM
	crm_role_permission 
WHERE
	id IN (
		4749806,
		4749813,
		4749820,
		4749827,
		4749834,
		4749841,
		4749848,
		4749855,
		4749862,
		4749869,
		4749876,
		4749883,
		4749890,
		4749897,
		4749904,
		4749911,
		4749918,
		4749925,
		4749932,
		4749939,
		4749946,
		4749953,
		4749960,
		4749967,
		4749974,
		4749981,
		4749988,
		4749995,
		4750002,
		4750009,
		4750016,
		4750023,
		4750030,
		4750037,
		4750044,
		4750051,
		4750058,
		4750065,
		4750072,
		4750079,
		4750086,
		4750093,
		4750100,
		4750107,
		4750114,
		4750121,
		4750128,
		4750135,
		4750142,
		4750149,
		4750156,
		4750163,
		4750170,
		4750177,
		4750184,
		4750191,
		4750198,
		4750205,
		4750212,
		4750219,
		4750226,
		4750233,
		4750240,
		4750247,
		4750254,
		4750261,
		4750268,
		4750275,
		4750282,
		4750289,
		4750296,
		4750303,
		4750310,
		4750317,
		4750324,
		4750331,
		4750338,
	4750345,
	4750)

殺掉事物

-- kill 線程ID(trx_mysql_thread_id)
kill 8375425;

只是臨時解決, 根本還是需要優(yōu)化代碼

參考博客

https://blog.51cto.com/u_6353447/5873555

https://blog.csdn.net/Boring_05/article/details/131169567