Page MenuHomePhabricator
Create Task
Maniphest T352010

Gradually drop old pagelinks columns
Closed, ResolvedPublic
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
  • s2: Done
  • s3: Done
  • s4: Done
  • s5: Done
  • s6: Done
  • s7: Done
  • s8: Done
  • labtestwiki

Progress of dropping the columns:

  • s1: Done
  • s2: Done
  • s3: Done
  • s4: Done
  • s5: Done
  • s6: Done
  • s7: Done
  • s8: Done
  • labtestwiki

Impact:

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Stop writing to the old pagelinks columns of s2operations/mediawiki-configmaster+0 -18
Stop writing to pagelinks old columns in enwikioperations/mediawiki-configmaster+0 -2
Stop writing to the old pagelinks columns in s8operations/mediawiki-configmaster+0 -2
Stop writing to the old columns of pagelinks in s6operations/mediawiki-configmaster+0 -5
Stop writing to old columns of pagelinks in most wikisoperations/mediawiki-configmaster+27 -5
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
Related Changes in GitLab:
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.Jun 15 2024, 2:40 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-15T02:40:20Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1246 (T352010)', diff saved to https://phabricator.wikimedia.org/P65001 and previous config saved to /var/cache/conftool/dbconfig/20240615-024019-ladsgroup.json

Stashbot added a comment.Jun 15 2024, 9:27 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-15T09:27:30Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2125 (T352010)', diff saved to https://phabricator.wikimedia.org/P65013 and previous config saved to /var/cache/conftool/dbconfig/20240615-092730-ladsgroup.json

Stashbot added a comment.Jun 15 2024, 11:18 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-15T23:18:23Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2125 (T352010)', diff saved to https://phabricator.wikimedia.org/P65029 and previous config saved to /var/cache/conftool/dbconfig/20240615-231822-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 12:03 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T00:03:44Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2125 (T352010)', diff saved to https://phabricator.wikimedia.org/P65032 and previous config saved to /var/cache/conftool/dbconfig/20240616-000343-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 12:04 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T00:04:22Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2126 (T352010)', diff saved to https://phabricator.wikimedia.org/P65033 and previous config saved to /var/cache/conftool/dbconfig/20240616-000421-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 5:08 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T05:08:39Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2126 (T352010)', diff saved to https://phabricator.wikimedia.org/P65038 and previous config saved to /var/cache/conftool/dbconfig/20240616-050838-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 5:54 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T05:54:00Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2126 (T352010)', diff saved to https://phabricator.wikimedia.org/P65041 and previous config saved to /var/cache/conftool/dbconfig/20240616-055359-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 5:54 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T05:54:11Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2138 (T352010)', diff saved to https://phabricator.wikimedia.org/P65042 and previous config saved to /var/cache/conftool/dbconfig/20240616-055411-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 1:16 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T13:16:31Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2138 (T352010)', diff saved to https://phabricator.wikimedia.org/P65043 and previous config saved to /var/cache/conftool/dbconfig/20240616-131630-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 2:01 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T14:01:52Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2138 (T352010)', diff saved to https://phabricator.wikimedia.org/P65046 and previous config saved to /var/cache/conftool/dbconfig/20240616-140152-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 2:02 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T14:02:15Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2148 (T352010)', diff saved to https://phabricator.wikimedia.org/P65047 and previous config saved to /var/cache/conftool/dbconfig/20240616-140214-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 9:34 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T21:34:01Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2148 (T352010)', diff saved to https://phabricator.wikimedia.org/P65049 and previous config saved to /var/cache/conftool/dbconfig/20240616-213400-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 10:19 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T22:19:22Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2148 (T352010)', diff saved to https://phabricator.wikimedia.org/P65052 and previous config saved to /var/cache/conftool/dbconfig/20240616-221921-ladsgroup.json

Stashbot added a comment.Jun 16 2024, 10:19 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-16T22:19:44Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2175 (T352010)', diff saved to https://phabricator.wikimedia.org/P65053 and previous config saved to /var/cache/conftool/dbconfig/20240616-221944-ladsgroup.json

Stashbot added a comment.Jun 17 2024, 6:11 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T06:11:05Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2175 (T352010)', diff saved to https://phabricator.wikimedia.org/P65073 and previous config saved to /var/cache/conftool/dbconfig/20240617-061105-ladsgroup.json

