-
Type:
Bug
-
Resolution: Fixed
-
None
-
Affects Version/s: None
-
Emptyshow more show less
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"}