TermTagger worker are creating a database deadlock on import

XMLWordPrintable

      Error was triggered by importing a local testpackage.

      Basically there occur two errors:

      ZfExtended_Log on t5dev.localdev: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE FROM `Zf_worker` WHERE (state = 'done') AND (endtime < NOW() - INTERVAL 1 HOUR)
      Trace: 
      #0 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
      #1 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
      #2 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
      #3 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DELETE FROM `Zf...', Array)
      #4 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Db/Adapter/Abstract.php(664): Zend_Db_Adapter_Pdo_Abstract->query('DELETE FROM `Zf...')
      #5 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Db/Table/Abstract.php(1201): Zend_Db_Adapter_Abstract->delete('Zf_worker', Array)
      #6 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Models/Worker.php(282): Zend_Db_Table_Abstract->delete(Array)
      #7 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Worker/Abstract.php(329): ZfExtended_Models_Worker->cleanGarbage()
      #8 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Worker/Abstract.php(293): ZfExtended_Worker_Abstract->_run()
      #9 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Controllers/WorkerController.php(117): ZfExtended_Worker_Abstract->runQueued()
      #10 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Controller/Action.php(516): ZfExtended_WorkerController->putAction()
      #11 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Controllers/RestController.php(229): Zend_Controller_Action->dispatch('putAction')
      #12 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('putAction')
      #13 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http))
      #14 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch()
      #15 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
      #16 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/BaseIndex.php(155): Zend_Application->run()
      #17 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/public/index.php(49): ZfExtended_BaseIndex->startApplication()
      #18 {main}Aufgerufene URL inkl. ggf. vorhandener POST-Parameter als get-Parameter: 
      /editor/worker/put/cleanupSessionAfterRun/1/id/2941/format/json/data/{"state":"running","hash":"55afa1daabcbd7.51635442"}
      
      ZfExtended_Log on t5dev.localdev: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE Zf_worker u, (
                          SELECT w.id from Zf_worker w
                          WHERE w.state = ?      
                              AND (
                                  	(NOT EXISTS (SELECT * 
                                          FROM Zf_worker_dependencies d1
                                          WHERE w.worker = d1.worker)
                                      )
                                  OR
                                      NOT EXISTS (SELECT * 
                                          FROM Zf_worker ws,Zf_worker ws2, Zf_worker_dependencies d2
                                          WHERE d2.dependency = ws.worker
                                             AND ws2.worker = d2.worker
                                             AND ws.taskGuid = ws2.taskGuid
                                             AND ws.state IN (?, ?, ?)
                                             AND ws2.id = w.id)
                                  )
                          ORDER BY w.id ASC
                          LIMIT 1
                      ) s
                      SET u.STATE = ?                                       
                      WHERE u.id = s.id;
      Trace:
      #0 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
      #1 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
      #2 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE Zf_worke...', Array)
      #3 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Models/Worker.php(131): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE Zf_worke...', Array)
      #4 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Worker/Abstract.php(335): ZfExtended_Models_Worker->wakeupScheduled('{4f3271d9-4485-...', 'default_import')
      #5 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Worker/Abstract.php(232): ZfExtended_Worker_Abstract->wakeUpAndStartNextWorkers('{4f3271d9-4485-...')
      #6 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/application/modules/editor/Plugins/TermTagger/Worker/Abstract.php(118): ZfExtended_Worker_Abstract->queue(NULL)
      #7 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/application/modules/editor/Plugins/TermTagger/Worker/TermTaggerImport.php(194): editor_Plugins_TermTagger_Worker_Abstract->queue()
      #8 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/application/modules/editor/Plugins/TermTagger/Worker/TermTaggerImport.php(181): editor_Plugins_TermTagger_Worker_TermTaggerImport->createNewWorkerChainEntry('{4f3271d9-4485-...')
      #9 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Worker/Abstract.php(317): editor_Plugins_TermTagger_Worker_TermTaggerImport->work()
      #10 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Worker/Abstract.php(293): ZfExtended_Worker_Abstract->_run()
      #11 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Controllers/WorkerController.php(117): ZfExtended_Worker_Abstract->runQueued()
      #12 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Controller/Action.php(516): ZfExtended_WorkerController->putAction()
      #13 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/Controllers/RestController.php(229): Zend_Controller_Action->dispatch('putAction')
      #14 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('putAction')
      #15 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http))
      #16 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch()
      #17 /mnt/mittagqi/www/icorrect/ZendFramework-1.12.9-minimal/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
      #18 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/library/ZfExtended/BaseIndex.php(155): Zend_Application->run()
      #19 /mnt/mittagqi/www/icorrect/www.t5.net-devbranched/public/index.php(49): ZfExtended_BaseIndex->startApplication()
      #20 {main}Aufgerufene URL inkl. ggf. vorhandener POST-Parameter als get-Parameter: 
      /editor/worker/put/cleanupSessionAfterRun/1/id/3040/format/json/data/{"state":"running","hash":"55afa25d28c580.22061479"}
      

            Assignee:
            Thomas Lauria
            Reporter:
            Thomas Lauria
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: