Page MenuHomePhabricator

ContentTranslation: DBQueryError: Error 1213: Deadlock found when trying to get lock
Open, MediumPublicPRODUCTION ERROR

Description

Error
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 = 3007077 AND cxc_section_id = '1255897500_0_2' AND cxc_origin = 'user' ORDER BY cxc_timestamp DESC LIMIT 1 FOR UPDATE
FrameLocationCall
from/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/Database.php(1230)
#0/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/Database.php(1214)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/Database.php(1188)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/Database.php(647)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/Database.php(1365)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/Database.php(1374)Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(810)Wikimedia\Rdbms\Database->selectRow(array, array, array, string, array, array)
#6/srv/mediawiki/php-1.44.0-wmf.23/extensions/ContentTranslation/includes/Store/TranslationCorporaStore.php(316)Wikimedia\Rdbms\SelectQueryBuilder->fetchRow()
#7/srv/mediawiki/php-1.44.0-wmf.23/extensions/ContentTranslation/includes/Store/TranslationCorporaStore.php(285)ContentTranslation\Store\TranslationCorporaStore->doFind(Wikimedia\Rdbms\DatabaseMySQL, array, array, string)
#8/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/Database.php(2291)ContentTranslation\Store\TranslationCorporaStore->ContentTranslation\Store\{closure}(Wikimedia\Rdbms\DatabaseMySQL, string)
#9/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)
#10/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/DBConnRef.php(661)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#11/srv/mediawiki/php-1.44.0-wmf.23/extensions/ContentTranslation/includes/Store/TranslationCorporaStore.php(287)Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure)
#12/srv/mediawiki/php-1.44.0-wmf.23/extensions/ContentTranslation/includes/Manager/TranslationCorporaManager.php(80)ContentTranslation\Store\TranslationCorporaStore->save(ContentTranslation\Entity\TranslationUnit, bool)
#13/srv/mediawiki/php-1.44.0-wmf.23/extensions/ContentTranslation/includes/ActionApi/ApiContentTranslationSave.php(109)ContentTranslation\Manager\TranslationCorporaManager->saveTranslationUnits(ContentTranslation\Translation, string)
#14/srv/mediawiki/php-1.44.0-wmf.23/includes/api/ApiMain.php(2005)ContentTranslation\ActionApi\ApiContentTranslationSave->execute()
#15/srv/mediawiki/php-1.44.0-wmf.23/includes/api/ApiMain.php(947)MediaWiki\Api\ApiMain->executeAction()
#16/srv/mediawiki/php-1.44.0-wmf.23/includes/api/ApiMain.php(918)MediaWiki\Api\ApiMain->executeActionWithErrorHandling()
#17/srv/mediawiki/php-1.44.0-wmf.23/includes/api/ApiEntryPoint.php(152)MediaWiki\Api\ApiMain->execute()
#18/srv/mediawiki/php-1.44.0-wmf.23/includes/MediaWikiEntryPoint.php(202)MediaWiki\Api\ApiEntryPoint->execute()
#19/srv/mediawiki/php-1.44.0-wmf.23/api.php(44)MediaWiki\MediaWikiEntryPoint->run()
#20/srv/mediawiki/w/api.php(3)require(string)
#21{main}
Impact

39 occurences in last 1 week

Notes

More instances: https://logstash.wikimedia.org/goto/6f6e9cd8ff4c3767b06f21e10da57f1b

Details

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