Page MenuHomePhabricator
Create Task
Maniphest T411163

Drop ar_sha1 from archive table in wmf production
Closed, ResolvedPublic
Actions

Description

  1. ALTER to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1207211/3/sql/mysql/patch-archive-drop-ar_sha1.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
  5. If the schema change has been tested already on some of the test/beta wikis: Change is running in beta cluster
  6. If the data should be made available on the labs replicas and/or dumps: No changes needed, already done in https://gerrit.wikimedia.org/r/c/operations/puppet/+/1191090

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:
SubjectRepoBranchLines +/-
db2161: Disable notificationsoperations/puppetproduction+2 -1
filtered_tables.txt: Remove ar_sha1 and rev_sha1operations/puppetproduction+0 -2
db1193: Disable notificationsoperations/puppetproduction+2 -1
db2212: Disable notificationsoperations/puppetproduction+2 -1
db1163: Disable notificationsoperations/puppetproduction+2 -1
Customize query in gerrit
Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
drop_ar_sha1_T411163.py: New schema changerepos/sre/schema-changes!52marosteguiT411163main
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.Jan 24 2026, 8:34 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-24T20:34:48Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2166 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87908 and previous config saved to /var/cache/conftool/dbconfig/20260124-203447-marostegui.json

Stashbot added a comment.Jan 24 2026, 11:32 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-24T23:32:56Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87909 and previous config saved to /var/cache/conftool/dbconfig/20260124-233255-marostegui.json

Stashbot added a comment.Jan 25 2026, 12:03 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-25T00:03:21Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87912 and previous config saved to /var/cache/conftool/dbconfig/20260125-000321-marostegui.json

Stashbot added a comment.Jan 25 2026, 12:03 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-25T00:03:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1192 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87913 and previous config saved to /var/cache/conftool/dbconfig/20260125-000345-marostegui.json

Stashbot added a comment.Jan 25 2026, 5:27 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-25T17:27:00Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2166 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87914 and previous config saved to /var/cache/conftool/dbconfig/20260125-172658-marostegui.json

Stashbot added a comment.Jan 25 2026, 5:57 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-25T17:57:25Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2166 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87917 and previous config saved to /var/cache/conftool/dbconfig/20260125-175724-marostegui.json

Stashbot added a comment.Jan 25 2026, 5:57 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-25T17:57:49Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2167 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87918 and previous config saved to /var/cache/conftool/dbconfig/20260125-175749-marostegui.json

Stashbot added a comment.Jan 25 2026, 9:54 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-25T21:54:11Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1192 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87919 and previous config saved to /var/cache/conftool/dbconfig/20260125-215410-marostegui.json

Stashbot added a comment.Jan 25 2026, 10:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-25T22:24:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1192 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87922 and previous config saved to /var/cache/conftool/dbconfig/20260125-222435-marostegui.json

Stashbot added a comment.Jan 25 2026, 10:25 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-25T22:25:00Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1193 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87923 and previous config saved to /var/cache/conftool/dbconfig/20260125-222500-marostegui.json

Stashbot added a comment.Jan 26 2026, 2:53 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-26T14:53:47Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2167 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87928 and previous config saved to /var/cache/conftool/dbconfig/20260126-145346-marostegui.json

Stashbot added a comment.Jan 26 2026, 3:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-26T15:24:12Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2167 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87931 and previous config saved to /var/cache/conftool/dbconfig/20260126-152411-marostegui.json

Stashbot added a comment.Jan 26 2026, 3:24 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-26T15:24:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2181 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87932 and previous config saved to /var/cache/conftool/dbconfig/20260126-152436-marostegui.json

Stashbot added a comment.Jan 26 2026, 8:18 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-26T20:18:35Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1193 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87942 and previous config saved to /var/cache/conftool/dbconfig/20260126-201834-marostegui.json