Stashbot added a comment.Jun 17 2024, 6:56 AM

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

Stashbot added a comment.Jun 17 2024, 6:56 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T06:56:48Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2189 (T352010)', diff saved to https://phabricator.wikimedia.org/P65084 and previous config saved to /var/cache/conftool/dbconfig/20240617-065647-ladsgroup.json

Stashbot added a comment.Jun 17 2024, 12:27 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T12:27:01Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2189 (T352010)', diff saved to https://phabricator.wikimedia.org/P65108 and previous config saved to /var/cache/conftool/dbconfig/20240617-122700-ladsgroup.json

Stashbot added a comment.Jun 17 2024, 1:12 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T13:12:23Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2189 (T352010)', diff saved to https://phabricator.wikimedia.org/P65111 and previous config saved to /var/cache/conftool/dbconfig/20240617-131222-ladsgroup.json

Stashbot added a comment.Jun 17 2024, 1:39 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T13:39:52Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1206 (T352010)', diff saved to https://phabricator.wikimedia.org/P65112 and previous config saved to /var/cache/conftool/dbconfig/20240617-133951-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Jun 17 2024, 1:46 PM
Stashbot added a comment.Jun 17 2024, 7:55 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T19:55:20Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2204 (T352010)', diff saved to https://phabricator.wikimedia.org/P65116 and previous config saved to /var/cache/conftool/dbconfig/20240617-195520-ladsgroup.json

Stashbot added a comment.Jun 17 2024, 9:44 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T21:44:50Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T352010)', diff saved to https://phabricator.wikimedia.org/P65118 and previous config saved to /var/cache/conftool/dbconfig/20240617-214449-ladsgroup.json

Stashbot added a comment.Jun 17 2024, 10:30 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T22:30:11Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T352010)', diff saved to https://phabricator.wikimedia.org/P65121 and previous config saved to /var/cache/conftool/dbconfig/20240617-223010-ladsgroup.json

Stashbot added a comment.Jun 17 2024, 11:43 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-17T23:43:03Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2204 (T352010)', diff saved to https://phabricator.wikimedia.org/P65122 and previous config saved to /var/cache/conftool/dbconfig/20240617-234302-ladsgroup.json

Stashbot added a comment.Jun 18 2024, 12:28 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-18T00:28:24Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2204 (T352010)', diff saved to https://phabricator.wikimedia.org/P65125 and previous config saved to /var/cache/conftool/dbconfig/20240618-002823-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Jun 20 2024, 10:31 AM
Stashbot added a comment.Jun 20 2024, 5:41 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-20T17:41:26Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1236 (T352010)', diff saved to https://phabricator.wikimedia.org/P65259 and previous config saved to /var/cache/conftool/dbconfig/20240620-174125-ladsgroup.json

Stashbot added a comment.Jun 21 2024, 12:07 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-21T00:07:17Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1236 (T352010)', diff saved to https://phabricator.wikimedia.org/P65275 and previous config saved to /var/cache/conftool/dbconfig/20240621-000716-ladsgroup.json

Stashbot added a comment.Jun 21 2024, 12:52 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-21T00:52:39Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1236 (T352010)', diff saved to https://phabricator.wikimedia.org/P65278 and previous config saved to /var/cache/conftool/dbconfig/20240621-005237-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Jun 24 2024, 1:10 PM
Marostegui added a subtask: T369020: Switchover s6 master (db1231 -> db1173).Jul 2 2024, 11:06 AM
Stashbot added a comment.Jul 3 2024, 11:27 AM

