Page MenuHomePhabricator

Fatal DBQueryError when moving a page on enwiki
Closed, DuplicatePublicPRODUCTION ERROR

Description

Error message
A database query error has occurred. This may indicate a bug in the software.
[XnF1nApAMMEAAEmn598AAAAE] 2020-03-18 01:13:03: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"
Impact

Couldn't complete the move.

Notes

A second later, for a different move[1], a similar error occurred: [XnF1nQpAMNQAA-olok8AAAAC] 2020-03-18 01:13:04: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Both moves were attempted again, and were successful.

[1] https://en.wikipedia.org/w/index.php?title=Special:MovePage&wpOldTitle=Bernardo+de+G%C3%A1lvez+%28statue%29&wpNewTitle=Equestrian+statue+of+Bernardo+de+G%C3%A1lvez&wpReason=%5B%5BWikipedia%3ARequested+moves%7Crequested+move%5D%5D%3B+consensus+at+%5B%5BTalk%3AEquestrian+statue+of+Bernardo+de+G%C3%A1lvez%5D%5D&wpMovetalk=1

Details

Request ID
XnF1nApAMMEAAEmn598AAAAE
Request URL
https://en.wikipedia.org/w/index.php?title=Special:MovePage&wpOldTitle=General+Winfield+Scott+Hancock+%28Ellicott%29&wpNewTitle=Equestrian+statue+of+Winfield+Scott+Hancock&wpReason=%5B%5BWikipedia%3ARequested+moves%7Crequested+move%5D%5D%3B+consensus+at+%5B%5BTalk%3AEquestrian+statue+of+Winfield+Scott+Hancock%5D%5D&wpMovetalk=1
Stack Trace
2020-03-18 01:13:03 [XnF1nApAMMEAAEmn598AAAAE] mw1351 enwiki 1.35.0-wmf.22 exception ERROR: [XnF1nApAMMEAAEmn598AAAAE] /w/index.php?title=Special:MovePage&action=submit   Wikimedia\Rdbms\DBQueryError from line 1626 of /srv/mediawiki/php-1.35.0-wmf.22/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: REPLACE INTO `watchlist` (wl_user,wl_namespace,wl_title,wl_notificationtimestamp) VALUES ('612302',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20120619202654'),('2563820',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20190916032134'),('6169056',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20200310133430'),('13747527',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20160916214357'),('14218903',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20190916032134'),('64853',0,'Equestrian_statue_of_Winfield_Scott_Hancock',NULL)
Function: WatchedItemStore::duplicateEntry
Error: 1213 Deadlock found when trying to get lock; try restarting transaction (10.64.16.101)
 {"exception_id":"XnF1nApAMMEAAEmn598AAAAE","exception_url":"/w/index.php?title=Special:MovePage&action=submit","caught_by":"mwe_handler"} 
[Exception Wikimedia\Rdbms\DBQueryError] (/srv/mediawiki/php-1.35.0-wmf.22/includes/libs/rdbms/database/Database.php:1626) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: REPLACE INTO `watchlist` (wl_user,wl_namespace,wl_title,wl_notificationtimestamp) VALUES ('612302',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20120619202654'),('2563820',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20190916032134'),('6169056',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20200310133430'),('13747527',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20160916214357'),('14218903',0,'Equestrian_statue_of_Winfield_Scott_Hancock','20190916032134'),('64853',0,'Equestrian_statue_of_Winfield_Scott_Hancock',NULL)
Function: WatchedItemStore::duplicateEntry
Error: 1213 Deadlock found when trying to get lock; try restarting transaction (10.64.16.101)

  #0 /srv/mediawiki/php-1.35.0-wmf.22/includes/libs/rdbms/database/Database.php(1610): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
  #1 /srv/mediawiki/php-1.35.0-wmf.22/includes/libs/rdbms/database/Database.php(1587): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
  #2 /srv/mediawiki/php-1.35.0-wmf.22/includes/libs/rdbms/database/Database.php(1166): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
  #3 /srv/mediawiki/php-1.35.0-wmf.22/includes/libs/rdbms/database/Database.php(3005): Wikimedia\Rdbms\Database->query(string, string)
  #4 /srv/mediawiki/php-1.35.0-wmf.22/includes/libs/rdbms/database/DatabaseMysqlBase.php(452): Wikimedia\Rdbms\Database->nativeReplace(string, array, string)
  #5 /srv/mediawiki/php-1.35.0-wmf.22/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\DatabaseMysqlBase->replace(string, array, array, string)
  #6 /srv/mediawiki/php-1.35.0-wmf.22/includes/libs/rdbms/database/DBConnRef.php(505): Wikimedia\Rdbms\DBConnRef->__call(string, array)
  #7 /srv/mediawiki/php-1.35.0-wmf.22/includes/watcheditem/WatchedItemStore.php(1258): Wikimedia\Rdbms\DBConnRef->replace(string, array, array, string)
  #8 /srv/mediawiki/php-1.35.0-wmf.22/includes/watcheditem/WatchedItemStore.php(1209): WatchedItemStore->duplicateEntry(TitleValue, TitleValue)
  #9 /srv/mediawiki/php-1.35.0-wmf.22/includes/MovePage.php(646): WatchedItemStore->duplicateAllAssociatedEntries(Title, Title)
  #10 /srv/mediawiki/php-1.35.0-wmf.22/includes/MovePage.php(374): MovePage->moveUnsafe(User, string, boolean, array)
  #11 /srv/mediawiki/php-1.35.0-wmf.22/includes/specials/SpecialMovepage.php(770): MovePage->moveIfAllowed(User, string, boolean)
  #12 /srv/mediawiki/php-1.35.0-wmf.22/includes/specials/SpecialMovepage.php(135): MovePageForm->doSubmit()
  #13 /srv/mediawiki/php-1.35.0-wmf.22/includes/specialpage/SpecialPage.php(575): MovePageForm->execute(NULL)
  #14 /srv/mediawiki/php-1.35.0-wmf.22/includes/specialpage/SpecialPageFactory.php(621): SpecialPage->run(NULL)
  #15 /srv/mediawiki/php-1.35.0-wmf.22/includes/MediaWiki.php(299): MediaWiki\SpecialPage\SpecialPageFactory->executePath(Title, RequestContext)
  #16 /srv/mediawiki/php-1.35.0-wmf.22/includes/MediaWiki.php(972): MediaWiki->performRequest()
  #17 /srv/mediawiki/php-1.35.0-wmf.22/includes/MediaWiki.php(535): MediaWiki->main()
  #18 /srv/mediawiki/php-1.35.0-wmf.22/index.php(47): MediaWiki->run()
  #19 /srv/mediawiki/w/index.php(3): require(string)
  #20 {main}

Event Timeline

Restricted Application added a project: User-DannyS712. · View Herald TranscriptMar 18 2020, 1:16 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
DannyS712 updated the task description. (Show Details)Mar 18 2020, 1:17 AM
DannyS712 moved this task from Unsorted to Reports on the User-DannyS712 board.
Krinkle renamed this task from DBQueryError when moving pages on enwiki to Fatal DBQueryError when moving a page on enwiki.Apr 8 2020, 4:13 PM
Krinkle edited projects, added MediaWiki-Page-rename; removed MediaWiki-General.