24-Aug-2017 12:24:47.021 WARNING [Thread-1708] dk.kb.webdanica.core.interfaces.harvesting.SingleSeedHarvest.log Unable to disable harvestdefiniton with id=2046
dk.netarkivet.common.exceptions.IOFailure: SQL Error while reading harvest definition 2046
SQLException trace:
SQL State:40001
Error Code:30000
java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, DOMAINS, (1,318)
Waiting XID : {2038070, S} , APP, SELECT domains.name, configurations.name FROM domains, configurations, harvest_configs WHERE harvest_id = ? AND configurations.config_id = harvest_configs.config_id AND configurations.domain_id = domains.domain_id
Granted XID : {2038061, X}
Lock : ROW, CONFIGURATIONS, (12,121)
Waiting XID : {2038061, X} , APP, UPDATE configurations SET comments = ?, template_id = ( SELECT template_id FROM ordertemplates WHERE name = ? ), maxobjects = ?, maxrate = ?, maxbytes = ? WHERE name = ? AND domain_id = ?
Granted XID : {2038070, S}
. The selected victim is XID : 2038070.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.ClientPreparedStatement.executeQuery(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at dk.netarkivet.harvester.datamodel.HarvestDefinitionDBDAO.read(HarvestDefinitionDBDAO.java:379)
at dk.netarkivet.harvester.datamodel.HarvestDefinitionDBDAO.read(HarvestDefinitionDBDAO.java:271)
at dk.kb.webdanica.core.interfaces.harvesting.SingleSeedHarvest.finishHarvest(SingleSeedHarvest.java:316)
at dk.kb.webdanica.webapp.workflow.HarvesterThread.run(HarvesterThread.java:36)
at java.lang.Thread.run(Thread.java:748)
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, DOMAINS, (1,318)
Waiting XID : {2038070, S} , APP, SELECT domains.name, configurations.name FROM domains, configurations, harvest_configs WHERE harvest_id = ? AND configurations.config_id = harvest_configs.config_id AND configurations.domain_id = domains.domain_id
Granted XID : {2038061, X}
Lock : ROW, CONFIGURATIONS, (12,121)
Waiting XID : {2038061, X} , APP, UPDATE configurations SET comments = ?, template_id = ( SELECT template_id FROM ordertemplates WHERE name = ? ), maxobjects = ?, maxrate = ?, maxbytes = ? WHERE name = ? AND domain_id = ?
Granted XID : {2038070, S}
. The selected victim is XID : 2038070.
at org.apache.derby.client.am.ClientStatement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseOpenQueryError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseOPNQRYreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readOpenQuery(Unknown Source)
at org.apache.derby.client.net.StatementReply.readOpenQuery(Unknown Source)
at org.apache.derby.client.net.NetStatement.readOpenQuery_(Unknown Source)
at org.apache.derby.client.am.ClientStatement.readOpenQuery(Unknown Source)
at org.apache.derby.client.am.ClientPreparedStatement.flowExecute(Unknown Source)
at org.apache.derby.client.am.ClientPreparedStatement.executeQueryX(Unknown Source)
... 7 more
End of SQLException trace
at dk.netarkivet.harvester.datamodel.HarvestDefinitionDBDAO.read(HarvestDefinitionDBDAO.java:413)
at dk.netarkivet.harvester.datamodel.HarvestDefinitionDBDAO.read(HarvestDefinitionDBDAO.java:271)
at dk.kb.webdanica.core.interfaces.harvesting.SingleSeedHarvest.finishHarvest(SingleSeedHarvest.java:316)
at dk.kb.webdanica.webapp.workflow.HarvesterThread.run(HarvesterThread.java:36)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, DOMAINS, (1,318)
Waiting XID : {2038070, S} , APP, SELECT domains.name, configurations.name FROM domains, configurations, harvest_configs WHERE harvest_id = ? AND configurations.config_id = harvest_configs.config_id AND configurations.domain_id = domains.domain_id
Granted XID : {2038061, X}
Lock : ROW, CONFIGURATIONS, (12,121)
Waiting XID : {2038061, X} , APP, UPDATE configurations SET comments = ?, template_id = ( SELECT template_id FROM ordertemplates WHERE name = ? ), maxobjects = ?, maxrate = ?, maxbytes = ? WHERE name = ? AND domain_id = ?
Granted XID : {2038070, S}
. The selected victim is XID : 2038070.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.ClientPreparedStatement.executeQuery(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at dk.netarkivet.harvester.datamodel.HarvestDefinitionDBDAO.read(HarvestDefinitionDBDAO.java:379)
... 4 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, DOMAINS, (1,318)
Waiting XID : {2038070, S} , APP, SELECT domains.name, configurations.name FROM domains, configurations, harvest_configs WHERE harvest_id = ? AND configurations.config_id = harvest_configs.config_id AND configurations.domain_id = domains.domain_id
Granted XID : {2038061, X}
Lock : ROW, CONFIGURATIONS, (12,121)
Waiting XID : {2038061, X} , APP, UPDATE configurations SET comments = ?, template_id = ( SELECT template_id FROM ordertemplates WHERE name = ? ), maxobjects = ?, maxrate = ?, maxbytes = ? WHERE name = ? AND domain_id = ?
Granted XID : {2038070, S}
. The selected victim is XID : 2038070.
at org.apache.derby.client.am.ClientStatement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseOpenQueryError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseOPNQRYreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readOpenQuery(Unknown Source)
at org.apache.derby.client.net.StatementReply.readOpenQuery(Unknown Source)
at org.apache.derby.client.net.NetStatement.readOpenQuery_(Unknown Source)
at org.apache.derby.client.am.ClientStatement.readOpenQuery(Unknown Source)
at org.apache.derby.client.am.ClientPreparedStatement.flowExecute(Unknown Source)
at org.apache.derby.client.am.ClientPreparedStatement.executeQueryX(Unknown Source)
... 7 more