Page MenuHomePhabricator
Create Task
Maniphest T434688

Create maintenance script to evaluate revisions performed between timestamps against content policies
Closed, ResolvedPublic
Actions

Description

Summary

We want to backfill entries in Special:AbuseReview by evaluating revisions between specified timestamps

Acceptance criteria

  • A maintenance script exists to backfill entries into Special:AbuseReview between specified timestamps

Details

Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
Follow-up: Improve performance of DB query in BackfillAbuseReview.phpDreamy Jazzmediawiki/extensions/WikimediaAntiAbusemaster+55 -9
Improve performance of DB query in BackfillAbuseReview.phpDreamy Jazzmediawiki/extensions/WikimediaAntiAbusewmf/1.47.0-wmf.15+23 -17
Improve performance of DB query in BackfillAbuseReview.phpDreamy Jazzmediawiki/extensions/WikimediaAntiAbusewmf/1.47.0-wmf.14+23 -17
Improve performance of DB query in BackfillAbuseReview.phpDreamy Jazzmediawiki/extensions/WikimediaAntiAbusemaster+23 -17
Create a maintenance script to backfill Special:AbuseReviewDreamy Jazzmediawiki/extensions/WikimediaAntiAbusewmf/1.47.0-wmf.14+278 -0
Create a maintenance script to backfill Special:AbuseReviewDreamy Jazzmediawiki/extensions/WikimediaAntiAbusewmf/1.47.0-wmf.15+278 -0
Create a maintenance script to backfill Special:AbuseReviewDreamy Jazzmediawiki/extensions/WikimediaAntiAbusemaster+278 -0
Customize query in gerrit

Event Timeline

Dreamy_Jazz created this task.Wed, Aug 12, 3:59 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptWed, Aug 12, 3:59 PM
Dreamy_Jazz claimed this task.Wed, Aug 12, 3:59 PM
Dreamy_Jazz edited projects, added: Product Safety and Integrity (Sprint Sunflower (Aug 11 - Aug 28)); removed: Product Safety and Integrity.
Dreamy_Jazz moved this task from Backlog to In progress on the Product Safety and Integrity (Sprint Sunflower (Aug 11 - Aug 28)) board.
gerritbot added a comment.Wed, Aug 12, 5:39 PM

Change #1324779 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/WikimediaAntiAbuse@master] Create a maintenance script to backfill Special:AbuseReview

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

gerritbot added a project: Patch-For-Review.Wed, Aug 12, 5:39 PM
gerritbot added a comment.Wed, Aug 12, 8:44 PM

Change #1324779 merged by jenkins-bot:

[mediawiki/extensions/WikimediaAntiAbuse@master] Create a maintenance script to backfill Special:AbuseReview

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

ReleaseTaggerBot added a project: MW-1.47-notes (1.47.0-wmf.16; 2026-08-18).Wed, Aug 12, 9:00 PM
gerritbot added a comment.Wed, Aug 12, 9:30 PM

Change #1324817 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/WikimediaAntiAbuse@wmf/1.47.0-wmf.15] Create a maintenance script to backfill Special:AbuseReview

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

gerritbot added a comment.Wed, Aug 12, 9:31 PM

Change #1324818 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/WikimediaAntiAbuse@wmf/1.47.0-wmf.14] Create a maintenance script to backfill Special:AbuseReview

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

gerritbot added a comment.Wed, Aug 12, 9:35 PM

Change #1324817 merged by jenkins-bot:

[mediawiki/extensions/WikimediaAntiAbuse@wmf/1.47.0-wmf.15] Create a maintenance script to backfill Special:AbuseReview

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

gerritbot added a comment.Wed, Aug 12, 9:36 PM

Change #1324818 merged by jenkins-bot:

[mediawiki/extensions/WikimediaAntiAbuse@wmf/1.47.0-wmf.14] Create a maintenance script to backfill Special:AbuseReview

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

Stashbot added a comment.Wed, Aug 12, 9:36 PM

