Drop oathauth_users table from production
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	taavi
	Oct 11 2023, 9:03 PM

Description

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

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	oathauth_users: Prepare for removal	operations/puppet	production	+0 -2

Customize query in gerrit

Related Objects
Search...

Status	Subtype	Assigned	Task
Open		None	T125653 Create new types of notifications
Resolved		None	T166622 Allow all users on all wikis to use OATHAuth
Duplicate		None	T399651 Separate recovery codes into a separate module
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
Resolved		sbassett	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	T151738 OATH code field should show numeric keyboard on mobile devices
Open		None	T399644 FY2025-26 WE4.6.2 Multiple Authenticators
Resolved		sbassett	T232336 Separate recovery codes into a separate 2FA module
Resolved	PRODUCTION ERROR	Tgr	T368468 Cannot switch 2FA method between TOTP and WebAuthn: InvalidArgumentException: User already has a key from a different module enabled (totp)
Resolved		Catrope	T230042 Allow multiple TOTP devices
Resolved		taavi	T242031 Allow multiple different 2FA devices
Resolved		• Marostegui	T348693 Drop oathauth_users table from production

Event Timeline

taavi created this task.Oct 11 2023, 9:03 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 11 2023, 9:03 PM

Kizule added a project: DBA.Oct 11 2023, 9:26 PM

Kizule subscribed.Oct 11 2023, 9:29 PM

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.

• Marostegui triaged this task as Medium priority.Oct 16 2023, 8:46 AM

Is this ready to go?

Yeah, I think this can go ahead now. Thanks.

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

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

gerritbot added a project: Patch-For-Review.Nov 24 2023, 6:59 AM

To be merged once dropped: https://gerrit.wikimedia.org/r/c/operations/puppet/+/977123/

• Marostegui updated the task description. (Show Details)Nov 24 2023, 7:00 AM

No errors so far

• Marostegui updated the task description. (Show Details)Nov 27 2023, 8:31 AM

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]>

Starting to drop it from private.dblist wikis.

Mentioned in SAL (#wikimedia-operations) [2023-11-29T08:22:43Z] <marostegui> oathauth_users from private.dblist T348693

• Marostegui updated the task description. (Show Details)Nov 29 2023, 8:24 AM

• Marostegui updated the task description. (Show Details)Nov 29 2023, 8:28 AM

Mentioned in SAL (#wikimedia-operations) [2023-11-29T08:28:28Z] <marostegui> oathauth_users from fishbowl.dblist T348693

^ Those two !log are missing the word "Drop" :-)
I have fixed manually on SAL

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

• Marostegui updated the task description. (Show Details)Nov 29 2023, 8:33 AM

Change 977123 merged by Marostegui:

[operations/puppet@production] oathauth_users: Prepare for removal

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

All done

Thank you!

Maintenance_bot removed a project: Patch-For-Review.Nov 29 2023, 9:11 AM

Maintenance_bot moved this task from In progress to Done on the DBA board.Nov 29 2023, 9:15 AM

Drop oathauth_users table from productionClosed, ResolvedPublicActions

Description

Details

Related ObjectsSearch...

Event Timeline

Drop oathauth_users table from production
Closed, ResolvedPublic
Actions

Related Objects
Search...