Page MenuHomePhabricator

Drop ar_sha1 from archive table in wmf production
Open, MediumPublic

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
  • s1
  • s2
  • s3
    •  codfw
    •  eqiad
  • s4
  • s5
    •  codfw
    •  eqiad
  • s6
    •  codfw
    •  eqiad
  • s7
  • s8
  • Puppet patch

Details

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

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

Mentioned in SAL (#wikimedia-operations) [2025-12-01T20:04:00Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2178 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86256 and previous config saved to /var/cache/conftool/dbconfig/20251201-200359-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-01T21:40:22Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1157 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86258 and previous config saved to /var/cache/conftool/dbconfig/20251201-214021-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-01T21:42:48Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2178 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86259 and previous config saved to /var/cache/conftool/dbconfig/20251201-214247-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-01T22:25:44Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1157 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86264 and previous config saved to /var/cache/conftool/dbconfig/20251201-222544-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-01T22:26:08Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1166 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86265 and previous config saved to /var/cache/conftool/dbconfig/20251201-222607-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-01T22:28:10Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2178 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86266 and previous config saved to /var/cache/conftool/dbconfig/20251201-222810-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T01:36:36Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2211 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86272 and previous config saved to /var/cache/conftool/dbconfig/20251202-013635-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T03:06:15Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86273 and previous config saved to /var/cache/conftool/dbconfig/20251202-030615-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T03:51:38Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86276 and previous config saved to /var/cache/conftool/dbconfig/20251202-035138-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T03:52:03Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1175 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86277 and previous config saved to /var/cache/conftool/dbconfig/20251202-035202-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T04:34:25Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2211 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86278 and previous config saved to /var/cache/conftool/dbconfig/20251202-043424-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T05:19:47Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2211 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86281 and previous config saved to /var/cache/conftool/dbconfig/20251202-051947-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T05:20:11Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2213 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86282 and previous config saved to /var/cache/conftool/dbconfig/20251202-052010-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T08:17:59Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2213 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86288 and previous config saved to /var/cache/conftool/dbconfig/20251202-081758-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T08:23:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86289 and previous config saved to /var/cache/conftool/dbconfig/20251202-082345-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T09:03:21Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2213 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86294 and previous config saved to /var/cache/conftool/dbconfig/20251202-090321-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T09:03:34Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2223 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86295 and previous config saved to /var/cache/conftool/dbconfig/20251202-090334-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T09:09:09Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86296 and previous config saved to /var/cache/conftool/dbconfig/20251202-090908-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T09:09:32Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1189 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86297 and previous config saved to /var/cache/conftool/dbconfig/20251202-090932-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T09:49:41Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2223 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86298 and previous config saved to /var/cache/conftool/dbconfig/20251202-094931-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T11:36:26Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2149 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86302 and previous config saved to /var/cache/conftool/dbconfig/20251202-113625-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T13:56:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86309 and previous config saved to /var/cache/conftool/dbconfig/20251202-135600-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T14:41:24Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1189 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86313 and previous config saved to /var/cache/conftool/dbconfig/20251202-144123-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T14:41:49Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1198 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86314 and previous config saved to /var/cache/conftool/dbconfig/20251202-144148-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T16:57:03Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2149 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86321 and previous config saved to /var/cache/conftool/dbconfig/20251202-165702-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T17:42:26Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2149 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86326 and previous config saved to /var/cache/conftool/dbconfig/20251202-174225-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T17:42:49Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2156 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86327 and previous config saved to /var/cache/conftool/dbconfig/20251202-174249-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T17:47:33Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db1212 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86328 and previous config saved to /var/cache/conftool/dbconfig/20251202-174732-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T22:06:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1212 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86329 and previous config saved to /var/cache/conftool/dbconfig/20251202-220600-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T22:51:23Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db1212 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86332 and previous config saved to /var/cache/conftool/dbconfig/20251202-225122-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T22:58:10Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86333 and previous config saved to /var/cache/conftool/dbconfig/20251202-225809-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T23:43:33Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2156 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86336 and previous config saved to /var/cache/conftool/dbconfig/20251202-234332-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-02T23:43:57Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2177 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86337 and previous config saved to /var/cache/conftool/dbconfig/20251202-234356-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T04:58:51Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86339 and previous config saved to /var/cache/conftool/dbconfig/20251203-045851-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T05:44:15Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2177 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86342 and previous config saved to /var/cache/conftool/dbconfig/20251203-054414-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T05:44:39Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2190 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86343 and previous config saved to /var/cache/conftool/dbconfig/20251203-054438-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T10:33:23Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2190 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86357 and previous config saved to /var/cache/conftool/dbconfig/20251203-103323-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T11:18:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2190 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86360 and previous config saved to /var/cache/conftool/dbconfig/20251203-111846-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T11:19:11Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2194 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86361 and previous config saved to /var/cache/conftool/dbconfig/20251203-111910-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T11:23:46Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2194 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86362 and previous config saved to /var/cache/conftool/dbconfig/20251203-112345-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T12:09:09Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2194 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86365 and previous config saved to /var/cache/conftool/dbconfig/20251203-120909-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T12:09:33Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2209 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86366 and previous config saved to /var/cache/conftool/dbconfig/20251203-120933-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T12:14:09Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2209 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86367 and previous config saved to /var/cache/conftool/dbconfig/20251203-121409-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T12:59:39Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2209 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86373 and previous config saved to /var/cache/conftool/dbconfig/20251203-125938-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T13:00:02Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Depooling db2227 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86374 and previous config saved to /var/cache/conftool/dbconfig/20251203-130002-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T13:04:38Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2227 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86375 and previous config saved to /var/cache/conftool/dbconfig/20251203-130437-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2025-12-03T13:50:01Z] <marostegui@cumin1003> dbctl commit (dc=all): 'Repooling after maintenance db2227 (T411163 T411164)', diff saved to https://phabricator.wikimedia.org/P86380 and previous config saved to /var/cache/conftool/dbconfig/20251203-135000-marostegui.json