Make old columns of externallinks nullable
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Ladsgroup
	Jul 25 2023, 10:26 AM

Description

ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/938871/5/maintenance/archives/patch-externallinks-el_to_default.sql
Where to run those changes: everywhere
When to run those changes: any time
If the schema change is backwards compatible: yes
If the schema change has been tested already on some of the test/beta wikis: beta cluster is running with the new schema
if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Progress:

Details

	Subject	Repo	Branch	Lines +/-
	Add make_el_to_nullable_T342617.py	operations/software/schema-changes	master	+39 -0

Customize query in gerrit

Related Objects
Search...

Status	Subtype	Assigned	Task
Resolved		Bawolff	T130058 Special:LinkSearch fails over 10,000
Open		None	T47237 LinkSearch uses numeric offset paging instead of paging by last entry returned
Resolved		Ladsgroup	T17218 LinkSearch results should use as much of the path as is provided, not simply search by domain
Resolved	Feature	Ladsgroup	T14810 Special:Linksearch should default to all protocols (protocol-less column for externallinks)
Resolved		Ladsgroup	T312666 Remove duplication in externallinks table
Resolved		Ladsgroup	T342617 Make old columns of externallinks nullable

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-11T14:25:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2146 (T342617)', diff saved to https://phabricator.wikimedia.org/P50500 and previous config saved to /var/cache/conftool/dbconfig/20230811-142550-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T14:26:12Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2153 (T342617)', diff saved to https://phabricator.wikimedia.org/P50501 and previous config saved to /var/cache/conftool/dbconfig/20230811-142611-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T15:24:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T342617)', diff saved to https://phabricator.wikimedia.org/P50502 and previous config saved to /var/cache/conftool/dbconfig/20230811-152433-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T16:04:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T342617)', diff saved to https://phabricator.wikimedia.org/P50505 and previous config saved to /var/cache/conftool/dbconfig/20230811-160453-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T16:09:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T342617)', diff saved to https://phabricator.wikimedia.org/P50506 and previous config saved to /var/cache/conftool/dbconfig/20230811-160953-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T16:10:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1184 (T342617)', diff saved to https://phabricator.wikimedia.org/P50507 and previous config saved to /var/cache/conftool/dbconfig/20230811-161025-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T16:50:13Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2153 (T342617)', diff saved to https://phabricator.wikimedia.org/P50511 and previous config saved to /var/cache/conftool/dbconfig/20230811-165013-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T16:50:34Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2167:3311 (T342617)', diff saved to https://phabricator.wikimedia.org/P50512 and previous config saved to /var/cache/conftool/dbconfig/20230811-165033-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T17:48:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T342617)', diff saved to https://phabricator.wikimedia.org/P50513 and previous config saved to /var/cache/conftool/dbconfig/20230811-174851-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T18:16:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1221 (T342617)', diff saved to https://phabricator.wikimedia.org/P50515 and previous config saved to /var/cache/conftool/dbconfig/20230811-181649-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T18:30:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T342617)', diff saved to https://phabricator.wikimedia.org/P50517 and previous config saved to /var/cache/conftool/dbconfig/20230811-183008-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T18:34:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T342617)', diff saved to https://phabricator.wikimedia.org/P50519 and previous config saved to /var/cache/conftool/dbconfig/20230811-183410-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T18:34:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1186 (T342617)', diff saved to https://phabricator.wikimedia.org/P50520 and previous config saved to /var/cache/conftool/dbconfig/20230811-183431-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T19:02:08Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1221 (T342617)', diff saved to https://phabricator.wikimedia.org/P50524 and previous config saved to /var/cache/conftool/dbconfig/20230811-190208-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T19:15:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2167:3311 (T342617)', diff saved to https://phabricator.wikimedia.org/P50525 and previous config saved to /var/cache/conftool/dbconfig/20230811-191527-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T19:15:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2170:3311 (T342617)', diff saved to https://phabricator.wikimedia.org/P50526 and previous config saved to /var/cache/conftool/dbconfig/20230811-191548-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T20:15:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T342617)', diff saved to https://phabricator.wikimedia.org/P50527 and previous config saved to /var/cache/conftool/dbconfig/20230811-201505-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T20:55:47Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T342617)', diff saved to https://phabricator.wikimedia.org/P50530 and previous config saved to /var/cache/conftool/dbconfig/20230811-205546-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T21:00:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1186 (T342617)', diff saved to https://phabricator.wikimedia.org/P50531 and previous config saved to /var/cache/conftool/dbconfig/20230811-210024-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T21:01:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1196 (T342617)', diff saved to https://phabricator.wikimedia.org/P50532 and previous config saved to /var/cache/conftool/dbconfig/20230811-210102-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T21:41:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2170:3311 (T342617)', diff saved to https://phabricator.wikimedia.org/P50535 and previous config saved to /var/cache/conftool/dbconfig/20230811-214105-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T21:41:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2173 (T342617)', diff saved to https://phabricator.wikimedia.org/P50536 and previous config saved to /var/cache/conftool/dbconfig/20230811-214142-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T22:47:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T342617)', diff saved to https://phabricator.wikimedia.org/P50537 and previous config saved to /var/cache/conftool/dbconfig/20230811-224741-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T23:20:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T342617)', diff saved to https://phabricator.wikimedia.org/P50540 and previous config saved to /var/cache/conftool/dbconfig/20230811-232043-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T23:33:00Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1196 (T342617)', diff saved to https://phabricator.wikimedia.org/P50541 and previous config saved to /var/cache/conftool/dbconfig/20230811-233259-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-11T23:33:21Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1206 (T342617)', diff saved to https://phabricator.wikimedia.org/P50542 and previous config saved to /var/cache/conftool/dbconfig/20230811-233320-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T00:06:02Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2173 (T342617)', diff saved to https://phabricator.wikimedia.org/P50545 and previous config saved to /var/cache/conftool/dbconfig/20230812-000602-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T00:06:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2174 (T342617)', diff saved to https://phabricator.wikimedia.org/P50546 and previous config saved to /var/cache/conftool/dbconfig/20230812-000623-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T01:13:30Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T342617)', diff saved to https://phabricator.wikimedia.org/P50547 and previous config saved to /var/cache/conftool/dbconfig/20230812-011330-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T01:49:01Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T342617)', diff saved to https://phabricator.wikimedia.org/P50550 and previous config saved to /var/cache/conftool/dbconfig/20230812-014901-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T01:58:49Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1206 (T342617)', diff saved to https://phabricator.wikimedia.org/P50551 and previous config saved to /var/cache/conftool/dbconfig/20230812-015849-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T01:59:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1207 (T342617)', diff saved to https://phabricator.wikimedia.org/P50552 and previous config saved to /var/cache/conftool/dbconfig/20230812-015910-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T02:34:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2174 (T342617)', diff saved to https://phabricator.wikimedia.org/P50555 and previous config saved to /var/cache/conftool/dbconfig/20230812-023419-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T02:34:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2176 (T342617)', diff saved to https://phabricator.wikimedia.org/P50556 and previous config saved to /var/cache/conftool/dbconfig/20230812-023441-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T03:52:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1207 (T342617)', diff saved to https://phabricator.wikimedia.org/P50557 and previous config saved to /var/cache/conftool/dbconfig/20230812-035205-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T04:16:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T342617)', diff saved to https://phabricator.wikimedia.org/P50559 and previous config saved to /var/cache/conftool/dbconfig/20230812-041608-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T04:37:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1207 (T342617)', diff saved to https://phabricator.wikimedia.org/P50562 and previous config saved to /var/cache/conftool/dbconfig/20230812-043724-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T05:01:28Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2176 (T342617)', diff saved to https://phabricator.wikimedia.org/P50564 and previous config saved to /var/cache/conftool/dbconfig/20230812-050127-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T05:56:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1219 (T342617)', diff saved to https://phabricator.wikimedia.org/P50565 and previous config saved to /var/cache/conftool/dbconfig/20230812-055651-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T07:39:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T342617)', diff saved to https://phabricator.wikimedia.org/P50566 and previous config saved to /var/cache/conftool/dbconfig/20230812-073953-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-12T08:25:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1219 (T342617)', diff saved to https://phabricator.wikimedia.org/P50569 and previous config saved to /var/cache/conftool/dbconfig/20230812-082511-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Aug 21 2023, 12:58 PM

Mentioned in SAL (#wikimedia-operations) [2023-08-21T13:01:18Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1172 (T342617)', diff saved to https://phabricator.wikimedia.org/P50609 and previous config saved to /var/cache/conftool/dbconfig/20230821-130118-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-21T13:49:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T342617)', diff saved to https://phabricator.wikimedia.org/P50621 and previous config saved to /var/cache/conftool/dbconfig/20230821-134926-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-21T13:49:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1213:3315 (T342617)', diff saved to https://phabricator.wikimedia.org/P50622 and previous config saved to /var/cache/conftool/dbconfig/20230821-134949-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-21T14:34:49Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T342617)', diff saved to https://phabricator.wikimedia.org/P50634 and previous config saved to /var/cache/conftool/dbconfig/20230821-143449-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-21T14:47:58Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1213:3315 (T342617)', diff saved to https://phabricator.wikimedia.org/P50637 and previous config saved to /var/cache/conftool/dbconfig/20230821-144757-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-08-21T15:33:17Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1213:3315 (T342617)', diff saved to https://phabricator.wikimedia.org/P50649 and previous config saved to /var/cache/conftool/dbconfig/20230821-153316-ladsgroup.json