Page MenuHomePhabricator

Rename index su_normalized on table spoofuser on wmf wikis
Open, LowestPublic

Description

As part of the abstract schema migration in T268535 there is a index rename from su_normalized to su_normname_idx

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/AntiSpoof/+/750804/6/sql/mysql/patch-spoofuser-index-su_normname_idx.sql
  2. Where to run those changes: all wikis + central auth
  3. When to run those changes: 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: beta already running with the new schema
  6. if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Progress

  • s1
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7
    • centralauth
  • s8
  • labtestwiki

Related Objects

Mentioned In
rSCHCH6b5d8c205015: rename_su_normalized_T312972.py: typo
rSCHCH1f2617160fab: rename_su_normalized_T312972.py: New schema change
Mentioned Here
P32278 dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T312972)'
P32275 dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T312972)'
P32274 dbctl commit (dc=all): 'Depooling db1146:3312 (T312972)'
P32273 dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T312972)'
P32270 dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T312972)'
P32269 dbctl commit (dc=all): 'Depooling db1170:3312 (T312972)'
P32268 dbctl commit (dc=all): 'Repooling after maintenance db1156 (T312972)'
P32265 dbctl commit (dc=all): 'Repooling after maintenance db1156 (T312972)'
P32264 dbctl commit (dc=all): 'Depooling db1156 (T312972)'
P32263 dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T312972)'
P32260 dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T312972)'
P32259 dbctl commit (dc=all): 'Depooling db1105:3312 (T312972)'
P32258 dbctl commit (dc=all): 'Repooling after maintenance db1122 (T312972)'
P32255 dbctl commit (dc=all): 'Repooling after maintenance db1122 (T312972)'
P32254 dbctl commit (dc=all): 'Depooling db1122 (T312972)'
P32253 dbctl commit (dc=all): 'Repooling after maintenance db1182 (T312972)'
P32250 dbctl commit (dc=all): 'Repooling after maintenance db1182 (T312972)'
P32249 dbctl commit (dc=all): 'Depooling db1182 (T312972)'
P32248 dbctl commit (dc=all): 'Repooling after maintenance db1129 (T312972)'
P32242 dbctl commit (dc=all): 'Repooling after maintenance db1172 (T312972)'
P32239 dbctl commit (dc=all): 'Repooling after maintenance db1172 (T312972)'
P32238 dbctl commit (dc=all): 'Depooling db1172 (T312972)'
P32237 dbctl commit (dc=all): 'Repooling after maintenance db1109 (T312972)'
P32234 dbctl commit (dc=all): 'Repooling after maintenance db1109 (T312972)'
P32233 dbctl commit (dc=all): 'Depooling db1109 (T312972)'
P32232 dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T312972)'
P32229 dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T312972)'
P32228 dbctl commit (dc=all): 'Depooling db1099:3318 (T312972)'
P32227 dbctl commit (dc=all): 'Repooling after maintenance db1114 (T312972)'
P32223 dbctl commit (dc=all): 'Repooling after maintenance db1114 (T312972)'
P32222 dbctl commit (dc=all): 'Depooling db1114 (T312972)'
P32221 dbctl commit (dc=all): 'Repooling after maintenance db1177 (T312972)'
P32217 dbctl commit (dc=all): 'Repooling after maintenance db1177 (T312972)'
P32216 dbctl commit (dc=all): 'Depooling db1177 (T312972)'
P32215 dbctl commit (dc=all): 'Repooling after maintenance db1126 (T312972)'
P32211 dbctl commit (dc=all): 'Repooling after maintenance db1126 (T312972)'
P32210 dbctl commit (dc=all): 'Depooling db1126 (T312972)'
P32209 dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T312972)'
P32205 dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T312972)'
P32204 dbctl commit (dc=all): 'Depooling db1101:3318 (T312972)'
P32203 dbctl commit (dc=all): 'Repooling after maintenance db1167 (T312972)'
P32200 dbctl commit (dc=all): 'Repooling after maintenance db1167 (T312972)'
P32197 dbctl commit (dc=all): 'Depooling db1167 (T312972)'
P32196 dbctl commit (dc=all): 'Repooling after maintenance db1178 (T312972)'
P32193 dbctl commit (dc=all): 'Repooling after maintenance db1178 (T312972)'
P32192 dbctl commit (dc=all): 'Depooling db1178 (T312972)'
P32191 dbctl commit (dc=all): 'Repooling after maintenance db1111 (T312972)'
P32188 dbctl commit (dc=all): 'Repooling after maintenance db1111 (T312972)'
P32187 dbctl commit (dc=all): 'Depooling db1111 (T312972)'
P32185 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T312972)'
P32181 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T312972)'
P32180 dbctl commit (dc=all): 'Depooling db1168 (T312972)'
P32179 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T312972)'
P32176 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T312972)'
P32175 dbctl commit (dc=all): 'Depooling db1131 (T312972)'
P32174 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T312972)'
P32171 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T312972)'
P32170 dbctl commit (dc=all): 'Depooling db1165 (T312972)'
P32169 dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T312972)'
P32164 dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T312972)'
P32163 dbctl commit (dc=all): 'Depooling db1113:3316 (T312972)'
P32162 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T312972)'
P32159 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T312972)'
P32158 dbctl commit (dc=all): 'Depooling db1098:3316 (T312972)'
P32157 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T312972)'
P32154 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T312972)'
P32153 dbctl commit (dc=all): 'Depooling db1096:3316 (T312972)'
P32152 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T312972)'
P32149 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T312972)'
P32148 dbctl commit (dc=all): 'Depooling db1180 (T312972)'
T268535: Convert AntiSpoof to AbstractSchema

