Fix renamed indexes of flaggedrevs table in production
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Ladsgroup
	Sep 29 2022, 4:44 PM

Description

It seems https://gerrit.wikimedia.org/r/c/mediawiki/extensions/FlaggedRevs/+/110451/1/backend/schema/mysql/FlaggedRevs.sql never was applied to production. We need to run the schema change to actually fix it.

ALTERs to run: TBD
Where to run those changes: flaggedrevs.dblist
When to run those changes: At 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: This has been around for ten years on new wikis.
if the data should be made available on the labs replicas and/or dumps: The table only contains public data.

Progress:

Details

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

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Open	None	T313251 Collect and fix schema drifts of wmf-deployed extension tables in production
Resolved	Ladsgroup	T313253 Fix Flaggedrevs database schema drifts in production
Resolved	Ladsgroup	T318950 Fix renamed indexes of flaggedrevs table in production

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

Mentioned in SAL (#wikimedia-operations) [2022-11-02T09:36:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2124 (T318950)', diff saved to https://phabricator.wikimedia.org/P37607 and previous config saved to /var/cache/conftool/dbconfig/20221102-093517-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T09:37:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37608 and previous config saved to /var/cache/conftool/dbconfig/20221102-093657-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T09:38:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2124 (T318950)', diff saved to https://phabricator.wikimedia.org/P37610 and previous config saved to /var/cache/conftool/dbconfig/20221102-093730-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T10:22:21Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37627 and previous config saved to /var/cache/conftool/dbconfig/20221102-102221-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T10:22:49Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1113:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37628 and previous config saved to /var/cache/conftool/dbconfig/20221102-102233-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T10:23:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2124 (T318950)', diff saved to https://phabricator.wikimedia.org/P37630 and previous config saved to /var/cache/conftool/dbconfig/20221102-102256-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Nov 2 2022, 10:23 AM

Mentioned in SAL (#wikimedia-operations) [2022-11-02T10:24:26Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2129 (T318950)', diff saved to https://phabricator.wikimedia.org/P37632 and previous config saved to /var/cache/conftool/dbconfig/20221102-102320-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T10:24:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37633 and previous config saved to /var/cache/conftool/dbconfig/20221102-102342-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T10:25:34Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2129 (T318950)', diff saved to https://phabricator.wikimedia.org/P37635 and previous config saved to /var/cache/conftool/dbconfig/20221102-102533-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T11:09:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37650 and previous config saved to /var/cache/conftool/dbconfig/20221102-110909-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T11:09:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1131 (T318950)', diff saved to https://phabricator.wikimedia.org/P37651 and previous config saved to /var/cache/conftool/dbconfig/20221102-110931-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T11:11:02Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2129 (T318950)', diff saved to https://phabricator.wikimedia.org/P37653 and previous config saved to /var/cache/conftool/dbconfig/20221102-111059-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T11:13:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1131 (T318950)', diff saved to https://phabricator.wikimedia.org/P37655 and previous config saved to /var/cache/conftool/dbconfig/20221102-111141-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T11:13:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2158 (T318950)', diff saved to https://phabricator.wikimedia.org/P37656 and previous config saved to /var/cache/conftool/dbconfig/20221102-111147-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T11:14:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T318950)', diff saved to https://phabricator.wikimedia.org/P37658 and previous config saved to /var/cache/conftool/dbconfig/20221102-111400-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T11:57:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1131 (T318950)', diff saved to https://phabricator.wikimedia.org/P37680 and previous config saved to /var/cache/conftool/dbconfig/20221102-115705-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T11:59:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1165 (T318950)', diff saved to https://phabricator.wikimedia.org/P37681 and previous config saved to /var/cache/conftool/dbconfig/20221102-115802-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T11:59:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2158 (T318950)', diff saved to https://phabricator.wikimedia.org/P37683 and previous config saved to /var/cache/conftool/dbconfig/20221102-115925-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T12:01:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2169:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37685 and previous config saved to /var/cache/conftool/dbconfig/20221102-115948-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T12:02:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1165 (T318950)', diff saved to https://phabricator.wikimedia.org/P37686 and previous config saved to /var/cache/conftool/dbconfig/20221102-120013-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T12:04:15Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2169:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37688 and previous config saved to /var/cache/conftool/dbconfig/20221102-120209-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T12:45:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1165 (T318950)', diff saved to https://phabricator.wikimedia.org/P37709 and previous config saved to /var/cache/conftool/dbconfig/20221102-124537-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T12:46:49Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1168 (T318950)', diff saved to https://phabricator.wikimedia.org/P37710 and previous config saved to /var/cache/conftool/dbconfig/20221102-124602-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T12:47:58Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2169:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37712 and previous config saved to /var/cache/conftool/dbconfig/20221102-124732-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T12:49:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2171:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37714 and previous config saved to /var/cache/conftool/dbconfig/20221102-124754-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T12:49:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T318950)', diff saved to https://phabricator.wikimedia.org/P37715 and previous config saved to /var/cache/conftool/dbconfig/20221102-124812-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T12:50:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2171:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37718 and previous config saved to /var/cache/conftool/dbconfig/20221102-125009-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T13:33:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T318950)', diff saved to https://phabricator.wikimedia.org/P37737 and previous config saved to /var/cache/conftool/dbconfig/20221102-133338-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T13:34:02Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1180 (T318950)', diff saved to https://phabricator.wikimedia.org/P37739 and previous config saved to /var/cache/conftool/dbconfig/20221102-133402-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T13:35:54Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2171:3316 (T318950)', diff saved to https://phabricator.wikimedia.org/P37741 and previous config saved to /var/cache/conftool/dbconfig/20221102-133533-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T13:37:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2180 (T318950)', diff saved to https://phabricator.wikimedia.org/P37743 and previous config saved to /var/cache/conftool/dbconfig/20221102-133559-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T13:39:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2180 (T318950)', diff saved to https://phabricator.wikimedia.org/P37747 and previous config saved to /var/cache/conftool/dbconfig/20221102-133819-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T13:40:13Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T318950)', diff saved to https://phabricator.wikimedia.org/P37748 and previous config saved to /var/cache/conftool/dbconfig/20221102-134012-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T14:23:46Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2180 (T318950)', diff saved to https://phabricator.wikimedia.org/P37772 and previous config saved to /var/cache/conftool/dbconfig/20221102-142345-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T14:25:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T318950)', diff saved to https://phabricator.wikimedia.org/P37773 and previous config saved to /var/cache/conftool/dbconfig/20221102-142540-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T14:26:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1187 (T318950)', diff saved to https://phabricator.wikimedia.org/P37774 and previous config saved to /var/cache/conftool/dbconfig/20221102-142605-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T14:28:19Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1187 (T318950)', diff saved to https://phabricator.wikimedia.org/P37775 and previous config saved to /var/cache/conftool/dbconfig/20221102-142818-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T15:13:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1187 (T318950)', diff saved to https://phabricator.wikimedia.org/P37790 and previous config saved to /var/cache/conftool/dbconfig/20221102-151341-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T15:14:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1201 (T318950)', diff saved to https://phabricator.wikimedia.org/P37791 and previous config saved to /var/cache/conftool/dbconfig/20221102-151403-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T15:16:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1201 (T318950)', diff saved to https://phabricator.wikimedia.org/P37792 and previous config saved to /var/cache/conftool/dbconfig/20221102-151613-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-02T16:01:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1201 (T318950)', diff saved to https://phabricator.wikimedia.org/P37804 and previous config saved to /var/cache/conftool/dbconfig/20221102-160136-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-15T14:21:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1202 (T318950)', diff saved to https://phabricator.wikimedia.org/P39738 and previous config saved to /var/cache/conftool/dbconfig/20221115-142130-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-15T14:23:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1202 (T318950)', diff saved to https://phabricator.wikimedia.org/P39739 and previous config saved to /var/cache/conftool/dbconfig/20221115-142342-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-11-15T15:09:02Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1202 (T318950)', diff saved to https://phabricator.wikimedia.org/P39750 and previous config saved to /var/cache/conftool/dbconfig/20221115-150901-ladsgroup.json