Page MenuHomePhabricator

Investigate unusual dbs in x1
Closed, ResolvedPublic

Description

Follow up to T297297: Investigate the unusual dbs in s3. This is more important than s3 even since if a deleted wiki gets recreated without the x1 database being dropped first, it will start reusing the data of the old wiki on x1 and that will be quite fun to clean up.

Here is the result:

ladsgroup@cumin1003:~$ sudo db-mysql db1224 -e "show databases;" > x1_dbs
ladsgroup@cumin1003:~$ vim x1_dbs
ladsgroup@cumin1003:~$ diff x1_dbs all.dblist
1d0
< Database
20,22d18
< alswikibooks
< alswikiquote
< alswiktionary
178d173
< cognate_wiktionary
303d297
< fixcopyrightwiki
306d299
< flowdb
372d364
< heartbeat
439d430
< information_schema
535d525
< labtestwiki
619,620d608
< mowiki
< mowiktionary
637d624
< mysql
704d690
< ops
723,724d708
< percona
< performance_schema
894d877
< sys
954d936
< trash
984d965
< ukwikimedia
1042d1022
< wikishared
  • alswikibooks
  • alswikiquote
  • alswiktionary
  • cognate_wiktionary: Needed
  • fixcopyrightwiki
  • flowdb: Needed
  • heartbeat: Needed
  • information_schema: Needed
  • labtestwiki
  • mowiki
  • mowiktionary
  • mysql: Needed
  • ops: Needed
  • percona
  • performance_schema: Needed
  • sys: Needed
  • trash
  • ukwikimedia
  • wikishared: Very Needed

Event Timeline

Ladsgroup triaged this task as Medium priority.Dec 5 2025, 1:24 AM
Ladsgroup moved this task from Triage to In progress on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2025-12-15T13:28:44Z] <Amir1> dropped databases of deleted wikis in x1 (T411835)

KOfori renamed this task from Investigate unusal dbs in x1 to Investigate unusual dbs in x1.Dec 15 2025, 2:14 PM
Ladsgroup updated the task description. (Show Details)
Ladsgroup moved this task from In progress to Done on the DBA board.