java lock wait_多线程环境出现大量java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting tr...

不知道是不是框架的原因 , 我是小白用户

```

java.lang.RuntimeException: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction

at cn.ffcs.memory.Memory.batch(Memory.java:146)

at cn.ffcs.memory.Memory.batch(Memory.java:127)

at com.passfeed.socialspider.instagram.pipeline.FeedPipeline.process(FeedPipeline.java:101)

at us.codecraft.webmagic.Spider.processRequest(Spider.java:425)

at us.codecraft.webmagic.Spider$1.run(Spider.java:322)

at us.codecraft.webmagic.thread.CountableThreadPool$1.run(CountableThreadPool.java:74)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction

at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2028)

at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1451)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2465)

at cn.ffcs.memory.Memory.batch(Memory.java:142)

... 8 more

Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) Lock wait timeout exceeded; try restarting transaction

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)

at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1980)

... 11 more

```