Page MenuHomePhabricator
Create Task
Maniphest T400908

Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transactionFunction: MediaWiki\Page\WikiPage::updateCategoryCountsQuery
Closed, DuplicatePublicPRODUCTION ERROR
Actions

Description

Error
  • service.version: 1.45.0-wmf.12
  • timestamp: 2025-07-31T05:42:58.082Z
  • labels.phpversion: 8.1.33
  • trace.id: ba430247-d3a6-420f-982b-b4dedda8e49a
  • Find trace.id in Logstash
labels.normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction
Function: MediaWiki\Page\WikiPage::updateCategoryCounts
Query: UPDATE  `category` SET cat_pages = cat_pages - 1 WHERE cat_id IN ([ids])
FrameLocationCall
from/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1232)
#0/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1216)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1190)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(647)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/Database.php(1518)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->update(string, array, array, string, array)
#5/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/database/DBConnRef.php(413)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6/srv/mediawiki/php-1.45.0-wmf.12/includes/libs/rdbms/querybuilder/UpdateQueryBuilder.php(332)Wikimedia\Rdbms\DBConnRef->update(string, array, array, string, array)
#7/srv/mediawiki/php-1.45.0-wmf.12/includes/page/WikiPage.php(2819)Wikimedia\Rdbms\UpdateQueryBuilder->execute()
#8/srv/mediawiki/php-1.45.0-wmf.12/includes/deferred/LinksUpdate/CategoryLinksTable.php(400)MediaWiki\Page\WikiPage->updateCategoryCounts(array, array, int)
#9/srv/mediawiki/php-1.45.0-wmf.12/includes/deferred/LinksUpdate/CategoryLinksTable.php(367)MediaWiki\Deferred\LinksUpdate\CategoryLinksTable->updateCategoryCounts(array, array)
#10/srv/mediawiki/php-1.45.0-wmf.12/includes/deferred/LinksUpdate/LinksTable.php(374)MediaWiki\Deferred\LinksUpdate\CategoryLinksTable->finishUpdate()
#11/srv/mediawiki/php-1.45.0-wmf.12/includes/deferred/LinksUpdate/LinksUpdate.php(225)MediaWiki\Deferred\LinksUpdate\LinksTable->update()
#12/srv/mediawiki/php-1.45.0-wmf.12/includes/deferred/LinksUpdate/LinksUpdate.php(185)MediaWiki\Deferred\LinksUpdate\LinksUpdate->doIncrementalUpdate()
#13/srv/mediawiki/php-1.45.0-wmf.12/includes/deferred/DeferredUpdates.php(459)MediaWiki\Deferred\LinksUpdate\LinksUpdate->doUpdate()
#14/srv/mediawiki/php-1.45.0-wmf.12/includes/deferred/RefreshSecondaryDataUpdate.php(113)MediaWiki\Deferred\DeferredUpdates::attemptUpdate(MediaWiki\Deferred\LinksUpdate\LinksUpdate)
#15/srv/mediawiki/php-1.45.0-wmf.12/includes/deferred/DeferredUpdates.php(459)MediaWiki\Deferred\RefreshSecondaryDataUpdate->doUpdate()
#16/srv/mediawiki/php-1.45.0-wmf.12/includes/Storage/DerivedPageDataUpdater.php(1882)MediaWiki\Deferred\DeferredUpdates::attemptUpdate(MediaWiki\Deferred\RefreshSecondaryDataUpdate)
#17/srv/mediawiki/php-1.45.0-wmf.12/includes/page/WikiPage.php(1901)MediaWiki\Storage\DerivedPageDataUpdater->doSecondaryDataUpdates(array)
#18/srv/mediawiki/php-1.45.0-wmf.12/includes/jobqueue/jobs/RefreshLinksJob.php(306)MediaWiki\Page\WikiPage->doSecondaryDataUpdates(array)
#19/srv/mediawiki/php-1.45.0-wmf.12/includes/jobqueue/jobs/RefreshLinksJob.php(216)MediaWiki\JobQueue\Jobs\RefreshLinksJob->runForTitle(MediaWiki\Title\Title)
#20/srv/mediawiki/php-1.45.0-wmf.12/extensions/EventBus/includes/JobExecutor.php(94)MediaWiki\JobQueue\Jobs\RefreshLinksJob->run()
#21/srv/mediawiki/rpc/RunSingleJob.php(60)MediaWiki\Extension\EventBus\JobExecutor->execute(array)
#22{main}
Notes

Noted a handful of these in 1.45.0-wmf.12 (T396373).

See logstash for full error with categories.

Details

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

Related Objects

Event Timeline

brennen created this task.Jul 31 2025, 3:04 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 31 2025, 3:04 PM
brennen added a project: Unstewarded-production-error.EditedJul 31 2025, 3:10 PM
brennen added a subscriber: daniel.

@daniel thoughts here?

Edit: Noted you're listed on Developers / Maintainers.

Umherirrender subscribed.Jul 31 2025, 6:00 PM

Similiar issue: T364404: Fatal "DBQueryError: Lock wait timeout exceeded" from WikiPage::updateCategoryCounts after some edits
Solution idea: T365303: Move update of category members count to CategoryMembershipChangeJob

Count_Count subscribed.EditedAug 1 2025, 11:00 AM

The category count is definitely broken today, see e.g. sub categories here all listed as empty when they are not: https://de.wikipedia.org/wiki/Kategorie:Wohngeb%C3%A4ude_in_Niedersachsen

Count_Count mentioned this in T400987: Regression: Category member counts broken in German Wikipedia .Aug 1 2025, 11:06 AM
brennen moved this task from Backlog to Logs/Train on the User-brennen board.Aug 1 2025, 5:09 PM
Mbch331 subscribed.Aug 1 2025, 8:13 PM
Umherirrender unsubscribed.Aug 6 2025, 8:11 PM
Umherirrender closed this task as a duplicate of T364404: Fatal "DBQueryError: Lock wait timeout exceeded" from WikiPage::updateCategoryCounts after some edits.Aug 25 2025, 7:32 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits