⚓ T194163 Drop change_tag.ct

Subject	Repo	Branch	Lines +/-
Drop $wgChangeTagsSchemaMigrationStage, part II	mediawiki/extensions/FlaggedRevs	master	+5 -19
Drop ct_tag column from change_tag table	mediawiki/core	master	+94 -30
Drop $wgChangeTagsSchemaMigrationStage	mediawiki/core	master	+115 -890
Drop $wgChangeTagsSchemaMigrationStage	mediawiki/extensions/ContentTranslation	master	+13 -24
Drop $wgChangeTagsSchemaMigrationStage	mediawiki/extensions/OAuth	master	+14 -26
Drop $wgChangeTagsSchemaMigrationStage	mediawiki/extensions/FlaggedRevs	master	+4 -40

Status	Assigned	Task
Resolved	Cenarium	T89553 Recent changes patrolling limited to tagged changes
Declined	None	T91425 ProblemChanges should only filter for tags indicating a 'problem'
Open	None	T134440 Add configuration settings for tags to allow more complex use cases (tracking)
Open	None	T95319 Add 'problem' status for tags
Resolved	Cenarium	T73236 Automatically tag edits that make a redirect, or convert a redirected page to a normal page, or move a page across namespaces, etc.
Resolved	None	T105189 [Bug] Wikidata action=query&list=tags should not take 15-25 seconds to respond
Resolved	Ladsgroup	T91535 Performance issues with tags
Resolved	Ladsgroup	T185355 Normalize change tag schema
Resolved	Ladsgroup	T194163 Drop change_tag.ct_tag column
Resolved	Marostegui	T210713 Drop change_tag.ct_tag column in production
Resolved	Marostegui	T234800 Switchover s1 primary database master db1067 -> db1083 - 14th Nov 06:00 - 06:30 UTC
Resolved	Trizek-WMF	T234801 Community Relations support needed for a read-only window for s1 (enwiki)

Lucas_Werkmeister_WMDE created this task.May 8 2018, 2:21 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 8 2018, 2:21 PM

Lucas_Werkmeister_WMDE mentioned this in T185355: Normalize change tag schema.May 8 2018, 2:27 PM

Lucas_Werkmeister_WMDE added a project: Wikidata-Campsite.Jun 5 2018, 1:35 PM

• Vvjjkkii renamed this task from Drop change_tag.ct_tag column to wddaaaaaaa.Jul 1 2018, 1:11 AM

• Vvjjkkii triaged this task as High priority.

• Vvjjkkii added projects: CheckUser, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), Tamil-Sites, Gamepress, Hashtags, Jade, KartoEditor, Language-2018-Apr-June, New-Editor-Experiences, Mail, TCB-Team (now WMDE-TechWish).

• Vvjjkkii updated the task description. (Show Details)

• Vvjjkkii removed a subscriber: Aklapper.

CommunityTechBot renamed this task from wddaaaaaaa to Drop change_tag.ct_tag column.Jul 1 2018, 3:32 PM

CommunityTechBot raised the priority of this task from High to Needs Triage.

CommunityTechBot updated the task description. (Show Details)

CommunityTechBot removed projects: TCB-Team (now WMDE-TechWish), Mail, New-Editor-Experiences, Language-2018-Apr-June, KartoEditor, Jade, Hashtags, Gamepress, Tamil-Sites, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), CheckUser.

CommunityTechBot added a subscriber: Aklapper.

Krinkle moved this task from Untriaged to Schema changes on the MediaWiki-libs-Rdbms board.Jul 28 2018, 10:39 PM

Ladsgroup claimed this task.Nov 14 2018, 6:27 PM

Ladsgroup edited projects, added Wikidata-Campsite (Wikidata-Campsite-Iteration-∞ (On Hold)); removed Wikidata-Campsite, Wikidata-Ministry-Of-Magic-Tech-Debt, Wikidata-Ministry-Of-Magic.

Restricted Application added a project: User-Ladsgroup. · View Herald TranscriptNov 14 2018, 6:27 PM

Ladsgroup moved this task from To Do (prioritised from top to bottom) to Doing on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞ (On Hold)) board.Nov 14 2018, 6:27 PM

