Page MenuHomePhabricator

Undeploy FlaggedRevs from Wikinews and drop FlaggedRevs tables
Closed, ResolvedPublic

Description

FlaggedRevs will be useless once Wikinews is closed.

Event Timeline

Change #1281506 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/mediawiki-config@master] Disable FlaggedRevs on wikinews

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

Deleting tables is considered (as title suggest)?

We’ll definitely check to see if they’re still needed. And yes, if it turns out they’re not needed, we’ll drop them.

In s3, the flaggedrevs tables were around 3GB in total. Not large but not non-negligible either. I don't think FR has any table that'd be useful afterwards, we dropped it for frwiki years ago.

Change #1284683 had a related patch set uploaded (by Ladsgroup; author: Ladsgroup):

[operations/mediawiki-config@master] Disable FR on wikinews wikis

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

Change #1281506 merged by jenkins-bot:

[operations/mediawiki-config@master] Disable FlaggedRevs on wikinews

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

Mentioned in SAL (#wikimedia-operations) [2026-05-11T16:20:26Z] <zabe@deploy1003> Started scap sync-world: Backport for [[gerrit:1281506|Disable FlaggedRevs on wikinews (T423577)]]

Mentioned in SAL (#wikimedia-operations) [2026-05-11T16:22:07Z] <zabe@deploy1003> zabe: Backport for [[gerrit:1281506|Disable FlaggedRevs on wikinews (T423577)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-05-11T16:27:20Z] <zabe@deploy1003> Finished scap sync-world: Backport for [[gerrit:1281506|Disable FlaggedRevs on wikinews (T423577)]] (duration: 06m 54s)

Change #1284683 abandoned by Ladsgroup:

[operations/mediawiki-config@master] Disable FR on wikinews wikis

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

These tables need to be dropped:

table exists where it should not: flaggedpage_config cawikinews
table exists where it should not: flaggedpages cawikinews
table exists where it should not: flaggedrevs cawikinews
table exists where it should not: flaggedrevs_promote cawikinews
table exists where it should not: flaggedrevs_statistics cawikinews
table exists where it should not: flaggedpage_config elwikinews
table exists where it should not: flaggedpages elwikinews
table exists where it should not: flaggedrevs elwikinews
table exists where it should not: flaggedrevs_promote elwikinews
table exists where it should not: flaggedrevs_statistics elwikinews
table exists where it should not: flaggedpage_config enwikinews
table exists where it should not: flaggedpages enwikinews
table exists where it should not: flaggedrevs enwikinews
table exists where it should not: flaggedrevs_promote enwikinews
table exists where it should not: flaggedrevs_statistics enwikinews
table exists where it should not: flaggedpage_config eswikinews
table exists where it should not: flaggedpages eswikinews
table exists where it should not: flaggedrevs eswikinews
table exists where it should not: flaggedrevs_promote eswikinews
table exists where it should not: flaggedrevs_statistics eswikinews
table exists where it should not: flaggedpage_config fawikinews
table exists where it should not: flaggedpages fawikinews
table exists where it should not: flaggedrevs fawikinews
table exists where it should not: flaggedrevs_promote fawikinews
table exists where it should not: flaggedrevs_statistics fawikinews
table exists where it should not: flaggedpage_config frwikinews
table exists where it should not: flaggedpages frwikinews
table exists where it should not: flaggedrevs frwikinews
table exists where it should not: flaggedrevs_promote frwikinews
table exists where it should not: flaggedrevs_statistics frwikinews
table exists where it should not: flaggedpage_config ptwikinews
table exists where it should not: flaggedpages ptwikinews
table exists where it should not: flaggedrevs ptwikinews
table exists where it should not: flaggedrevs_promote ptwikinews
table exists where it should not: flaggedrevs_statistics ptwikinews
table exists where it should not: flaggedpage_config ruwikinews
table exists where it should not: flaggedpages ruwikinews
table exists where it should not: flaggedrevs ruwikinews
table exists where it should not: flaggedrevs_promote ruwikinews
table exists where it should not: flaggedrevs_statistics ruwikinews
table exists where it should not: flaggedpage_config tawikinews
table exists where it should not: flaggedpages tawikinews
table exists where it should not: flaggedrevs tawikinews
table exists where it should not: flaggedrevs_promote tawikinews
table exists where it should not: flaggedrevs_statistics tawikinews

Mentioned in SAL (#wikimedia-operations) [2026-05-26T13:53:22Z] <Amir1> drop flaggedrevs tables on cawikinews (T423577)

I wait until next week and then drop the rest tables.

Mentioned in SAL (#wikimedia-operations) [2026-06-01T16:58:13Z] <Amir1> drop flaggedrevs tables on wikinews wikis (T423577)

Ladsgroup added a project: DBA.
Ladsgroup moved this task from Triage to Done on the DBA board.