Page MenuHomePhabricator
Create Task
Maniphest T352010

Gradually drop old pagelinks columns
Open, Needs TriagePublic
Actions

Description

Steps to drop the columns:

  • Make sure maintenance has finished and data has been migrated
  • Change PK:
ALTER TABLE pagelinks DROP PRIMARY KEY, ADD PRIMARY KEY (`pl_from`, `pl_target_id`);
  • Stop writing to the old columns
  • Make communications if needed
  • Drop the columns and indexes:
ALTER TABLE pagelinks DROP COLUMN pl_namespace, DROP COLUMN pl_title;
DROP INDEX pl_namespace ON pagelinks;
DROP INDEX pl_backlinks_namespace ON pagelinks;
optimize table pagelinks;

Progress of PK change:

  • s1: In progress
  • s2: NOT YET
  • s3: Done everywhere except eqiad master
  • s4: Done
  • s5: Done
  • s6: Done everywhere except eqiad master
  • s7: Done everywhere except eqiad master
  • s8: In progress
  • labtestwiki

Progress of dropping the columns:

  • s1: NOT YET
  • s2: NOT YET
  • s3: NOT YET
  • s4: Done everywhere except dc masters
  • s5: NOT YET
  • s6: NOT YET
  • s7: NOT YET
  • s8: NOT YET
  • labtestwiki

Impact:

Details

SubjectRepoBranchLines +/-
Stop writing to old pagelinks schema in s4operations/mediawiki-configmaster+2 -0
Stop writing to the old columns of pagelinks in testwikioperations/mediawiki-configmaster+1 -1
beta: Stop writing to the old pagelinks columns in simplewikioperations/mediawiki-configmaster+1 -0
Customize query in gerrit
TitleReferenceAuthorSource BranchDest Branch
Add change_pagelinks_pkrepos/sre/schema-changes!3ladsgroupchange_pagelinks_pkmain
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.Tue, Apr 23, 2:42 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-23T14:42:03Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T352010)', diff saved to https://phabricator.wikimedia.org/P61112 and previous config saved to /var/cache/conftool/dbconfig/20240423-144202-ladsgroup.json

Stashbot added a comment.Tue, Apr 23, 3:27 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-23T15:27:26Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T352010)', diff saved to https://phabricator.wikimedia.org/P61121 and previous config saved to /var/cache/conftool/dbconfig/20240423-152725-ladsgroup.json

Stashbot added a comment.Tue, Apr 23, 11:19 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-23T23:19:30Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2145 (T352010)', diff saved to https://phabricator.wikimedia.org/P61128 and previous config saved to /var/cache/conftool/dbconfig/20240423-231923-ladsgroup.json

Stashbot added a comment.Wed, Apr 24, 4:52 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T04:52:42Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2152 (T352010)', diff saved to https://phabricator.wikimedia.org/P61129 and previous config saved to /var/cache/conftool/dbconfig/20240424-045230-ladsgroup.json

Stashbot added a comment.Wed, Apr 24, 8:54 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T08:54:47Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T352010)', diff saved to https://phabricator.wikimedia.org/P61131 and previous config saved to /var/cache/conftool/dbconfig/20240424-085442-ladsgroup.json

Stashbot added a comment.Wed, Apr 24, 9:40 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T09:40:05Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T352010)', diff saved to https://phabricator.wikimedia.org/P61137 and previous config saved to /var/cache/conftool/dbconfig/20240424-094004-ladsgroup.json

Stashbot added a comment.Wed, Apr 24, 9:40 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T09:40:28Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2146 (T352010)', diff saved to https://phabricator.wikimedia.org/P61138 and previous config saved to /var/cache/conftool/dbconfig/20240424-094027-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Wed, Apr 24, 9:42 AM
Stashbot added a comment.Wed, Apr 24, 4:19 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T16:19:00Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2152 (T352010)', diff saved to https://phabricator.wikimedia.org/P61172 and previous config saved to /var/cache/conftool/dbconfig/20240424-161859-ladsgroup.json

Stashbot added a comment.Wed, Apr 24, 5:04 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T17:04:22Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2152 (T352010)', diff saved to https://phabricator.wikimedia.org/P61175 and previous config saved to /var/cache/conftool/dbconfig/20240424-170421-ladsgroup.json

