Page MenuHomePhabricator

Enable revert risk filters for first batch of wikis: < 1000 monthly edits
Open, Stalled, MediumPublic5 Estimated Story Points

Description

Description
In order to manage the rollout of the revert risk filters, we're splitting the wikis identified in P84306 into batches. The wikis have been batched by their edit counts to ensure that we begin with wikis that have fewer edit counts and work our way up to those with higher monthly edit counts where the script is bound to take longer.

Acceptance Criteria

  • ORES tables are created

Note that we can create all tables for all wikis at once and should coordinate with an SRE to complete this step as part of this ticket.

  • Extension is turned on at those wikis
  • Backfill scripts are ran for all wikis in the batch without breaking.

Note that you may need to run the backfill script multiple times per wiki to pre-populate enough data for the UI.

  • Verify that the revert risk scores are populated successfully in those wikis.

Batch One Wikis

wiki namemonthly active editorsmonthly nonbot editsdatabase codeores installed?
Tahitian Wikipedia010tywikino
Sango Wikipedia012sgwikino
Pali Wikipedia116piwikino
Kikuyu Wikipedia016kiwikino
Ewe Wikipedia017eewikino
Zhuang Wikipedia017zawikino
Chamorro Wikipedia018chwikino
Inupiaq Wikipedia021ikwikino
Dzongkha Wikipedia122dzwikino
Novial Wikipedia123novwikino
Sranan Tongo Wikipedia123srnwikino
Jamaican Patois Wikipedia123jamwikino
Cheyenne Wikipedia025chywikino
Pontic Wikipedia126pntwikino
Rundi Wikipedia030rnwikino
Kongo Wikipedia131kgwikino
Fulah Wikipedia132ffwikino
Bislama Wikipedia133biwikino
Tongan Wikipedia133towikino
Buryat Wikipedia135bxrwikino
Kabiyè Wikipedia135kbpwikino
Ganda Wikipedia136lgwikino
Venda Wikipedia136vewikino
Karachay-Balkar Wikipedia136krcwikino
Swati Wikipedia137sswikino
Tok Pisin Wikipedia137tpiwikino
Romani Wikipedia139rmywikino
Buginese Wikipedia142bugwikino
Kabardian Wikipedia147kbdwikino
Bambara Wikipedia049bmwikino
Colognian Wikipedia150kshwikino
Ladino Wikipedia252ladwikino
Gan Chinese Wikipedia153ganwikino
Zeelandic Wikipedia155zeawikino
Nauru Wikipedia156nawikino
Gagauz Wikipedia157gagwikino
Manx Wikipedia158gvwikino
Tumbuka Wikipedia158tumwikino
Kalmyk Wikipedia159xalwikino
Lingala Wikipedia265lnwikino
Inuktitut Wikipedia165iuwikino
Northern Sotho Wikipedia168nsowikino
Norfuk / Pitkern Wikipedia168pihwikino
Dinka Wikipedia271dinwikino
Saterland Frisian Wikipedia171stqwikino
Aymara Wikipedia276aywikino
Tsonga Wikipedia177tswikino
Mirandese Wikipedia278mwlwikino
Latgalian Wikipedia179ltgwikino
Min Dong Chinese Wikipedia281cdowikino
Laki Wikipedia084lbewikino
Tibetan Wikipedia287bowikino
Twi Wikipedia189twwikino
Xhosa Wikipedia291xhwikino
Kara-Kalpak Wikipedia291kaawikino
Komi-Permyak Wikipedia091koiwikino
Adyghe Wikipedia192adywikino
Tetum Wikipedia195tetwikino
Kashubian Wikipedia296csbwikino
Pennsylvania German Wikipedia297pdcwikino
Aramaic Wikipedia299arcwikino
Kalaallisut Wikipedia199klwikino
Aromanian Wikipedia199roa_rupwikino
Basa Banyumasan Wikipedia199map_bmswikino
Friulian Wikipedia2103furwikino
Cherokee Wikipedia1103chrwikino
Moksha Wikipedia1104mdfwikino
Maori Wikipedia2108miwikino
Southern Sotho Wikipedia1108stwikino
Church Slavic Wikipedia2109cuwikino
Lojban Wikipedia1109jbowikino
Nāhuatl Wikipedia1110nahwikino
Wolof Wikipedia2113wowikino
Kashmiri Wikipedia1113kswikino
Palatine German Wikipedia2120pflwikino
Atikamekw Wikipedia3124atjwikino
Cree Wikipedia2124crwikino
Tswana Wikipedia1125tnwikino
Neapolitan Wikipedia3126napwikino
Guianan Creole Wikipedia1128gcrwikino
Samogitian Wikipedia4129bat_smgwikino
Bishnupriya Wikipedia3131bpywikino
Võro Wikipedia3136fiu_vrowikino
Tigrinya Wikipedia2140tiwikino
Samoan Wikipedia1140smwikino
Newari Wikipedia1143newwikino
Nyanja Wikipedia2145nywikino
Divehi Wikipedia1146dvwikino
Komi Wikipedia2150kvwikino
Oromo Wikipedia1158omwikino
Gilaki Wikipedia3161glkwikino
Romansh Wikipedia3163rmwikino
Extremaduran Wikipedia2168extwikino
Gothic Wikipedia1170gotwikino
Udmurt Wikipedia3171udmwikino
Tarandíne Wikipedia2179roa_tarawikino
Kinyarwanda Wikipedia3180rwwikino
Picard Wikipedia5181pcdwikino
Fijian Wikipedia1188fjwikino
West Flemish Wikipedia3198vlswikino
Sicilian Wikipedia4199scnwikino
Livvi-Karelian Wikipedia4208olowikino
Western Mari Wikipedia1209mrjwikino
N'Ko Wikipedia5212nqowikino
Avaric Wikipedia2226avwikino
Lower Sorbian Wikipedia3228dsbwikino
Igbo Wikipedia5235igwikino
Mazanderani Wikipedia5241mznwikino
Amharic Wikipedia4247amwikino
Hakka Chinese Wikipedia2265hakwikino
Old English Wikipedia3284angwikino
Akan Wikipedia3285akwikino
Lingua Franca Nova Wikipedia4288lfnwikino
Eastern Mari Wikipedia3289mhrwikino
Lezghian Wikipedia4290lezwikino
Banjar Wikipedia4299bjnwikino
Scottish Gaelic Wikipedia5301gdwikino
Hawaiian Wikipedia3304hawwikino
Piedmontese Wikipedia5306pmswikino
Uyghur Wikipedia4306ugwikino
Silesian Wikipedia4306szlwikino
Northern Sami Wikipedia4317sewikino
Turkmen Wikipedia6331tkwikino
Lao Wikipedia6343lowikino
Papiamento Wikipedia3353papwikino
Corsican Wikipedia5371cowikino
Quechua Wikipedia6384quwikino
Pangasinan Wikipedia1385pagwikino
Faroese Wikipedia6403fowikino
Guarani Wikipedia3414gnwikino
Maithili Wikipedia6418maiwikino
Nouormand Wikipedia2422nrmwikino
Low Saxon Wikipedia6451nds_nlwikino
Upper Sorbian Wikipedia3452hsbwikino
Maltese Wikipedia8463mtwikino
Mingrelian Wikipedia5463xmfwikino
Achinese Wikipedia5494acewikino
Fiji Hindi Wikipedia3539hifwikino
Sardinian Wikipedia7545scwikino
Limburgish Wikipedia6547liwikino
Arpitan Wikipedia4577frpwikino
Chavacano de Zamboanga Wikipedia2591cbk_zamwikino
Cornish Wikipedia5595kwwikino
Crimean Tatar Wikipedia6602crhwikino
Rusyn Wikipedia4606ruewikino
Shan Wikipedia3607shnwikino
Ossetic Wikipedia5616oswikino
Goan Konkani Wikipedia3636gomwikino
Tuvinian Wikipedia5642tyvwikino
Ingush Wikipedia3643inhwikino
Sanskrit Wikipedia6656sawikino
Emiliano-Romagnolo Wikipedia4670emlwikino
Interlingue Wikipedia6690iewikino
Ladin Wikipedia4690lldwikino
Sundanese Wikipedia12722suwikino
Kabyle Wikipedia4749kabwikino
Erzya Wikipedia5755myvwikino
Sakizaya Wikipedia8801szywikino
Somali Wikipedia15812sowikino
Pampanga Wikipedia2824pamwikino
Zulu Wikipedia4835zuwikino
Min Nan Wikipedia13857zh_min_nanwikino
Tulu Wikipedia9892tcywikino
Ido Wikipedia6907iowikino
Mon Wikipedia6937mnwwikino
Yoruba Wikipedia11962yowikino

