DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction ([db])Function: ContentTranslation\TranslationStorageManager::saveQuery
Closed, DuplicatePublicPRODUCTION ERROR
Actions

Assigned To

None

Authored By

	brennen
	Apr 21 2022, 3:56 PM

Description

Error

mwversion: 1.39.0-wmf.8
reqId: 8e01737b-4f59-4345-b92e-b9ef21774206
Find reqId in Logstash

normalized_message

[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction (db1103)
Function: ContentTranslation\TranslationStorageManager::save
Query: SELECT  *  FROM `cx_corpora`    WHERE cxc

exception.trace

from /srv/mediawiki/php-1.39.0-wmf.8/includes/libs/rdbms/database/Database.php(1779)
#0 /srv/mediawiki/php-1.39.0-wmf.8/includes/libs/rdbms/database/Database.php(1763): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.39.0-wmf.8/includes/libs/rdbms/database/Database.php(1737): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.39.0-wmf.8/includes/libs/rdbms/database/Database.php(1217): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.39.0-wmf.8/includes/libs/rdbms/database/Database.php(1983): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.39.0-wmf.8/includes/libs/rdbms/database/Database.php(2084): Wikimedia\Rdbms\Database->select(string, string, array, string, array, array)
#5 /srv/mediawiki/php-1.39.0-wmf.8/extensions/ContentTranslation/includes/TranslationStorageManager.php(163): Wikimedia\Rdbms\Database->selectRow(string, string, array, string, array)
#6 /srv/mediawiki/php-1.39.0-wmf.8/extensions/ContentTranslation/includes/TranslationStorageManager.php(148): ContentTranslation\TranslationStorageManager::doFind(Wikimedia\Rdbms\DatabaseMysqli, array, array, string)
#7 /srv/mediawiki/php-1.39.0-wmf.8/includes/libs/rdbms/database/Database.php(4608): ContentTranslation\TranslationStorageManager::ContentTranslation\{closure}(Wikimedia\Rdbms\DatabaseMysqli, string)
#8 /srv/mediawiki/php-1.39.0-wmf.8/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)
#9 /srv/mediawiki/php-1.39.0-wmf.8/includes/libs/rdbms/database/DBConnRef.php(605): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#10 /srv/mediawiki/php-1.39.0-wmf.8/extensions/ContentTranslation/includes/TranslationStorageManager.php(156): Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure)
#11 /srv/mediawiki/php-1.39.0-wmf.8/extensions/ContentTranslation/includes/ActionApi/ApiContentTranslationSave.php(239): ContentTranslation\TranslationStorageManager::save(ContentTranslation\TranslationUnit, boolean)
#12 /srv/mediawiki/php-1.39.0-wmf.8/extensions/ContentTranslation/includes/ActionApi/ApiContentTranslationSave.php(86): ContentTranslation\ActionApi\ApiContentTranslationSave->saveTranslationUnits(array, ContentTranslation\Translation)
#13 /srv/mediawiki/php-1.39.0-wmf.8/includes/api/ApiMain.php(1902): ContentTranslation\ActionApi\ApiContentTranslationSave->execute()
#14 /srv/mediawiki/php-1.39.0-wmf.8/includes/api/ApiMain.php(874): ApiMain->executeAction()
#15 /srv/mediawiki/php-1.39.0-wmf.8/includes/api/ApiMain.php(845): ApiMain->executeActionWithErrorHandling()
#16 /srv/mediawiki/php-1.39.0-wmf.8/api.php(90): ApiMain->execute()
#17 /srv/mediawiki/php-1.39.0-wmf.8/api.php(45): wfApiMain()
#18 /srv/mediawiki/w/api.php(3): require(string)
#19 {main}

Impact

Notes

Seen in 1.39.0-wmf.8 (T305214).

Details

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

Related Objects

Mentioned Here: T256229: ContentTranslation\TranslationStorageManager::saveQuery: Deadlock found when trying to get lock; try restarting transaction
T256899: Error 1213: Deadlock found when trying to get lock; Function: ContentTranslation\TranslationStorageManager::createQuery
T305214: 1.39.0-wmf.8 deployment blockers

Event Timeline

brennen created this task.Apr 21 2022, 3:56 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 21 2022, 3:56 PM

brennen renamed this task from Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction (db1103)Function: ContentTranslation\TranslationStorageManager::saveQuery: SELECT * FROM `cx_corpora` WHERE cxc_translation_id = 1579817 AND cxc_section_id = '1' AND cxc_origin = 'user' ORDER BY cxc_timestamp DESC LIMIT 1 FOR UPDATE to DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction ([db])Function: ContentTranslation\TranslationStorageManager::saveQuery.Apr 21 2022, 3:57 PM

brennen added a project: User-brennen.

KartikMistry added subscribers: santhosh, ngkountas.Apr 21 2022, 4:34 PM

Krinkle moved this task from Untriaged to Apr 2022 on the Wikimedia-production-error board.Apr 21 2022, 5:08 PM

brennen moved this task from Backlog to Logs/Train on the User-brennen board.Apr 25 2022, 10:28 PM

Removing team tag after triage.

This happens 0-3 per day, on average about once a day. In fact I believe it's duplicate of T256229: ContentTranslation\TranslationStorageManager::saveQuery: Deadlock found when trying to get lock; try restarting transaction and will mark it as such.

• Nikerabbit closed this task as a duplicate of T256229: ContentTranslation\TranslationStorageManager::saveQuery: Deadlock found when trying to get lock; try restarting transaction.May 11 2022, 2:03 PM

DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction ([db])Function: ContentTranslation\TranslationStorageManager::saveQueryClosed, DuplicatePublicPRODUCTION ERRORActions