Frequent DB writes on HTTP GET from PageTriage
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	aaron
	Dec 10 2016, 7:10 PM

Description

Expectation (writes <= 0) by MediaWiki::main not met:
query-m: REPLACE INTO `pagetriage_page_tags` (ptrpt_page_id,ptrpt_tag_id,ptrpt_value) VALUES ('X') [TRX#9f2762]
#0 /srv/mediawiki/php-1.29.0-wmf.5/includes/libs/rdbms/TransactionProfiler.php(215): TransactionProfiler->reportExpectationViolated()
#1 /srv/mediawiki/php-1.29.0-wmf.5/includes/libs/rdbms/database/Database.php(959): TransactionProfiler->recordQueryCompletion()
#2 /srv/mediawiki/php-1.29.0-wmf.5/includes/libs/rdbms/database/Database.php(870): Database->doProfiledQuery()
#3 /srv/mediawiki/php-1.29.0-wmf.5/includes/libs/rdbms/database/Database.php(2148): Database->query()
#4 /srv/mediawiki/php-1.29.0-wmf.5/includes/libs/rdbms/database/DatabaseMysqlBase.php(486): Database->nativeReplace()
#5 /srv/mediawiki/php-1.29.0-wmf.5/extensions/PageTriage/includes/ArticleMetadata.php(502): DatabaseMysqlBase->replace()
#6 /srv/mediawiki/php-1.29.0-wmf.5/extensions/PageTriage/includes/ArticleMetadata.php(393): ArticleCompileProcessor->save()
#7 /srv/mediawiki/php-1.29.0-wmf.5/extensions/PageTriage/includes/ArticleMetadata.php(180): ArticleCompileProcessor->compileMetadata()
#8 /srv/mediawiki/php-1.29.0-wmf.5/extensions/PageTriage/PageTriage.hooks.php(333): ArticleMetadata->getMetadata()
#9 /srv/mediawiki/php-1.29.0-wmf.5/extensions/PageTriage/PageTriage.hooks.php(313): PageTriageHooks::isArticleNew()
#10 /srv/mediawiki/php-1.29.0-wmf.5/extensions/PageTriage/PageTriage.hooks.php(378): PageTriageHooks::shouldShowNoIndex()
#11 /srv/mediawiki/php-1.29.0-wmf.5/includes/Hooks.php(195): PageTriageHooks::onArticleViewFooter()
#12 /srv/mediawiki/php-1.29.0-wmf.5/includes/page/Article.php(987): Hooks::run()
#13 /srv/mediawiki/php-1.29.0-wmf.5/includes/page/Article.php(706): Article->showViewFooter()
#14 /srv/mediawiki/php-1.29.0-wmf.5/includes/actions/ViewAction.php(71): Article->view()
#15 /srv/mediawiki/php-1.29.0-wmf.5/includes/MediaWiki.php(495): ViewAction->show()
#16 /srv/mediawiki/php-1.29.0-wmf.5/includes/MediaWiki.php(289): MediaWiki->performAction()
#17 /srv/mediawiki/php-1.29.0-wmf.5/includes/MediaWiki.php(851): MediaWiki->performRequest()
#18 /srv/mediawiki/php-1.29.0-wmf.5/includes/MediaWiki.php(512): MediaWiki->main()
#19 /srv/mediawiki/php-1.29.0-wmf.5/index.php(43): MediaWiki->run()
#20 /srv/mediawiki/w/index.php(3): include()
#21 {main}

Details

	Subject	Repo	Branch	Lines +/-
	Defer secondary page metadata backfill DB writes	mediawiki/extensions/PageTriage	master	+15 -3

Customize query in gerrit

Related Objects

Mentioned In: T152851: TMH should not make DB writes on HTTP GET for its on-the-fly transcode corrections

Event Timeline

aaron created this task.Dec 10 2016, 7:10 PM

Restricted Application added a project: Collaboration-Team-Triage. · View Herald TranscriptDec 10 2016, 7:10 PM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Change 326279 had a related patch set uploaded (by Aaron Schulz):
Defer secondary page metadata backfill DB writes

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

gerritbot added a project: Patch-For-Review.Dec 10 2016, 7:28 PM

Catrope closed this task as Resolved.Dec 11 2016, 1:58 AM

Catrope claimed this task.

Change 326279 merged by jenkins-bot:
Defer secondary page metadata backfill DB writes

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

ReleaseTaggerBot added a project: MW-1.29-release (WMF-deploy-2016-12-13_(1.29.0-wmf.6)).Dec 11 2016, 2:00 AM

Catrope reassigned this task from Catrope to aaron.Dec 11 2016, 6:03 AM

Catrope subscribed.

According to a comment, this should be rare. I wonder if there is another bug present here.

Quiddity mentioned this in T152851: TMH should not make DB writes on HTTP GET for its on-the-fly transcode corrections.Aug 24 2017, 1:58 AM

Frequent DB writes on HTTP GET from PageTriageClosed, ResolvedPublicActions

Description

Details

Related Objects

Event Timeline

Frequent DB writes on HTTP GET from PageTriage
Closed, ResolvedPublic
Actions