Page MenuHomePhabricator

Drop oathauth_users table from production
Closed, ResolvedPublic

Description

TBD, I feel like there's a process to follow for this that I can't find at the moment.

Dropped from:

  • private.dblist
  • fishbowl.dblist
  • centralauth

Event Timeline

Ladsgroup moved this task from Triage to Blocked on the DBA board.
Ladsgroup subscribed.

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

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

Marostegui moved this task from Blocked to In progress on the DBA board.

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

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

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

Change 977123 merged by Marostegui:

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

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

Marostegui updated the task description. (Show Details)

All done