Page MenuHomePhabricator
Create Task
Maniphest T367261

Rebuild recentchanges table everywhere
Closed, ResolvedPublic
Actions

Description

The recent schema changes on the recentchanges tables is revealing some random index corruptions across some sections. We should rebuild the table everywhere to make sure those are gone.
s3 seems to be the most affected (also it has the biggest number of recentchanges tables).

Progress

  • s1
  • s2
    • eqiad
    • codfw
  • s3
  • s4
    • eqiad
    • codfw
  • s5
  • s6
  • s7
    • eqiad
    • codfw
  • s8

Details

TitleReferenceAuthorSource BranchDest Branch
optimize_recentchanges.py: Optimize this tablerepos/sre/schema-changes!19marosteguiT367261main
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 14, 9:58 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T09:58:10Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2128 (T367261)', diff saved to https://phabricator.wikimedia.org/P64939 and previous config saved to /var/cache/conftool/dbconfig/20240614-095809-marostegui.json

Stashbot added a comment.Fri, Jun 14, 10:43 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T10:43:30Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2128 (T367261)', diff saved to https://phabricator.wikimedia.org/P64942 and previous config saved to /var/cache/conftool/dbconfig/20240614-104330-marostegui.json

Stashbot added a comment.Fri, Jun 14, 10:43 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T10:43:52Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2157 (T367261)', diff saved to https://phabricator.wikimedia.org/P64943 and previous config saved to /var/cache/conftool/dbconfig/20240614-104352-marostegui.json

Stashbot added a comment.Fri, Jun 14, 10:47 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T10:47:42Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2157 (T367261)', diff saved to https://phabricator.wikimedia.org/P64945 and previous config saved to /var/cache/conftool/dbconfig/20240614-104742-marostegui.json

Stashbot added a comment.Fri, Jun 14, 11:33 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T11:33:03Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2157 (T367261)', diff saved to https://phabricator.wikimedia.org/P64949 and previous config saved to /var/cache/conftool/dbconfig/20240614-113303-marostegui.json

Stashbot added a comment.Fri, Jun 14, 11:33 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T11:33:26Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2171 (T367261)', diff saved to https://phabricator.wikimedia.org/P64950 and previous config saved to /var/cache/conftool/dbconfig/20240614-113325-marostegui.json

Stashbot added a comment.Fri, Jun 14, 11:37 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T11:37:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2171 (T367261)', diff saved to https://phabricator.wikimedia.org/P64952 and previous config saved to /var/cache/conftool/dbconfig/20240614-113712-marostegui.json

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

