MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction

    技术2022-07-21  65

    {"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

    Processed: 0.008, SQL: 9