Page MenuHomePhabricator
Create Task
Maniphest T411164

Drop rev_sha1 from revision table in wmf production
Open, MediumPublic
Actions

Description

  1. ALTER to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1207216/5/sql/mysql/patch-revision-drop-rev_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
  • s2
  • s3
    •  codfw
    •  eqiad
  • s4
  • s5
    •  codfw
    •  eqiad
  • s6
    •  codfw
    •  eqiad
  • s7
  • s8
  • Puppet patch

Details

Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
drop_rev_sha1_T411164.py: New schema changerepos/sre/schema-changes!54marosteguiT411164_2main
drop_rev_sha1_T411164.py: New schema changerepos/sre/schema-changes!53marosteguiT411164main
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.Mon, Dec 1, 9:40 PM

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

Stashbot added a comment.Mon, Dec 1, 9:42 PM

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

Stashbot added a comment.Mon, Dec 1, 10:25 PM

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

Stashbot added a comment.Mon, Dec 1, 10:26 PM

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

Stashbot added a comment.Mon, Dec 1, 10:28 PM

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

Stashbot added a comment.Tue, Dec 2, 1:36 AM

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

Stashbot added a comment.Tue, Dec 2, 3:06 AM

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

Stashbot added a comment.Tue, Dec 2, 3:51 AM

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

Stashbot added a comment.Tue, Dec 2, 3:52 AM

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

Stashbot added a comment.Tue, Dec 2, 4:34 AM

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

Stashbot added a comment.Tue, Dec 2, 5:19 AM

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

Stashbot added a comment.Tue, Dec 2, 5:20 AM

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

• Marostegui updated the task description. (Show Details)Tue, Dec 2, 6:31 AM
• Marostegui updated the task description. (Show Details)
• Marostegui updated the task description. (Show Details)Tue, Dec 2, 6:47 AM
• Marostegui updated the task description. (Show Details)Tue, Dec 2, 6:56 AM
Stashbot added a comment.Tue, Dec 2, 8:18 AM

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

Stashbot added a comment.Tue, Dec 2, 8:23 AM

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

Stashbot added a comment.Tue, Dec 2, 9:03 AM

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

Stashbot added a comment.Tue, Dec 2, 9:03 AM

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

Stashbot added a comment.Tue, Dec 2, 9:09 AM

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

Stashbot added a comment.Tue, Dec 2, 9:09 AM

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

Stashbot added a comment.Tue, Dec 2, 9:49 AM

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

• Marostegui updated the task description. (Show Details)Tue, Dec 2, 11:35 AM
• Marostegui updated the task description. (Show Details)
Stashbot added a comment.Tue, Dec 2, 11:36 AM

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

Stashbot added a comment.Tue, Dec 2, 1:56 PM

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

Stashbot added a comment.Tue, Dec 2, 2:41 PM

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

Stashbot added a comment.Tue, Dec 2, 2:41 PM

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

Stashbot added a comment.Tue, Dec 2, 4:57 PM

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

Stashbot added a comment.Tue, Dec 2, 5:42 PM

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

Stashbot added a comment.Tue, Dec 2, 5:42 PM

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

Stashbot added a comment.Tue, Dec 2, 5:47 PM

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

Stashbot added a comment.Tue, Dec 2, 10:06 PM

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

Stashbot added a comment.Tue, Dec 2, 10:51 PM

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

Stashbot added a comment.Tue, Dec 2, 10:58 PM

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

Stashbot added a comment.Tue, Dec 2, 11:43 PM

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

Stashbot added a comment.Tue, Dec 2, 11:43 PM

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

• Marostegui updated the task description. (Show Details)Wed, Dec 3, 4:56 AM
Stashbot added a comment.Wed, Dec 3, 4:58 AM

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

Stashbot added a comment.Wed, Dec 3, 5:44 AM

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

Stashbot added a comment.Wed, Dec 3, 5:44 AM

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

Stashbot added a comment.Wed, Dec 3, 10:33 AM

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

Stashbot added a comment.Wed, Dec 3, 11:18 AM

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

Stashbot added a comment.Wed, Dec 3, 11:19 AM

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

Stashbot added a comment.Wed, Dec 3, 11:23 AM

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

Stashbot added a comment.Wed, Dec 3, 12:09 PM

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

Stashbot added a comment.Wed, Dec 3, 12:09 PM

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

Stashbot added a comment.Wed, Dec 3, 12:14 PM

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

Stashbot added a comment.Wed, Dec 3, 12:59 PM

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

Stashbot added a comment.Wed, Dec 3, 1:00 PM

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

Stashbot added a comment.Wed, Dec 3, 1:04 PM

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

Stashbot added a comment.Wed, Dec 3, 1:50 PM

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

• Marostegui updated the task description. (Show Details)Wed, Dec 3, 3:06 PM
• Marostegui updated the task description. (Show Details)Thu, Dec 4, 5:53 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