Mentioned in SAL (#wikimedia-operations) [2024-06-14T12:22:34Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2171 (T367261)', diff saved to https://phabricator.wikimedia.org/P64962 and previous config saved to /var/cache/conftool/dbconfig/20240614-122233-marostegui.json

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

Mentioned in SAL (#wikimedia-operations) [2024-06-14T12:22:56Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2178 (T367261)', diff saved to https://phabricator.wikimedia.org/P64963 and previous config saved to /var/cache/conftool/dbconfig/20240614-122255-marostegui.json

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

Mentioned in SAL (#wikimedia-operations) [2024-06-14T12:25:30Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2178 (T367261)', diff saved to https://phabricator.wikimedia.org/P64964 and previous config saved to /var/cache/conftool/dbconfig/20240614-122530-marostegui.json

Stashbot added a comment.Fri, Jun 14, 1:10 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T13:10:51Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2178 (T367261)', diff saved to https://phabricator.wikimedia.org/P64968 and previous config saved to /var/cache/conftool/dbconfig/20240614-131051-marostegui.json

Stashbot added a comment.Fri, Jun 14, 1:11 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T13:11:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2192 (T367261)', diff saved to https://phabricator.wikimedia.org/P64969 and previous config saved to /var/cache/conftool/dbconfig/20240614-131113-marostegui.json

Stashbot added a comment.Fri, Jun 14, 1:13 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T13:13:40Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2192 (T367261)', diff saved to https://phabricator.wikimedia.org/P64970 and previous config saved to /var/cache/conftool/dbconfig/20240614-131339-marostegui.json

Stashbot added a comment.Fri, Jun 14, 1:59 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T13:59:00Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2192 (T367261)', diff saved to https://phabricator.wikimedia.org/P64973 and previous config saved to /var/cache/conftool/dbconfig/20240614-135900-marostegui.json

Stashbot added a comment.Fri, Jun 14, 2:01 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T14:01:25Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2211 (T367261)', diff saved to https://phabricator.wikimedia.org/P64974 and previous config saved to /var/cache/conftool/dbconfig/20240614-140125-marostegui.json

Stashbot added a comment.Fri, Jun 14, 2:04 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T14:04:05Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2211 (T367261)', diff saved to https://phabricator.wikimedia.org/P64975 and previous config saved to /var/cache/conftool/dbconfig/20240614-140404-marostegui.json

Stashbot added a comment.Fri, Jun 14, 2:49 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-14T14:49:26Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2211 (T367261)', diff saved to https://phabricator.wikimedia.org/P64979 and previous config saved to /var/cache/conftool/dbconfig/20240614-144925-marostegui.json

Marostegui updated the task description. (Show Details)Sat, Jun 15, 5:01 AM
Marostegui updated the task description. (Show Details)
Marostegui updated the task description. (Show Details)
Stashbot added a comment.Sat, Jun 15, 5:02 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-15T05:02:37Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1158 (T367261)', diff saved to https://phabricator.wikimedia.org/P65002 and previous config saved to /var/cache/conftool/dbconfig/20240615-050236-marostegui.json

Stashbot added a comment.Sat, Jun 15, 5:33 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-15T05:33:47Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T367261)', diff saved to https://phabricator.wikimedia.org/P65003 and previous config saved to /var/cache/conftool/dbconfig/20240615-053346-marostegui.json

Stashbot added a comment.Sat, Jun 15, 6:19 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-15T06:19:08Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T367261)', diff saved to https://phabricator.wikimedia.org/P65006 and previous config saved to /var/cache/conftool/dbconfig/20240615-061908-marostegui.json

Stashbot added a comment.Sat, Jun 15, 6:19 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-15T06:19:19Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1170 (T367261)', diff saved to https://phabricator.wikimedia.org/P65007 and previous config saved to /var/cache/conftool/dbconfig/20240615-061919-marostegui.json

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

Mentioned in SAL (#wikimedia-operations) [2024-06-17T05:03:24Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2122 (T367261)', diff saved to https://phabricator.wikimedia.org/P65054 and previous config saved to /var/cache/conftool/dbconfig/20240617-050324-marostegui.json

Stashbot added a comment.Mon, Jun 17, 5:08 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T05:08:53Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2125 (T367261)', diff saved to https://phabricator.wikimedia.org/P65057 and previous config saved to /var/cache/conftool/dbconfig/20240617-050852-marostegui.json

Marostegui updated the task description. (Show Details)Mon, Jun 17, 5:11 AM
Stashbot added a comment.Mon, Jun 17, 5:18 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T05:18:05Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2125 (T367261)', diff saved to https://phabricator.wikimedia.org/P65059 and previous config saved to /var/cache/conftool/dbconfig/20240617-051805-marostegui.json

Marostegui updated the task description. (Show Details)Mon, Jun 17, 5:34 AM
Stashbot added a comment.Mon, Jun 17, 6:03 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T06:03:26Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2125 (T367261)', diff saved to https://phabricator.wikimedia.org/P65068 and previous config saved to /var/cache/conftool/dbconfig/20240617-060326-marostegui.json

Stashbot added a comment.Mon, Jun 17, 6:03 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T06:03:54Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2126 (T367261)', diff saved to https://phabricator.wikimedia.org/P65069 and previous config saved to /var/cache/conftool/dbconfig/20240617-060352-marostegui.json

Stashbot added a comment.Mon, Jun 17, 6:08 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T06:08:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2126 (T367261)', diff saved to https://phabricator.wikimedia.org/P65070 and previous config saved to /var/cache/conftool/dbconfig/20240617-060812-marostegui.json

Marostegui updated the task description. (Show Details)Mon, Jun 17, 6:18 AM
Marostegui updated the task description. (Show Details)Mon, Jun 17, 6:23 AM
Marostegui updated the task description. (Show Details)Mon, Jun 17, 6:26 AM
Stashbot added a comment.Mon, Jun 17, 6:53 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T06:53:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2126 (T367261)', diff saved to https://phabricator.wikimedia.org/P65081 and previous config saved to /var/cache/conftool/dbconfig/20240617-065335-marostegui.json

Stashbot added a comment.Mon, Jun 17, 6:53 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T06:53:58Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2138 (T367261)', diff saved to https://phabricator.wikimedia.org/P65082 and previous config saved to /var/cache/conftool/dbconfig/20240617-065357-marostegui.json

Stashbot added a comment.Mon, Jun 17, 7:00 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T07:00:10Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2138 (T367261)', diff saved to https://phabricator.wikimedia.org/P65085 and previous config saved to /var/cache/conftool/dbconfig/20240617-070009-marostegui.json

Marostegui updated the task description. (Show Details)Mon, Jun 17, 7:06 AM
Stashbot added a comment.Mon, Jun 17, 7:45 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T07:45:31Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2138 (T367261)', diff saved to https://phabricator.wikimedia.org/P65088 and previous config saved to /var/cache/conftool/dbconfig/20240617-074530-marostegui.json

Stashbot added a comment.Mon, Jun 17, 7:45 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T07:45:42Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2148 (T367261)', diff saved to https://phabricator.wikimedia.org/P65089 and previous config saved to /var/cache/conftool/dbconfig/20240617-074542-marostegui.json

Stashbot added a comment.Mon, Jun 17, 7:52 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T07:52:35Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2148 (T367261)', diff saved to https://phabricator.wikimedia.org/P65090 and previous config saved to /var/cache/conftool/dbconfig/20240617-075234-marostegui.json

Stashbot added a comment.Mon, Jun 17, 8:38 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T08:37:59Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2148 (T367261)', diff saved to https://phabricator.wikimedia.org/P65093 and previous config saved to /var/cache/conftool/dbconfig/20240617-083755-marostegui.json

Stashbot added a comment.Mon, Jun 17, 8:49 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T08:49:07Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2189 (T367261)', diff saved to https://phabricator.wikimedia.org/P65094 and previous config saved to /var/cache/conftool/dbconfig/20240617-084906-marostegui.json

Stashbot added a comment.Mon, Jun 17, 9:34 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T09:34:28Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2189 (T367261)', diff saved to https://phabricator.wikimedia.org/P65100 and previous config saved to /var/cache/conftool/dbconfig/20240617-093427-marostegui.json

Stashbot added a comment.Mon, Jun 17, 9:40 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T09:40:35Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2204 (T367261)', diff saved to https://phabricator.wikimedia.org/P65101 and previous config saved to /var/cache/conftool/dbconfig/20240617-094034-marostegui.json

Stashbot added a comment.Mon, Jun 17, 9:44 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T09:44:18Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2204 (T367261)', diff saved to https://phabricator.wikimedia.org/P65102 and previous config saved to /var/cache/conftool/dbconfig/20240617-094417-marostegui.json

Stashbot added a comment.Mon, Jun 17, 10:29 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T10:29:39Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2204 (T367261)', diff saved to https://phabricator.wikimedia.org/P65107 and previous config saved to /var/cache/conftool/dbconfig/20240617-102938-marostegui.json

Marostegui updated the task description. (Show Details)Tue, Jun 18, 5:00 AM
Marostegui updated the task description. (Show Details)Tue, Jun 18, 5:18 AM
Stashbot added a comment.Tue, Jun 18, 7:12 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-18T07:12:51Z] <marostegui> dbmaint codfw s4 deploy schema change T367261

Marostegui updated the task description. (Show Details)Tue, Jun 18, 7:14 AM
Marostegui updated the task description. (Show Details)Tue, Jun 18, 8:50 AM
Marostegui updated the task description. (Show Details)Tue, Jun 18, 9:09 AM
Stashbot added a comment.Tue, Jun 18, 9:10 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-18T09:10:52Z] <marostegui> dbmaint eqiad s4 deploy schema change T367261

Marostegui updated the task description. (Show Details)Tue, Jun 18, 11:17 AM
Marostegui updated the task description. (Show Details)Tue, Jun 18, 11:21 AM
Marostegui closed this task as Resolved.Tue, Jun 18, 11:52 AM
Marostegui updated the task description. (Show Details)

This is completed

Maintenance_bot moved this task from In progress to Done on the DBA board.Tue, Jun 18, 12:29 PM
jcrespo closed subtask T367162: db1240.s3 index issues as Resolved.Fri, Jun 21, 12:00 PM
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