Page MenuHomePhabricator

File moving timed out/failed: Wikimedia\Rdbms\DBQueryError: Error 1205: Lock wait timeout exceeded; try restarting transaction Function: MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds
Open, Needs TriagePublicPRODUCTION ERROR

Description

Steps to replicate the issue (include links if applicable):

Tried to move https://commons.wikimedia.org/wiki/File:J_Class_World_Championship_-_Newport_Shipyard_by_D_Ramey_Logan.webm using API:

https://commons.wikimedia.org/w/api.php?action=move
action	"move"
format	"json"
from	"File:J+Class+World+Championship+-+Newport+Shipyard+by+D+Ramey+Logan.webm"
to	"File:J+Class+World+Championship+-+Newport+Shipyard+by+Don+Ramey+Logan.webm"
reason	"[[Special:PermanentLink/1234689896|FR1]]"
movetalk	"1"
watchlist	"nochange"
tags	"AJSBulkRename"
assertuser	"Alexis+Jazz"

Tried to move https://commons.wikimedia.org/wiki/File:Wedge_Video_D_Ramey_Logan.ogv using API:

action	"move"
format	"json"
from	"File:Wedge+Video+D+Ramey+Logan.ogv"
to	"File:Large+waves+from+Hurricane+Marie+at+the+Wedge+Video+Don+Ramey+Logan.ogv"
reason	"[[Special:PermanentLink/1234689896|FR1]]"
movetalk	"1"
watchlist	"nochange"
tags	"AJSBulkRename"
assertuser	"Alexis+Jazz"

Tokens were included in the request.

What happens?:
First file: NS_BINDING_ABORTED

Second file:

HTTP 200, 16839ms
error	Object { code: "internal_api_error_DBQueryError", info: "[cd5d4dd2-e43d-473a-9554-bc6d9b294ca0] Caught exception of type Wikimedia\\Rdbms\\DBQueryError", errorclass: "Wikimedia\\Rdbms\\DBQueryError" }
servedby	"mw-api-ext.eqiad.main-6d8f95854d-g659g"

[cd5d4dd2-e43d-473a-9554-bc6d9b294ca0]

What should have happened instead?:
Moved files

Software version (on Special:Version page; skip for WMF-hosted wikis like Wikipedia):
https://commons.wikimedia.org/wiki/User:Alexis_Jazz/AJSBulkRename but as it's an API call I can't imagine it matters.


