Page MenuHomePhabricator
Create Task
Maniphest T367856

Cleanup revision table schema
Open, LowPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/924468/9/maintenance/archives/patch-revision-cleanup.sql
  2. Where to run those changes: all
  3. When to run those changes: When DBA has time
  4. If the schema change is backwards compatible: Yes.
  5. If the schema change has been tested already on some of the test/beta wikis: Is stable on betacluster
  6. If the data should be made available on the labs replicas and/or dumps: No changes needed

Progress

  • s1
  • s2
    • eqiad ()
    • codfw (running)
  • s3
  • s4
  • s5
  • s6
    • eqiad (pending master)
    • codfw (pending master)
  • s7
  • s8
  • labtestwiki

Details

TitleReferenceAuthorSource BranchDest Branch
change_revision_rev_id_T367856.py: New schema changerepos/sre/schema-changes!20marosteguiT367856main
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.Fri, Jun 21, 2:10 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-21T14:10:50Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2217 (T367856)', diff saved to https://phabricator.wikimedia.org/P65314 and previous config saved to /var/cache/conftool/dbconfig/20240621-141050-marostegui.json

VirginiaPoundstone moved this task from Incoming to To be discussed on the Data Products board.Fri, Jun 21, 4:22 PM
VirginiaPoundstone moved this task from To be discussed to Incoming on the Data Products board.Fri, Jun 21, 4:28 PM
Stashbot added a comment.Fri, Jun 21, 8:49 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-21T20:49:42Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2217 (T367856)', diff saved to https://phabricator.wikimedia.org/P65330 and previous config saved to /var/cache/conftool/dbconfig/20240621-204941-marostegui.json

Stashbot added a comment.Fri, Jun 21, 9:35 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-21T21:35:03Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2217 (T367856)', diff saved to https://phabricator.wikimedia.org/P65333 and previous config saved to /var/cache/conftool/dbconfig/20240621-213503-marostegui.json

Marostegui updated the task description. (Show Details)Sun, Jun 23, 6:03 AM
Stashbot added a comment.Sun, Jun 23, 6:05 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T06:05:21Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1165 (T367856)', diff saved to https://phabricator.wikimedia.org/P65354 and previous config saved to /var/cache/conftool/dbconfig/20240623-060520-marostegui.json

Stashbot added a comment.Sun, Jun 23, 8:42 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T08:42:51Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1165 (T367856)', diff saved to https://phabricator.wikimedia.org/P65355 and previous config saved to /var/cache/conftool/dbconfig/20240623-084250-marostegui.json

Stashbot added a comment.Sun, Jun 23, 9:28 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T09:28:12Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1165 (T367856)', diff saved to https://phabricator.wikimedia.org/P65358 and previous config saved to /var/cache/conftool/dbconfig/20240623-092811-marostegui.json

Stashbot added a comment.Sun, Jun 23, 9:28 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T09:28:33Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1168 (T367856)', diff saved to https://phabricator.wikimedia.org/P65359 and previous config saved to /var/cache/conftool/dbconfig/20240623-092833-marostegui.json

Stashbot added a comment.Sun, Jun 23, 11:59 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T11:59:38Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T367856)', diff saved to https://phabricator.wikimedia.org/P65360 and previous config saved to /var/cache/conftool/dbconfig/20240623-115938-marostegui.json

Stashbot added a comment.Sun, Jun 23, 12:45 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T12:45:01Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T367856)', diff saved to https://phabricator.wikimedia.org/P65363 and previous config saved to /var/cache/conftool/dbconfig/20240623-124459-marostegui.json

Stashbot added a comment.Sun, Jun 23, 12:45 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T12:45:22Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1173 (T367856)', diff saved to https://phabricator.wikimedia.org/P65364 and previous config saved to /var/cache/conftool/dbconfig/20240623-124522-marostegui.json

Stashbot added a comment.Sun, Jun 23, 3:27 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T15:27:00Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1173 (T367856)', diff saved to https://phabricator.wikimedia.org/P65365 and previous config saved to /var/cache/conftool/dbconfig/20240623-152700-marostegui.json

Stashbot added a comment.Sun, Jun 23, 4:12 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T16:12:22Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1173 (T367856)', diff saved to https://phabricator.wikimedia.org/P65368 and previous config saved to /var/cache/conftool/dbconfig/20240623-161221-marostegui.json

Stashbot added a comment.Sun, Jun 23, 4:12 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T16:12:43Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1180 (T367856)', diff saved to https://phabricator.wikimedia.org/P65369 and previous config saved to /var/cache/conftool/dbconfig/20240623-161243-marostegui.json

