Page MenuHomePhabricator

Frequent deadlocks in LinksUpdate->invalidateImageDescriptions()
Closed, ResolvedPublic

Description

Query: UPDATE page SET page_touched = '20150403092057' WHERE page_id = '3375557' AND (page_touched < '20150403092057')
Function: SqlDataUpdate::invalidatePages
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.16.29)

#0 /srv/mediawiki/php-1.25wmf23/includes/db/Database.php(1205): DatabaseBase->reportQueryError()
#1 /srv/mediawiki/php-1.25wmf23/includes/db/Database.php(2156): DatabaseBase->query()
#2 /srv/mediawiki/php-1.25wmf23/includes/db/LoadBalancer.php(1233): DatabaseBase->update()
#3 /srv/mediawiki/php-1.25wmf23/includes/deferred/SqlDataUpdate.php(147): DBConnRef->call()
#4 /srv/mediawiki/php-1.25wmf23/includes/deferred/LinksUpdate.php(297): SqlDataUpdate->invalidatePages()
#5 /srv/mediawiki/php-1.25wmf23/includes/deferred/LinksUpdate.php(166): LinksUpdate->invalidateImageDescriptions()
#6 /srv/mediawiki/php-1.25wmf23/includes/deferred/LinksUpdate.php(145): LinksUpdate->doIncrementalUpdate()
#7 /srv/mediawiki/php-1.25wmf23/includes/deferred/DataUpdate.php(101): LinksUpdate->doUpdate()
#8 /srv/mediawiki/php-1.25wmf23/includes/page/WikiPage.php(2201): DataUpdate::runUpdates()
#9 /srv/mediawiki/php-1.25wmf23/includes/page/WikiPage.php(1870): WikiPage->doEditUpdates()
#10 /srv/mediawiki/php-1.25wmf23/includes/page/Article.php(1991): WikiPage->doEditContent()
#11 /srv/mediawiki/php-1.25wmf23/includes/EditPage.php(1905): Article->
call()
#12 /srv/mediawiki/php-1.25wmf23/includes/EditPage.php(1298): EditPage->internalAttemptSave()
#13 /srv/mediawiki/php-1.25wmf23/includes/api/ApiEditPage.php(412): EditPage->attemptSave()
#14 /srv/mediawiki/php-1.25wmf23/includes/api/ApiMain.php(1037): ApiEditPage->execute()
#15 /srv/mediawiki/php-1.25wmf23/includes/api/ApiMain.php(394): ApiMain->executeAction()
#16 /srv/mediawiki/php-1.25wmf23/includes/api/ApiMain.php(367): ApiMain->executeActionWithErrorHandling()
#17 /srv/mediawiki/php-1.25wmf23/api.php(88): ApiMain->execute()
#18 /srv/mediawiki/w/api.php(3): include()
#19 {main}

Event Timeline

aaron raised the priority of this task from to Needs Triage.
aaron updated the task description. (Show Details)
aaron subscribed.

@aaron: Please assign projects to your tasks otherwise noone will find them.

Change 201729 had a related patch set uploaded (by Aaron Schulz):
Cut down on deadlocks in invalidatePages()

https://gerrit.wikimedia.org/r/201729

Change 201729 merged by jenkins-bot:
Cut down on deadlocks in invalidatePages()

https://gerrit.wikimedia.org/r/201729

aaron claimed this task.