Question

java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transa

java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)

Answer 1

好像是更新表出现死锁了，运行批处理时出现死锁了，你可以百度一下杀死死锁的方法，把数据库中的死锁杀掉，重新执行批处理即可