Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transactionFunction: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsagesQuery: INSERT IGNORE INTO `wbc_entity_usage`
Open, Needs TriagePublicPRODUCTION ERROR

Description

Error
labels.normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction
Function: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages
Query: INSERT IGNORE INTO `wbc_entity_usage` (eu_page_
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(1496)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->insert(string, array, string, array)
#5/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/database/DBConnRef.php(407)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6/srv/mediawiki/php-1.44.0-wmf.23/includes/libs/rdbms/querybuilder/InsertQueryBuilder.php(340)Wikimedia\Rdbms\DBConnRef->insert(string, array, string, array)
#7/srv/mediawiki/php-1.44.0-wmf.23/extensions/Wikibase/client/includes/Usage/Sql/EntityUsageTable.php(188)Wikimedia\Rdbms\InsertQueryBuilder->execute()
#8/srv/mediawiki/php-1.44.0-wmf.23/extensions/Wikibase/client/includes/Usage/Sql/SqlUsageTracker.php(161)Wikibase\Client\Usage\Sql\EntityUsageTable->addUsages(int, array)
#9/srv/mediawiki/php-1.44.0-wmf.23/extensions/Wikibase/client/includes/Store/UsageUpdater.php(82)Wikibase\Client\Usage\Sql\SqlUsageTracker->addUsedEntities(int, array)
#10/srv/mediawiki/php-1.44.0-wmf.23/extensions/Wikibase/client/includes/Store/AddUsagesForPageJob.php(117)Wikibase\Client\Store\UsageUpdater->addUsagesForPage(int, array)
#11/srv/mediawiki/php-1.44.0-wmf.23/extensions/EventBus/includes/JobExecutor.php(88)Wikibase\Client\Store\AddUsagesForPageJob->run()
#12/srv/mediawiki/rpc/RunSingleJob.php(60)MediaWiki\Extension\EventBus\JobExecutor->execute(array)
#13{main}
Impact

Unclear.

Notes

These seem to be continuously happening at a low level. Last 3 months:

2025-04-10-09:25:58.png (251×633 px, 17 KB)

Details

Request URL
https://mw-jobrunner.discovery.wmnet/rpc/RunSingleJob.php