-
Bug
-
Resolution: Unresolved
-
None
-
None
-
High
-
DB locking of segment processing table improved to reduce dead locks there.
-
Emptyshow more show less
problem
Zend_Db_Statement_Exception: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: INSERT INTO `LEK_segment_processing` (`segmentId`, `taskGui d`) VALUES (22233010, '{8b4bfc27-523f-4630-9a39-ce36341be528}'),(22233022, '{8b4bfc27-523f-4630-9a39-ce36341be528}'),(22233025, '{8b4bfc27-523f-4630-9a39-ce36341be528}'),(22233031, '{8b4bfc27-523f-4630-9a39-ce36341be528}'),(22 233034, '{8b4bfc27-523f-4630-9a39-ce36341be528}'),(22233038, '{8b4bfc27-52
trace
#0 [...]vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute() #1 [...]vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute() #2 [...]vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(267): Zend_Db_Adapter_Abstract->query() #3 [...]application/modules/editor/src/Segment/Db/Processing.php(179): Zend_Db_Adapter_Pdo_Abstract->query() #4 [...]application/modules/editor/src/Segment/Db/Processing.php(167): MittagQI\Translate5\Segment\Db\Processing->insertPreparedSegments() #5 [...]application/modules/editor/Segment/Quality/Manager.php(305): MittagQI\Translate5\Segment\Db\Processing->prepareOperation() #6 [...]application/modules/editor/Segment/Quality/OperationWorker.php(63): editor_Segment_Quality_Manager->prepareOperation() #7 [...]library/ZfExtended/Worker/Abstract.php(483): editor_Segment_Quality_OperationWorker->work() #8 [...]library/ZfExtended/Worker/Abstract.php(399): ZfExtended_Worker_Abstract->_run() #9 [...]Translate5/MaintenanceCli/Command/WorkerRunCommand.php(142): ZfExtended_Worker_Abstract->runQueued() #10 [...]vendor/symfony/console/Command/Command.php(298): Translate5\MaintenanceCli\Command\WorkerRunCommand->execute() #11 [...]vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run() #12 [...]vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand() #13 [...]vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun() #14 [...]Translate5/maintenance-cli.php(287): Symfony\Component\Console\Application->run()
solution
investigate and improve locking there