Stashbot added a comment.Wed, Apr 24, 5:05 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T17:05:06Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2154 (T352010)', diff saved to https://phabricator.wikimedia.org/P61176 and previous config saved to /var/cache/conftool/dbconfig/20240424-170444-ladsgroup.json

Stashbot added a comment.Wed, Apr 24, 6:16 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T18:16:53Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T352010)', diff saved to https://phabricator.wikimedia.org/P61177 and previous config saved to /var/cache/conftool/dbconfig/20240424-181653-ladsgroup.json

Stashbot added a comment.Wed, Apr 24, 7:02 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T19:02:15Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T352010)', diff saved to https://phabricator.wikimedia.org/P61180 and previous config saved to /var/cache/conftool/dbconfig/20240424-190214-ladsgroup.json

Stashbot added a comment.Wed, Apr 24, 7:03 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-24T19:03:39Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2153 (T352010)', diff saved to https://phabricator.wikimedia.org/P61181 and previous config saved to /var/cache/conftool/dbconfig/20240424-190237-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 4:50 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T04:50:24Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2154 (T352010)', diff saved to https://phabricator.wikimedia.org/P61185 and previous config saved to /var/cache/conftool/dbconfig/20240425-045023-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 5:08 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T05:08:47Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T352010)', diff saved to https://phabricator.wikimedia.org/P61187 and previous config saved to /var/cache/conftool/dbconfig/20240425-050845-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 5:35 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T05:35:46Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2154 (T352010)', diff saved to https://phabricator.wikimedia.org/P61190 and previous config saved to /var/cache/conftool/dbconfig/20240425-053545-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 5:36 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T05:36:20Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2161 (T352010)', diff saved to https://phabricator.wikimedia.org/P61191 and previous config saved to /var/cache/conftool/dbconfig/20240425-053608-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 5:54 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T05:54:09Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T352010)', diff saved to https://phabricator.wikimedia.org/P61193 and previous config saved to /var/cache/conftool/dbconfig/20240425-055408-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 5:54 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T05:54:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2170 (T352010)', diff saved to https://phabricator.wikimedia.org/P61194 and previous config saved to /var/cache/conftool/dbconfig/20240425-055431-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 2:25 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T14:25:20Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2170 (T352010)', diff saved to https://phabricator.wikimedia.org/P61212 and previous config saved to /var/cache/conftool/dbconfig/20240425-142520-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 3:10 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T15:10:42Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2170 (T352010)', diff saved to https://phabricator.wikimedia.org/P61215 and previous config saved to /var/cache/conftool/dbconfig/20240425-151041-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 3:12 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T15:12:54Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2173 (T352010)', diff saved to https://phabricator.wikimedia.org/P61216 and previous config saved to /var/cache/conftool/dbconfig/20240425-151120-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Thu, Apr 25, 5:10 PM
Stashbot added a comment.Thu, Apr 25, 5:12 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T17:12:18Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2161 (T352010)', diff saved to https://phabricator.wikimedia.org/P61218 and previous config saved to /var/cache/conftool/dbconfig/20240425-171218-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 5:14 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T17:14:01Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2147 (T352010)', diff saved to https://phabricator.wikimedia.org/P61219 and previous config saved to /var/cache/conftool/dbconfig/20240425-171329-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 5:57 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T17:57:40Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2161 (T352010)', diff saved to https://phabricator.wikimedia.org/P61222 and previous config saved to /var/cache/conftool/dbconfig/20240425-175739-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 5:58 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T17:58:28Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2162 (T352010)', diff saved to https://phabricator.wikimedia.org/P61223 and previous config saved to /var/cache/conftool/dbconfig/20240425-175802-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 10:26 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T22:26:39Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T352010)', diff saved to https://phabricator.wikimedia.org/P61227 and previous config saved to /var/cache/conftool/dbconfig/20240425-222638-ladsgroup.json