Stashbot added a comment.Sun, Jun 23, 6:47 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T18:47:23Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T367856)', diff saved to https://phabricator.wikimedia.org/P65370 and previous config saved to /var/cache/conftool/dbconfig/20240623-184722-marostegui.json

Stashbot added a comment.Sun, Jun 23, 7:32 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T19:32:45Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T367856)', diff saved to https://phabricator.wikimedia.org/P65373 and previous config saved to /var/cache/conftool/dbconfig/20240623-193244-marostegui.json

Stashbot added a comment.Sun, Jun 23, 7:33 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T19:33:07Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1187 (T367856)', diff saved to https://phabricator.wikimedia.org/P65374 and previous config saved to /var/cache/conftool/dbconfig/20240623-193306-marostegui.json

Stashbot added a comment.Sun, Jun 23, 10:04 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T22:04:26Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1187 (T367856)', diff saved to https://phabricator.wikimedia.org/P65375 and previous config saved to /var/cache/conftool/dbconfig/20240623-220426-marostegui.json

Stashbot added a comment.Sun, Jun 23, 10:49 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T22:49:46Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1187 (T367856)', diff saved to https://phabricator.wikimedia.org/P65378 and previous config saved to /var/cache/conftool/dbconfig/20240623-224946-marostegui.json

Stashbot added a comment.Sun, Jun 23, 10:50 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-23T22:50:08Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1201 (T367856)', diff saved to https://phabricator.wikimedia.org/P65379 and previous config saved to /var/cache/conftool/dbconfig/20240623-225008-marostegui.json

Stashbot added a comment.Mon, Jun 24, 1:13 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-24T01:13:16Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1201 (T367856)', diff saved to https://phabricator.wikimedia.org/P65380 and previous config saved to /var/cache/conftool/dbconfig/20240624-011315-marostegui.json

Stashbot added a comment.Mon, Jun 24, 1:58 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-24T01:58:37Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1201 (T367856)', diff saved to https://phabricator.wikimedia.org/P65383 and previous config saved to /var/cache/conftool/dbconfig/20240624-015836-marostegui.json

Stashbot added a comment.Mon, Jun 24, 1:59 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-24T01:58:59Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1224 (T367856)', diff saved to https://phabricator.wikimedia.org/P65384 and previous config saved to /var/cache/conftool/dbconfig/20240624-015859-marostegui.json

Stashbot added a comment.Mon, Jun 24, 4:17 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-24T04:17:48Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T367856)', diff saved to https://phabricator.wikimedia.org/P65385 and previous config saved to /var/cache/conftool/dbconfig/20240624-041747-marostegui.json

Stashbot added a comment.Mon, Jun 24, 5:03 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-24T05:03:09Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T367856)', diff saved to https://phabricator.wikimedia.org/P65388 and previous config saved to /var/cache/conftool/dbconfig/20240624-050309-marostegui.json

VirginiaPoundstone moved this task from Incoming to Radar (other teams) on the Data Products board.Mon, Jun 24, 6:45 PM
VirginiaPoundstone moved this task from Radar (other teams) to To be discussed on the Data Products board.
Marostegui updated the task description. (Show Details)Tue, Jun 25, 5:20 AM
Stashbot added a comment.Tue, Jun 25, 5:32 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-25T05:32:40Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2125 (T367856)', diff saved to https://phabricator.wikimedia.org/P65394 and previous config saved to /var/cache/conftool/dbconfig/20240625-053239-marostegui.json

Marostegui updated the task description. (Show Details)Tue, Jun 25, 6:05 AM
TheDJ mentioned this in T368364: Transcodes of audio-only samples are not running for new uploads.Tue, Jun 25, 12:58 PM
Stashbot added a comment.Tue, Jun 25, 6:43 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-25T18:43:49Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2125 (T367856)', diff saved to https://phabricator.wikimedia.org/P65425 and previous config saved to /var/cache/conftool/dbconfig/20240625-184349-marostegui.json

Stashbot added a comment.Tue, Jun 25, 7:29 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-25T19:29:11Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2125 (T367856)', diff saved to https://phabricator.wikimedia.org/P65429 and previous config saved to /var/cache/conftool/dbconfig/20240625-192910-marostegui.json

Stashbot added a comment.Tue, Jun 25, 7:29 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-25T19:29:48Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2126 (T367856)', diff saved to https://phabricator.wikimedia.org/P65430 and previous config saved to /var/cache/conftool/dbconfig/20240625-192947-marostegui.json

