Page MenuHomePhabricator

Errors during page moves
Closed, DuplicatePublic

Description

[XTDfjApAAEIAAHL3um4AAAAR] 2019-07-18 21:07:25: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

I tried the same move again, and got:

[XTDftwpAIC4AAJwJyIkAAABW] 2019-07-18 21:08:16: Fatal exception of type "Wikimedia\Rdbms\DBTransactionSizeError" (write duration was 4.0942652225494)

I tried a third time, and the moves worked: page move, associated talk page

Event Timeline

Restricted Application added a project: User-DannyS712. · View Herald TranscriptJul 18 2019, 9:10 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript

This looks similar to T222402: Multiple page or file undelete/restore requests around the same time can deadlock (Fatal DBQueryError).

exception.file	       	/srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/database/Database.php:1589
exception.message	       	A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: INSERT IGNORE INTO `page` (page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len) VALUES ('0','Dark_Angel_(2000_TV_series)','','0','1','0.121083704639','20190718210725','0','0')
Function: WikiPage::insertOn
Error: 1213 Deadlock found when trying to get lock; try restarting transaction (10.64.32.64)
exception.trace
#0 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/database/Database.php(1557): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/database/Database.php(1146): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/database/Database.php(2118): Wikimedia\Rdbms\Database->query(string, string)
#3 /srv/mediawiki/php-1.34.0-wmf.13/includes/page/WikiPage.php(1345): Wikimedia\Rdbms\Database->insert(string, array, string, string)
#4 /srv/mediawiki/php-1.34.0-wmf.13/includes/MovePage.php(809): WikiPage->insertOn(Wikimedia\Rdbms\DatabaseMysqli)
#5 /srv/mediawiki/php-1.34.0-wmf.13/includes/MovePage.php(452): MovePage->moveToInternal(User, Title, string, boolean, array)
#6 /srv/mediawiki/php-1.34.0-wmf.13/includes/MovePage.php(294): MovePage->moveUnsafe(User, string, boolean, array)
#7 /srv/mediawiki/php-1.34.0-wmf.13/includes/specials/SpecialMovepage.php(610): MovePage->moveIfAllowed(User, string, boolean)
#8 /srv/mediawiki/php-1.34.0-wmf.13/includes/specials/SpecialMovepage.php(130): MovePageForm->doSubmit()
#9 /srv/mediawiki/php-1.34.0-wmf.13/includes/specialpage/SpecialPage.php(571): MovePageForm->execute(NULL)
#10 /srv/mediawiki/php-1.34.0-wmf.13/includes/specialpage/SpecialPageFactory.php(581): SpecialPage->run(NULL)
#11 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(288): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext)
#12 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(884): MediaWiki->performRequest()
#13 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(515): MediaWiki->main()
#14 /srv/mediawiki/php-1.34.0-wmf.13/index.php(42): MediaWiki->run()
#15 /srv/mediawiki/w/index.php(3): require(string)
#16 {main}
exception_id	       	XTDfjApAAEIAAHL3um4AAAAR
exception_url	       	/w/index.php?title=Special:MovePage&action=submit
exception.file	       	/srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/loadbalancer/LoadBalancer.php:1536
exception.message	       	Transaction spent 4.0942652225494 second(s) in writes, exceeding the limit of 3
exception.trace
#0 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1982): Wikimedia\Rdbms\LoadBalancer->Wikimedia\Rdbms\{closure}(Wikimedia\Rdbms\DatabaseMysqli)
#1 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1550): Wikimedia\Rdbms\LoadBalancer->forEachOpenMasterConnection(Closure)
#2 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/lbfactory/LBFactory.php(230): Wikimedia\Rdbms\LoadBalancer->approveMasterChanges(array, string, integer)
#3 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/lbfactory/LBFactoryMulti.php(368): Wikimedia\Rdbms\LBFactory->Wikimedia\Rdbms\{closure}(Wikimedia\Rdbms\LoadBalancer, string, array)
#4 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/lbfactory/LBFactory.php(232): Wikimedia\Rdbms\LBFactoryMulti->forEachLB(Closure, array)
#5 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/lbfactory/LBFactory.php(287): Wikimedia\Rdbms\LBFactory->forEachLBCallMethod(string, array)
#6 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(595): Wikimedia\Rdbms\LBFactory->commitMasterChanges(string, array)
#7 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(566): MediaWiki::preOutputCommit(RequestContext, Closure)
#8 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(900): MediaWiki->doPreOutputCommit(Closure)
#9 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(515): MediaWiki->main()
#10 /srv/mediawiki/php-1.34.0-wmf.13/index.php(42): MediaWiki->run()
#11 /srv/mediawiki/w/index.php(3): require(string)
#12 {main}
exception_id	       	XTDftwpAIC4AAJwJyIkAAABW
exception_url	       	/w/index.php?title=Special:MovePage&action=submit
Krinkle added a subscriber: Krinkle.

Thanks, it is in fact exactly the same issue :)

DannyS712 moved this task from Unsorted to Archive on the User-DannyS712 board.Jul 23 2019, 4:45 PM
mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:05 PM