Stashbot added a comment.Jan 26 2026, 8:49 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-26T20:49:00Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1193 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87945 and previous config saved to /var/cache/conftool/dbconfig/20260126-204900-marostegui.json

Stashbot added a comment.Jan 26 2026, 8:49 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-26T20:49:25Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1203 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87946 and previous config saved to /var/cache/conftool/dbconfig/20260126-204925-marostegui.json

Marostegui closed subtask T415238: Switchover s1 master (db1163 -> db1184) as Resolved.Jan 27 2026, 8:26 AM
gerritbot added a comment.Jan 27 2026, 8:28 AM

Change #1233641 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] db1163: Disable notifications

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

gerritbot added a project: Patch-For-Review.Jan 27 2026, 8:28 AM
Stashbot added a comment.Jan 27 2026, 8:28 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T08:28:49Z] <marostegui> Deploy schema change on old s1 master db1163 T411163 T411164

gerritbot added a comment.Jan 27 2026, 8:29 AM

Change #1233641 merged by Marostegui:

[operations/puppet@production] db1163: Disable notifications

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

Maintenance_bot removed a project: Patch-For-Review.Jan 27 2026, 8:31 AM
Marostegui updated the task description. (Show Details)Jan 27 2026, 8:42 AM
Stashbot added a comment.Jan 27 2026, 12:22 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T12:22:49Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2181 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87956 and previous config saved to /var/cache/conftool/dbconfig/20260127-122248-marostegui.json

Stashbot added a comment.Jan 27 2026, 12:53 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T12:53:15Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2181 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87959 and previous config saved to /var/cache/conftool/dbconfig/20260127-125314-marostegui.json

Stashbot added a comment.Jan 27 2026, 12:53 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T12:53:39Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2195 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87960 and previous config saved to /var/cache/conftool/dbconfig/20260127-125338-marostegui.json

Stashbot added a comment.Jan 27 2026, 6:46 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T18:46:48Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1203 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87970 and previous config saved to /var/cache/conftool/dbconfig/20260127-184647-marostegui.json

Stashbot added a comment.Jan 27 2026, 7:17 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T19:17:13Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1203 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87973 and previous config saved to /var/cache/conftool/dbconfig/20260127-191713-marostegui.json

Stashbot added a comment.Jan 27 2026, 7:17 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T19:17:27Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1214 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87974 and previous config saved to /var/cache/conftool/dbconfig/20260127-191726-marostegui.json

Marostegui updated the task description. (Show Details)Jan 28 2026, 6:41 AM
Marostegui closed subtask T415171: Switchover s1 master (db2212 -> db2203) as Resolved.Jan 28 2026, 6:52 AM
gerritbot added a comment.Jan 28 2026, 6:53 AM

Change #1234145 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] db2212: Disable notifications

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

gerritbot added a project: Patch-For-Review.Jan 28 2026, 6:53 AM
Stashbot added a comment.Jan 28 2026, 6:54 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-28T06:54:22Z] <marostegui> Deploy schema change on old s1 master db2212 T411163 T411164

gerritbot added a comment.Jan 28 2026, 6:54 AM

Change #1234145 merged by Marostegui:

[operations/puppet@production] db2212: Disable notifications

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

Marostegui updated the task description. (Show Details)Jan 28 2026, 7:23 AM
Marostegui added a subtask: T415748: Switchover s8 master (db2161 -> db2165).
Maintenance_bot removed a project: Patch-For-Review.Jan 28 2026, 7:31 AM
Stashbot added a comment.Jan 28 2026, 7:44 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-28T07:44:25Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2195 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87984 and previous config saved to /var/cache/conftool/dbconfig/20260128-074424-marostegui.json

Stashbot added a comment.Jan 28 2026, 8:14 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-28T08:14:51Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2195 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P87987 and previous config saved to /var/cache/conftool/dbconfig/20260128-081449-marostegui.json

