Creating this task to narrow the actionable for DBA instead of using T208425 which is the Epic
Following up the conversation on IRC with @Ladsgroup I have renamed wb_terms to T248086_wb_terms on the following hosts and wikis (all in codfw):
root@cumin1001:/home/marostegui# for i in db2106 db2109 db2081; do echo $i; mysql.py -h$i information_schema -e "select table_schema,table_name from tables where table_name like '%wb_terms';";done db2106 +-----------------+------------------+ | table_schema | table_name | +-----------------+------------------+ | commonswiki | T248086_wb_terms | | testcommonswiki | T248086_wb_terms | +-----------------+------------------+ db2109 +------------------+------------------+ | table_schema | table_name | +------------------+------------------+ | testwikidatawiki | T248086_wb_terms | +------------------+------------------+ db2081 +--------------+------------------+ | table_schema | table_name | +--------------+------------------+ | wikidatawiki | T248086_wb_terms | +--------------+------------------+
None of those hosts have slaves.
If there are any writes, replication will break and we'll notice.
If that happens, we just need to revert and restart replication with:
set session sql_log_bin=0; rename table T248086_wb_terms to wb_terms; start slave;"
Let's give it 24h or so. Once we are fully sure nothing is writing, maybe we can move forward and rename the table on s3 (testwikidatawiki) eqiad host and monitor for errors.
The table must not be deleted on labs yet for s8 (wikidatawiki).
The table in s4: commonswiki, testcommonswiki is empty
The table in s3: wikidatawiki has around 500k rows
s4 (commonswiki, testcommonswiki). Empty table, to be dropped everywhere. To be run on the master with if exists ( (renamed everywhere)
- master: db1138
s3 (wikidatawiki). Table with 500k rows, to be dropped everywhere, including labs and dbstore hosts
- labsdb1012 (table renamed to: T248086_wb_terms)
- labsdb1011 (table renamed to: T248086_wb_terms)
- labsdb1010 (table renamed to: T248086_wb_terms)
- labsdb1009 (table renamed to: T248086_wb_terms)
- dbstore1004 (table renamed to: T248086_wb_terms)
- db2127 (table renamed to: T248086_wb_terms)
- db2109 (table renamed to: T248086_wb_terms)
- db2105 (table renamed to: T248086_wb_terms)
- db2098 (table renamed to: T248086_wb_terms)
- db2094 (table renamed to: T248086_wb_terms)
- db2074 (table renamed to: T248086_wb_terms)
- db1124 (table renamed to: T248086_wb_terms)
- db1112 (table renamed to: T248086_wb_terms)
- db1095 (table renamed to: T248086_wb_terms)
- db1078 (table renamed to: T248086_wb_terms)
- db1075 (table renamed to: T248086_wb_terms)
- db1123 (table renamed to: T248086_wb_terms)
s8 (wikidatawiki). To be dropped everywhere but NOT ON LABS/SANITARIUM/DBSTORE
- labsdb1012 (table renamed to: T248086_wb_terms)
- labsdb1011 (table renamed to: T248086_wb_terms)
- labsdb1010 (table renamed to: T248086_wb_terms)
- labsdb1009 (table renamed to: T248086_wb_terms)
- dbstore1005 (table renamed to: T248086_wb_terms)
- db2100 (table renamed to: T248086_wb_terms)
- db2094 (table renamed to: T248086_wb_terms)
- db2086 (table renamed to: T248086_wb_terms)
- db2085 (table renamed to: T248086_wb_terms)
- db2083 (table renamed to: T248086_wb_terms)
- db2082 (table renamed to: T248086_wb_terms)
- db2081 (table renamed to: T248086_wb_terms)
- db2080 (table renamed to: T248086_wb_terms)
- db2079 (table renamed to: T248086_wb_terms)
- db1126 (table renamed to: T248086_wb_terms)
- db1124 (table renamed to: T248086_wb_terms)
- db1116 (table renamed to: T248086_wb_terms)
- db1111 (table renamed to: T248086_wb_terms)
- db1114 (table renamed to: T248086_wb_terms)
- db1109 MASTER (table renamed to: T248086_wb_terms)
- db1104 (table renamed to: T248086_wb_terms)
- db1101 (table renamed to: T248086_wb_terms)
- db1099 (table renamed to: T248086_wb_terms)
- db1092 (table renamed to: T248086_wb_terms)
- db1087 (table renamed to: T248086_wb_terms)