Page MenuHomePhabricator

Schema change to change primary key of templatelinks
Closed, ResolvedPublic

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

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) [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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 updated the task description. (Show Details)