Page MenuHomePhabricator

Drop old columns of externallinks
Closed, ResolvedPublic

Description

After T342617: Make old columns of externallinks nullable and T342683: Stop writing to the old externallinks columns in beta cluster and production are done for a wiki

Done for testwiki, ongoing for ruwikinews

Progress:

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

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) [2023-08-31T11:13:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2151 (T343718)', diff saved to https://phabricator.wikimedia.org/P52184 and previous config saved to /var/cache/conftool/dbconfig/20230831-111353-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T11:31:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2151 (T343718)', diff saved to https://phabricator.wikimedia.org/P52186 and previous config saved to /var/cache/conftool/dbconfig/20230831-113136-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T11:36:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1187 (T343718)', diff saved to https://phabricator.wikimedia.org/P52189 and previous config saved to /var/cache/conftool/dbconfig/20230831-113603-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T11:36:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1201 (T343718)', diff saved to https://phabricator.wikimedia.org/P52190 and previous config saved to /var/cache/conftool/dbconfig/20230831-113613-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T11:39:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1201 (T343718)', diff saved to https://phabricator.wikimedia.org/P52191 and previous config saved to /var/cache/conftool/dbconfig/20230831-113922-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T12:16:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2151 (T343718)', diff saved to https://phabricator.wikimedia.org/P52196 and previous config saved to /var/cache/conftool/dbconfig/20230831-121654-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T12:17:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2158 (T343718)', diff saved to https://phabricator.wikimedia.org/P52197 and previous config saved to /var/cache/conftool/dbconfig/20230831-121721-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T12:24:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1201 (T343718)', diff saved to https://phabricator.wikimedia.org/P52198 and previous config saved to /var/cache/conftool/dbconfig/20230831-122441-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T12:25:40Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1213:3316 (T343718)', diff saved to https://phabricator.wikimedia.org/P52199 and previous config saved to /var/cache/conftool/dbconfig/20230831-122502-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T12:34:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T343718)', diff saved to https://phabricator.wikimedia.org/P52200 and previous config saved to /var/cache/conftool/dbconfig/20230831-123428-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T12:42:40Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1213:3316 (T343718)', diff saved to https://phabricator.wikimedia.org/P52201 and previous config saved to /var/cache/conftool/dbconfig/20230831-124240-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T13:19:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T343718)', diff saved to https://phabricator.wikimedia.org/P52206 and previous config saved to /var/cache/conftool/dbconfig/20230831-131947-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T13:20:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2169:3316 (T343718)', diff saved to https://phabricator.wikimedia.org/P52207 and previous config saved to /var/cache/conftool/dbconfig/20230831-132009-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T13:27:59Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1213:3316 (T343718)', diff saved to https://phabricator.wikimedia.org/P52208 and previous config saved to /var/cache/conftool/dbconfig/20230831-132759-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T13:28:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1224 (T343718)', diff saved to https://phabricator.wikimedia.org/P52209 and previous config saved to /var/cache/conftool/dbconfig/20230831-132820-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T13:30:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T343718)', diff saved to https://phabricator.wikimedia.org/P52210 and previous config saved to /var/cache/conftool/dbconfig/20230831-133029-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T13:39:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2169:3316 (T343718)', diff saved to https://phabricator.wikimedia.org/P52211 and previous config saved to /var/cache/conftool/dbconfig/20230831-133905-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T14:15:54Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1224 (T343718)', diff saved to https://phabricator.wikimedia.org/P52220 and previous config saved to /var/cache/conftool/dbconfig/20230831-141547-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T14:24:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2169:3316 (T343718)', diff saved to https://phabricator.wikimedia.org/P52221 and previous config saved to /var/cache/conftool/dbconfig/20230831-142424-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T14:24:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2171:3316 (T343718)', diff saved to https://phabricator.wikimedia.org/P52222 and previous config saved to /var/cache/conftool/dbconfig/20230831-142445-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T14:44:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2171:3316 (T343718)', diff saved to https://phabricator.wikimedia.org/P52225 and previous config saved to /var/cache/conftool/dbconfig/20230831-144425-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T15:29:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2171:3316 (T343718)', diff saved to https://phabricator.wikimedia.org/P52231 and previous config saved to /var/cache/conftool/dbconfig/20230831-152943-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T15:30:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2180 (T343718)', diff saved to https://phabricator.wikimedia.org/P52232 and previous config saved to /var/cache/conftool/dbconfig/20230831-153005-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T15:32:18Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2180 (T343718)', diff saved to https://phabricator.wikimedia.org/P52233 and previous config saved to /var/cache/conftool/dbconfig/20230831-153217-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-31T16:17:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2180 (T343718)', diff saved to https://phabricator.wikimedia.org/P52236 and previous config saved to /var/cache/conftool/dbconfig/20230831-161736-ladsgroup.json

As we'll have eqiad depooled for some time after the switchover, let's do those once that is happening.

To which MediaWiki version does this change belong? I'm asking because mw:Manual:Externallinks_table should be updated.

To which MediaWiki version does this change belong? I'm asking because mw:Manual:Externallinks_table should be updated.

1.41 which hasn't been released yet.

I completely forgot about dc masters, they showed up in the drift report. The eqiad ones are still running.

Mentioned in SAL (#wikimedia-operations) [2024-01-23T14:06:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1173 (T343718)', diff saved to https://phabricator.wikimedia.org/P55372 and previous config saved to /var/cache/conftool/dbconfig/20240123-140636-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2024-01-30T10:59:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2114 (T343718)', diff saved to https://phabricator.wikimedia.org/P55892 and previous config saved to /var/cache/conftool/dbconfig/20240130-105954-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2024-01-30T11:02:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2114 (T343718)', diff saved to https://phabricator.wikimedia.org/P55893 and previous config saved to /var/cache/conftool/dbconfig/20240130-110207-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2024-01-30T11:47:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2114 (T343718)', diff saved to https://phabricator.wikimedia.org/P55896 and previous config saved to /var/cache/conftool/dbconfig/20240130-114726-ladsgroup.json

Ladsgroup updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-operations) [2024-03-05T10:59:51Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Depooling db2218 (T343718)', diff saved to https://phabricator.wikimedia.org/P58466 and previous config saved to /var/cache/conftool/dbconfig/20240305-105950-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2024-03-05T11:30:28Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2218 (T343718)', diff saved to https://phabricator.wikimedia.org/P58469 and previous config saved to /var/cache/conftool/dbconfig/20240305-113027-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2024-03-05T12:15:47Z] <ladsgroup@cumin1002> dbctl commit (dc=all): 'Repooling after maintenance db2218 (T343718)', diff saved to https://phabricator.wikimedia.org/P58473 and previous config saved to /var/cache/conftool/dbconfig/20240305-121546-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2024-03-25T15:14:17Z] <ladsgroup@cumin1002> START - Cookbook sre.hosts.downtime for 1 day, 0:00:00 on 13 hosts with reason: Maint T343718

Mentioned in SAL (#wikimedia-operations) [2024-03-25T15:14:29Z] <ladsgroup@cumin1002> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 1 day, 0:00:00 on 13 hosts with reason: Maint T343718

Mentioned in SAL (#wikimedia-operations) [2024-03-26T11:06:23Z] <ladsgroup@cumin1002> START - Cookbook sre.hosts.downtime for 1 day, 0:00:00 on 16 hosts with reason: Maint T343718

Mentioned in SAL (#wikimedia-operations) [2024-03-26T11:06:38Z] <ladsgroup@cumin1002> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 1 day, 0:00:00 on 16 hosts with reason: Maint T343718

Mentioned in SAL (#wikimedia-operations) [2024-03-26T20:46:11Z] <ladsgroup@cumin1002> START - Cookbook sre.hosts.downtime for 1 day, 0:00:00 on 13 hosts with reason: Maint T343718

Mentioned in SAL (#wikimedia-operations) [2024-03-26T20:46:34Z] <ladsgroup@cumin1002> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 1 day, 0:00:00 on 13 hosts with reason: Maint T343718

Mentioned in SAL (#wikimedia-operations) [2024-03-26T20:54:42Z] <ladsgroup@cumin1002> START - Cookbook sre.hosts.downtime for 1 day, 0:00:00 on 17 hosts with reason: Maint T343718

Mentioned in SAL (#wikimedia-operations) [2024-03-26T20:54:58Z] <ladsgroup@cumin1002> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 1 day, 0:00:00 on 17 hosts with reason: Maint T343718

Ladsgroup updated the task description. (Show Details)
Ladsgroup moved this task from In progress to Done on the DBA board.

Change #1054495 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] filtered_tables.txt: Remove old columns

https://gerrit.wikimedia.org/r/1054495

Change #1054495 merged by Marostegui:

[operations/puppet@production] filtered_tables.txt: Remove old columns

https://gerrit.wikimedia.org/r/1054495