Event Timeline

Restricted Application added subscribers: jhsoby-WMNO, Stang, Aklapper. · View Herald Transcript
DMburugu renamed this task from Run the backfill scripts for first batch of wikis: < 1000 monthly edits to Enable revert risk filters for first batch of wikis: < 1000 monthly edits.Dec 5 2025, 2:08 PM
DMburugu updated the task description. (Show Details)
Kgraessle set the point value for this task to 5.Dec 9 2025, 3:16 PM
Kgraessle moved this task from To be estimated to Estimated on the Moderator-Tools-Team board.
Samwalton9-WMF moved this task from Estimated to Kanban on the Moderator-Tools-Team board.

@Ladsgroup

When is a good time to create all the ORES database tables for the following wikis?

tywiki
sgwiki
piwiki
kiwiki
eewiki
zawiki
chwiki
ikwiki
dzwiki
novwiki
srnwiki
jamwiki
chywiki
pntwiki
rnwiki
kgwiki
ffwiki
biwiki
towiki
bxrwiki
kbpwiki
lgwiki
vewiki
krcwiki
sswiki
tpiwiki
rmywiki
bugwiki
kbdwiki
bmwiki
kshwiki
ladwiki
ganwiki
zeawiki
nawiki
gagwiki
gvwiki
tumwiki
xalwiki
lnwiki
iuwiki
nsowiki
pihwiki
dinwiki
stqwiki
aywiki
tswiki
mwlwiki
ltgwiki
cdowiki
lbewiki
bowiki
twwiki
xhwiki
kaawiki
koiwiki
adywiki
tetwiki
csbwiki
pdcwiki
arcwiki
klwiki
roa_rupwiki
map_bmswiki
furwiki
chrwiki
mdfwiki
miwiki
stwiki
cuwiki
jbowiki
nahwiki
wowiki
kswiki
pflwiki
atjwiki
crwiki
tnwiki
napwiki
gcrwiki
bat_smgwiki
bpywiki
fiu_vrowiki
tiwiki
smwiki
newwiki
nywiki
dvwiki
kvwiki
omwiki
glkwiki
rmwiki
extwiki
gotwiki
udmwiki
roa_tarawiki
rwwiki
pcdwiki
fjwiki
vlswiki
scnwiki
olowiki
mrjwiki
nqowiki
avwiki
dsbwiki
igwiki
mznwiki
amwiki
hakwiki
angwiki
akwiki
lfnwiki
mhrwiki
lezwiki
bjnwiki
gdwiki
hawwiki
pmswiki
ugwiki
szlwiki
sewiki
tkwiki
lowiki
papwiki
cowiki
quwiki
pagwiki
fowiki
gnwiki
maiwiki
nrmwiki
nds_nlwiki
hsbwiki
mtwiki
xmfwiki
acewiki
hifwiki
scwiki
liwiki
frpwiki
cbk_zamwiki
kwwiki
crhwiki
ruewiki
shnwiki
oswiki
gomwiki
tyvwiki
inhwiki
sawiki
emlwiki
iewiki
lldwiki
suwiki
kabwiki
myvwiki
szywiki
sowiki
pamwiki
zuwiki
zh_min_nanwiki
tcywiki
iowiki
mnwwiki
yowiki
vowiki
wawiki
iawiki
sahwiki
kmwiki
snwiki
awawiki
bclwiki
bhwiki
kywiki
warwiki
pswiki
vepwiki
zh_classicalwiki
abwiki
htwiki
mgwiki
barwiki
yiwiki
lrcwiki
ilowiki
azbwiki
frrwiki
gorwiki
lijwiki
hywwiki
cebwiki
wuuwiki
siwiki
lmowiki
orwiki
cvwiki
jvwiki
arywiki
pnbwiki
guwiki
banwiki
satwiki
anwiki
alswiki
brwiki
minwiki
sdwiki
gawiki
aswiki
nvwiki
avkwiki
mnwiki
cewiki
ttwiki
fywiki
mywiki
knwiki
lbwiki
kuwiki
be_x_oldwiki
newiki
ckbwiki
diqwiki
scowiki
ndswiki
bawiki
sqwiki
vecwiki
uzwiki
ocwiki
shwiki
astwiki
tgwiki
tawiki
urwiki
slwiki
zh_yuewiki
skwiki
ltwiki
eowiki
glwiki
hrwiki
mswiki
kawiki
euwiki
dawiki
bgwiki
hiwiki
thwiki
elwiki
nowiki
hywiki
arzwiki
viwiki
dewiki
jawiki
Kgraessle changed the task status from Open to Stalled.Jan 30 2026, 8:44 PM
Kgraessle added a subscriber: Samwalton9-WMF.

