Change Details

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 `T208425_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 | T208425_wb_terms | | testcommonswiki | T208425_wb_terms | +-----------------+------------------+ db2109 +------------------+------------------+ | table_schema | table_name | +------------------+------------------+ | testwikidatawiki | T208425_wb_terms | +------------------+------------------+ db2081 +--------------+------------------+ | table_schema | table_name | +--------------+------------------+ | wikidatawiki | T208425_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 T208425_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 (renamed on db2106 - needs to be dropped there manually) 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 on db2106 - needs to be dropped there manually)) [] master: db1138 s3 (wikidatawiki). Table with 500k rows, to be dropped everywhere, including labs and dbstore hosts [] labsdb1012 [] labsdb1011 [] labsdb1010 [] labsdb1009 [] dbstore1004 [] db2127 [] db2109 (table renamed) [] db2105 [] db2098 [] db2094 [] db2074 [] db1124 [] db1112 [] db1095 [] db1078 (table renamed) [] db1075 [] db1123 s8 (wikidatawiki). To be dropped everywhere but** NOT ON LABS/SANITARIUM/DBSTORE ** [] labsdb1012 NOT HERE YET [] labsdb1011 NOT HERE YET [] labsdb1010 NOT HERE YET [] labsdb1009 NOT HERE YET [] dbstore1005 NOT HERE YET [] db2100 [] db2094 [] db2086 [] db2085 [] db2083 [] db2082 [] db2081 (table renamed) [] db2080 [] db2079 [] db1126 [] db1124 NOT HERE YET [] db1116 [] db1111 [] db1109 MASTER [] db1104 (table renamed) [] db1101 [] db1099 [] db1092 [] db1087 DO NOT USE REPLICATION

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 `T208425_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 | T208425_wb_terms | | testcommonswiki | T208425_wb_terms | +-----------------+------------------+ db2109 +------------------+------------------+ | table_schema | table_name | +------------------+------------------+ | testwikidatawiki | T208425_wb_terms | +------------------+------------------+ db2081 +--------------+------------------+ | table_schema | table_name | +--------------+------------------+ | wikidatawiki | T208425_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 T208425_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 (renamed on ALL CODFW) 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 on ALL CODFW) [] master: db1138 s3 (wikidatawiki). Table with 500k rows, to be dropped everywhere, including labs and dbstore hosts [] labsdb1012 [] labsdb1011 [] labsdb1010 [] labsdb1009 [] dbstore1004 [] 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 [] db1112 [] db1095 [] db1078 (table renamed) [] db1075 [] db1123 s8 (wikidatawiki). To be dropped everywhere but** NOT ON LABS/SANITARIUM/DBSTORE ** [] labsdb1012 NOT HERE YET [] labsdb1011 NOT HERE YET [] labsdb1010 NOT HERE YET [] labsdb1009 NOT HERE YET [] dbstore1005 NOT HERE YET [] 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 [] db1124 NOT HERE YET [] db1116 [] db1111 [] db1109 MASTER [] db1104 (table renamed) [] db1101 [] db1099 [] db1092 [] db1087 DO NOT USE REPLICATION

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 `T208425_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 | T208425_wb_terms | | testcommonswiki | T208425_wb_terms | +-----------------+------------------+ db2109 +------------------+------------------+ | table_schema | table_name | +------------------+------------------+ | testwikidatawiki | T208425_wb_terms | +------------------+------------------+ db2081 +--------------+------------------+ | table_schema | table_name | +--------------+------------------+ | wikidatawiki | T208425_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 T208425_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 (renamed on db2106 - needs to be dropped there manuallyALL CODFW) 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 on db2106 - needs to be dropped there manually)ALL CODFW) [] master: db1138 s3 (wikidatawiki). Table with 500k rows, to be dropped everywhere, including labs and dbstore hosts [] labsdb1012 [] labsdb1011 [] labsdb1010 [] labsdb1009 [] dbstore1004 [] 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 [] db1112 [] db1095 [] db1078 (table renamed) [] db1075 [] db1123 s8 (wikidatawiki). To be dropped everywhere but** NOT ON LABS/SANITARIUM/DBSTORE ** [] labsdb1012 NOT HERE YET [] labsdb1011 NOT HERE YET [] labsdb1010 NOT HERE YET [] labsdb1009 NOT HERE YET [] dbstore1005 NOT HERE YET [] 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 [] db1124 NOT HERE YET [] db1116 [] db1111 [] db1109 MASTER [] db1104 (table renamed) [] db1101 [] db1099 [] db1092 [] db1087 DO NOT USE REPLICATION