Stashbot added a comment.Thu, Apr 25, 11:12 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-25T23:12:01Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2147 (T352010)', diff saved to https://phabricator.wikimedia.org/P61230 and previous config saved to /var/cache/conftool/dbconfig/20240425-231201-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 1:06 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T01:06:29Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T352010)', diff saved to https://phabricator.wikimedia.org/P61231 and previous config saved to /var/cache/conftool/dbconfig/20240426-010628-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 1:51 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T01:51:50Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T352010)', diff saved to https://phabricator.wikimedia.org/P61234 and previous config saved to /var/cache/conftool/dbconfig/20240426-015149-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 1:53 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T01:53:07Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2174 (T352010)', diff saved to https://phabricator.wikimedia.org/P61235 and previous config saved to /var/cache/conftool/dbconfig/20240426-015212-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 5:37 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T05:37:56Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2162 (T352010)', diff saved to https://phabricator.wikimedia.org/P61236 and previous config saved to /var/cache/conftool/dbconfig/20240426-053756-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 6:23 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T06:23:18Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2162 (T352010)', diff saved to https://phabricator.wikimedia.org/P61239 and previous config saved to /var/cache/conftool/dbconfig/20240426-062317-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 6:24 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T06:24:05Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2163 (T352010)', diff saved to https://phabricator.wikimedia.org/P61240 and previous config saved to /var/cache/conftool/dbconfig/20240426-062340-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 11:34 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T11:34:17Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T352010)', diff saved to https://phabricator.wikimedia.org/P61247 and previous config saved to /var/cache/conftool/dbconfig/20240426-113416-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 12:19 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T12:19:41Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T352010)', diff saved to https://phabricator.wikimedia.org/P61250 and previous config saved to /var/cache/conftool/dbconfig/20240426-121939-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 12:21 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T12:21:00Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2176 (T352010)', diff saved to https://phabricator.wikimedia.org/P61251 and previous config saved to /var/cache/conftool/dbconfig/20240426-121951-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 6:23 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T18:23:20Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2163 (T352010)', diff saved to https://phabricator.wikimedia.org/P61256 and previous config saved to /var/cache/conftool/dbconfig/20240426-182320-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 7:08 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T19:08:42Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2163 (T352010)', diff saved to https://phabricator.wikimedia.org/P61259 and previous config saved to /var/cache/conftool/dbconfig/20240426-190842-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 7:10 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T19:10:48Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2164 (T352010)', diff saved to https://phabricator.wikimedia.org/P61260 and previous config saved to /var/cache/conftool/dbconfig/20240426-190909-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 10:27 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T22:27:28Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T352010)', diff saved to https://phabricator.wikimedia.org/P61261 and previous config saved to /var/cache/conftool/dbconfig/20240426-222728-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 11:12 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T23:12:53Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T352010)', diff saved to https://phabricator.wikimedia.org/P61264 and previous config saved to /var/cache/conftool/dbconfig/20240426-231252-ladsgroup.json

Stashbot added a comment.Fri, Apr 26, 11:13 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-26T23:13:52Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2188 (T352010)', diff saved to https://phabricator.wikimedia.org/P61265 and previous config saved to /var/cache/conftool/dbconfig/20240426-231316-ladsgroup.json

Stashbot added a comment.Sat, Apr 27, 6:57 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-27T06:57:28Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T352010)', diff saved to https://phabricator.wikimedia.org/P61266 and previous config saved to /var/cache/conftool/dbconfig/20240427-065728-ladsgroup.json

Stashbot added a comment.Sat, Apr 27, 7:06 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-27T07:06:49Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2164 (T352010)', diff saved to https://phabricator.wikimedia.org/P61267 and previous config saved to /var/cache/conftool/dbconfig/20240427-070648-ladsgroup.json

Stashbot added a comment.Sat, Apr 27, 7:42 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-27T07:42:50Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2188 (T352010)', diff saved to https://phabricator.wikimedia.org/P61272 and previous config saved to /var/cache/conftool/dbconfig/20240427-074250-ladsgroup.json

Stashbot added a comment.Sat, Apr 27, 7:52 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-27T07:52:10Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2164 (T352010)', diff saved to https://phabricator.wikimedia.org/P61273 and previous config saved to /var/cache/conftool/dbconfig/20240427-075210-ladsgroup.json

Stashbot added a comment.Sat, Apr 27, 7:52 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-27T07:52:56Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2166 (T352010)', diff saved to https://phabricator.wikimedia.org/P61274 and previous config saved to /var/cache/conftool/dbconfig/20240427-075233-ladsgroup.json

Stashbot added a comment.Sat, Apr 27, 2:47 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-27T14:47:05Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2212 (T352010)', diff saved to https://phabricator.wikimedia.org/P61275 and previous config saved to /var/cache/conftool/dbconfig/20240427-144642-ladsgroup.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