Change 473601 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Drop ct_tag column from change_tag table

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

gerritbot added a project: Patch-For-Review.Nov 14 2018, 8:20 PM

Ladsgroup moved this task from Doing to Peer Review on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞ (On Hold)) board.Nov 14 2018, 8:20 PM

Change 473629 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/core@master] Drop $wgChangeTagsSchemaMigrationStage

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

Addshore triaged this task as Medium priority.Nov 15 2018, 11:04 AM

Change 473743 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/extensions/OAuth@master] Drop $wgChangeTagsSchemaMigrationStage

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

Change 473744 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/extensions/FlaggedRevs@master] Drop $wgChangeTagsSchemaMigrationStage

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

Change 473745 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/extensions/ContentTranslation@master] Drop $wgChangeTagsSchemaMigrationStage

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

Change 473744 merged by jenkins-bot:
[mediawiki/extensions/FlaggedRevs@master] Drop $wgChangeTagsSchemaMigrationStage

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

Change 473743 merged by jenkins-bot:
[mediawiki/extensions/OAuth@master] Drop $wgChangeTagsSchemaMigrationStage

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

ReleaseTaggerBot added a project: MW-1.33-notes (1.33.0-wmf.6; 2018-11-27).Nov 15 2018, 6:00 PM

Change 473745 merged by jenkins-bot:
[mediawiki/extensions/ContentTranslation@master] Drop $wgChangeTagsSchemaMigrationStage

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

Change 473629 merged by jenkins-bot:
[mediawiki/core@master] Drop $wgChangeTagsSchemaMigrationStage

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

Change 473601 merged by jenkins-bot:
[mediawiki/core@master] Drop ct_tag column from change_tag table

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

ReleaseTaggerBot edited projects, added MW-1.33-notes (1.33.0-wmf.8; 2018-12-11); removed MW-1.33-notes (1.33.0-wmf.6; 2018-11-27).Nov 29 2018, 12:01 AM

Ladsgroup moved this task from Peer Review to Doing on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞ (On Hold)) board.Nov 29 2018, 10:25 AM

Change 476470 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/extensions/FlaggedRevs@master] Drop $wgChangeTagsSchemaMigrationStage, part II

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

Change 476470 merged by jenkins-bot:
[mediawiki/extensions/FlaggedRevs@master] Drop $wgChangeTagsSchemaMigrationStage, part II

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

Beta cluster:

MariaDB [enwiki]> select * from change_tag limit 5;
+-------+----------+-----------+-----------+-----------+-----------+
| ct_id | ct_rc_id | ct_log_id | ct_rev_id | ct_params | ct_tag_id |
+-------+----------+-----------+-----------+-----------+-----------+
|     1 |    14356 |      2444 |      NULL | NULL      |        15 |
|     2 |    14360 |      2446 |      NULL | NULL      |        15 |
|     3 |    14768 |      2731 |      NULL | NULL      |        15 |
|     4 |    14961 |      2868 |      NULL | NULL      |        15 |
|     5 |    15072 |      2936 |      NULL | NULL      |        15 |
+-------+----------+-----------+-----------+-----------+-----------+
5 rows in set (0.00 sec)

Marostegui changed the status of subtask T210713: Drop change_tag.ct_tag column in production from Open to Stalled.Feb 26 2019, 8:02 AM

• Petar.petkovic removed a project: Patch-For-Review.May 21 2019, 2:48 PM

DannyS712 changed the status of subtask T210713: Drop change_tag.ct_tag column in production from Stalled to Open.Nov 14 2019, 6:41 AM

Restricted Application added a project: Wikidata. · View Herald TranscriptNov 14 2019, 6:41 AM

Maintenance_bot moved this task from incoming to in progress on the Wikidata board.Nov 14 2019, 7:15 AM

Maintenance_bot moved this task from Incoming to In progress on the User-Ladsgroup board.

Maintenance_bot moved this task from In progress to Done on the User-Ladsgroup board.

Marostegui closed subtask T210713: Drop change_tag.ct_tag column in production as Resolved.Nov 14 2019, 8:02 AM