Page MenuHomePhabricator
Create Task
Maniphest T391056

Drop afl_patrolled_by from abuse_filter_log in production
Closed, ResolvedPublic
Actions

Description

Deployment of T391027: AbuseFilter: Drop afl_patrolled_by completely unused column

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/AbuseFilter/+/1134049/1/db_patches/mysql/patch-drop-afl_patrolled_by.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: any time
  4. If the schema change is backwards compatible: Nah
  5. If the schema change has been tested already on some of the test/beta wikis: beta cluster is running with the new schema
  6. if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Progress:

  • s1
    • replicas
    • codfw master
    • eqiad master
  • s2
    • Done
  • s3
    • Done
  • s4
    • Done
  • s5
    • Started
    • Done
  • s6:
    • Started
    • Done
  • s7
    • Started
    • Done
  • s8
    • replicas
    • codfw master
    • eqiad master

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.Jun 25 2025, 3:45 PM

Mentioned in SAL (#wikimedia-operations) [2025-06-25T15:45:29Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db1167 (T391056)', diff saved to https://phabricator.wikimedia.org/P78692 and previous config saved to /var/cache/conftool/dbconfig/20250625-154529-fceratto.json

Stashbot added a comment.Jun 25 2025, 3:46 PM

Mentioned in SAL (#wikimedia-operations) [2025-06-25T15:46:37Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T391056)', diff saved to https://phabricator.wikimedia.org/P78693 and previous config saved to /var/cache/conftool/dbconfig/20250625-154637-fceratto.json

ops-monitoring-bot added a comment.Jun 25 2025, 4:03 PM

Start pool of db1167 gradually with 4 steps - Pooling in - fceratto@cumin1002

ops-monitoring-bot added a comment.Jun 25 2025, 4:33 PM

Completed pool of db1167 gradually with 4 steps - Pooling in - fceratto@cumin1002

ops-monitoring-bot added a comment.Jun 26 2025, 9:18 AM

Start pool of db2161 gradually with 4 steps - Pooling in - fceratto@cumin1002

Ladsgroup closed subtask T397164: Switchover s8 master (db2161 -> db2165) as Resolved.Jun 26 2025, 10:01 AM
ops-monitoring-bot added a comment.Jun 26 2025, 10:04 AM

Completed pool of db2161 gradually with 4 steps - Pooling in - fceratto@cumin1002

Stashbot added a comment.Jun 26 2025, 12:23 PM

Mentioned in SAL (#wikimedia-operations) [2025-06-26T12:23:34Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2240 (T391056)', diff saved to https://phabricator.wikimedia.org/P78707 and previous config saved to /var/cache/conftool/dbconfig/20250626-122333-fceratto.json

Stashbot added a comment.Jun 26 2025, 12:29 PM

Mentioned in SAL (#wikimedia-operations) [2025-06-26T12:29:53Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2240 (T391056)', diff saved to https://phabricator.wikimedia.org/P78708 and previous config saved to /var/cache/conftool/dbconfig/20250626-122952-fceratto.json

ops-monitoring-bot added a comment.Jun 26 2025, 1:39 PM

Start pool of db2240 gradually with 4 steps - Pooling in - fceratto@cumin1002

FCeratto-WMF closed subtask T397163: Switchover s4 master (db2240 -> db2179) as Resolved.Jun 26 2025, 1:43 PM
FCeratto-WMF updated the task description. (Show Details)
Ladsgroup added a comment.Jun 26 2025, 1:50 PM

I think we still need to do s4 and s8 in eqiad too? Their switchover is a different beast though since that requires actual read only time and setting the wikis to RO for a bit (it's user-facing impact)

ops-monitoring-bot added a comment.Jun 26 2025, 2:24 PM

Completed pool of db2240 gradually with 4 steps - Pooling in - fceratto@cumin1002

FCeratto-WMF updated the task description. (Show Details)Jun 26 2025, 4:08 PM
FCeratto-WMF updated the task description. (Show Details)Jun 27 2025, 8:19 AM
FCeratto-WMF added a subtask: T398014: Switchover s1 master (db2203 -> db2212).Jun 27 2025, 8:27 AM
FCeratto-WMF moved this task from In progress to Blocked on the DBA board.Jun 30 2025, 12:17 PM
ops-monitoring-bot added a comment.Jul 10 2025, 9:14 AM

Start pool of db2161 gradually with 4 steps - Pooling in - fceratto@cumin1002

ops-monitoring-bot added a comment.Jul 10 2025, 9:14 AM

Completed pool of db2161 gradually with 4 steps - Pooling in - fceratto@cumin1002

ops-monitoring-bot added a comment.Jul 10 2025, 9:15 AM

Start pool of db2240 gradually with 4 steps - Pooling in - fceratto@cumin1002

ops-monitoring-bot added a comment.Jul 10 2025, 9:15 AM

Completed pool of db2240 gradually with 4 steps - Pooling in - fceratto@cumin1002

FCeratto-WMF changed the status of subtask T398014: Switchover s1 master (db2203 -> db2212) from Open to In Progress.Jul 21 2025, 2:10 PM
FCeratto-WMF closed subtask T398014: Switchover s1 master (db2203 -> db2212) as Resolved.Jul 21 2025, 4:00 PM
Marostegui added a comment.Jul 21 2025, 5:02 PM

@FCeratto-WMF now that the s1 codfw master is switched, remember to apply this schema change there too.

Stashbot added a comment.Aug 12 2025, 7:49 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T07:49:33Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2145 (T391056)', diff saved to https://phabricator.wikimedia.org/P81056 and previous config saved to /var/cache/conftool/dbconfig/20250812-074932-fceratto.json

Stashbot added a comment.Aug 12 2025, 7:50 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T07:50:42Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T391056)', diff saved to https://phabricator.wikimedia.org/P81057 and previous config saved to /var/cache/conftool/dbconfig/20250812-075041-fceratto.json

Stashbot added a comment.Aug 12 2025, 8:36 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T08:36:04Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T391056)', diff saved to https://phabricator.wikimedia.org/P81065 and previous config saved to /var/cache/conftool/dbconfig/20250812-083603-fceratto.json

Stashbot added a comment.Aug 12 2025, 8:36 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T08:36:38Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2146 (T391056)', diff saved to https://phabricator.wikimedia.org/P81066 and previous config saved to /var/cache/conftool/dbconfig/20250812-083637-fceratto.json

Stashbot added a comment.Aug 12 2025, 8:37 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T08:37:47Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T391056)', diff saved to https://phabricator.wikimedia.org/P81067 and previous config saved to /var/cache/conftool/dbconfig/20250812-083746-fceratto.json

Stashbot added a comment.Aug 12 2025, 9:23 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T09:23:11Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T391056)', diff saved to https://phabricator.wikimedia.org/P81075 and previous config saved to /var/cache/conftool/dbconfig/20250812-092310-fceratto.json

Stashbot added a comment.Aug 12 2025, 9:23 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T09:23:35Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2153 (T391056)', diff saved to https://phabricator.wikimedia.org/P81076 and previous config saved to /var/cache/conftool/dbconfig/20250812-092334-fceratto.json

Stashbot added a comment.Aug 12 2025, 9:24 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T09:24:44Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T391056)', diff saved to https://phabricator.wikimedia.org/P81077 and previous config saved to /var/cache/conftool/dbconfig/20250812-092443-fceratto.json