@Samwalton9-WMF

Not sure if we have discussed the thresholds for these smaller wikis. I don't think it makes sense to do any kind of threshold analysis, but perhaps we can just pick a default of 0.85 to begin with?

@Samwalton9-WMF

Not sure if we have discussed the thresholds for these smaller wikis. I don't think it makes sense to do any kind of threshold analysis, but perhaps we can just pick a default of 0.85 to begin with?

That makes sense to me!

Dillon changed the task status from Stalled to In Progress.Feb 5 2026, 5:38 PM

Go for it.

Thanks!
Does this mean we're good to create the tables anytime? I don't need to schedule a specific time block to do it?

You don't need a specific time for it. Just let us know before so we can keep an eye on replication and co.

@Ladsgroup ok sounds great, how does 18:00 UTC tomorrow February 18th sound?

Change #1240672 had a related patch set uploaded (by Kgraessle; author: Kgraessle):

[operations/mediawiki-config@master] Enable revert risk filters for first batch of wikis: < 1000 monthly edits

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

patch 1240672 looks good and needs to be scheduled for backport; maybe @Kgraessle can run that in one of the earlier upcoming backport slots?

Scheduled a backport for these changes for Monday 9am UTC.

Change #1240672 merged by jenkins-bot:

[operations/mediawiki-config@master] Enable revert risk filters for first batch of wikis: < 1000 monthly edits

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