Event Timeline

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

Mentioned in SAL (#wikimedia-operations) [2022-08-03T05:41:06Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1111 (T312972)', diff saved to https://phabricator.wikimedia.org/P32187 and previous config saved to /var/cache/conftool/dbconfig/20220803-054106-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T05:45:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1111 (T312972)', diff saved to https://phabricator.wikimedia.org/P32188 and previous config saved to /var/cache/conftool/dbconfig/20220803-054526-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T06:30:45Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1111 (T312972)', diff saved to https://phabricator.wikimedia.org/P32191 and previous config saved to /var/cache/conftool/dbconfig/20220803-063045-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T06:31:49Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1178 (T312972)', diff saved to https://phabricator.wikimedia.org/P32192 and previous config saved to /var/cache/conftool/dbconfig/20220803-063148-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T06:36:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T312972)', diff saved to https://phabricator.wikimedia.org/P32193 and previous config saved to /var/cache/conftool/dbconfig/20220803-063656-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T07:22:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1178 (T312972)', diff saved to https://phabricator.wikimedia.org/P32196 and previous config saved to /var/cache/conftool/dbconfig/20220803-072214-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T07:22:54Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1167 (T312972)', diff saved to https://phabricator.wikimedia.org/P32197 and previous config saved to /var/cache/conftool/dbconfig/20220803-072253-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T08:23:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T312972)', diff saved to https://phabricator.wikimedia.org/P32200 and previous config saved to /var/cache/conftool/dbconfig/20220803-082318-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T09:08:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1167 (T312972)', diff saved to https://phabricator.wikimedia.org/P32203 and previous config saved to /var/cache/conftool/dbconfig/20220803-090836-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T09:09:13Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1101:3318 (T312972)', diff saved to https://phabricator.wikimedia.org/P32204 and previous config saved to /var/cache/conftool/dbconfig/20220803-090912-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T09:10:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T312972)', diff saved to https://phabricator.wikimedia.org/P32205 and previous config saved to /var/cache/conftool/dbconfig/20220803-091019-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T09:55:39Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T312972)', diff saved to https://phabricator.wikimedia.org/P32209 and previous config saved to /var/cache/conftool/dbconfig/20220803-095538-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T09:56:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1126 (T312972)', diff saved to https://phabricator.wikimedia.org/P32210 and previous config saved to /var/cache/conftool/dbconfig/20220803-095559-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T09:57:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1126 (T312972)', diff saved to https://phabricator.wikimedia.org/P32211 and previous config saved to /var/cache/conftool/dbconfig/20220803-095706-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T10:42:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1126 (T312972)', diff saved to https://phabricator.wikimedia.org/P32215 and previous config saved to /var/cache/conftool/dbconfig/20220803-104224-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T10:42:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1177 (T312972)', diff saved to https://phabricator.wikimedia.org/P32216 and previous config saved to /var/cache/conftool/dbconfig/20220803-104246-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T11:43:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T312972)', diff saved to https://phabricator.wikimedia.org/P32217 and previous config saved to /var/cache/conftool/dbconfig/20220803-114301-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T12:28:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T312972)', diff saved to https://phabricator.wikimedia.org/P32221 and previous config saved to /var/cache/conftool/dbconfig/20220803-122819-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T12:29:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1114 (T312972)', diff saved to https://phabricator.wikimedia.org/P32222 and previous config saved to /var/cache/conftool/dbconfig/20220803-122929-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T12:33:37Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1114 (T312972)', diff saved to https://phabricator.wikimedia.org/P32223 and previous config saved to /var/cache/conftool/dbconfig/20220803-123336-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T13:18:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1114 (T312972)', diff saved to https://phabricator.wikimedia.org/P32227 and previous config saved to /var/cache/conftool/dbconfig/20220803-131855-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T13:19:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1099:3318 (T312972)', diff saved to https://phabricator.wikimedia.org/P32228 and previous config saved to /var/cache/conftool/dbconfig/20220803-131916-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T13:25:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T312972)', diff saved to https://phabricator.wikimedia.org/P32229 and previous config saved to /var/cache/conftool/dbconfig/20220803-132524-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T14:10:43Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T312972)', diff saved to https://phabricator.wikimedia.org/P32232 and previous config saved to /var/cache/conftool/dbconfig/20220803-141042-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T14:11:04Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1109 (T312972)', diff saved to https://phabricator.wikimedia.org/P32233 and previous config saved to /var/cache/conftool/dbconfig/20220803-141103-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T14:13:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1109 (T312972)', diff saved to https://phabricator.wikimedia.org/P32234 and previous config saved to /var/cache/conftool/dbconfig/20220803-141310-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T14:58:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1109 (T312972)', diff saved to https://phabricator.wikimedia.org/P32237 and previous config saved to /var/cache/conftool/dbconfig/20220803-145828-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T14:58:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1172 (T312972)', diff saved to https://phabricator.wikimedia.org/P32238 and previous config saved to /var/cache/conftool/dbconfig/20220803-145849-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T14:59:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T312972)', diff saved to https://phabricator.wikimedia.org/P32239 and previous config saved to /var/cache/conftool/dbconfig/20220803-145956-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T15:45:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T312972)', diff saved to https://phabricator.wikimedia.org/P32242 and previous config saved to /var/cache/conftool/dbconfig/20220803-154515-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T19:33:34Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1129 (T312972)', diff saved to https://phabricator.wikimedia.org/P32248 and previous config saved to /var/cache/conftool/dbconfig/20220803-193334-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T19:33:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1182 (T312972)', diff saved to https://phabricator.wikimedia.org/P32249 and previous config saved to /var/cache/conftool/dbconfig/20220803-193354-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T19:36:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1182 (T312972)', diff saved to https://phabricator.wikimedia.org/P32250 and previous config saved to /var/cache/conftool/dbconfig/20220803-193607-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T20:21:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1182 (T312972)', diff saved to https://phabricator.wikimedia.org/P32253 and previous config saved to /var/cache/conftool/dbconfig/20220803-202125-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T20:21:46Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1122 (T312972)', diff saved to https://phabricator.wikimedia.org/P32254 and previous config saved to /var/cache/conftool/dbconfig/20220803-202146-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T20:26:59Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1122 (T312972)', diff saved to https://phabricator.wikimedia.org/P32255 and previous config saved to /var/cache/conftool/dbconfig/20220803-202658-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T21:12:17Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1122 (T312972)', diff saved to https://phabricator.wikimedia.org/P32258 and previous config saved to /var/cache/conftool/dbconfig/20220803-211216-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T21:12:38Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1105:3312 (T312972)', diff saved to https://phabricator.wikimedia.org/P32259 and previous config saved to /var/cache/conftool/dbconfig/20220803-211237-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T21:14:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T312972)', diff saved to https://phabricator.wikimedia.org/P32260 and previous config saved to /var/cache/conftool/dbconfig/20220803-211449-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T22:00:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T312972)', diff saved to https://phabricator.wikimedia.org/P32263 and previous config saved to /var/cache/conftool/dbconfig/20220803-220007-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T22:00:57Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1156 (T312972)', diff saved to https://phabricator.wikimedia.org/P32264 and previous config saved to /var/cache/conftool/dbconfig/20220803-220057-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T22:03:09Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1156 (T312972)', diff saved to https://phabricator.wikimedia.org/P32265 and previous config saved to /var/cache/conftool/dbconfig/20220803-220309-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T22:48:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1156 (T312972)', diff saved to https://phabricator.wikimedia.org/P32268 and previous config saved to /var/cache/conftool/dbconfig/20220803-224827-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T22:50:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1170:3312 (T312972)', diff saved to https://phabricator.wikimedia.org/P32269 and previous config saved to /var/cache/conftool/dbconfig/20220803-225015-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-03T23:50:31Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T312972)', diff saved to https://phabricator.wikimedia.org/P32270 and previous config saved to /var/cache/conftool/dbconfig/20220803-235030-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-04T00:35:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T312972)', diff saved to https://phabricator.wikimedia.org/P32273 and previous config saved to /var/cache/conftool/dbconfig/20220804-003549-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-04T00:36:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1146:3312 (T312972)', diff saved to https://phabricator.wikimedia.org/P32274 and previous config saved to /var/cache/conftool/dbconfig/20220804-003611-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-04T00:38:23Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T312972)', diff saved to https://phabricator.wikimedia.org/P32275 and previous config saved to /var/cache/conftool/dbconfig/20220804-003822-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-08-04T01:23:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T312972)', diff saved to https://phabricator.wikimedia.org/P32278 and previous config saved to /var/cache/conftool/dbconfig/20220804-012341-marostegui.json