java.lang.Exception

Deadlock

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web10

Stack trace

  • java.lang.Exception: Deadlock at org.apache.manifoldcf.core.database.DBInterfaceDerby.reinterpretException(DBInterfaceDerby.java:816) at org.apache.manifoldcf.core.database.DBInterfaceDerby.performQuery(DBInterfaceDerby.java:976) at org.apache.manifoldcf.crawler.jobs.JobManager.addDocuments(JobManager.java:4085) at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.processDocumentReferences(WorkerThread.java:1932) at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.flush(WorkerThread.java:1863) at org.apache.manifoldcf.crawler.system.WorkerThread.run(WorkerThread.java:554) Caused by: org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: SQLException getting resultset (40001): A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {722, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Granted XID : {717, X} Lock : ROW, JOBQUEUE, (1,29) Waiting XID : {717, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Granted XID : {718, X} Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {718, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {725, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {723, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE . The selected victim is XID : 722. at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:717) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:745) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1430) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:186) at org.apache.manifoldcf.core.database.DBInterfaceDerby.performQuery(DBInterfaceDerby.java:972) ... 4 more Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {722, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Granted XID : {717, X} Lock : ROW, JOBQUEUE, (1,29) Waiting XID : {717, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Granted XID : {718, X} Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {718, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {725, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {723, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE . The selected victim is XID : 722. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) at org.apache.manifoldcf.core.database.Database.getData(Database.java:948) at org.apache.manifoldcf.core.database.Database.execute(Database.java:866) at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:677) Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {722, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Granted XID : {717, X} Lock : ROW, JOBQUEUE, (1,29) Waiting XID : {717, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Granted XID : {718, X} Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {718, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {725, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE Lock : ROW, JOBQUEUE, (1,28) Waiting XID : {723, U} , APP, SELECT id,status,checktime FROM jobqueue WHERE dochash=? AND jobid=? FOR UPDATE . The selected victim is XID : 722. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 12 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 1 month ago
Once, 3 months ago
Once, 3 months ago
Once, 8 months ago
81 times, 1 year ago
1 more bugmates