Drop foreign keys and rename index for table echo_push_subscription on wmf wikis
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Umherirrender
	Jul 13 2022, 6:11 PM

Description

Apply T306473 on wmf wikis

ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/Echo/+/784322/7/sql/mysql/patch-cleanup-push_subscription-foreign-keys-indexes.sql
Where to run those changes: x1 + wikitech, mediawiki, metawiki and officewiki
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 already 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

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

Mentioned In: rSCHCHbd8df210ba95: Add rename_echo_push_indexes_T312975.py
Mentioned Here: P32941 dbctl commit (dc=all): 'Repooling after maintenance db2115 (T312975)'
P32937 dbctl commit (dc=all): 'Repooling after maintenance db2115 (T312975)'
P32936 dbctl commit (dc=all): 'Depooling db2115 (T312975)'
P32935 dbctl commit (dc=all): 'Repooling after maintenance db2131 (T312975)'
P32928 dbctl commit (dc=all): 'Repooling after maintenance db2131 (T312975)'
P32926 dbctl commit (dc=all): 'Depooling db2131 (T312975)'
P32925 dbctl commit (dc=all): 'Repooling after maintenance db1137 (T312975)'
P32916 dbctl commit (dc=all): 'Repooling after maintenance db1137 (T312975)'
P32915 dbctl commit (dc=all): 'Depooling db1137 (T312975)'
P32914 dbctl commit (dc=all): 'Repooling after maintenance db1120 (T312975)'
P32907 dbctl commit (dc=all): 'Repooling after maintenance db1120 (T312975)'
P32906 dbctl commit (dc=all): 'Depooling db1120 (T312975)'
T306473: Drop foreign keys from echo table echo_push_subscription

Umherirrender triaged this task as Lowest priority.Jul 13 2022, 6:31 PM

Ladsgroup moved this task from Ready to In progress on the DBA board.

It's on wikishared, that makes things much easier.

Change 826271 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/software/schema-changes@master] Add rename_echo_push_indexes_T312975.py

Mentioned in SAL (#wikimedia-operations) [2022-08-24T11:59:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1120 (T312975)', diff saved to https://phabricator.wikimedia.org/P32906 and previous config saved to /var/cache/conftool/dbconfig/20220824-115935-ladsgroup.json

Change 826271 merged by jenkins-bot:

[operations/software/schema-changes@master] Add rename_echo_push_indexes_T312975.py

Mentioned in SAL (#wikimedia-operations) [2022-08-24T12:03:47Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1120 (T312975)', diff saved to https://phabricator.wikimedia.org/P32907 and previous config saved to /var/cache/conftool/dbconfig/20220824-120346-ladsgroup.json

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

Mentioned in SAL (#wikimedia-operations) [2022-08-24T12:50:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1137 (T312975)', diff saved to https://phabricator.wikimedia.org/P32915 and previous config saved to /var/cache/conftool/dbconfig/20220824-125003-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-24T12:54:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1137 (T312975)', diff saved to https://phabricator.wikimedia.org/P32916 and previous config saved to /var/cache/conftool/dbconfig/20220824-125414-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-24T13:39:33Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1137 (T312975)', diff saved to https://phabricator.wikimedia.org/P32925 and previous config saved to /var/cache/conftool/dbconfig/20220824-133932-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-24T13:39:54Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2131 (T312975)', diff saved to https://phabricator.wikimedia.org/P32926 and previous config saved to /var/cache/conftool/dbconfig/20220824-133953-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-24T13:41:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2131 (T312975)', diff saved to https://phabricator.wikimedia.org/P32928 and previous config saved to /var/cache/conftool/dbconfig/20220824-134104-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-24T14:26:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2131 (T312975)', diff saved to https://phabricator.wikimedia.org/P32935 and previous config saved to /var/cache/conftool/dbconfig/20220824-142623-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-24T14:27:15Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2115 (T312975)', diff saved to https://phabricator.wikimedia.org/P32936 and previous config saved to /var/cache/conftool/dbconfig/20220824-142715-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-24T14:29:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2115 (T312975)', diff saved to https://phabricator.wikimedia.org/P32937 and previous config saved to /var/cache/conftool/dbconfig/20220824-142926-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-08-24T15:14:46Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2115 (T312975)', diff saved to https://phabricator.wikimedia.org/P32941 and previous config saved to /var/cache/conftool/dbconfig/20220824-151445-ladsgroup.json

Ladsgroup closed this task as Resolved.Aug 24 2022, 5:42 PM

Ladsgroup moved this task from In progress to Done on the DBA board.