Page MenuHomePhabricator
Create Task
Maniphest T407997

Drop the afl_ip column and the afl_ip_timestamp index from the abuse_filter_log table
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/AbuseFilter/+/4b51823b0109c2891690e1bad61aea7c18306ea4/db_patches/mysql/patch-drop-afl_ip.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: When DBA has time
  4. If the schema change is backwards compatible: No, but column is no longer used so dropping the column should have no effect
  5. If the schema change has been tested already on some of the test/beta wikis: Deployed to the beta wikis
  6. If the data should be made available on the labs replicas and/or dumps: No changes needed to existing visibility

Progress

  • s1
    •  codfw
    • eqiad
  • s2
    •  codfw
    • eqiad
  • s3
    •  codfw
    • eqiad
  • s4
    •  codfw
    • eqiad
  • s5
    •  codfw
    • eqiad
  • s6
    •  codfw
    • eqiad
  • s7
    •  codfw
    • eqiad
  • s8
    •  codfw
    • eqiad

Details

Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
repl_prepare_schema.sh: Remove afl_ipMarosteguioperations/softwaremaster+0 -1
rebuild_abuse_filter_log_trigger.sh: Quick oneliner to drop a triggerMarosteguioperations/softwaremaster+39 -0
Customize query in gerrit
Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
drop_afl_ip_T407997.py: New schema changerepos/sre/schema-changes!50marosteguiT407997main
Customize query in GitLab

Related Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Nov 11 2025, 12:56 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T12:56:56Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2236 (T407997)', diff saved to https://phabricator.wikimedia.org/P85167 and previous config saved to /var/cache/conftool/dbconfig/20251111-125656-marostegui.json

Stashbot added a comment.Nov 11 2025, 12:57 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T12:57:21Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2237 (T407997)', diff saved to https://phabricator.wikimedia.org/P85168 and previous config saved to /var/cache/conftool/dbconfig/20251111-125720-marostegui.json

Stashbot added a comment.Nov 11 2025, 1:04 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T13:04:05Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T407997)', diff saved to https://phabricator.wikimedia.org/P85169 and previous config saved to /var/cache/conftool/dbconfig/20251111-130405-marostegui.json

Stashbot added a comment.Nov 11 2025, 1:49 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T13:49:27Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2237 (T407997)', diff saved to https://phabricator.wikimedia.org/P85174 and previous config saved to /var/cache/conftool/dbconfig/20251111-134926-marostegui.json

Stashbot added a comment.Nov 11 2025, 1:54 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T13:54:44Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2240 (T407997)', diff saved to https://phabricator.wikimedia.org/P85176 and previous config saved to /var/cache/conftool/dbconfig/20251111-135444-marostegui.json

Stashbot added a comment.Nov 11 2025, 2:01 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T14:01:26Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T407997)', diff saved to https://phabricator.wikimedia.org/P85177 and previous config saved to /var/cache/conftool/dbconfig/20251111-140125-marostegui.json

Stashbot added a comment.Nov 11 2025, 2:46 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T14:46:48Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T407997)', diff saved to https://phabricator.wikimedia.org/P85183 and previous config saved to /var/cache/conftool/dbconfig/20251111-144648-marostegui.json

Stashbot added a comment.Nov 11 2025, 2:47 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T14:47:12Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2245 (T407997)', diff saved to https://phabricator.wikimedia.org/P85184 and previous config saved to /var/cache/conftool/dbconfig/20251111-144711-marostegui.json

Stashbot added a comment.Nov 11 2025, 2:53 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T14:53:56Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2245 (T407997)', diff saved to https://phabricator.wikimedia.org/P85185 and previous config saved to /var/cache/conftool/dbconfig/20251111-145355-marostegui.json

Stashbot added a comment.Nov 11 2025, 3:39 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T15:39:18Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2245 (T407997)', diff saved to https://phabricator.wikimedia.org/P85188 and previous config saved to /var/cache/conftool/dbconfig/20251111-153918-marostegui.json

Stashbot added a comment.Nov 11 2025, 3:39 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T15:39:43Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2246 (T407997)', diff saved to https://phabricator.wikimedia.org/P85189 and previous config saved to /var/cache/conftool/dbconfig/20251111-153942-marostegui.json

Stashbot added a comment.Nov 11 2025, 3:46 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T15:46:25Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2246 (T407997)', diff saved to https://phabricator.wikimedia.org/P85191 and previous config saved to /var/cache/conftool/dbconfig/20251111-154624-marostegui.json

Marostegui updated the task description. (Show Details)Nov 11 2025, 4:08 PM
Stashbot added a comment.Nov 11 2025, 4:09 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T16:09:51Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1221 (T407997)', diff saved to https://phabricator.wikimedia.org/P85194 and previous config saved to /var/cache/conftool/dbconfig/20251111-160950-marostegui.json

