Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction (db1138)Function: WikiPage::updateCategoryCountsQuery: UPDATE `category` SET cat_pages = cat_pages + 1,cat_files = cat_files + 1 WHERE cat_title IN ('Images_from_Deskthority','PD-author','Released_into_the_public_domain_by_the_copyright_holder_missing_SDC_copyright_license')
Closed, DuplicatePublicPRODUCTION ERROR

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting transaction (db1138)
Function: WikiPage::updateCategoryCounts
Query: UPDATE  `category` SET cat_pages = cat_pages + 1,cat_files =
exception.trace
from /srv/mediawiki/php-1.38.0-wmf.21/includes/libs/rdbms/database/Database.php(1776)
#0 /srv/mediawiki/php-1.38.0-wmf.21/includes/libs/rdbms/database/Database.php(1760): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.38.0-wmf.21/includes/libs/rdbms/database/Database.php(1734): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.38.0-wmf.21/includes/libs/rdbms/database/Database.php(1297): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.38.0-wmf.21/includes/libs/rdbms/database/Database.php(2636): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.38.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(69): Wikimedia\Rdbms\Database->update(string, array, string, string)
#5 /srv/mediawiki/php-1.38.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(381): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/php-1.38.0-wmf.21/includes/page/WikiPage.php(3135): Wikimedia\Rdbms\DBConnRef->update(string, array, array, string)
#7 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/LinksUpdate/CategoryLinksTable.php(306): WikiPage->updateCategoryCounts(array, array, integer)
#8 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/LinksUpdate/CategoryLinksTable.php(272): MediaWiki\Deferred\LinksUpdate\CategoryLinksTable->updateCategoryCounts(array, array)
#9 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/LinksUpdate/LinksTable.php(391): MediaWiki\Deferred\LinksUpdate\CategoryLinksTable->finishUpdate()
#10 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/LinksUpdate/LinksUpdate.php(291): MediaWiki\Deferred\LinksUpdate\LinksTable->update()
#11 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/LinksUpdate/LinksUpdate.php(251): MediaWiki\Deferred\LinksUpdate\LinksUpdate->doIncrementalUpdate()
#12 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/DeferredUpdates.php(536): MediaWiki\Deferred\LinksUpdate\LinksUpdate->doUpdate()
#13 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/RefreshSecondaryDataUpdate.php(103): DeferredUpdates::attemptUpdate(MediaWiki\Deferred\LinksUpdate\LinksUpdate, Wikimedia\Rdbms\LBFactoryMulti)
#14 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/DeferredUpdates.php(536): RefreshSecondaryDataUpdate->doUpdate()
#15 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/DeferredUpdates.php(419): DeferredUpdates::attemptUpdate(RefreshSecondaryDataUpdate, Wikimedia\Rdbms\LBFactoryMulti)
#16 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/DeferredUpdates.php(229): DeferredUpdates::run(RefreshSecondaryDataUpdate, Wikimedia\Rdbms\LBFactoryMulti, Monolog\Logger, BufferingStatsdDataFactory, MediaWiki\JobQueue\JobQueueGroupFactory, string)
#17 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/DeferredUpdatesScope.php(264): DeferredUpdates::{closure}(RefreshSecondaryDataUpdate, integer)
#18 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/DeferredUpdatesScope.php(196): DeferredUpdatesScope->processStageQueue(integer, integer, Closure)
#19 /srv/mediawiki/php-1.38.0-wmf.21/includes/deferred/DeferredUpdates.php(250): DeferredUpdatesScope->processUpdates(integer, Closure)
#20 /srv/mediawiki/php-1.38.0-wmf.21/includes/MediaWiki.php(1114): DeferredUpdates::doUpdates()
#21 /srv/mediawiki/php-1.38.0-wmf.21/includes/MediaWiki.php(839): MediaWiki->restInPeace()
#22 /srv/mediawiki/php-1.38.0-wmf.21/includes/MediaWiki.php(588): MediaWiki->doPostOutputShutdown()
#23 /srv/mediawiki/php-1.38.0-wmf.21/index.php(53): MediaWiki->run()
#24 /srv/mediawiki/php-1.38.0-wmf.21/index.php(46): wfIndexMain()
#25 /srv/mediawiki/w/index.php(3): require(string)
#26 {main}
Impact
Notes

Details

Request URL
https://commons.wikimedia.org/wiki/Special:Upload