Details
-
Bug
-
Resolution: Fixed
-
None
-
None
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
- relates to
-
TRANSLATE-351 optimize table locking of segment meta table in termtagger import
- Backlog
-
- Done
-
- Done