Stashbot added a comment.Tue, Jun 25, 11:35 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-25T23:35:20Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2126 (T367856)', diff saved to https://phabricator.wikimedia.org/P65436 and previous config saved to /var/cache/conftool/dbconfig/20240625-233520-marostegui.json

Stashbot added a comment.Wed, Jun 26, 12:20 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-26T00:20:41Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2126 (T367856)', diff saved to https://phabricator.wikimedia.org/P65439 and previous config saved to /var/cache/conftool/dbconfig/20240626-002041-marostegui.json

Stashbot added a comment.Wed, Jun 26, 12:21 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-26T00:21:04Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2138 (T367856)', diff saved to https://phabricator.wikimedia.org/P65440 and previous config saved to /var/cache/conftool/dbconfig/20240626-002103-marostegui.json

Stashbot added a comment.Wed, Jun 26, 11:26 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-26T11:26:14Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2138 (T367856)', diff saved to https://phabricator.wikimedia.org/P65467 and previous config saved to /var/cache/conftool/dbconfig/20240626-112614-marostegui.json

Stashbot added a comment.Wed, Jun 26, 12:11 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-26T12:11:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2138 (T367856)', diff saved to https://phabricator.wikimedia.org/P65470 and previous config saved to /var/cache/conftool/dbconfig/20240626-121136-marostegui.json

Stashbot added a comment.Wed, Jun 26, 12:11 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-26T12:11:58Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2148 (T367856)', diff saved to https://phabricator.wikimedia.org/P65471 and previous config saved to /var/cache/conftool/dbconfig/20240626-121158-marostegui.json

Milimetric subscribed.Wed, Jun 26, 3:57 PM

Thanks for pinging us on this. The sqoop code should run without modification, so we're good downstream. Thank you!

Stashbot added a comment.Thu, Jun 27, 12:10 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-27T00:10:29Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2148 (T367856)', diff saved to https://phabricator.wikimedia.org/P65498 and previous config saved to /var/cache/conftool/dbconfig/20240627-001028-marostegui.json

Stashbot added a comment.Thu, Jun 27, 12:55 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-27T00:55:51Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2148 (T367856)', diff saved to https://phabricator.wikimedia.org/P65501 and previous config saved to /var/cache/conftool/dbconfig/20240627-005549-marostegui.json

Stashbot added a comment.Thu, Jun 27, 12:56 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-27T00:56:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2175 (T367856)', diff saved to https://phabricator.wikimedia.org/P65502 and previous config saved to /var/cache/conftool/dbconfig/20240627-005613-marostegui.json

Stashbot added a comment.Thu, Jun 27, 12:04 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-27T12:04:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2175 (T367856)', diff saved to https://phabricator.wikimedia.org/P65522 and previous config saved to /var/cache/conftool/dbconfig/20240627-120435-marostegui.json

Stashbot added a comment.Thu, Jun 27, 12:49 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-27T12:49:58Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2175 (T367856)', diff saved to https://phabricator.wikimedia.org/P65528 and previous config saved to /var/cache/conftool/dbconfig/20240627-124957-marostegui.json

Stashbot added a comment.Thu, Jun 27, 12:50 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-27T12:50:20Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2189 (T367856)', diff saved to https://phabricator.wikimedia.org/P65529 and previous config saved to /var/cache/conftool/dbconfig/20240627-125019-marostegui.json

Stashbot added a comment.Thu, Jun 27, 10:31 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-27T22:31:43Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2189 (T367856)', diff saved to https://phabricator.wikimedia.org/P65539 and previous config saved to /var/cache/conftool/dbconfig/20240627-223142-marostegui.json

Stashbot added a comment.Thu, Jun 27, 11:17 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-27T23:17:04Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2189 (T367856)', diff saved to https://phabricator.wikimedia.org/P65542 and previous config saved to /var/cache/conftool/dbconfig/20240627-231703-marostegui.json

Stashbot added a comment.Fri, Jun 28, 8:29 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-28T08:29:46Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2204 (T367856)', diff saved to https://phabricator.wikimedia.org/P65543 and previous config saved to /var/cache/conftool/dbconfig/20240628-082946-marostegui.json

Stashbot added a comment.Fri, Jun 28, 12:14 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-28T12:14:05Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2204 (T367856)', diff saved to https://phabricator.wikimedia.org/P65544 and previous config saved to /var/cache/conftool/dbconfig/20240628-121404-marostegui.json

Stashbot added a comment.Fri, Jun 28, 12:59 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-28T12:59:27Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2204 (T367856)', diff saved to https://phabricator.wikimedia.org/P65547 and previous config saved to /var/cache/conftool/dbconfig/20240628-125926-marostegui.json

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