Page MenuHomePhabricator
Paste P12080

'test' databases
ActivePublic

Authored by Kormat on Tue, Jul 28, 11:59 AM.
while read server port; do out=$(sudo -i mysql.py --connect-timeout=5 -BN -h $server -P $port -e "show databases like 'test'; show databases like 'test\\_%'"); [ -n "$out" ] && { echo "$server $port" $out; }; done < instances
db1075.eqiad.wmnet 3306 test
db1078.eqiad.wmnet 3306 test
db1079.eqiad.wmnet 3306 test
db1081.eqiad.wmnet 3306 test
db1083.eqiad.wmnet 3306 test
db1084.eqiad.wmnet 3306 test
db1085.eqiad.wmnet 3306 test
db1086.eqiad.wmnet 3306 test
db1088.eqiad.wmnet 3306 test
db1089.eqiad.wmnet 3306 test
db1090.eqiad.wmnet 3317 test
db1091.eqiad.wmnet 3306 test
db1093.eqiad.wmnet 3306 test
db1094.eqiad.wmnet 3306 test
db1095.eqiad.wmnet 3313 test
db1096.eqiad.wmnet 3315 test
db1096.eqiad.wmnet 3316 test
db1098.eqiad.wmnet 3316 test
db1098.eqiad.wmnet 3317 test
db1099.eqiad.wmnet 3311 test
db1100.eqiad.wmnet 3306 test
db1101.eqiad.wmnet 3317 test
db1112.eqiad.wmnet 3306 test
db1113.eqiad.wmnet 3316 test
db1116.eqiad.wmnet 3317 test
db1117.eqiad.wmnet 3325 test_labsdbaccounts
db1120.eqiad.wmnet 3306 test
db1121.eqiad.wmnet 3306 test
db1123.eqiad.wmnet 3306 test
db1127.eqiad.wmnet 3306 test
db1130.eqiad.wmnet 3306 test
db1131.eqiad.wmnet 3306 test
db1133.eqiad.wmnet 3306 test_labsdbaccounts
db1134.eqiad.wmnet 3306 test
db1135.eqiad.wmnet 3306 test
db1136.eqiad.wmnet 3306 test
db1138.eqiad.wmnet 3306 test
db1141.eqiad.wmnet 3306 test
db1144.eqiad.wmnet 3314 test
db1144.eqiad.wmnet 3315 test
db1145.eqiad.wmnet 3314 test
db1145.eqiad.wmnet 3315 test
db1148.eqiad.wmnet 3306 test
db1149.eqiad.wmnet 3306 test
db2073.codfw.wmnet 3306 test
db2074.codfw.wmnet 3306 test
db2076.codfw.wmnet 3306 test
db2077.codfw.wmnet 3306 test
db2078.codfw.wmnet 3325 test_labsdbaccounts
db2085.codfw.wmnet 3311 test
db2086.codfw.wmnet 3317 test
db2087.codfw.wmnet 3316 test
db2087.codfw.wmnet 3317 test
db2088.codfw.wmnet 3311 test
db2089.codfw.wmnet 3316 test
db2090.codfw.wmnet 3306 test
db2092.codfw.wmnet 3306 test
db2093.codfw.wmnet 3306 test test_labswiki
db2114.codfw.wmnet 3306 test
db2118.codfw.wmnet 3306 test
db2120.codfw.wmnet 3306 test
db2121.codfw.wmnet 3306 test
db2122.codfw.wmnet 3306 test
db2135.codfw.wmnet 3306 test_labsdbaccounts
db2136.codfw.wmnet 3306 test
dbstore1003.eqiad.wmnet 3311 test
dbstore1003.eqiad.wmnet 3317 test
dbstore1004.eqiad.wmnet 3313 test
dbstore1004.eqiad.wmnet 3314 test
es1011.eqiad.wmnet 3306 test
es1013.eqiad.wmnet 3306 test
es1014.eqiad.wmnet 3306 test
es1017.eqiad.wmnet 3306 test
es2017.codfw.wmnet 3306 test
es2018.codfw.wmnet 3306 test
es2019.codfw.wmnet 3306 test
pc1008.eqiad.wmnet 3306 test

Event Timeline

Kormat created this paste.Tue, Jul 28, 11:59 AM
Kormat edited the content of this paste. (Show Details)Tue, Jul 28, 12:03 PM
while read server port dbs; do for db in $dbs; do echo "$server $port $db:" $(sudo -i mysql.py -BN -h $server -P $port $db -e "show tables"); done; done < test.dbs

db1075.eqiad.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1                                                                                                                                                        
db1078.eqiad.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1                                                                                                                                                        
db1079.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1                                                                                                                                                                 
db1081.eqiad.wmnet 3306 test: t1 t2                                                                                                                                                                               
db1083.eqiad.wmnet 3306 test: eltx
db1084.eqiad.wmnet 3306 test: eltx
db1085.eqiad.wmnet 3306 test: dsns replicate
db1086.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1
db1088.eqiad.wmnet 3306 test: dsns replicate
db1089.eqiad.wmnet 3306 test: eltx
db1090.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1
db1091.eqiad.wmnet 3306 test: eltx
db1093.eqiad.wmnet 3306 test: dsns replicate
db1094.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1
db1095.eqiad.wmnet 3313 test: idbt ipblocks t3 t5 t6 test1
db1096.eqiad.wmnet 3315 test:
db1096.eqiad.wmnet 3316 test: replicate
db1098.eqiad.wmnet 3316 test: replicate
db1098.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1
db1099.eqiad.wmnet 3311 test: eltx
db1100.eqiad.wmnet 3306 test:
db1101.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1
db1112.eqiad.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1
db1113.eqiad.wmnet 3316 test: replicate
db1116.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1
db1117.eqiad.wmnet 3325 test_labsdbaccounts: account account_host
db1120.eqiad.wmnet 3306 test:
db1121.eqiad.wmnet 3306 test: t1 t2
db1123.eqiad.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1
db1127.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1
db1130.eqiad.wmnet 3306 test:
db1131.eqiad.wmnet 3306 test: dsns replicate
db1133.eqiad.wmnet 3306 test_labsdbaccounts: account account_host
db1134.eqiad.wmnet 3306 test: eltx
db1135.eqiad.wmnet 3306 test: eltx
db1136.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1
db1138.eqiad.wmnet 3306 test: t1 t2
db1141.eqiad.wmnet 3306 test: t1 t2
db1144.eqiad.wmnet 3314 test: t1 t2
db1144.eqiad.wmnet 3315 test:
db1145.eqiad.wmnet 3314 test: t1 t2
db1145.eqiad.wmnet 3315 test:
db1148.eqiad.wmnet 3306 test: t1 t2
db1149.eqiad.wmnet 3306 test: t1 t2
db2073.codfw.wmnet 3306 test: t1 t2
db2074.codfw.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1
db2076.codfw.wmnet 3306 test: replicate
db2077.codfw.wmnet 3306 test: idbt t3 t5 t6 test1
db2078.codfw.wmnet 3325 test_labsdbaccounts: account account_host
db2085.codfw.wmnet 3311 test: eltx
db2086.codfw.wmnet 3317 test: idbt t3 t5 t6 test1
db2087.codfw.wmnet 3316 test: replicate
db2087.codfw.wmnet 3317 test: idbt t3 t5 t6 test1
db2088.codfw.wmnet 3311 test: eltx
db2089.codfw.wmnet 3316 test: replicate
db2090.codfw.wmnet 3306 test: t1 t2
db2092.codfw.wmnet 3306 test: eltx
db2093.codfw.wmnet 3306 test:
db2093.codfw.wmnet 3306 test_labswiki: abuse_filter abuse_filter_action abuse_filter_history abuse_filter_log actor archive babel betafeatures_user_counts bv2017_edits category categorylinks change_tag change_ta
g_def comment config content content_models cu_changes cu_log echo_email_batch echo_event echo_notification echo_target_page external_user externallinks filearchive flow_ext_ref flow_revision flow_subscription f
low_topic_list flow_tree_node flow_tree_revision flow_wiki_ref flow_workflow geo_tags global_block_whitelist globalblocks globalimagelinks hidden historical_thread image imagelinks interwiki ip_changes ipblocks
ipblocks_restrictions iwlinks job l10n_cache langlinks ldap_domains linter log_search logging mathoid module_deps msg_resource msg_resource_links oaiaudit oaiharvest oaiuser oathauth_users oathauth_users_restore
 oauth2_access_tokens oauth_accepted_consumer oauth_registered_consumer objectcache oldimage openstack_notification_event openstack_puppet_classes openstack_puppet_groups openstack_puppet_vars openstack_tokens p
age page_props page_restrictions pagelinks profiling protected_titles querycache querycache_info querycachetwo recentchanges redirect revision revision_actor_temp revision_comment_temp searchindex site_identifie
rs site_stats sites slot_roles slots spoofuser templatelinks text thread thread_history thread_pending_relationship thread_reaction titlekey trackbacks transcache updatelog updates uploadstash user user_daily_co
ntribs user_former_groups user_groups user_message_state user_newtalk user_openid user_properties watchlist watchlist_expiry wikilove_log
db2114.codfw.wmnet 3306 test: replicate
db2118.codfw.wmnet 3306 test: idbt t3 t5 t6 test1
db2120.codfw.wmnet 3306 test: idbt t3 t5 t6 test1
db2121.codfw.wmnet 3306 test: idbt t3 t5 t6 test1
db2122.codfw.wmnet 3306 test: idbt t3 t5 t6 test1
db2135.codfw.wmnet 3306 test_labsdbaccounts: account account_host
db2136.codfw.wmnet 3306 test: t1 t2
dbstore1003.eqiad.wmnet 3311 test: eltx
dbstore1003.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1
dbstore1004.eqiad.wmnet 3313 test: idbt ipblocks t3 t5 t6 test1
dbstore1004.eqiad.wmnet 3314 test: t1 t2
es1011.eqiad.wmnet 3306 test:
es1013.eqiad.wmnet 3306 test:
es1014.eqiad.wmnet 3306 test:
es1017.eqiad.wmnet 3306 test:
es2017.codfw.wmnet 3306 test:
es2018.codfw.wmnet 3306 test:
es2019.codfw.wmnet 3306 test:
pc1008.eqiad.wmnet 3306 test:
Kormat added a comment.EditedTue, Jul 28, 12:32 PM
cat test.dbs | grep '\<test\>' | grep codfw | while read server port ignore; do echo "$server:$port"; sudo -i mysql.py -h $server -P $port -e "set sql_log_bin=0; drop database if exists test"; done

Diff looks good:

kormat@cumin1001:~(0:0)$ diff -u test.dbs test.dbs.2
--- test.dbs    2020-07-28 12:02:26.882398853 +0000
+++ test.dbs.2  2020-07-28 12:41:32.236716003 +0000
@@ -42,27 +42,9 @@
 db1145.eqiad.wmnet 3315 test
 db1148.eqiad.wmnet 3306 test
 db1149.eqiad.wmnet 3306 test
-db2073.codfw.wmnet 3306 test
-db2074.codfw.wmnet 3306 test
-db2076.codfw.wmnet 3306 test
-db2077.codfw.wmnet 3306 test
 db2078.codfw.wmnet 3325 test_labsdbaccounts
-db2085.codfw.wmnet 3311 test
-db2086.codfw.wmnet 3317 test
-db2087.codfw.wmnet 3316 test
-db2087.codfw.wmnet 3317 test
-db2088.codfw.wmnet 3311 test
-db2089.codfw.wmnet 3316 test
-db2090.codfw.wmnet 3306 test
-db2092.codfw.wmnet 3306 test
-db2093.codfw.wmnet 3306 test test_labswiki
-db2114.codfw.wmnet 3306 test
-db2118.codfw.wmnet 3306 test
-db2120.codfw.wmnet 3306 test
-db2121.codfw.wmnet 3306 test
-db2122.codfw.wmnet 3306 test
+db2093.codfw.wmnet 3306 test_labswiki
 db2135.codfw.wmnet 3306 test_labsdbaccounts
-db2136.codfw.wmnet 3306 test
 dbstore1003.eqiad.wmnet 3311 test
 dbstore1003.eqiad.wmnet 3317 test
 dbstore1004.eqiad.wmnet 3313 test
@@ -71,7 +53,4 @@
 es1013.eqiad.wmnet 3306 test
 es1014.eqiad.wmnet 3306 test
 es1017.eqiad.wmnet 3306 test
-es2017.codfw.wmnet 3306 test
-es2018.codfw.wmnet 3306 test
-es2019.codfw.wmnet 3306 test
 pc1008.eqiad.wmnet 3306 test
Kormat changed the title of this paste from untitled to 'test' databases.Wed, Jul 29, 9:15 AM