MySQLTransactionRollbackException: Lock wait timeout exceeded； try restarting transaction

{"status":-1,"message":"新增异常:\n### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction\n### The error may exist in class path resource [mapper/InsertMapMapper.xml]\n### The error may involve com.dcxx.wxqsgpt.dao.InsertMapMapper.insertInfo2-Inline\n### The error occurred while setting parameters\n### SQL: insert into XXXX

今天在做数据批量插入的时候，报了一个这个错，导致批量插入失败，是数据库表哪里没配置好，谢谢这位老哥的文章，帮我解决了问题，我把链接放在下面。参考链接：https://blog.csdn.net/qq_40233736/article/details/95044995