Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-1673

Parallele import of several large import packages produces deadlock

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • None
    • None
    • Import/Export

    Description

      When importing several large import packages with very deep nested folders, the DB produces a deadlock.

      Also this occured at a customer instance and is described with error trace in TS-111.

       

      Exception: Zend_Db_Statement_Exception
      Level: ERROR
      Errorcode: E9999
      Message: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `Zf_worker` w1 LEFT OUTER JOIN `Zf_worker` w2 ON w1.`taskGuid` = w2.`taskGuid` AND w1.`worker` = w2.`worker` AND w2.`state` = "running" AND w1.`id` != w2.`id` SET `w1`.`state` = 'running', `w1`.`starttime` = NOW(), `w1`.`maxRuntime` = NOW() + INTERVAL 1 HOUR, `w1`.`pid` = 8375 WHERE w2.id IS NULL AND w1.id = ?
      Domain: core
      File (Line): /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Db/Statement/Pdo.php (235)
      Request: PUT /editor/worker/973?cleanupSessionAfterRun=1
      Trace:
      #0 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `Zf_work...', Array) #3 /webs/dev/marc.translate5.net/library/ZfExtended/Models/Worker.php(285): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `Zf_work...', Array) #4 /webs/dev/marc.translate5.net/library/ZfExtended/Worker/Abstract.php(503): ZfExtended_Models_Worker->setRunning(true) #5 /webs/dev/marc.translate5.net/library/ZfExtended/Worker/Abstract.php(465): ZfExtended_Worker_Abstract->_run() #6 /webs/dev/marc.translate5.net/library/ZfExtended/Controllers/WorkerController.php(119): ZfExtended_Worker_Abstract->runQueued() #7 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Controller/Action.php(516): ZfExtended_WorkerController->putAction() #8 /webs/dev/marc.translate5.net/library/ZfExtended/Controllers/AAARestController.php(287): Zend_Controller_Action->dispatch('putAction') #9 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('putAction') #10 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #11 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch() #12 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run() #13 /webs/dev/marc.translate5.net/library/ZfExtended/Application.php(47): Zend_Application->run() #14 /webs/dev/marc.translate5.net/library/ZfExtended/BaseIndex.php(153): ZfExtended_Application->run() #15 /webs/dev/marc.translate5.net/public/index.php(35): ZfExtended_BaseIndex->startApplication() #16 {main}
      Request:
      Array ( [cleanupSessionAfterRun] => 1 )
      Exception: PDOException
      Level: ERROR
      Errorcode: E9999
      Message: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
      Domain: core
      File (Line): /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Db/Statement/Pdo.php (228)
      Request: PUT /editor/worker/973?cleanupSessionAfterRun=1
      Trace:
      #0 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `Zf_work...', Array) #4 /webs/dev/marc.translate5.net/library/ZfExtended/Models/Worker.php(285): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `Zf_work...', Array) #5 /webs/dev/marc.translate5.net/library/ZfExtended/Worker/Abstract.php(503): ZfExtended_Models_Worker->setRunning(true) #6 /webs/dev/marc.translate5.net/library/ZfExtended/Worker/Abstract.php(465): ZfExtended_Worker_Abstract->_run() #7 /webs/dev/marc.translate5.net/library/ZfExtended/Controllers/WorkerController.php(119): ZfExtended_Worker_Abstract->runQueued() #8 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Controller/Action.php(516): ZfExtended_WorkerController->putAction() #9 /webs/dev/marc.translate5.net/library/ZfExtended/Controllers/AAARestController.php(287): Zend_Controller_Action->dispatch('putAction') #10 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('putAction') #11 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #12 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch() #13 /webs/mittagqi_meta/other/zend/Zend-z1-php7.3-1.13.2-p1/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run() #14 /webs/dev/marc.translate5.net/library/ZfExtended/Application.php(47): Zend_Application->run() #15 /webs/dev/marc.translate5.net/library/ZfExtended/BaseIndex.php(153): ZfExtended_Application->run() #16 /webs/dev/marc.translate5.net/public/index.php(35): ZfExtended_BaseIndex->startApplication() #17 {main}
      Request:
      Array ( [cleanupSessionAfterRun] => 1 )

      Attachments

        Issue Links

          Activity

            People

              tlauria Thomas Lauria
              marcmittag Marc Mittag [Administrator]
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: