Marostegui added a comment.
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.
TASK DETAIL
https://phabricator.wikimedia.org/T208425
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Marostegui
Cc: Bugreporter, Ladsgroup, JAllemandou, ArielGlenn, jcrespo, Joe, Gehel,
alaa_wmde, Marostegui, Jdforrester-WMF, Addshore, Aklapper, Iflorez,
darthmon_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer,
Minhnv-2809, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude,
Lydia_Pintscher, Mbch331, Jay8g, Krenair
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
