mysql.user2 table present on s1, s2, s6
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Marostegui
	Aug 17 2021, 10:55 AM

Description

I just found this table on s6 hosts:

root@db1098.eqiad.wmnet[mysql]> select * from user2\G
*************************** 1. row ***************************
                 Host: browne.wikimedia.org
                 User: toolserver
             Password: xxxx
          Select_priv: N
          Insert_priv: N
          Update_priv: N
          Delete_priv: N
          Create_priv: N
            Drop_priv: N
          Reload_priv: N
        Shutdown_priv: N
         Process_priv: N
            File_priv: N
           Grant_priv: N
      References_priv: N
           Index_priv: N
           Alter_priv: N
         Show_db_priv: N
           Super_priv: N
Create_tmp_table_priv: N
     Lock_tables_priv: N
         Execute_priv: N
      Repl_slave_priv: Y
     Repl_client_priv: N
             ssl_type:
           ssl_cipher:
          x509_issuer:
         x509_subject:
        max_questions: 0
          max_updates: 0
      max_connections: 0
1 row in set (0.001 sec)

That table has not been written since 2013 and it is on myisam!:

root@db1098.eqiad.wmnet[mysql]> select * from information_schema.tables where table_name="user2"\G
*************************** 1. row ***************************
   TABLE_CATALOG: def
    TABLE_SCHEMA: mysql
      TABLE_NAME: user2
      TABLE_TYPE: BASE TABLE
          ENGINE: MyISAM
         VERSION: 10
      ROW_FORMAT: Dynamic
      TABLE_ROWS: 1
  AVG_ROW_LENGTH: 76
     DATA_LENGTH: 76
 MAX_DATA_LENGTH: 281474976710655
    INDEX_LENGTH: 1024
       DATA_FREE: 0
  AUTO_INCREMENT: NULL
     CREATE_TIME: 2013-10-07 09:12:26
     UPDATE_TIME: 2013-10-07 09:12:26
      CHECK_TIME: NULL
 TABLE_COLLATION: binary
        CHECKSUM: NULL
  CREATE_OPTIONS:
   TABLE_COMMENT:
MAX_INDEX_LENGTH: 17179868160
       TEMPORARY: N
1 row in set (0.002 sec)

Deletion progress