Stashbot added a comment.Jan 28 2026, 3:11 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-28T15:11:34Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1214 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P88001 and previous config saved to /var/cache/conftool/dbconfig/20260128-151133-marostegui.json

Stashbot added a comment.Jan 28 2026, 3:42 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-28T15:41:59Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1214 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P88006 and previous config saved to /var/cache/conftool/dbconfig/20260128-154158-marostegui.json

Stashbot added a comment.Jan 28 2026, 3:42 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-28T15:42:25Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1226 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P88007 and previous config saved to /var/cache/conftool/dbconfig/20260128-154224-marostegui.json

Marostegui updated the task description. (Show Details)Jan 29 2026, 6:36 AM
Marostegui added a subtask: T415879: Switchover s8 master (db1209 -> db1193).Jan 29 2026, 9:41 AM
Marostegui updated the task description. (Show Details)Jan 29 2026, 10:59 AM
Stashbot added a comment.Jan 29 2026, 11:24 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-29T11:24:38Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1226 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P88111 and previous config saved to /var/cache/conftool/dbconfig/20260129-112437-marostegui.json

Stashbot added a comment.Jan 29 2026, 11:55 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-29T11:55:04Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1226 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P88117 and previous config saved to /var/cache/conftool/dbconfig/20260129-115503-marostegui.json

Marostegui closed subtask T415879: Switchover s8 master (db1209 -> db1193) as Resolved.Jan 29 2026, 12:59 PM
Stashbot added a comment.Jan 29 2026, 1:02 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-29T13:02:50Z] <marostegui> Run schema change on old s8 eqiad master (db1209) T411164 T411163

Marostegui updated the task description. (Show Details)Jan 29 2026, 1:03 PM
Marostegui updated the task description. (Show Details)Jan 30 2026, 11:28 AM
gerritbot added a comment.Feb 2 2026, 6:00 AM

Change #1235614 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] db1193: Disable notifications

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

gerritbot added a project: Patch-For-Review.Feb 2 2026, 6:01 AM
Stashbot added a comment.Feb 2 2026, 6:02 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-02T06:02:05Z] <marostegui> Deploy schema change on old s8 eqiad master db1193 T411164 T411163

gerritbot added a comment.Feb 2 2026, 6:04 AM

Change #1235614 merged by Marostegui:

[operations/puppet@production] db1193: Disable notifications

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

gerritbot added a comment.Feb 2 2026, 6:11 AM

Change #1235615 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] db2161: Disable notifications

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

gerritbot added a comment.Feb 2 2026, 6:13 AM

Change #1235615 merged by Marostegui:

[operations/puppet@production] db2161: Disable notifications

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

Marostegui closed subtask T415748: Switchover s8 master (db2161 -> db2165) as Resolved.Feb 2 2026, 6:15 AM
Marostegui updated the task description. (Show Details)
Maintenance_bot removed a project: Patch-For-Review.Feb 2 2026, 6:32 AM
Marostegui updated the task description. (Show Details)Feb 3 2026, 5:47 AM
gerritbot added a comment.Feb 3 2026, 5:48 AM

Change #1236104 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] filtered_tables.txt: Remove ar_sha1 and rev_sha1

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

gerritbot added a project: Patch-For-Review.Feb 3 2026, 5:49 AM
Marostegui updated the task description. (Show Details)Feb 3 2026, 5:49 AM
gerritbot added a comment.Feb 3 2026, 6:19 AM

Change #1236104 merged by Marostegui:

[operations/puppet@production] filtered_tables.txt: Remove ar_sha1 and rev_sha1

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

Marostegui closed this task as Resolved.Feb 3 2026, 6:19 AM
Marostegui updated the task description. (Show Details)

Finally all done!

Maintenance_bot moved this task from In progress to Done on the DBA board.Feb 3 2026, 6:29 AM
Maintenance_bot removed a project: Patch-For-Review.Feb 3 2026, 6:37 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