Stashbot added a comment.Nov 11 2025, 4:16 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T16:16:37Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1221 (T407997)', diff saved to https://phabricator.wikimedia.org/P85195 and previous config saved to /var/cache/conftool/dbconfig/20251111-161636-marostegui.json

Marostegui closed subtask T408780: Drop abuse_filter_log trigger for afl_ip column as Resolved.Nov 11 2025, 4:27 PM
Marostegui updated the task description. (Show Details)
Stashbot added a comment.Nov 11 2025, 5:02 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T17:02:00Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1221 (T407997)', diff saved to https://phabricator.wikimedia.org/P85200 and previous config saved to /var/cache/conftool/dbconfig/20251111-170159-marostegui.json

Stashbot added a comment.Nov 11 2025, 5:05 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T17:05:05Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1242 (T407997)', diff saved to https://phabricator.wikimedia.org/P85201 and previous config saved to /var/cache/conftool/dbconfig/20251111-170504-marostegui.json

Stashbot added a comment.Nov 11 2025, 5:11 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T17:11:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1242 (T407997)', diff saved to https://phabricator.wikimedia.org/P85202 and previous config saved to /var/cache/conftool/dbconfig/20251111-171145-marostegui.json

Stashbot added a comment.Nov 11 2025, 5:57 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T17:57:08Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1242 (T407997)', diff saved to https://phabricator.wikimedia.org/P85205 and previous config saved to /var/cache/conftool/dbconfig/20251111-175708-marostegui.json

Stashbot added a comment.Nov 11 2025, 5:57 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T17:57:33Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1243 (T407997)', diff saved to https://phabricator.wikimedia.org/P85206 and previous config saved to /var/cache/conftool/dbconfig/20251111-175732-marostegui.json

Stashbot added a comment.Nov 11 2025, 6:04 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T18:04:14Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T407997)', diff saved to https://phabricator.wikimedia.org/P85207 and previous config saved to /var/cache/conftool/dbconfig/20251111-180414-marostegui.json

Stashbot added a comment.Nov 11 2025, 6:49 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T18:49:37Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1243 (T407997)', diff saved to https://phabricator.wikimedia.org/P85210 and previous config saved to /var/cache/conftool/dbconfig/20251111-184936-marostegui.json

Stashbot added a comment.Nov 11 2025, 6:50 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T18:50:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1244 (T407997)', diff saved to https://phabricator.wikimedia.org/P85211 and previous config saved to /var/cache/conftool/dbconfig/20251111-185000-marostegui.json

Stashbot added a comment.Nov 11 2025, 6:56 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T18:56:39Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1244 (T407997)', diff saved to https://phabricator.wikimedia.org/P85212 and previous config saved to /var/cache/conftool/dbconfig/20251111-185637-marostegui.json

Stashbot added a comment.Nov 11 2025, 7:42 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T19:42:02Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1244 (T407997)', diff saved to https://phabricator.wikimedia.org/P85215 and previous config saved to /var/cache/conftool/dbconfig/20251111-194201-marostegui.json

Stashbot added a comment.Nov 11 2025, 7:47 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T19:47:15Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1247 (T407997)', diff saved to https://phabricator.wikimedia.org/P85216 and previous config saved to /var/cache/conftool/dbconfig/20251111-194714-marostegui.json

Stashbot added a comment.Nov 11 2025, 7:53 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T19:53:55Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T407997)', diff saved to https://phabricator.wikimedia.org/P85217 and previous config saved to /var/cache/conftool/dbconfig/20251111-195354-marostegui.json

Stashbot added a comment.Nov 11 2025, 8:39 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T20:39:18Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1247 (T407997)', diff saved to https://phabricator.wikimedia.org/P85220 and previous config saved to /var/cache/conftool/dbconfig/20251111-203917-marostegui.json

Stashbot added a comment.Nov 11 2025, 8:39 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T20:39:42Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1248 (T407997)', diff saved to https://phabricator.wikimedia.org/P85221 and previous config saved to /var/cache/conftool/dbconfig/20251111-203942-marostegui.json

Stashbot added a comment.Nov 11 2025, 8:46 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T20:46:19Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T407997)', diff saved to https://phabricator.wikimedia.org/P85222 and previous config saved to /var/cache/conftool/dbconfig/20251111-204618-marostegui.json

Stashbot added a comment.Nov 11 2025, 9:31 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T21:31:42Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1248 (T407997)', diff saved to https://phabricator.wikimedia.org/P85225 and previous config saved to /var/cache/conftool/dbconfig/20251111-213141-marostegui.json