Error
  • mwversion: 1.47.0-wmf.9
  • timestamp: 2026-07-04T02:22:13.659Z
  • phpversion: 8.3.31
  • reqId: cd5d4dd2-e43d-473a-9554-bc6d9b294ca0
  • Find reqId in Logstash
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1205: Lock wait timeout exceeded; try restarting transaction
Function: MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds
Query: SELECT  rev_id,rev_page,rev_timestamp,rev_minor_edit,
FrameLocationCall
from/srv/mediawiki/php-1.47.0-wmf.9/includes/libs/Rdbms/Database/Database.php(1230)
#0/srv/mediawiki/php-1.47.0-wmf.9/includes/libs/Rdbms/Database/Database.php(1214)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.47.0-wmf.9/includes/libs/Rdbms/Database/Database.php(1188)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.47.0-wmf.9/includes/libs/Rdbms/Database/Database.php(644)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.47.0-wmf.9/includes/libs/Rdbms/Database/Database.php(1368)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.47.0-wmf.9/includes/libs/Rdbms/Database/Database.php(1378)Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5/srv/mediawiki/php-1.47.0-wmf.9/includes/libs/Rdbms/Database/DBConnRef.php(129)Wikimedia\Rdbms\Database->selectRow(array, array, array, string, array, array)
#6/srv/mediawiki/php-1.47.0-wmf.9/includes/libs/Rdbms/Database/DBConnRef.php(402)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#7/srv/mediawiki/php-1.47.0-wmf.9/includes/libs/Rdbms/QueryBuilder/SelectQueryBuilder.php(809)Wikimedia\Rdbms\DBConnRef->selectRow(array, array, array, string, array, array)
#8/srv/mediawiki/php-1.47.0-wmf.9/includes/Revision/RevisionStore.php(2355)Wikimedia\Rdbms\SelectQueryBuilder->fetchRow()
#9/srv/mediawiki/php-1.47.0-wmf.9/includes/Revision/RevisionStore.php(2303)MediaWiki\Revision\RevisionStore->fetchRevisionRowFromConds(Wikimedia\Rdbms\DBConnRef, array, int, array)
#10/srv/mediawiki/php-1.47.0-wmf.9/includes/Revision/RevisionStore.php(2265)MediaWiki\Revision\RevisionStore->loadRevisionFromConds(Wikimedia\Rdbms\DBConnRef, array, int, null, array)
#11/srv/mediawiki/php-1.47.0-wmf.9/includes/Revision/RevisionStore.php(1282)MediaWiki\Revision\RevisionStore->newRevisionFromConds(array, int)
#12/srv/mediawiki/php-1.47.0-wmf.9/includes/Page/WikiPage.php(727)MediaWiki\Revision\RevisionStore->getRevisionByPageId(int, int, int)
#13/srv/mediawiki/php-1.47.0-wmf.9/includes/Page/WikiPage.php(759)MediaWiki\Page\WikiPage->loadLastEdit()
#14/srv/mediawiki/php-1.47.0-wmf.9/includes/Storage/DerivedPageDataUpdater.php(511)MediaWiki\Page\WikiPage->getRevisionRecord()
#15/srv/mediawiki/php-1.47.0-wmf.9/includes/Storage/PageUpdater.php(440)MediaWiki\Storage\DerivedPageDataUpdater->grabLatestRevision()
#16/srv/mediawiki/php-1.47.0-wmf.9/includes/Storage/PageUpdater.php(337)MediaWiki\Storage\PageUpdater->grabParentRevision()
#17/srv/mediawiki/php-1.47.0-wmf.9/includes/Storage/PageUpdater.php(734)MediaWiki\Storage\PageUpdater->setForceEmptyRevision(bool)
#18/srv/mediawiki/php-1.47.0-wmf.9/includes/Page/MovePage.php(965)MediaWiki\Storage\PageUpdater->saveDummyRevision(string, int)
#19/srv/mediawiki/php-1.47.0-wmf.9/includes/Page/MovePage.php(665)MediaWiki\Page\MovePage->moveToInternal(MediaWiki\User\User, MediaWiki\Title\Title, string, bool, array)
#20/srv/mediawiki/php-1.47.0-wmf.9/includes/Page/MovePage.php(495)MediaWiki\Page\MovePage->moveUnsafe(MediaWiki\User\User, string, bool, array)
#21/srv/mediawiki/php-1.47.0-wmf.9/includes/Api/ApiMove.php(98)MediaWiki\Page\MovePage->moveIfAllowed(MediaWiki\User\User, string, bool, array)
#22/srv/mediawiki/php-1.47.0-wmf.9/includes/Api/ApiMain.php(2049)MediaWiki\Api\ApiMove->execute()
#23/srv/mediawiki/php-1.47.0-wmf.9/includes/Api/ApiMain.php(947)MediaWiki\Api\ApiMain->executeAction()
#24/srv/mediawiki/php-1.47.0-wmf.9/includes/Api/ApiMain.php(918)MediaWiki\Api\ApiMain->executeActionWithErrorHandling()
#25/srv/mediawiki/php-1.47.0-wmf.9/includes/Api/ApiEntryPoint.php(138)MediaWiki\Api\ApiMain->execute()
#26/srv/mediawiki/php-1.47.0-wmf.9/includes/MediaWikiEntryPoint.php(180)MediaWiki\Api\ApiEntryPoint->execute()
#27/srv/mediawiki/php-1.47.0-wmf.9/api.php(30)MediaWiki\MediaWikiEntryPoint->run()
#28/srv/mediawiki/w/api.php(3)require(string)
#29{main}
Impact
Notes

Details

Request URL
https://commons.wikimedia.org/w/api.php?action=move

Event Timeline

Restricted Application changed the subtype of this task from "Bug Report" to "Production Error". · View Herald TranscriptJul 4 2026, 2:32 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
AlexisJazz set Request URL to [cd5d4dd2-e43d-473a-9554-bc6d9b294ca0].
Aklapper renamed this task from File moving timed out/failed to File moving timed out/failed: Wikimedia\Rdbms\DBQueryError: Error 1205: Lock wait timeout exceeded; try restarting transaction Function: MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds.Jul 4 2026, 2:58 AM
Aklapper set Request URL to https://commons.wikimedia.org/w/api.php?action=move.
Aklapper updated the task description. (Show Details)