TBD, I feel like there's a process to follow for this that I can't find at the moment.
- Merge once dropped: https://gerrit.wikimedia.org/r/c/operations/puppet/+/977123/
Dropped from:
- private.dblist
- fishbowl.dblist
- centralauth
TBD, I feel like there's a process to follow for this that I can't find at the moment.
Dropped from:
Subject | Repo | Branch | Lines +/- | |
---|---|---|---|---|
oathauth_users: Prepare for removal | operations/puppet | production | +0 -2 |
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Open | None | T125653 Create new types of notifications | |||
Open | None | T166622 Allow all users on all wikis to use OATHAuth | |||
Open | None | T100375 Improve user experience of Two-Factor process | |||
Open | None | T352856 Recovery code improvements | |||
Resolved | Reedy | T131788 Users should be notified when only two recovery codes are left | |||
Open | None | T150601 Add option to generate new set of recovery codes | |||
Open | None | T244348 Recovery option for WebAuthn | |||
Open | None | T356004 Help password managers to detect TOTP login input | |||
Open | None | T232336 Separate recovery codes into a separate MFA method | |||
Open | taavi | T242031 Allow multiple different 2FA devices | |||
Resolved | Marostegui | T348693 Drop oathauth_users table from production |
https://wikitech.wikimedia.org/wiki/Schema_changes ?
Let me know once it's ready and we will take care of it
Dropping a table isn't considered a schema change, you can just create a regular ticket for it (or convert this one to that).
Just let us know the sections and if there are views associated to it.
I have renamed this table on db1174, if nothing breaks in the next few days I will drop it everywhere.
-rw-rw---- 1 mysql mysql 9.0M Oct 11 11:39 oathauth_users.ibd
This is the new name:
root@db1174.eqiad.wmnet[centralauth]> show tables like '%oathauth_users'; +-----------------------------------------+ | Tables_in_centralauth (%oathauth_users) | +-----------------------------------------+ | T348693_oathauth_users | +-----------------------------------------+ 1 row in set (0.001 sec)
Change 977123 had a related patch set uploaded (by Marostegui; author: Marostegui):
[operations/puppet@production] oathauth_users: Prepare for removal
To be merged once dropped: https://gerrit.wikimedia.org/r/c/operations/puppet/+/977123/
Renamed this table on officewiki on db1175 too:
root@db1175.eqiad.wmnet[officewiki]> rename table oathauth_users to T348693_oathauth_users; Query OK, 0 rows affected (0.005 sec) root@db1175.eqiad.wmnet[officewiki]>
Mentioned in SAL (#wikimedia-operations) [2023-11-29T08:22:43Z] <marostegui> oathauth_users from private.dblist T348693
Mentioned in SAL (#wikimedia-operations) [2023-11-29T08:28:28Z] <marostegui> oathauth_users from fishbowl.dblist T348693
root@db2118:/srv/sqldata/centralauth# ls -lh oathauth_users.ibd
-rw-rw---- 1 mysql mysql 5.0M Oct 11 11:00 oathauth_users.ibd
Mentioned in SAL (#wikimedia-operations) [2023-11-29T08:33:31Z] <marostegui> Drop oathauth_users from centralauth T348693
Change 977123 merged by Marostegui:
[operations/puppet@production] oathauth_users: Prepare for removal