Stashbot added a comment.Aug 12 2025, 10:10 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T10:10:07Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T391056)', diff saved to https://phabricator.wikimedia.org/P81085 and previous config saved to /var/cache/conftool/dbconfig/20250812-101006-fceratto.json

Stashbot added a comment.Aug 12 2025, 10:10 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T10:10:30Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2170 (T391056)', diff saved to https://phabricator.wikimedia.org/P81086 and previous config saved to /var/cache/conftool/dbconfig/20250812-101029-fceratto.json

Stashbot added a comment.Aug 12 2025, 10:12 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T10:12:39Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2170 (T391056)', diff saved to https://phabricator.wikimedia.org/P81088 and previous config saved to /var/cache/conftool/dbconfig/20250812-101238-fceratto.json

Stashbot added a comment.Aug 12 2025, 10:58 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T10:58:02Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2170 (T391056)', diff saved to https://phabricator.wikimedia.org/P81095 and previous config saved to /var/cache/conftool/dbconfig/20250812-105801-fceratto.json

Stashbot added a comment.Aug 12 2025, 10:58 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T10:58:25Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2173 (T391056)', diff saved to https://phabricator.wikimedia.org/P81096 and previous config saved to /var/cache/conftool/dbconfig/20250812-105824-fceratto.json

Stashbot added a comment.Aug 12 2025, 10:59 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T10:59:34Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T391056)', diff saved to https://phabricator.wikimedia.org/P81097 and previous config saved to /var/cache/conftool/dbconfig/20250812-105933-fceratto.json

Stashbot added a comment.Aug 12 2025, 11:44 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T11:44:56Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T391056)', diff saved to https://phabricator.wikimedia.org/P81103 and previous config saved to /var/cache/conftool/dbconfig/20250812-114455-fceratto.json

Stashbot added a comment.Aug 12 2025, 11:45 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T11:45:15Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2174 (T391056)', diff saved to https://phabricator.wikimedia.org/P81105 and previous config saved to /var/cache/conftool/dbconfig/20250812-114514-fceratto.json

Stashbot added a comment.Aug 12 2025, 11:46 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T11:46:24Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T391056)', diff saved to https://phabricator.wikimedia.org/P81107 and previous config saved to /var/cache/conftool/dbconfig/20250812-114623-fceratto.json

Stashbot added a comment.Aug 12 2025, 12:31 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T12:31:46Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T391056)', diff saved to https://phabricator.wikimedia.org/P81113 and previous config saved to /var/cache/conftool/dbconfig/20250812-123145-fceratto.json

Stashbot added a comment.Aug 12 2025, 12:31 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T12:31:58Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2176 (T391056)', diff saved to https://phabricator.wikimedia.org/P81114 and previous config saved to /var/cache/conftool/dbconfig/20250812-123157-fceratto.json

Stashbot added a comment.Aug 12 2025, 12:33 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T12:33:07Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T391056)', diff saved to https://phabricator.wikimedia.org/P81115 and previous config saved to /var/cache/conftool/dbconfig/20250812-123306-fceratto.json

Stashbot added a comment.Aug 12 2025, 1:18 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T13:18:29Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T391056)', diff saved to https://phabricator.wikimedia.org/P81123 and previous config saved to /var/cache/conftool/dbconfig/20250812-131829-fceratto.json

Stashbot added a comment.Aug 12 2025, 1:18 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T13:18:52Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2188 (T391056)', diff saved to https://phabricator.wikimedia.org/P81124 and previous config saved to /var/cache/conftool/dbconfig/20250812-131851-fceratto.json

Stashbot added a comment.Aug 12 2025, 1:20 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T13:20:02Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T391056)', diff saved to https://phabricator.wikimedia.org/P81125 and previous config saved to /var/cache/conftool/dbconfig/20250812-132001-fceratto.json

Stashbot added a comment.Aug 12 2025, 2:05 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T14:05:24Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T391056)', diff saved to https://phabricator.wikimedia.org/P81129 and previous config saved to /var/cache/conftool/dbconfig/20250812-140523-fceratto.json

Stashbot added a comment.Aug 12 2025, 2:06 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T14:06:04Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2203 (T391056)', diff saved to https://phabricator.wikimedia.org/P81130 and previous config saved to /var/cache/conftool/dbconfig/20250812-140603-fceratto.json

Stashbot added a comment.Aug 12 2025, 2:24 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T14:24:01Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2203 (T391056)', diff saved to https://phabricator.wikimedia.org/P81131 and previous config saved to /var/cache/conftool/dbconfig/20250812-142400-fceratto.json

Stashbot added a comment.Aug 12 2025, 3:09 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T15:09:45Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Depooling db2216 (T391056)', diff saved to https://phabricator.wikimedia.org/P81137 and previous config saved to /var/cache/conftool/dbconfig/20250812-150944-fceratto.json

Stashbot added a comment.Aug 12 2025, 3:10 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T15:10:54Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2216 (T391056)', diff saved to https://phabricator.wikimedia.org/P81138 and previous config saved to /var/cache/conftool/dbconfig/20250812-151053-fceratto.json

Stashbot added a comment.Aug 12 2025, 3:56 PM

Mentioned in SAL (#wikimedia-operations) [2025-08-12T15:56:17Z] <fceratto@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2216 (T391056)', diff saved to https://phabricator.wikimedia.org/P81141 and previous config saved to /var/cache/conftool/dbconfig/20250812-155616-fceratto.json

Ladsgroup updated the task description. (Show Details)Aug 26 2025, 12:54 AM
Ladsgroup updated the task description. (Show Details)Aug 26 2025, 12:58 AM
Stashbot added a comment.Aug 26 2025, 12:59 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-26T00:59:53Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1249 (T391056)', diff saved to https://phabricator.wikimedia.org/P81747 and previous config saved to /var/cache/conftool/dbconfig/20250826-005952-ladsgroup.json

Stashbot added a comment.Aug 26 2025, 1:06 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-26T01:06:18Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T391056)', diff saved to https://phabricator.wikimedia.org/P81748 and previous config saved to /var/cache/conftool/dbconfig/20250826-010618-ladsgroup.json

Stashbot added a comment.Aug 26 2025, 1:51 AM

Mentioned in SAL (#wikimedia-operations) [2025-08-26T01:51:41Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1249 (T391056)', diff saved to https://phabricator.wikimedia.org/P81751 and previous config saved to /var/cache/conftool/dbconfig/20250826-015141-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Sep 2 2025, 3:17 PM
Ladsgroup moved this task from Blocked to In progress on the DBA board.Sep 3 2025, 10:05 AM
Ladsgroup closed this task as Resolved.Sep 9 2025, 12:31 PM
Ladsgroup updated the task description. (Show Details)
Ladsgroup moved this task from In progress to Done on the DBA board.
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