Page MenuHomePhabricator

Adjust the field type of oauth_accepted_consumer.oaac_accepted to fixed binary on wmf wikis
Closed, ResolvedPublic

Description

Apply part of T300446 to wmf wikis

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/OAuth/+/758066/6/schema/mysql/patch-oauth_accepted_consumer-timestamp.sql
  2. Where to run those changes: metawiki + labswiki, labstestwiki
  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

  • labtestwiki
  • labswiki
  • s7

Event Timeline

Change 813736 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/software/schema-changes@master] change_oaac_accepted_T312977.py: New schema change

https://gerrit.wikimedia.org/r/813736

Change 813736 merged by jenkins-bot:

[operations/software/schema-changes@master] change_oaac_accepted_T312977.py: New schema change

https://gerrit.wikimedia.org/r/813736

Done on labtestwiki and labswiki with replication
Deploying on s7 with the script.

Mentioned in SAL (#wikimedia-operations) [2022-07-14T11:08:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1136 (T312977)', diff saved to https://phabricator.wikimedia.org/P31046 and previous config saved to /var/cache/conftool/dbconfig/20220714-110759-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T11:53:17Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1136 (T312977)', diff saved to https://phabricator.wikimedia.org/P31049 and previous config saved to /var/cache/conftool/dbconfig/20220714-115316-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T11:54:51Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1174 (T312977)', diff saved to https://phabricator.wikimedia.org/P31050 and previous config saved to /var/cache/conftool/dbconfig/20220714-115448-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T11:57:04Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T312977)', diff saved to https://phabricator.wikimedia.org/P31051 and previous config saved to /var/cache/conftool/dbconfig/20220714-115701-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T12:42:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1174 (T312977)', diff saved to https://phabricator.wikimedia.org/P31054 and previous config saved to /var/cache/conftool/dbconfig/20220714-124219-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T12:42:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1170:3317 (T312977)', diff saved to https://phabricator.wikimedia.org/P31055 and previous config saved to /var/cache/conftool/dbconfig/20220714-124239-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T12:45:16Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T312977)', diff saved to https://phabricator.wikimedia.org/P31057 and previous config saved to /var/cache/conftool/dbconfig/20220714-124515-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T13:30:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T312977)', diff saved to https://phabricator.wikimedia.org/P31062 and previous config saved to /var/cache/conftool/dbconfig/20220714-133031-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T13:30:51Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1098:3317 (T312977)', diff saved to https://phabricator.wikimedia.org/P31063 and previous config saved to /var/cache/conftool/dbconfig/20220714-133051-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T13:33:31Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T312977)', diff saved to https://phabricator.wikimedia.org/P31064 and previous config saved to /var/cache/conftool/dbconfig/20220714-133331-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T14:18:47Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T312977)', diff saved to https://phabricator.wikimedia.org/P31072 and previous config saved to /var/cache/conftool/dbconfig/20220714-141846-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T14:19:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1101:3317 (T312977)', diff saved to https://phabricator.wikimedia.org/P31073 and previous config saved to /var/cache/conftool/dbconfig/20220714-141917-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T14:35:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T312977)', diff saved to https://phabricator.wikimedia.org/P31075 and previous config saved to /var/cache/conftool/dbconfig/20220714-143525-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T15:20:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T312977)', diff saved to https://phabricator.wikimedia.org/P31081 and previous config saved to /var/cache/conftool/dbconfig/20220714-152040-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T15:21:18Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1158 (T312977)', diff saved to https://phabricator.wikimedia.org/P31082 and previous config saved to /var/cache/conftool/dbconfig/20220714-152118-marostegui.json

Marostegui updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-operations) [2022-07-14T15:23:31Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T312977)', diff saved to https://phabricator.wikimedia.org/P31083 and previous config saved to /var/cache/conftool/dbconfig/20220714-152331-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-07-14T16:08:47Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1158 (T312977)', diff saved to https://phabricator.wikimedia.org/P31087 and previous config saved to /var/cache/conftool/dbconfig/20220714-160846-marostegui.json