Page MenuHomePhabricator
Create Task
Maniphest T312863

Schema change to change primary key of templatelinks
Closed, ResolvedPublic
Actions

Description

This is needed before we can stop writing to the old fields

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/801383/12/maintenance/archives/patch-templatelinks-tl_title-nullable.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: Do not run it on s1 yet (until T299424 is done)
  4. If the schema change is backwards compatible: Yes
  5. If the schema change has been tested already on some of the test/beta wikis: beta cluster is running with the new schema
  6. if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Probably better to simply run it on testwiki first so I can change the config there.

Progress:

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

Details

ProjectBranchLines +/-Subject
operations/software/schema-changesmaster+46 -0Add change_templatelinks_pk.py
Customize query in gerrit

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.Sep 9 2022, 1:38 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T13:38:47Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2112 (T312863)', diff saved to https://phabricator.wikimedia.org/P34336 and previous config saved to /var/cache/conftool/dbconfig/20220909-133846-ladsgroup.json

Stashbot added a comment.Sep 9 2022, 3:06 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T15:06:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T312863)', diff saved to https://phabricator.wikimedia.org/P34338 and previous config saved to /var/cache/conftool/dbconfig/20220909-150651-ladsgroup.json

Stashbot added a comment.Sep 9 2022, 3:52 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T15:52:13Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T312863)', diff saved to https://phabricator.wikimedia.org/P34341 and previous config saved to /var/cache/conftool/dbconfig/20220909-155213-ladsgroup.json

Stashbot added a comment.Sep 9 2022, 3:52 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T15:52:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1118 (T312863)', diff saved to https://phabricator.wikimedia.org/P34342 and previous config saved to /var/cache/conftool/dbconfig/20220909-155234-ladsgroup.json

• Ladsgroup updated the task description. (Show Details)Sep 9 2022, 6:23 PM
Stashbot added a comment.Sep 9 2022, 7:33 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T19:33:16Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2112 (T312863)', diff saved to https://phabricator.wikimedia.org/P34343 and previous config saved to /var/cache/conftool/dbconfig/20220909-193316-ladsgroup.json

Stashbot added a comment.Sep 9 2022, 8:18 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T20:18:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2112 (T312863)', diff saved to https://phabricator.wikimedia.org/P34347 and previous config saved to /var/cache/conftool/dbconfig/20220909-201835-ladsgroup.json

Stashbot added a comment.Sep 9 2022, 8:18 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T20:18:57Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2116 (T312863)', diff saved to https://phabricator.wikimedia.org/P34348 and previous config saved to /var/cache/conftool/dbconfig/20220909-201857-ladsgroup.json

Liz added a subscriber: Liz.Sep 9 2022, 9:44 PM
Stashbot added a comment.Sep 9 2022, 9:57 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T21:57:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1118 (T312863)', diff saved to https://phabricator.wikimedia.org/P34349 and previous config saved to /var/cache/conftool/dbconfig/20220909-215704-ladsgroup.json

Stashbot added a comment.Sep 9 2022, 10:42 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T22:42:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1118 (T312863)', diff saved to https://phabricator.wikimedia.org/P34352 and previous config saved to /var/cache/conftool/dbconfig/20220909-224223-ladsgroup.json

