Page MenuHomePhabricator

Fix renamed indexes of flaggedrevs_tracking table in production
Closed, ResolvedPublic

Description

The second part of https://gerrit.wikimedia.org/r/c/mediawiki/extensions/FlaggedRevs/+/110451/1/backend/schema/mysql/FlaggedRevs.sql#b131

  1. ALTERs to run: See above
  2. Where to run those changes: flaggedrevs.dblist
  3. When to run those changes: At any time
  4. If the schema change is backwards compatible: Yes.
  5. 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.
  6. if the data should be made available on the labs replicas and/or dumps: The table only contains public data.

Progress:

  • s1: Done
  • s2: Done
  • s3: Done
  • s4: NA
  • s5: Done
  • s6: Done
  • s7: Done
  • s8; NA

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) [2022-12-08T08:44:21Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2122 (T322618)', diff saved to https://phabricator.wikimedia.org/P42588 and previous config saved to /var/cache/conftool/dbconfig/20221208-084421-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T08:44:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2150 (T322618)', diff saved to https://phabricator.wikimedia.org/P42589 and previous config saved to /var/cache/conftool/dbconfig/20221208-084442-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T08:46:59Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2150 (T322618)', diff saved to https://phabricator.wikimedia.org/P42590 and previous config saved to /var/cache/conftool/dbconfig/20221208-084659-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T08:56:58Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1127 (T322618)', diff saved to https://phabricator.wikimedia.org/P42591 and previous config saved to /var/cache/conftool/dbconfig/20221208-085657-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T08:57:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1158 (T322618)', diff saved to https://phabricator.wikimedia.org/P42592 and previous config saved to /var/cache/conftool/dbconfig/20221208-085724-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T09:32:19Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2150 (T322618)', diff saved to https://phabricator.wikimedia.org/P42595 and previous config saved to /var/cache/conftool/dbconfig/20221208-093218-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T09:32:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2159 (T322618)', diff saved to https://phabricator.wikimedia.org/P42596 and previous config saved to /var/cache/conftool/dbconfig/20221208-093255-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T09:35:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2159 (T322618)', diff saved to https://phabricator.wikimedia.org/P42597 and previous config saved to /var/cache/conftool/dbconfig/20221208-093511-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T09:57:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T322618)', diff saved to https://phabricator.wikimedia.org/P42599 and previous config saved to /var/cache/conftool/dbconfig/20221208-095741-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T10:20:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2159 (T322618)', diff saved to https://phabricator.wikimedia.org/P42603 and previous config saved to /var/cache/conftool/dbconfig/20221208-102030-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T10:20:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2168:3317 (T322618)', diff saved to https://phabricator.wikimedia.org/P42604 and previous config saved to /var/cache/conftool/dbconfig/20221208-102052-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T10:23:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2168:3317 (T322618)', diff saved to https://phabricator.wikimedia.org/P42605 and previous config saved to /var/cache/conftool/dbconfig/20221208-102308-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T10:43:01Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T322618)', diff saved to https://phabricator.wikimedia.org/P42609 and previous config saved to /var/cache/conftool/dbconfig/20221208-104300-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T10:43:22Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1170:3317 (T322618)', diff saved to https://phabricator.wikimedia.org/P42610 and previous config saved to /var/cache/conftool/dbconfig/20221208-104322-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T10:44:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T322618)', diff saved to https://phabricator.wikimedia.org/P42611 and previous config saved to /var/cache/conftool/dbconfig/20221208-104432-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T11:08:28Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2168:3317 (T322618)', diff saved to https://phabricator.wikimedia.org/P42614 and previous config saved to /var/cache/conftool/dbconfig/20221208-110828-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T11:08:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2169:3317 (T322618)', diff saved to https://phabricator.wikimedia.org/P42615 and previous config saved to /var/cache/conftool/dbconfig/20221208-110849-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T11:11:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2169:3317 (T322618)', diff saved to https://phabricator.wikimedia.org/P42616 and previous config saved to /var/cache/conftool/dbconfig/20221208-111105-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T11:29:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T322618)', diff saved to https://phabricator.wikimedia.org/P42619 and previous config saved to /var/cache/conftool/dbconfig/20221208-112951-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T11:30:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1174 (T322618)', diff saved to https://phabricator.wikimedia.org/P42620 and previous config saved to /var/cache/conftool/dbconfig/20221208-113030-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T11:32:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T322618)', diff saved to https://phabricator.wikimedia.org/P42621 and previous config saved to /var/cache/conftool/dbconfig/20221208-113240-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T11:56:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2169:3317 (T322618)', diff saved to https://phabricator.wikimedia.org/P42624 and previous config saved to /var/cache/conftool/dbconfig/20221208-115627-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T11:57:00Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2182 (T322618)', diff saved to https://phabricator.wikimedia.org/P42625 and previous config saved to /var/cache/conftool/dbconfig/20221208-115659-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T11:59:16Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2182 (T322618)', diff saved to https://phabricator.wikimedia.org/P42626 and previous config saved to /var/cache/conftool/dbconfig/20221208-115915-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T12:18:02Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T322618)', diff saved to https://phabricator.wikimedia.org/P42629 and previous config saved to /var/cache/conftool/dbconfig/20221208-121801-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T12:18:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1181 (T322618)', diff saved to https://phabricator.wikimedia.org/P42630 and previous config saved to /var/cache/conftool/dbconfig/20221208-121823-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T12:20:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T322618)', diff saved to https://phabricator.wikimedia.org/P42631 and previous config saved to /var/cache/conftool/dbconfig/20221208-122032-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T12:44:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2182 (T322618)', diff saved to https://phabricator.wikimedia.org/P42634 and previous config saved to /var/cache/conftool/dbconfig/20221208-124435-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T13:05:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1181 (T322618)', diff saved to https://phabricator.wikimedia.org/P42637 and previous config saved to /var/cache/conftool/dbconfig/20221208-130551-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T13:06:13Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1191 (T322618)', diff saved to https://phabricator.wikimedia.org/P42638 and previous config saved to /var/cache/conftool/dbconfig/20221208-130612-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T13:08:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1191 (T322618)', diff saved to https://phabricator.wikimedia.org/P42639 and previous config saved to /var/cache/conftool/dbconfig/20221208-130822-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T13:53:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1191 (T322618)', diff saved to https://phabricator.wikimedia.org/P42642 and previous config saved to /var/cache/conftool/dbconfig/20221208-135341-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T13:54:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1194 (T322618)', diff saved to https://phabricator.wikimedia.org/P42643 and previous config saved to /var/cache/conftool/dbconfig/20221208-135402-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T13:56:12Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1194 (T322618)', diff saved to https://phabricator.wikimedia.org/P42644 and previous config saved to /var/cache/conftool/dbconfig/20221208-135611-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T14:41:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1194 (T322618)', diff saved to https://phabricator.wikimedia.org/P42647 and previous config saved to /var/cache/conftool/dbconfig/20221208-144131-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T14:41:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1202 (T322618)', diff saved to https://phabricator.wikimedia.org/P42648 and previous config saved to /var/cache/conftool/dbconfig/20221208-144152-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T14:46:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1202 (T322618)', diff saved to https://phabricator.wikimedia.org/P42649 and previous config saved to /var/cache/conftool/dbconfig/20221208-144602-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-12-08T15:31:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1202 (T322618)', diff saved to https://phabricator.wikimedia.org/P42654 and previous config saved to /var/cache/conftool/dbconfig/20221208-153123-ladsgroup.json

Ladsgroup updated the task description. (Show Details)

This was quite a messy one, I'll double check before closing.

Mentioned in SAL (#wikimedia-operations) [2023-01-24T05:58:16Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2107 (T322618)', diff saved to https://phabricator.wikimedia.org/P43268 and previous config saved to /var/cache/conftool/dbconfig/20230124-055816-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-01-24T06:00:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2107 (T322618)', diff saved to https://phabricator.wikimedia.org/P43269 and previous config saved to /var/cache/conftool/dbconfig/20230124-060035-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-01-24T06:01:30Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2118 (T322618)', diff saved to https://phabricator.wikimedia.org/P43270 and previous config saved to /var/cache/conftool/dbconfig/20230124-060129-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-01-24T06:03:46Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2118 (T322618)', diff saved to https://phabricator.wikimedia.org/P43271 and previous config saved to /var/cache/conftool/dbconfig/20230124-060345-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-01-24T06:45:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2107 (T322618)', diff saved to https://phabricator.wikimedia.org/P43276 and previous config saved to /var/cache/conftool/dbconfig/20230124-064554-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-01-24T06:49:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2118 (T322618)', diff saved to https://phabricator.wikimedia.org/P43277 and previous config saved to /var/cache/conftool/dbconfig/20230124-064905-ladsgroup.json

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

Now it's honest to god done!!!!