Page MenuHomePhabricator

Schema change to change primary key of templatelinks
Open, HighPublic

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: NOT YET
  • s2: Done
  • s3: Done except on master
  • s4: Done except on master
  • s5: Done
  • s6: Done except on master
  • s7: Done except on master
  • 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-07-25T16:14:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T312863)', diff saved to https://phabricator.wikimedia.org/P31892 and previous config saved to /var/cache/conftool/dbconfig/20220725-161416-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-07-25T16:59:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T312863)', diff saved to https://phabricator.wikimedia.org/P31895 and previous config saved to /var/cache/conftool/dbconfig/20220725-165931-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-07-25T21:56:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1096:3315 (T312863)', diff saved to https://phabricator.wikimedia.org/P31897 and previous config saved to /var/cache/conftool/dbconfig/20220725-215637-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-07-25T22:41:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1096:3315 (T312863)', diff saved to https://phabricator.wikimedia.org/P31900 and previous config saved to /var/cache/conftool/dbconfig/20220725-224153-ladsgroup.json

Ladsgroup updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-operations) [2022-08-06T17:59:16Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1149 (T312863)', diff saved to https://phabricator.wikimedia.org/P32295 and previous config saved to /var/cache/conftool/dbconfig/20220806-175916-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-07T11:20:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1149 (T312863)', diff saved to https://phabricator.wikimedia.org/P32296 and previous config saved to /var/cache/conftool/dbconfig/20220807-112031-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-07T12:05:49Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1149 (T312863)', diff saved to https://phabricator.wikimedia.org/P32299 and previous config saved to /var/cache/conftool/dbconfig/20220807-120549-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-07T12:06:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1141 (T312863)', diff saved to https://phabricator.wikimedia.org/P32300 and previous config saved to /var/cache/conftool/dbconfig/20220807-120610-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-07T13:06:26Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1141 (T312863)', diff saved to https://phabricator.wikimedia.org/P32301 and previous config saved to /var/cache/conftool/dbconfig/20220807-130625-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-07T13:51:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1141 (T312863)', diff saved to https://phabricator.wikimedia.org/P32304 and previous config saved to /var/cache/conftool/dbconfig/20220807-135143-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-07T13:52:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1142 (T312863)', diff saved to https://phabricator.wikimedia.org/P32305 and previous config saved to /var/cache/conftool/dbconfig/20220807-135204-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-08T07:11:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1142 (T312863)', diff saved to https://phabricator.wikimedia.org/P32306 and previous config saved to /var/cache/conftool/dbconfig/20220808-071144-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-08T07:57:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1142 (T312863)', diff saved to https://phabricator.wikimedia.org/P32309 and previous config saved to /var/cache/conftool/dbconfig/20220808-075702-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-08T07:57:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1144:3314 (T312863)', diff saved to https://phabricator.wikimedia.org/P32310 and previous config saved to /var/cache/conftool/dbconfig/20220808-075723-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-09T01:45:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1144:3314 (T312863)', diff saved to https://phabricator.wikimedia.org/P32314 and previous config saved to /var/cache/conftool/dbconfig/20220809-014534-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-09T02:30:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1144:3314 (T312863)', diff saved to https://phabricator.wikimedia.org/P32317 and previous config saved to /var/cache/conftool/dbconfig/20220809-023052-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-09T02:31:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1148 (T312863)', diff saved to https://phabricator.wikimedia.org/P32318 and previous config saved to /var/cache/conftool/dbconfig/20220809-023113-ladsgroup.json

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

Mentioned in SAL (#wikimedia-operations) [2022-08-09T20:55:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1148 (T312863)', diff saved to https://phabricator.wikimedia.org/P32332 and previous config saved to /var/cache/conftool/dbconfig/20220809-205548-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-10T13:01:08Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1160 (T312863)', diff saved to https://phabricator.wikimedia.org/P32343 and previous config saved to /var/cache/conftool/dbconfig/20220810-130108-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-11T06:17:34Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1160 (T312863)', diff saved to https://phabricator.wikimedia.org/P32353 and previous config saved to /var/cache/conftool/dbconfig/20220811-061734-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-11T07:02:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1160 (T312863)', diff saved to https://phabricator.wikimedia.org/P32356 and previous config saved to /var/cache/conftool/dbconfig/20220811-070252-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-11T07:03:13Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1147 (T312863)', diff saved to https://phabricator.wikimedia.org/P32357 and previous config saved to /var/cache/conftool/dbconfig/20220811-070312-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-12T00:17:16Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1147 (T312863)', diff saved to https://phabricator.wikimedia.org/P32365 and previous config saved to /var/cache/conftool/dbconfig/20220812-001715-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-12T01:02:34Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1147 (T312863)', diff saved to https://phabricator.wikimedia.org/P32368 and previous config saved to /var/cache/conftool/dbconfig/20220812-010233-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-12T01:03:12Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1121 (T312863)', diff saved to https://phabricator.wikimedia.org/P32369 and previous config saved to /var/cache/conftool/dbconfig/20220812-010312-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-12T18:52:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1121 (T312863)', diff saved to https://phabricator.wikimedia.org/P32371 and previous config saved to /var/cache/conftool/dbconfig/20220812-185243-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-12T19:38:01Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1121 (T312863)', diff saved to https://phabricator.wikimedia.org/P32374 and previous config saved to /var/cache/conftool/dbconfig/20220812-193801-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-12T19:38:22Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1146:3314 (T312863)', diff saved to https://phabricator.wikimedia.org/P32375 and previous config saved to /var/cache/conftool/dbconfig/20220812-193822-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-13T12:51:56Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1146:3314 (T312863)', diff saved to https://phabricator.wikimedia.org/P32376 and previous config saved to /var/cache/conftool/dbconfig/20220813-125156-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-13T13:37:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1146:3314 (T312863)', diff saved to https://phabricator.wikimedia.org/P32379 and previous config saved to /var/cache/conftool/dbconfig/20220813-133713-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-14T08:54:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1141 (T312863)', diff saved to https://phabricator.wikimedia.org/P32380 and previous config saved to /var/cache/conftool/dbconfig/20220814-085443-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-15T01:50:21Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1141 (T312863)', diff saved to https://phabricator.wikimedia.org/P32382 and previous config saved to /var/cache/conftool/dbconfig/20220815-015020-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-15T02:35:39Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1141 (T312863)', diff saved to https://phabricator.wikimedia.org/P32385 and previous config saved to /var/cache/conftool/dbconfig/20220815-023538-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-16T06:23:50Z] <ladsgroup@cumin1001> START - Cookbook sre.hosts.downtime for 1 day, 0:00:00 on db1163.eqiad.wmnet with reason: Maint work on old s1 master (T312984 T312863 T310011 T309311 T60674 T298560 T298555 T310485 T301312)

Mentioned in SAL (#wikimedia-operations) [2022-08-16T06:24:04Z] <ladsgroup@cumin1001> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 1 day, 0:00:00 on db1163.eqiad.wmnet with reason: Maint work on old s1 master (T312984 T312863 T310011 T309311 T60674 T298560 T298555 T310485 T301312)

Actually this is not for this ticket. We haven't done s1 templatelinks.

Ladsgroup updated the task description. (Show Details)