Stashbot added a comment.Sep 9 2022, 10:42 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-09T22:42:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1184 (T312863)', diff saved to https://phabricator.wikimedia.org/P34353 and previous config saved to /var/cache/conftool/dbconfig/20220909-224245-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 2:10 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T02:10:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T312863)', diff saved to https://phabricator.wikimedia.org/P34360 and previous config saved to /var/cache/conftool/dbconfig/20220910-021007-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 2:55 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T02:55:26Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2116 (T312863)', diff saved to https://phabricator.wikimedia.org/P34367 and previous config saved to /var/cache/conftool/dbconfig/20220910-025526-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 2:55 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T02:55:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2130 (T312863)', diff saved to https://phabricator.wikimedia.org/P34368 and previous config saved to /var/cache/conftool/dbconfig/20220910-025548-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 4:38 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T04:38:30Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T312863)', diff saved to https://phabricator.wikimedia.org/P34369 and previous config saved to /var/cache/conftool/dbconfig/20220910-043829-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 5:23 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T05:23:49Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T312863)', diff saved to https://phabricator.wikimedia.org/P34372 and previous config saved to /var/cache/conftool/dbconfig/20220910-052349-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 5:24 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T05:24:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1186 (T312863)', diff saved to https://phabricator.wikimedia.org/P34373 and previous config saved to /var/cache/conftool/dbconfig/20220910-052410-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 8:51 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T08:51:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T312863)', diff saved to https://phabricator.wikimedia.org/P34374 and previous config saved to /var/cache/conftool/dbconfig/20220910-085143-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 9:37 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T09:37:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2130 (T312863)', diff saved to https://phabricator.wikimedia.org/P34377 and previous config saved to /var/cache/conftool/dbconfig/20220910-093703-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 11:26 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T11:26:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T312863)', diff saved to https://phabricator.wikimedia.org/P34378 and previous config saved to /var/cache/conftool/dbconfig/20220910-112605-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 12:11 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T12:11:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T312863)', diff saved to https://phabricator.wikimedia.org/P34381 and previous config saved to /var/cache/conftool/dbconfig/20220910-121124-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 2:55 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T14:55:59Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2145 (T312863)', diff saved to https://phabricator.wikimedia.org/P34382 and previous config saved to /var/cache/conftool/dbconfig/20220910-145558-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 8:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T20:47:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T312863)', diff saved to https://phabricator.wikimedia.org/P34392 and previous config saved to /var/cache/conftool/dbconfig/20220910-204719-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 9:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T21:32:39Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2145 (T312863)', diff saved to https://phabricator.wikimedia.org/P34395 and previous config saved to /var/cache/conftool/dbconfig/20220910-213238-ladsgroup.json

Stashbot added a comment.Sep 10 2022, 9:33 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-10T21:33:00Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2146 (T312863)', diff saved to https://phabricator.wikimedia.org/P34396 and previous config saved to /var/cache/conftool/dbconfig/20220910-213300-ladsgroup.json

Stashbot added a comment.Sep 11 2022, 3:33 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-11T03:33:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T312863)', diff saved to https://phabricator.wikimedia.org/P34397 and previous config saved to /var/cache/conftool/dbconfig/20220911-033355-ladsgroup.json

Stashbot added a comment.Sep 11 2022, 4:19 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-11T04:19:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T312863)', diff saved to https://phabricator.wikimedia.org/P34400 and previous config saved to /var/cache/conftool/dbconfig/20220911-041914-ladsgroup.json

Stashbot added a comment.Sep 11 2022, 4:19 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-11T04:19:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2153 (T312863)', diff saved to https://phabricator.wikimedia.org/P34401 and previous config saved to /var/cache/conftool/dbconfig/20220911-041936-ladsgroup.json

Stashbot added a comment.Sep 11 2022, 10:16 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-11T10:16:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T312863)', diff saved to https://phabricator.wikimedia.org/P34403 and previous config saved to /var/cache/conftool/dbconfig/20220911-101647-ladsgroup.json

Stashbot added a comment.Sep 11 2022, 11:02 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-11T11:02:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T312863)', diff saved to https://phabricator.wikimedia.org/P34406 and previous config saved to /var/cache/conftool/dbconfig/20220911-110207-ladsgroup.json

Stashbot added a comment.Sep 11 2022, 11:02 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-11T11:02:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2167:3311 (T312863)', diff saved to https://phabricator.wikimedia.org/P34407 and previous config saved to /var/cache/conftool/dbconfig/20220911-110228-ladsgroup.json

Stashbot added a comment.Sep 11 2022, 5:11 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-11T17:11:02Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T312863)', diff saved to https://phabricator.wikimedia.org/P34414 and previous config saved to /var/cache/conftool/dbconfig/20220911-171102-ladsgroup.json