Mentioned in SAL (#wikimedia-operations) [2024-07-03T11:27:29Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1192 (T352010)', diff saved to https://phabricator.wikimedia.org/P65714 and previous config saved to /var/cache/conftool/dbconfig/20240703-112728-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Jul 3 2024, 11:28 AM
Stashbot added a comment.Jul 3 2024, 10:36 PM

Mentioned in SAL (#wikimedia-operations) [2024-07-03T22:36:33Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1192 (T352010)', diff saved to https://phabricator.wikimedia.org/P65768 and previous config saved to /var/cache/conftool/dbconfig/20240703-223632-ladsgroup.json

Stashbot added a comment.Jul 3 2024, 11:21 PM

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

Marostegui closed subtask T369020: Switchover s6 master (db1231 -> db1173) as Resolved.Jul 4 2024, 5:06 AM
Ladsgroup updated the task description. (Show Details)Jul 4 2024, 9:23 AM
Ladsgroup updated the task description. (Show Details)Jul 5 2024, 11:13 AM
Stashbot added a comment.Jul 5 2024, 11:13 AM

Mentioned in SAL (#wikimedia-operations) [2024-07-05T11:13:22Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2207 (T352010)', diff saved to https://phabricator.wikimedia.org/P65861 and previous config saved to /var/cache/conftool/dbconfig/20240705-111322-ladsgroup.json

Stashbot added a comment.Jul 5 2024, 5:11 PM

Mentioned in SAL (#wikimedia-operations) [2024-07-05T17:11:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2207 (T352010)', diff saved to https://phabricator.wikimedia.org/P65872 and previous config saved to /var/cache/conftool/dbconfig/20240705-171131-ladsgroup.json

Stashbot added a comment.Jul 5 2024, 5:56 PM

Mentioned in SAL (#wikimedia-operations) [2024-07-05T17:56:54Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2207 (T352010)', diff saved to https://phabricator.wikimedia.org/P65878 and previous config saved to /var/cache/conftool/dbconfig/20240705-175653-ladsgroup.json

Marostegui closed subtask T364069: Rebuild pagelinks tables as Resolved.Jul 8 2024, 4:55 AM
Stashbot added a comment.Jul 9 2024, 2:00 PM

Mentioned in SAL (#wikimedia-operations) [2024-07-09T14:00:33Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2212 (T352010)', diff saved to https://phabricator.wikimedia.org/P66059 and previous config saved to /var/cache/conftool/dbconfig/20240709-140033-ladsgroup.json

Stashbot added a comment.Jul 9 2024, 8:27 PM

Mentioned in SAL (#wikimedia-operations) [2024-07-09T20:27:10Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2212 (T352010)', diff saved to https://phabricator.wikimedia.org/P66088 and previous config saved to /var/cache/conftool/dbconfig/20240709-202709-ladsgroup.json

Stashbot added a comment.Jul 9 2024, 9:12 PM

Mentioned in SAL (#wikimedia-operations) [2024-07-09T21:12:32Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2212 (T352010)', diff saved to https://phabricator.wikimedia.org/P66091 and previous config saved to /var/cache/conftool/dbconfig/20240709-211231-ladsgroup.json

Stashbot added a comment.Jul 10 2024, 11:30 AM

Mentioned in SAL (#wikimedia-operations) [2024-07-10T11:30:10Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1162 (T352010)', diff saved to https://phabricator.wikimedia.org/P66114 and previous config saved to /var/cache/conftool/dbconfig/20240710-113010-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Jul 10 2024, 11:31 AM
Stashbot added a comment.Jul 10 2024, 3:57 PM

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

Stashbot added a comment.Jul 10 2024, 4:42 PM

Mentioned in SAL (#wikimedia-operations) [2024-07-10T16:42:26Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1162 (T352010)', diff saved to https://phabricator.wikimedia.org/P66158 and previous config saved to /var/cache/conftool/dbconfig/20240710-164225-ladsgroup.json

Stashbot added a comment.Jul 26 2024, 3:31 PM

Mentioned in SAL (#wikimedia-operations) [2024-07-26T15:31:46Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db1163 (T352010)', diff saved to https://phabricator.wikimedia.org/P66945 and previous config saved to /var/cache/conftool/dbconfig/20240726-153145-ladsgroup.json

Stashbot added a comment.Jul 26 2024, 11:34 PM

Mentioned in SAL (#wikimedia-operations) [2024-07-26T23:34:55Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T352010)', diff saved to https://phabricator.wikimedia.org/P66949 and previous config saved to /var/cache/conftool/dbconfig/20240726-233454-ladsgroup.json

Stashbot added a comment.Jul 27 2024, 12:20 AM

Mentioned in SAL (#wikimedia-operations) [2024-07-27T00:20:16Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T352010)', diff saved to https://phabricator.wikimedia.org/P66954 and previous config saved to /var/cache/conftool/dbconfig/20240727-002016-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Jul 28 2024, 10:06 PM
Ladsgroup closed this task as Resolved.Jul 28 2024, 10:10 PM
Ladsgroup triaged this task as Medium priority.
Ladsgroup updated the task description. (Show Details)
Ladsgroup moved this task from In progress to Done on the DBA board.
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