contenttranslationlangtrend API fails with DBQueryError (Table 'wikishared.change_tag' doesn't exist from Translation::getDeletionTrend)
Closed, ResolvedPublicBUG REPORT
Actions

Description

List of steps to reproduce (step by step, including full links if applicable):

Access https://en.wikipedia.org/w/api.php?action=query&format=json&list=contenttranslationlangtrend&target=en

What happens?:

Response

{"error":{"code":"internal_api_error_DBQueryError","info":"[365014b2-91d4-4140-a888-7e7daac527b7] Caught exception of type Wikimedia\\Rdbms\\DBQueryError","errorclass":"Wikimedia\\Rdbms\\DBQueryError"},"servedby":"mw1374"}

Error 1146: Table 'wikishared.change_tag' doesn't exist (db1120)
Function: ContentTranslation\Translation::getDeletionTrend
Query: SELECT ar_timestamp, count(ar_page_id) as count FROM `change_tag`, `archive` WHERE ...

What should have happened instead?:

API should return data without errors

Details

	Subject	Repo	Branch	Lines +/-
	Fix: contenttranslationlangtrend API fails with Internal DBQueryError	mediawiki/extensions/ContentTranslation	master	+1 -2

Customize query in gerrit

Event Timeline

• santhosh created this task.Feb 28 2022, 4:41 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 28 2022, 4:41 AM

• santhosh triaged this task as High priority.Feb 28 2022, 4:42 AM

Full log example: https://logstash.wikimedia.org/app/discover#/doc/logstash-*/logstash-deploy-2022.02.28?id=GC6gPn8BxNOh7eZ4Sq0i

• santhosh changed the task status from Open to In Progress.Feb 28 2022, 4:51 AM

• santhosh moved this task from Quarter Backlog to In Progress on the Language-Team (Language-2022-January-March) board.

• santhosh claimed this task.Feb 28 2022, 5:00 AM

Change 766321 had a related patch set uploaded (by Santhosh; author: Santhosh):

[mediawiki/extensions/ContentTranslation@master] Fix: contenttranslationlangtrend API fails with Internal DBQueryError

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

gerritbot added a project: Patch-For-Review.Feb 28 2022, 5:00 AM

• santhosh moved this task from In Progress to In Review on the Language-Team (Language-2022-January-March) board.Feb 28 2022, 5:00 AM

Change 766321 merged by jenkins-bot:

[mediawiki/extensions/ContentTranslation@master] Fix: contenttranslationlangtrend API fails with Internal DBQueryError

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

• santhosh moved this task from In Review to Recheck after deployment on the Language-Team (Language-2022-January-March) board.Feb 28 2022, 8:41 AM

ReleaseTaggerBot added a project: MW-1.38-notes (1.38.0-wmf.24; 2022-02-28).Feb 28 2022, 9:00 AM

Maintenance_bot removed a project: Patch-For-Review.Feb 28 2022, 9:10 AM

Found in production as well. Glad to see a fix is already en-route.

Krinkle renamed this task from contenttranslationlangtrend API fails with Internal DBQueryError to contenttranslationlangtrend API fails with DBQueryError (Table 'wikishared.change_tag' doesn't exist fromContentTranslation\Translation::getDeletionTrend).Feb 28 2022, 3:07 PM

Krinkle renamed this task from contenttranslationlangtrend API fails with DBQueryError (Table 'wikishared.change_tag' doesn't exist fromContentTranslation\Translation::getDeletionTrend) to contenttranslationlangtrend API fails with DBQueryError (Table 'wikishared.change_tag' doesn't exist from Translation::getDeletionTrend).

QA note: https://test.wikipedia.org/wiki/Special:ContentTranslationStats should work as expected. Stats page was broken because of the API failure

Checked testwiki wmf.24 Special:ContentTranslationStats and enwiki wmf.24 Special:ContentTranslationStats.

Logstash doesn't show the error for wmf.24 - https://logstash.wikimedia.org/goto/cfdffe03d0de8914dc6305d0f6ce1328

Nikerabbit moved this task from Needs QA to Done on the Language-Team (Language-2022-January-March) board.Mar 4 2022, 8:44 AM

contenttranslationlangtrend API fails with DBQueryError (Table 'wikishared.change_tag' doesn't exist from Translation::getDeletionTrend)Closed, ResolvedPublicBUG REPORTActions

Description

Details

Event Timeline

contenttranslationlangtrend API fails with DBQueryError (Table 'wikishared.change_tag' doesn't exist from Translation::getDeletionTrend)
Closed, ResolvedPublicBUG REPORT
Actions