Page MenuHomePhabricator
Create Task
Maniphest T343718

Drop old columns of externallinks
Open, MediumPublic
Actions

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 except eqiad master
  • s2: Done
  • s3: Done
  • s4: Done
  • s5: Done
  • s6: Done
  • s7: Done
  • s8: Done
  • labtestwiki

Details

SubjectRepoBranchLines +/-
Drop old externallinks columnsoperations/software/schema-changesmaster+43 -0
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.Aug 31 2023, 10:48 AM

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

Stashbot added a comment.Aug 31 2023, 10:48 AM

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

Stashbot added a comment.Aug 31 2023, 10:50 AM

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

Stashbot added a comment.Aug 31 2023, 11:13 AM

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

Stashbot added a comment.Aug 31 2023, 11:13 AM

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

Stashbot added a comment.Aug 31 2023, 11:31 AM

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

Stashbot added a comment.Aug 31 2023, 11:36 AM

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

Stashbot added a comment.Aug 31 2023, 11:36 AM

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

Stashbot added a comment.Aug 31 2023, 11:39 AM

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

Stashbot added a comment.Aug 31 2023, 12:16 PM

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

Stashbot added a comment.Aug 31 2023, 12:17 PM

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

Stashbot added a comment.Aug 31 2023, 12:24 PM

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

Stashbot added a comment.Aug 31 2023, 12:25 PM

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

Stashbot added a comment.Aug 31 2023, 12:34 PM

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

Stashbot added a comment.Aug 31 2023, 12:42 PM

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

Stashbot added a comment.Aug 31 2023, 1:19 PM

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

Stashbot added a comment.Aug 31 2023, 1:20 PM

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

Stashbot added a comment.Aug 31 2023, 1:28 PM

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

Stashbot added a comment.Aug 31 2023, 1:28 PM

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

Stashbot added a comment.Aug 31 2023, 1:30 PM

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

Stashbot added a comment.Aug 31 2023, 1:39 PM

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

Stashbot added a comment.Aug 31 2023, 2:15 PM

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

Stashbot added a comment.Aug 31 2023, 2:24 PM

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

Stashbot added a comment.Aug 31 2023, 2:24 PM

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

Stashbot added a comment.Aug 31 2023, 2:44 PM

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

Stashbot added a comment.Aug 31 2023, 3:29 PM

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

Stashbot added a comment.Aug 31 2023, 3:30 PM

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

Stashbot added a comment.Aug 31 2023, 3:32 PM

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

Stashbot added a comment.Aug 31 2023, 4:17 PM

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

Ladsgroup updated the task description. (Show Details)Sep 1 2023, 8:38 AM
Ladsgroup closed subtask T344866: Queries to externallinks table fail following schema changes as Resolved.Sep 1 2023, 8:59 AM
• Marostegui subscribed.Sep 1 2023, 9:36 AM

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

JJMC89 mentioned this in T346347: Missing columns for table `externallinks` in Quarry.Sep 14 2023, 3:14 PM
Bdijkstra subscribed.Sep 14 2023, 4:05 PM

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

Ladsgroup added a comment.Sep 15 2023, 8:50 AM
In T343718#9167356, @Bdijkstra wrote:

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.

Ladsgroup added a comment.Dec 7 2023, 6:25 PM

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

Ladsgroup updated the task description. (Show Details)Dec 11 2023, 5:44 PM
Stashbot added a comment.Jan 23 2024, 2:06 PM

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

Ladsgroup updated the task description. (Show Details)Jan 25 2024, 11:29 AM
Stashbot added a comment.Jan 30 2024, 10:59 AM

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

Stashbot added a comment.Jan 30 2024, 11:02 AM

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

Ladsgroup updated the task description. (Show Details)Jan 30 2024, 11:05 AM
Stashbot added a comment.Jan 30 2024, 11:47 AM

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)Feb 1 2024, 1:22 PM
Ladsgroup updated the task description. (Show Details)Feb 8 2024, 10:52 AM
Ladsgroup updated the task description. (Show Details)
Ladsgroup updated the task description. (Show Details)Feb 8 2024, 9:11 PM
Ladsgroup updated the task description. (Show Details)Mar 5 2024, 10:57 AM
Stashbot added a comment.Mar 5 2024, 10:59 AM

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

Stashbot added a comment.Mar 5 2024, 11:30 AM

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

Stashbot added a comment.Mar 5 2024, 12:15 PM

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

Ladsgroup updated the task description. (Show Details)Mar 5 2024, 12:54 PM
Stashbot added a comment.Mar 25 2024, 3:14 PM

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

Stashbot added a comment.Mar 25 2024, 3:14 PM

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

Ladsgroup updated the task description. (Show Details)Mar 25 2024, 3:28 PM
Ladsgroup updated the task description. (Show Details)Mar 25 2024, 3:32 PM
Stashbot added a comment.Mar 26 2024, 11:06 AM

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

Stashbot added a comment.Mar 26 2024, 11:06 AM

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

Stashbot added a comment.Mar 26 2024, 8:46 PM

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

Stashbot added a comment.Mar 26 2024, 8:46 PM

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

Stashbot added a comment.Mar 26 2024, 8:54 PM

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

Stashbot added a comment.Mar 26 2024, 8:54 PM

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)Mar 26 2024, 10:11 PM
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