Mentioned in SAL (#wikimedia-operations) [2026-08-12T21:36:27Z] <dreamyjazz@deploy1003> Started scap sync-world: Backport for [[gerrit:1324817|Create a maintenance script to backfill Special:AbuseReview (T434688)]], [[gerrit:1324818|Create a maintenance script to backfill Special:AbuseReview (T434688)]]

Stashbot added a comment.Wed, Aug 12, 9:40 PM

Mentioned in SAL (#wikimedia-operations) [2026-08-12T21:40:29Z] <dreamyjazz@deploy1003> dreamyjazz: Backport for [[gerrit:1324817|Create a maintenance script to backfill Special:AbuseReview (T434688)]], [[gerrit:1324818|Create a maintenance script to backfill Special:AbuseReview (T434688)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

ReleaseTaggerBot edited projects, added: MW-1.47-notes (1.47.0-wmf.15; 2026-08-11); removed: MW-1.47-notes (1.47.0-wmf.16; 2026-08-18).Wed, Aug 12, 10:00 PM
Stashbot added a comment.Wed, Aug 12, 10:21 PM

Mentioned in SAL (#wikimedia-operations) [2026-08-12T22:21:56Z] <dreamyjazz@deploy1003> Finished scap sync-world: Backport for [[gerrit:1324817|Create a maintenance script to backfill Special:AbuseReview (T434688)]], [[gerrit:1324818|Create a maintenance script to backfill Special:AbuseReview (T434688)]] (duration: 45m 29s)

Maintenance_bot removed a project: Patch-For-Review.Wed, Aug 12, 10:31 PM
gerritbot added a comment.Wed, Aug 12, 11:37 PM

Change #1324831 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/WikimediaAntiAbuse@master] Improve performance of DB query in BackfillAbuseReview.php

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

gerritbot added a project: Patch-For-Review.Wed, Aug 12, 11:37 PM
gerritbot added a comment.Thu, Aug 13, 5:23 AM

Change #1324831 merged by jenkins-bot:

[mediawiki/extensions/WikimediaAntiAbuse@master] Improve performance of DB query in BackfillAbuseReview.php

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

Maintenance_bot removed a project: Patch-For-Review.Thu, Aug 13, 5:30 AM
ReleaseTaggerBot edited projects, added: MW-1.47-notes (1.47.0-wmf.16; 2026-08-18); removed: MW-1.47-notes (1.47.0-wmf.15; 2026-08-11).Thu, Aug 13, 6:01 AM
gerritbot added a comment.Thu, Aug 13, 8:07 AM

Change #1325407 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/WikimediaAntiAbuse@wmf/1.47.0-wmf.15] Improve performance of DB query in BackfillAbuseReview.php

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

gerritbot added a project: Patch-For-Review.Thu, Aug 13, 8:07 AM

Change #1325408 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/WikimediaAntiAbuse@wmf/1.47.0-wmf.14] Improve performance of DB query in BackfillAbuseReview.php

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

gerritbot added a comment.Thu, Aug 13, 9:27 AM

Change #1325408 merged by jenkins-bot:

[mediawiki/extensions/WikimediaAntiAbuse@wmf/1.47.0-wmf.14] Improve performance of DB query in BackfillAbuseReview.php

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

gerritbot added a comment.Thu, Aug 13, 9:30 AM

Change #1325407 merged by jenkins-bot:

[mediawiki/extensions/WikimediaAntiAbuse@wmf/1.47.0-wmf.15] Improve performance of DB query in BackfillAbuseReview.php

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

Stashbot added a comment.Thu, Aug 13, 9:30 AM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T09:30:26Z] <dreamyjazz@deploy1003> Started scap sync-world: Backport for [[gerrit:1325408|Improve performance of DB query in BackfillAbuseReview.php (T434688)]], [[gerrit:1325407|Improve performance of DB query in BackfillAbuseReview.php (T434688)]]

Maintenance_bot removed a project: Patch-For-Review.Thu, Aug 13, 9:31 AM
Stashbot added a comment.Thu, Aug 13, 9:32 AM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T09:32:29Z] <dreamyjazz@deploy1003> dreamyjazz: Backport for [[gerrit:1325408|Improve performance of DB query in BackfillAbuseReview.php (T434688)]], [[gerrit:1325407|Improve performance of DB query in BackfillAbuseReview.php (T434688)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Thu, Aug 13, 9:37 AM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T09:37:23Z] <dreamyjazz@deploy1003> Finished scap sync-world: Backport for [[gerrit:1325408|Improve performance of DB query in BackfillAbuseReview.php (T434688)]], [[gerrit:1325407|Improve performance of DB query in BackfillAbuseReview.php (T434688)]] (duration: 06m 57s)

Dreamy_Jazz added a project: DE4.1 Platform capacity.Thu, Aug 13, 9:40 AM
Stashbot added a comment.Thu, Aug 13, 9:41 AM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T09:41:12Z] <Dreamy_Jazz> Running mwscript-k8s WikimediaAntiAbuse:BackfillAbuseReview.php --wiki=testwiki --start-timestamp="20260311000000" --end-timestamp="20260805000000" --sleep="5" --batch-size="2" for T434688

Stashbot added a comment.Thu, Aug 13, 9:46 AM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T09:46:33Z] <Dreamy_Jazz> Running mwscript-k8s WikimediaAntiAbuse:BackfillAbuseReview.php --wiki=enwiki --start-timestamp="20260801000000" --end-timestamp="20260802000000" --sleep="3" --batch-size="5" for T434688