Stashbot added a comment.Sep 11 2022, 5:56 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-11T17:56:21Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T312863)', diff saved to https://phabricator.wikimedia.org/P34417 and previous config saved to /var/cache/conftool/dbconfig/20220911-175621-ladsgroup.json

Stashbot added a comment.Sep 11 2022, 5:56 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-11T17:56:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2170:3311 (T312863)', diff saved to https://phabricator.wikimedia.org/P34418 and previous config saved to /var/cache/conftool/dbconfig/20220911-175643-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 12:03 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T00:03:56Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T312863)', diff saved to https://phabricator.wikimedia.org/P34419 and previous config saved to /var/cache/conftool/dbconfig/20220912-000356-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 12:49 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T00:49:15Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T312863)', diff saved to https://phabricator.wikimedia.org/P34422 and previous config saved to /var/cache/conftool/dbconfig/20220912-004915-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 12:49 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T00:49:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2173 (T312863)', diff saved to https://phabricator.wikimedia.org/P34423 and previous config saved to /var/cache/conftool/dbconfig/20220912-004952-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 6:43 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T06:43:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T312863)', diff saved to https://phabricator.wikimedia.org/P34442 and previous config saved to /var/cache/conftool/dbconfig/20220912-064350-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 7:29 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T07:29:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T312863)', diff saved to https://phabricator.wikimedia.org/P34450 and previous config saved to /var/cache/conftool/dbconfig/20220912-072909-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 7:29 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T07:29:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2174 (T312863)', diff saved to https://phabricator.wikimedia.org/P34452 and previous config saved to /var/cache/conftool/dbconfig/20220912-072931-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 1:28 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T13:28:46Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T312863)', diff saved to https://phabricator.wikimedia.org/P34514 and previous config saved to /var/cache/conftool/dbconfig/20220912-132846-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 2:14 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T14:14:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T312863)', diff saved to https://phabricator.wikimedia.org/P34518 and previous config saved to /var/cache/conftool/dbconfig/20220912-141405-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 2:14 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T14:14:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2176 (T312863)', diff saved to https://phabricator.wikimedia.org/P34519 and previous config saved to /var/cache/conftool/dbconfig/20220912-141427-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 8:16 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T20:16:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T312863)', diff saved to https://phabricator.wikimedia.org/P34545 and previous config saved to /var/cache/conftool/dbconfig/20220912-201604-ladsgroup.json

Stashbot added a comment.Sep 12 2022, 9:01 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-12T21:01:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T312863)', diff saved to https://phabricator.wikimedia.org/P34549 and previous config saved to /var/cache/conftool/dbconfig/20220912-210123-ladsgroup.json

• Ladsgroup updated the task description. (Show Details)Sep 13 2022, 6:57 AM
Marostegui closed subtask T317614: Switchover codfw s1 master (db2103 -> db2112) as Resolved.Sep 13 2022, 9:22 AM
Stashbot added a comment.Sep 13 2022, 11:07 AM

Mentioned in SAL (#wikimedia-operations) [2022-09-13T11:07:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2103 (T312863)', diff saved to https://phabricator.wikimedia.org/P34594 and previous config saved to /var/cache/conftool/dbconfig/20220913-110755-ladsgroup.json

Stashbot added a comment.Sep 13 2022, 4:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-13T16:47:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2103 (T312863)', diff saved to https://phabricator.wikimedia.org/P34631 and previous config saved to /var/cache/conftool/dbconfig/20220913-164734-ladsgroup.json

Stashbot added a comment.Sep 13 2022, 5:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-09-13T17:32:54Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2103 (T312863)', diff saved to https://phabricator.wikimedia.org/P34639 and previous config saved to /var/cache/conftool/dbconfig/20220913-173254-ladsgroup.json

• Ladsgroup closed this task as Resolved.Sep 14 2022, 8:34 AM
• Ladsgroup updated the task description. (Show Details)
Maintenance_bot moved this task from In progress to Done on the DBA board.Sep 14 2022, 9:15 AM
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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