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: Done everywhere except dc masters
  • s2: NOT YET
  • s3: Done
  • s4: Done
  • s5: Done
  • s6: Done everywhere except eqiad master
  • s7: Done everywhere except eqiad master
  • s8: Done everywhere except dc masters
  • 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.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

Stashbot added a comment.Sat, Apr 27, 7:40 PM

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

Stashbot added a comment.Sat, Apr 27, 8:25 PM

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

Stashbot added a comment.Sat, Apr 27, 8:26 PM

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

Stashbot added a comment.Sat, Apr 27, 10:25 PM

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

Stashbot added a comment.Sat, Apr 27, 11:11 PM

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

Stashbot added a comment.Sat, Apr 27, 11:11 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-27T23:11:36Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2216 (T352010)', diff saved to https://phabricator.wikimedia.org/P61286 and previous config saved to /var/cache/conftool/dbconfig/20240427-231136-ladsgroup.json

Stashbot added a comment.Sun, Apr 28, 6:53 AM

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

Stashbot added a comment.Sun, Apr 28, 6:59 AM

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

Stashbot added a comment.Sun, Apr 28, 7:38 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-28T07:38:28Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2216 (T352010)', diff saved to https://phabricator.wikimedia.org/P61293 and previous config saved to /var/cache/conftool/dbconfig/20240428-073827-ladsgroup.json

Stashbot added a comment.Sun, Apr 28, 7:44 AM

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

Stashbot added a comment.Sun, Apr 28, 7:45 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-28T07:45:12Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2181 (T352010)', diff saved to https://phabricator.wikimedia.org/P61295 and previous config saved to /var/cache/conftool/dbconfig/20240428-074511-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Sun, Apr 28, 3:00 PM
Stashbot added a comment.Sun, Apr 28, 7:19 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-28T19:19:38Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2181 (T352010)', diff saved to https://phabricator.wikimedia.org/P61296 and previous config saved to /var/cache/conftool/dbconfig/20240428-191938-ladsgroup.json

Stashbot added a comment.Sun, Apr 28, 8:05 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-28T20:05:00Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2181 (T352010)', diff saved to https://phabricator.wikimedia.org/P61299 and previous config saved to /var/cache/conftool/dbconfig/20240428-200500-ladsgroup.json

Stashbot added a comment.Sun, Apr 28, 8:05 PM

Mentioned in SAL (#wikimedia-operations) [2024-04-28T20:05:42Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2195 (T352010)', diff saved to https://phabricator.wikimedia.org/P61300 and previous config saved to /var/cache/conftool/dbconfig/20240428-200522-ladsgroup.json

Stashbot added a comment.Mon, Apr 29, 4:58 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-29T04:58:52Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2195 (T352010)', diff saved to https://phabricator.wikimedia.org/P61301 and previous config saved to /var/cache/conftool/dbconfig/20240429-045851-ladsgroup.json

Stashbot added a comment.Mon, Apr 29, 5:44 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-29T05:44:14Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2195 (T352010)', diff saved to https://phabricator.wikimedia.org/P61308 and previous config saved to /var/cache/conftool/dbconfig/20240429-054413-ladsgroup.json

Stashbot added a comment.Tue, Apr 30, 9:10 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-30T09:10:50Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1157 (T352010)', diff saved to https://phabricator.wikimedia.org/P61480 and previous config saved to /var/cache/conftool/dbconfig/20240430-091049-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Tue, Apr 30, 10:05 AM
Ladsgroup updated the task description. (Show Details)Tue, Apr 30, 3:45 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