ReleaseTaggerBot edited projects, added: MW-1.47-notes (1.47.0-wmf.15; 2026-08-11); removed: MW-1.47-notes (1.47.0-wmf.16; 2026-08-18).Thu, Aug 13, 10:00 AM
gerritbot added a comment.Thu, Aug 13, 10:28 AM

Change #1325439 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/WikimediaAntiAbuse@master] Follow-up: Improve performance of DB query in BackfillAbuseReview.php

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

gerritbot added a project: Patch-For-Review.Thu, Aug 13, 10:28 AM
Dreamy_Jazz moved this task from In progress to Needs review on the Product Safety and Integrity (Sprint Sunflower (Aug 11 - Aug 28)) board.Thu, Aug 13, 12:35 PM
Dreamy_Jazz moved this task from Needs review to In progress on the Product Safety and Integrity (Sprint Sunflower (Aug 11 - Aug 28)) board.
Dreamy_Jazz moved this task from In progress to Needs review on the Product Safety and Integrity (Sprint Sunflower (Aug 11 - Aug 28)) board.Thu, Aug 13, 12:45 PM
Stashbot added a comment.Thu, Aug 13, 1:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T13:24:08Z] <Dreamy_Jazz> Running mwscript-k8s WikimediaAntiAbuse:BackfillAbuseReview.php --wiki=enwiki --start-timestamp="20260803000000" --end-timestamp="20260804000000" --sleep="5" --batch-size="10" for T434688

Stashbot added a comment.Thu, Aug 13, 1:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T13:24:16Z] <Dreamy_Jazz> Running mwscript-k8s WikimediaAntiAbuse:BackfillAbuseReview.php --wiki=enwiki --start-timestamp="20260804000000" --end-timestamp="20260805000000" --sleep="5" --batch-size="10" for T434688

Stashbot added a comment.Thu, Aug 13, 1:25 PM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T13:25:12Z] <Dreamy_Jazz> Running mwscript-k8s WikimediaAntiAbuse:BackfillAbuseReview.php --wiki=enwiki --start-timestamp="20260802000000" --end-timestamp="20260803000000" --sleep="5" --batch-size="10" for T434688

Stashbot added a comment.Thu, Aug 13, 1:43 PM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T13:43:45Z] <Dreamy_Jazz> Running mwscript-k8s WikimediaAntiAbuse:BackfillAbuseReview.php --wiki=enwiki --start-timestamp="20260805000000" --end-timestamp="20260806000000" --sleep="5" --batch-size="10" for T434688

Stashbot added a comment.Thu, Aug 13, 11:16 PM

Mentioned in SAL (#wikimedia-operations) [2026-08-13T23:16:51Z] <Dreamy_Jazz> Running mwscript-k8s WikimediaAntiAbuse:BackfillAbuseReview.php --wiki=enwiki --start-timestamp="20260807000000" --end-timestamp="20260808000000" --sleep="5" --batch-size="50" for T434688

Stashbot added a comment.Fri, Aug 14, 9:49 AM

Mentioned in SAL (#wikimedia-operations) [2026-08-14T09:49:14Z] <Dreamy_Jazz> mwscript-k8s WikimediaAntiAbuse:BackfillAbuseReview.php --wiki=enwiki --start-timestamp="20260808000000" --end-timestamp="20260812120000" --sleep="5" --batch-size="50" for T434688

gerritbot added a comment.Mon, Aug 17, 5:40 AM

Change #1325439 merged by jenkins-bot:

[mediawiki/extensions/WikimediaAntiAbuse@master] Follow-up: Improve performance of DB query in BackfillAbuseReview.php

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

kostajh closed this task as Resolved.Mon, Aug 17, 5:46 AM
kostajh moved this task from Needs review to Done on the Product Safety and Integrity (Sprint Sunflower (Aug 11 - Aug 28)) board.
ReleaseTaggerBot edited projects, added: MW-1.47-notes (1.47.0-wmf.16; 2026-08-18); removed: MW-1.47-notes (1.47.0-wmf.15; 2026-08-11).Mon, Aug 17, 6:00 AM
Maintenance_bot removed a project: Patch-For-Review.Mon, Aug 17, 6:30 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits