Uploaded image for project: 'WebDanica'
  1. WebDanica
  2. WEBDAN-212

Interface with netarchivesuite got a message about DB deadlock

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • DATABASE, HARVESTING
    • None
    • webdanicasprint - sommer 2017

    Description

      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
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            svc Søren Vejrup Carlsen (Inactive)
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: