Description
I'm using quartz on my java project with version 2.2.3 and getting This Error
org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Lock wait timeout exceeded; try restarting transaction
| at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157)
| at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)
| at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3796)
| at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggersFired(JobStoreSupport.java:2916)
| at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:336)
| Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
| at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
| at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
| at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
| at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
| at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
| at com.mysql.jdbc.Util.getInstance(Util.java:408)
| at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951)
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
| at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487)
| at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
| at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
| at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
| at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
| at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96)
| ... 4 common frames omitted
Anyone have solution for this?