Mentioned in SAL (#wikimedia-operations) [2026-03-02T08:07:20Z] <kgraessle@deploy2002> Started scap sync-world: Backport for [[gerrit:1240672|Enable revert risk filters for first batch of wikis: < 1000 monthly edits (T411485)]]

Mentioned in SAL (#wikimedia-operations) [2026-03-02T08:30:37Z] <kgraessle@deploy2002> kgraessle: Backport for [[gerrit:1240672|Enable revert risk filters for first batch of wikis: < 1000 monthly edits (T411485)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-03-02T08:44:32Z] <kgraessle@deploy2002> Finished scap sync-world: Backport for [[gerrit:1240672|Enable revert risk filters for first batch of wikis: < 1000 monthly edits (T411485)]] (duration: 37m 12s)

Change #1247065 had a related patch set uploaded (by Kgraessle; author: Kgraessle):

[operations/mediawiki-config@master] Enable revert risk filters for first batch of wikis: < 1000 monthly edits

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

Kgraessle changed the task status from In Progress to Stalled.Mar 17 2026, 4:41 PM

Moving the deployment out a week so that we can focus on the enwiki silent rollout for PersonalDashboard this week.

Kgraessle changed the task status from Stalled to Open.Mar 25 2026, 12:06 PM
Kgraessle changed the task status from Open to Stalled.Mar 30 2026, 3:11 PM

Stalling this while we figure out an automated testing strategy for the team.