Page MenuHomePhabricator

Rebuild pagelinks tables
Closed, ResolvedPublic

Description

Due to some sporadic corruption on s3 and s1 on some of the indexes, let's run the following on all wikis

alter table pagelinks engine=innodb,force

This should be run as a normal schema change with replication disabled (enabled for sanitarium masters)

Progress

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

Details

TitleReferenceAuthorSource BranchDest Branch
optimize_table: New directoryrepos/sre/schema-changes!12marosteguioptimizemain
rebuild_pagelinks_T364069.py: Schema changerepos/sre/schema-changes!10marosteguiT364069main
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) [2024-07-02T18:54:43Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T364069)', diff saved to https://phabricator.wikimedia.org/P65671 and previous config saved to /var/cache/conftool/dbconfig/20240702-185443-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-02T19:40:05Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T364069)', diff saved to https://phabricator.wikimedia.org/P65674 and previous config saved to /var/cache/conftool/dbconfig/20240702-194005-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-02T19:40:28Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2188 (T364069)', diff saved to https://phabricator.wikimedia.org/P65675 and previous config saved to /var/cache/conftool/dbconfig/20240702-194027-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-02T22:13:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T364069)', diff saved to https://phabricator.wikimedia.org/P65676 and previous config saved to /var/cache/conftool/dbconfig/20240702-221312-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-02T22:58:36Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T364069)', diff saved to https://phabricator.wikimedia.org/P65679 and previous config saved to /var/cache/conftool/dbconfig/20240702-225835-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T01:17:01Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2203 (T364069)', diff saved to https://phabricator.wikimedia.org/P65684 and previous config saved to /var/cache/conftool/dbconfig/20240703-011701-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T03:47:51Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2203 (T364069)', diff saved to https://phabricator.wikimedia.org/P65685 and previous config saved to /var/cache/conftool/dbconfig/20240703-034751-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T04:33:13Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2203 (T364069)', diff saved to https://phabricator.wikimedia.org/P65688 and previous config saved to /var/cache/conftool/dbconfig/20240703-043312-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T04:33:35Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db2216 (T364069)', diff saved to https://phabricator.wikimedia.org/P65689 and previous config saved to /var/cache/conftool/dbconfig/20240703-043335-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T06:58:00Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2216 (T364069)', diff saved to https://phabricator.wikimedia.org/P65701 and previous config saved to /var/cache/conftool/dbconfig/20240703-065759-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T07:43:21Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2216 (T364069)', diff saved to https://phabricator.wikimedia.org/P65705 and previous config saved to /var/cache/conftool/dbconfig/20240703-074321-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T07:52:46Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1169 (T364069)', diff saved to https://phabricator.wikimedia.org/P65706 and previous config saved to /var/cache/conftool/dbconfig/20240703-075245-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T11:06:28Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T364069)', diff saved to https://phabricator.wikimedia.org/P65711 and previous config saved to /var/cache/conftool/dbconfig/20240703-110627-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T11:51:50Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T364069)', diff saved to https://phabricator.wikimedia.org/P65717 and previous config saved to /var/cache/conftool/dbconfig/20240703-115149-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T11:52:11Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1184 (T364069)', diff saved to https://phabricator.wikimedia.org/P65718 and previous config saved to /var/cache/conftool/dbconfig/20240703-115211-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T15:01:21Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T364069)', diff saved to https://phabricator.wikimedia.org/P65734 and previous config saved to /var/cache/conftool/dbconfig/20240703-150121-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T15:46:44Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T364069)', diff saved to https://phabricator.wikimedia.org/P65749 and previous config saved to /var/cache/conftool/dbconfig/20240703-154643-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T15:47:17Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1186 (T364069)', diff saved to https://phabricator.wikimedia.org/P65750 and previous config saved to /var/cache/conftool/dbconfig/20240703-154716-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T18:55:12Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T364069)', diff saved to https://phabricator.wikimedia.org/P65759 and previous config saved to /var/cache/conftool/dbconfig/20240703-185511-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T19:40:34Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T364069)', diff saved to https://phabricator.wikimedia.org/P65765 and previous config saved to /var/cache/conftool/dbconfig/20240703-194033-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T19:40:56Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1195 (T364069)', diff saved to https://phabricator.wikimedia.org/P65766 and previous config saved to /var/cache/conftool/dbconfig/20240703-194055-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T22:37:00Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1195 (T364069)', diff saved to https://phabricator.wikimedia.org/P65769 and previous config saved to /var/cache/conftool/dbconfig/20240703-223659-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T23:22:21Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1195 (T364069)', diff saved to https://phabricator.wikimedia.org/P65775 and previous config saved to /var/cache/conftool/dbconfig/20240703-232221-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-03T23:23:02Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1196 (T364069)', diff saved to https://phabricator.wikimedia.org/P65776 and previous config saved to /var/cache/conftool/dbconfig/20240703-232302-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T02:26:09Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T364069)', diff saved to https://phabricator.wikimedia.org/P65781 and previous config saved to /var/cache/conftool/dbconfig/20240704-022608-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T03:11:30Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T364069)', diff saved to https://phabricator.wikimedia.org/P65784 and previous config saved to /var/cache/conftool/dbconfig/20240704-031129-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T03:11:52Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1206 (T364069)', diff saved to https://phabricator.wikimedia.org/P65785 and previous config saved to /var/cache/conftool/dbconfig/20240704-031151-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T06:15:17Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T364069)', diff saved to https://phabricator.wikimedia.org/P65790 and previous config saved to /var/cache/conftool/dbconfig/20240704-061517-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T07:00:39Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T364069)', diff saved to https://phabricator.wikimedia.org/P65793 and previous config saved to /var/cache/conftool/dbconfig/20240704-070038-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T07:01:01Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1207 (T364069)', diff saved to https://phabricator.wikimedia.org/P65794 and previous config saved to /var/cache/conftool/dbconfig/20240704-070100-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T10:06:22Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1207 (T364069)', diff saved to https://phabricator.wikimedia.org/P65797 and previous config saved to /var/cache/conftool/dbconfig/20240704-100622-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T10:51:44Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1207 (T364069)', diff saved to https://phabricator.wikimedia.org/P65800 and previous config saved to /var/cache/conftool/dbconfig/20240704-105143-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T10:52:06Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1218 (T364069)', diff saved to https://phabricator.wikimedia.org/P65801 and previous config saved to /var/cache/conftool/dbconfig/20240704-105205-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T13:48:07Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1218 (T364069)', diff saved to https://phabricator.wikimedia.org/P65824 and previous config saved to /var/cache/conftool/dbconfig/20240704-134806-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T14:33:28Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1218 (T364069)', diff saved to https://phabricator.wikimedia.org/P65829 and previous config saved to /var/cache/conftool/dbconfig/20240704-143327-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T14:33:50Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1219 (T364069)', diff saved to https://phabricator.wikimedia.org/P65830 and previous config saved to /var/cache/conftool/dbconfig/20240704-143350-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T17:37:35Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T364069)', diff saved to https://phabricator.wikimedia.org/P65831 and previous config saved to /var/cache/conftool/dbconfig/20240704-173735-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T18:22:57Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T364069)', diff saved to https://phabricator.wikimedia.org/P65834 and previous config saved to /var/cache/conftool/dbconfig/20240704-182257-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T18:23:09Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1232 (T364069)', diff saved to https://phabricator.wikimedia.org/P65835 and previous config saved to /var/cache/conftool/dbconfig/20240704-182308-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T21:16:44Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1232 (T364069)', diff saved to https://phabricator.wikimedia.org/P65836 and previous config saved to /var/cache/conftool/dbconfig/20240704-211644-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T22:02:06Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1232 (T364069)', diff saved to https://phabricator.wikimedia.org/P65839 and previous config saved to /var/cache/conftool/dbconfig/20240704-220205-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-04T22:02:27Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1234 (T364069)', diff saved to https://phabricator.wikimedia.org/P65840 and previous config saved to /var/cache/conftool/dbconfig/20240704-220227-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-05T00:47:07Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1234 (T364069)', diff saved to https://phabricator.wikimedia.org/P65841 and previous config saved to /var/cache/conftool/dbconfig/20240705-004707-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-05T01:32:29Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1234 (T364069)', diff saved to https://phabricator.wikimedia.org/P65844 and previous config saved to /var/cache/conftool/dbconfig/20240705-013229-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-05T01:32:51Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Depooling db1235 (T364069)', diff saved to https://phabricator.wikimedia.org/P65845 and previous config saved to /var/cache/conftool/dbconfig/20240705-013250-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-05T04:26:42Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1235 (T364069)', diff saved to https://phabricator.wikimedia.org/P65846 and previous config saved to /var/cache/conftool/dbconfig/20240705-042641-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2024-07-05T05:12:03Z] <marostegui@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1235 (T364069)', diff saved to https://phabricator.wikimedia.org/P65852 and previous config saved to /var/cache/conftool/dbconfig/20240705-051202-marostegui.json

Marostegui updated the task description. (Show Details)

This is done