Page MenuHomePhabricator
Create Task
Maniphest T233503

internal_api_error_DBQueryError when moving file on commons
Closed, DuplicatePublicPRODUCTION ERROR
Actions

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

Related Objects

Event Timeline

DannyS712 created this task.Sep 21 2019, 9:52 PM
Restricted Application added projects: User-DannyS712, Platform Engineering. · View Herald TranscriptSep 21 2019, 9:52 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Aklapper added a comment.Sep 21 2019, 10:13 PM
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

Aklapper closed this task as a duplicate of T223175: Fatal DB error when moving pages: Duplicate entry for key 'name_title' / Lock contention / Deadlock.Sep 21 2019, 10:14 PM
Aklapper removed projects: Platform Engineering, MediaWiki-libs-Rdbms, MediaWiki-File-management.
DannyS712 moved this task from Unsorted to Archive on the User-DannyS712 board.Oct 28 2019, 10:11 AM
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