Stashbot added a comment.Nov 11 2025, 9:32 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T21:32:06Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1249 (T407997)', diff saved to https://phabricator.wikimedia.org/P85226 and previous config saved to /var/cache/conftool/dbconfig/20251111-213205-marostegui.json

Stashbot added a comment.Nov 11 2025, 9:38 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T21:38:43Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T407997)', diff saved to https://phabricator.wikimedia.org/P85227 and previous config saved to /var/cache/conftool/dbconfig/20251111-213842-marostegui.json

Stashbot added a comment.Nov 11 2025, 10:24 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T22:24:06Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T407997)', diff saved to https://phabricator.wikimedia.org/P85230 and previous config saved to /var/cache/conftool/dbconfig/20251111-222405-marostegui.json

Stashbot added a comment.Nov 11 2025, 10:24 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T22:24:30Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1252 (T407997)', diff saved to https://phabricator.wikimedia.org/P85231 and previous config saved to /var/cache/conftool/dbconfig/20251111-222430-marostegui.json

Stashbot added a comment.Nov 11 2025, 10:31 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T22:31:10Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T407997)', diff saved to https://phabricator.wikimedia.org/P85232 and previous config saved to /var/cache/conftool/dbconfig/20251111-223109-marostegui.json

Stashbot added a comment.Nov 11 2025, 11:16 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T23:16:32Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1252 (T407997)', diff saved to https://phabricator.wikimedia.org/P85235 and previous config saved to /var/cache/conftool/dbconfig/20251111-231632-marostegui.json

Stashbot added a comment.Nov 11 2025, 11:16 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T23:16:56Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1260 (T407997)', diff saved to https://phabricator.wikimedia.org/P85236 and previous config saved to /var/cache/conftool/dbconfig/20251111-231655-marostegui.json

Stashbot added a comment.Nov 11 2025, 11:23 PM

Mentioned in SAL (#wikimedia-operations) [2025-11-11T23:23:35Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1260 (T407997)', diff saved to https://phabricator.wikimedia.org/P85237 and previous config saved to /var/cache/conftool/dbconfig/20251111-232334-marostegui.json

Stashbot added a comment.Nov 12 2025, 12:08 AM

Mentioned in SAL (#wikimedia-operations) [2025-11-12T00:08:58Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1260 (T407997)', diff saved to https://phabricator.wikimedia.org/P85240 and previous config saved to /var/cache/conftool/dbconfig/20251112-000857-marostegui.json

Stashbot added a comment.Nov 12 2025, 12:09 AM

Mentioned in SAL (#wikimedia-operations) [2025-11-12T00:09:22Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1261 (T407997)', diff saved to https://phabricator.wikimedia.org/P85241 and previous config saved to /var/cache/conftool/dbconfig/20251112-000922-marostegui.json

Stashbot added a comment.Nov 12 2025, 12:16 AM

Mentioned in SAL (#wikimedia-operations) [2025-11-12T00:16:05Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1261 (T407997)', diff saved to https://phabricator.wikimedia.org/P85242 and previous config saved to /var/cache/conftool/dbconfig/20251112-001604-marostegui.json

Stashbot added a comment.Nov 12 2025, 1:01 AM

Mentioned in SAL (#wikimedia-operations) [2025-11-12T01:01:28Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1261 (T407997)', diff saved to https://phabricator.wikimedia.org/P85245 and previous config saved to /var/cache/conftool/dbconfig/20251112-010128-marostegui.json

Stashbot added a comment.Nov 12 2025, 1:01 AM

Mentioned in SAL (#wikimedia-operations) [2025-11-12T01:01:52Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1263 (T407997)', diff saved to https://phabricator.wikimedia.org/P85246 and previous config saved to /var/cache/conftool/dbconfig/20251112-010151-marostegui.json

Stashbot added a comment.Nov 12 2025, 1:08 AM

Mentioned in SAL (#wikimedia-operations) [2025-11-12T01:08:28Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1263 (T407997)', diff saved to https://phabricator.wikimedia.org/P85247 and previous config saved to /var/cache/conftool/dbconfig/20251112-010828-marostegui.json

Stashbot added a comment.Nov 12 2025, 1:53 AM

Mentioned in SAL (#wikimedia-operations) [2025-11-12T01:53:51Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1263 (T407997)', diff saved to https://phabricator.wikimedia.org/P85250 and previous config saved to /var/cache/conftool/dbconfig/20251112-015351-marostegui.json

Marostegui updated the task description. (Show Details)Nov 12 2025, 7:02 AM
Marostegui closed this task as Resolved.Nov 12 2025, 7:11 AM
Marostegui updated the task description. (Show Details)

All done!

Maintenance_bot moved this task from In progress to Done on the DBA board.Nov 12 2025, 7:29 AM
Dreamy_Jazz added a comment.Nov 12 2025, 10:28 AM

Thanks!

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