Page MenuHomePhabricator

Error 1213: Deadlock found when trying to get lock; TranslationCorporaStore::saveQuery
Open, MediumPublic4 Estimated Story PointsPRODUCTION ERROR

Description

Error
  • mwversion: 1.45.0-wmf.18
  • timestamp: 2025-09-14T05:52:22.730Z
  • phpversion: 8.1.33
  • reqId: b15b0d1c-5081-41a3-83bc-afe0180f40f3
  • Find reqId in Logstash
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction
Function: ContentTranslation\Store\TranslationCorporaStore::save
Query: SELECT  cxc_translation_id,cxc_section_id,cxc_origin,cxc_timestamp,cxc_sequence_id,cxc_content  FROM `cx_corpora`    WHERE cxc_translation_id = 3197280 AND cxc_section_id = '1311002282_1_60' AND cxc_origin = 'user'  ORDER BY cxc_timestamp DESC LIMIT 1   FOR UPDATE
FrameLocationCall
from/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/database/Database.php(1239)
#0/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/database/Database.php(1223)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/database/Database.php(1197)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/database/Database.php(654)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/database/Database.php(1377)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/database/Database.php(1387)Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(810)Wikimedia\Rdbms\Database->selectRow(array, array, array, string, array, array)
#6/srv/mediawiki/php-1.45.0-wmf.18/extensions/ContentTranslation/includes/Store/TranslationCorporaStore.php(329)Wikimedia\Rdbms\SelectQueryBuilder->fetchRow()
#7/srv/mediawiki/php-1.45.0-wmf.18/extensions/ContentTranslation/includes/Store/TranslationCorporaStore.php(286)ContentTranslation\Store\TranslationCorporaStore->doFind(Wikimedia\Rdbms\DatabaseMySQL, array, array, string)
#8/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/database/Database.php(2334)ContentTranslation\Store\TranslationCorporaStore->ContentTranslation\Store\{closure}(Wikimedia\Rdbms\DatabaseMySQL, string)
#9/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)
#10/srv/mediawiki/php-1.45.0-wmf.18/includes/libs/rdbms/database/DBConnRef.php(754)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#11/srv/mediawiki/php-1.45.0-wmf.18/extensions/ContentTranslation/includes/Store/TranslationCorporaStore.php(288)Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure)
#12/srv/mediawiki/php-1.45.0-wmf.18/extensions/ContentTranslation/includes/Manager/TranslationCorporaManager.php(77)ContentTranslation\Store\TranslationCorporaStore->save(ContentTranslation\Entity\TranslationUnit, bool)
#13/srv/mediawiki/php-1.45.0-wmf.18/extensions/ContentTranslation/includes/ActionApi/ApiContentTranslationSave.php(116)ContentTranslation\Manager\TranslationCorporaManager->saveTranslationUnits(ContentTranslation\Translation, string)
#14/srv/mediawiki/php-1.45.0-wmf.18/includes/api/ApiMain.php(2036)ContentTranslation\ActionApi\ApiContentTranslationSave->execute()
#15/srv/mediawiki/php-1.45.0-wmf.18/includes/api/ApiMain.php(958)MediaWiki\Api\ApiMain->executeAction()
#16/srv/mediawiki/php-1.45.0-wmf.18/includes/api/ApiMain.php(929)MediaWiki\Api\ApiMain->executeActionWithErrorHandling()
#17/srv/mediawiki/php-1.45.0-wmf.18/includes/api/ApiEntryPoint.php(152)MediaWiki\Api\ApiMain->execute()
#18/srv/mediawiki/php-1.45.0-wmf.18/includes/MediaWikiEntryPoint.php(198)MediaWiki\Api\ApiEntryPoint->execute()
#19/srv/mediawiki/php-1.45.0-wmf.18/api.php(44)MediaWiki\MediaWikiEntryPoint->run()
#20/srv/mediawiki/w/api.php(3)require(string)
#21{main}
Impact

Probably causes failure when saving drafts. 4 occurrences in the last 1 day.

Details

Request URL
https://el.wikipedia.org/w/api.php

Event Timeline

abi_ triaged this task as High priority.
Nikerabbit subscribed.

Looking at our CX dashboard, this is the most frequent error in the last 2 weeks. This makes it a good candidate to investigate and try to fix as part of wrapping up LPL Projects (CX observability) project this quarter by fixing most frequent errors.

Nikerabbit lowered the priority of this task from High to Medium.Nov 6 2025, 7:40 AM
Nikerabbit set the point value for this task to 4.
Nikerabbit moved this task from Backlog to Ready for dev on the LPL Essential (FY2025-26 Q2) board.