Page MenuHomePhabricator

DBQueryError when moving page on zhwiktionary
Closed, DuplicatePublic

Description

After T222024, I want to cleanup pages that title starts with Appendix and in main namespace. So I move those pages by API (specify fromid). 2 pages is ok. But 1 throws

{
    "error": {
        "code": "internal_api_error_DBQueryError",
        "info": "[XO6QZgpAAEcAAExbA2IAAAAN] Caught exception of type Wikimedia\\Rdbms\\DBQueryError",
        "errorclass": "Wikimedia\\Rdbms\\DBQueryError"
    },
    "servedby": "mw1276"
}
2019-05-29 14:00:22 [XO6QZgpAAEcAAExbA2IAAAAN] mw1276 zhwiktionary 1.34.0-wmf.7 exception ERROR: [XO6QZgpAAEcAAExbA2IAAAAN] /w/api.php   Wikimedia\Rdbms\DBQueryError from line 1586 of /srv/mediawiki/php-1.34.0-wmf.7/includes/libs/rdbms/database/Database.php: 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 = '100',page_title = '白一平-沙加爾上古漢語重建系統' WHERE page_id = '1376552'
Function: MovePage::moveToInternal
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.0.205)
 {"exception_id":"XO6QZgpAAEcAAExbA2IAAAAN","exception_url":"/w/api.php","caught_by":"mwe_handler"} 
[Exception Wikimedia\Rdbms\DBQueryError] (/srv/mediawiki/php-1.34.0-wmf.7/includes/libs/rdbms/database/Database.php:1586) 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 = '100',page_title = '白一平-沙加爾上古漢語重建系統' WHERE page_id = '1376552'
Function: MovePage::moveToInternal
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.0.205)

  #0 /srv/mediawiki/php-1.34.0-wmf.7/includes/libs/rdbms/database/Database.php(1554): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
  #1 /srv/mediawiki/php-1.34.0-wmf.7/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
  #2 /srv/mediawiki/php-1.34.0-wmf.7/includes/libs/rdbms/database/Database.php(2161): Wikimedia\Rdbms\Database->query(string, string)
  #3 /srv/mediawiki/php-1.34.0-wmf.7/includes/MovePage.php(749): Wikimedia\Rdbms\Database->update(string, array, array, string)
  #4 /srv/mediawiki/php-1.34.0-wmf.7/includes/MovePage.php(444): MovePage->moveToInternal(User, Title, string, boolean, array)
  #5 /srv/mediawiki/php-1.34.0-wmf.7/includes/MovePage.php(254): MovePage->moveUnsafe(User, string, boolean, array)
  #6 /srv/mediawiki/php-1.34.0-wmf.7/includes/api/ApiMove.php(190): MovePage->move(User, string, boolean, array)
  #7 /srv/mediawiki/php-1.34.0-wmf.7/includes/api/ApiMove.php(87): ApiMove->movePage(Title, Title, string, boolean, array)
  #8 /srv/mediawiki/php-1.34.0-wmf.7/includes/api/ApiMain.php(1595): ApiMove->execute()
  #9 /srv/mediawiki/php-1.34.0-wmf.7/includes/api/ApiMain.php(531): ApiMain->executeAction()
  #10 /srv/mediawiki/php-1.34.0-wmf.7/includes/api/ApiMain.php(502): ApiMain->executeActionWithErrorHandling()
  #11 /srv/mediawiki/php-1.34.0-wmf.7/api.php(87): ApiMain->execute()
  #12 /srv/mediawiki/w/api.php(3): include(string)
  #13 {main}