Page MenuHomePhabricator

internal_api_error_DBQueryError when moving file on commons
Closed, DuplicatePublicPRODUCTION ERROR

Description

Error message
Error while moving the page.
A detailed description of the error is shown below:
API request failed (internal_api_error_DBQueryError): [XYaaBApAAEwAAEtKNFwAAACY] Caught exception of type Wikimedia\Rdbms\DBQueryError <i>at Sat, 21 Sep 2019 21:45:56 GMT</i> <u>served by mw1281</u>
Impact
Notes

Attempting to move file on commons using global "Move & Replace"
https://commons.wikimedia.org/wiki/File:OpinionPollingSpainGeneralElection2019.png

Tried again, and again there was an error:

Error message #2
Error while moving the page.
A detailed description of the error is shown below:
API request failed (internal_api_error_DBQueryError): [XYabFwpAAK4AABSYoLAAAAAM] Caught exception of type Wikimedia\Rdbms\DBQueryError <i>at Sat, 21 Sep 2019 21:50:31 GMT</i> <u>served by mw1312</u>

Details

Request ID
XYaaBApAAEwAAEtKNFwAAACY
Stack Trace
[XYaaBApAAEwAAEtKNFwAAACY] Caught exception of type Wikimedia\Rdbms\DBQueryError

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
exception.message	   	A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: UPDATE  `page` SET page_namespace = '6',page_title = 'OpinionPollingSpainGeneralElection2019-04.png' WHERE page_id = '46596071'
Function: MovePage::moveToInternal
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.0.93)
exception.trace
#0 /srv/mediawiki/php-1.34.0-wmf.23/includes/libs/rdbms/database/Database.php(1573): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/php-1.34.0-wmf.23/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/php-1.34.0-wmf.23/includes/libs/rdbms/database/Database.php(2185): Wikimedia\Rdbms\Database->query(string, string)
#3 /srv/mediawiki/php-1.34.0-wmf.23/includes/MovePage.php(816): Wikimedia\Rdbms\Database->update(string, array, array, string)
#4 /srv/mediawiki/php-1.34.0-wmf.23/includes/MovePage.php(517): MovePage->moveToInternal(User, Title, string, boolean, array)
#5 /srv/mediawiki/php-1.34.0-wmf.23/includes/MovePage.php(327): MovePage->moveUnsafe(User, string, boolean, array)
#6 /srv/mediawiki/php-1.34.0-wmf.23/includes/api/ApiMove.php(194): MovePage->move(User, string, boolean, array)
#7 /srv/mediawiki/php-1.34.0-wmf.23/includes/api/ApiMove.php(91): ApiMove->movePage(Title, Title, string, boolean, array)
#8 /srv/mediawiki/php-1.34.0-wmf.23/includes/api/ApiMain.php(1599): ApiMove->execute()
#9 /srv/mediawiki/php-1.34.0-wmf.23/includes/api/ApiMain.php(537): ApiMain->executeAction()
#10 /srv/mediawiki/php-1.34.0-wmf.23/includes/api/ApiMain.php(508): ApiMain->executeActionWithErrorHandling()
#11 /srv/mediawiki/php-1.34.0-wmf.23/api.php(87): ApiMain->execute()
#12 /srv/mediawiki/w/api.php(3): require(string)
#13 {main}

Same trace as T224592: DBQueryError when moving page on zhwiktionary marked as a duplicate of T223175: Fatal DB error when moving pages: Duplicate entry for key 'name_title' / Lock contention / Deadlock

DannyS712 moved this task from Unsorted to Archive on the User-DannyS712 board.Oct 28 2019, 10:11 AM