Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@hellojinjie
Last active December 23, 2015 18:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hellojinjie/6679436 to your computer and use it in GitHub Desktop.
Save hellojinjie/6679436 to your computer and use it in GitHub Desktop.
mysql lock wait timeout
176329 Deadlock found when trying to get lock; try restarting transaction
176330 com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
176331 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
176332 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
176333 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
176334 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
176335 at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
176336 at com.mysql.jdbc.Util.getInstance(Util.java:386)
176337 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1065)
176338 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
176339 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
176340 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
176341 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
176342 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
176343 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
176344 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
176345 at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:920)
176346 at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2870)
176347 at com.neulion.qos.statistic.site.dao.enterprise.EnterpriseRealtimeCollection.execute(EnterpriseRealtimeCollection.java:965)
176348 at com.neulion.qos.statistic.site.dao.DBInsertThread.run(DBInsertThread.java:19)
106626 Lock wait timeout exceeded; try restarting transaction
106627 java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
106628 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
106629 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
106630 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
106631 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
106632 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
106633 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
106634 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
106635 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
106636 at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:920)
106637 at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2870)
106638 at com.neulion.qos.statistic.site.dao.enterprise.EnterpriseRealtimeCollection.execute(EnterpriseRealtimeCollection.java:965)
106639 at com.neulion.qos.statistic.site.dao.DBInsertThread.run(DBInsertThread.java:19)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment