Page MenuHomePhabricator
Paste P10674

zarcillo
ActivePublic

Authored by jcrespo on Mar 10 2020, 10:04 AM.
Tags
None
Referenced Files
F31674053: raw.txt
Mar 10 2020, 10:04 AM
Subscribers
None
root@db1115.eqiad.wmnet[zarcillo]> select name, `group`, section FROM instances LEFT JOIN section_instances on instances.name = section_instances.instance;
+---------------------+-------------+-----------------+
| name | group | section |
+---------------------+-------------+-----------------+
| db1074 | core | s2 |
| db1075 | core | s3 |
| db1076 | core | s2 |
| db1077 | test | test-s4 |
| db1078 | core | s3 |
| db1079 | core | s7 |
| db1080 | core | s1 |
| db1081 | core | s4 |
| db1082 | core | s5 |
| db1083 | core | s1 |
| db1084 | core | s4 |
| db1085 | core | s6 |
| db1086 | core | s7 |
| db1087 | core | s8 |
| db1088 | core | s6 |
| db1089 | core | s1 |
| db1090:3312 | core | s2 |
| db1090:3317 | core | s7 |
| db1091 | core | s4 |
| db1092 | core | s8 |
| db1093 | core | s6 |
| db1094 | core | s7 |
| db1095:3313 | dbstore | s3 |
| db1096:3315 | core | s5 |
| db1096:3316 | core | s6 |
| db1097:3314 | core | s4 |
| db1097:3315 | core | s5 |
| db1098:3316 | core | s6 |
| db1098:3317 | core | s7 |
| db1099:3311 | core | s1 |
| db1099:3318 | core | s8 |
| db1100 | core | s5 |
| db1101:3317 | core | s7 |
| db1101:3318 | core | s8 |
| db1102:3314 | dbstore | s4 |
| db1102:3315 | dbstore | s5 |
| db1103:3312 | core | s2 |
| db1103:3314 | core | s4 |
| db1104 | core | s8 |
| db1105:3311 | core | s1 |
| db1105:3312 | core | s2 |
| db1106 | core | s1 |
| db1107 | core | s1 |
| db1108 | misc | m4 |
| db1109 | core | s8 |
| db1110 | core | s5 |
| db1111 | core | s8 |
| db1112 | core | s3 |
| db1113:3315 | core | s5 |
| db1113:3316 | core | s6 |
| db1114 | test | test-s1 |
| db1115 | misc | tendril |
| db1116:3317 | dbstore | s7 |
| db1116:3318 | dbstore | s8 |
| db1117:3321 | misc | m1 |
| db1117:3322 | misc | m2 |
| db1117:3323 | misc | m3 |
| db1117:3325 | misc | m5 |
| db1118 | core | s1 |
| db1119 | core | s1 |
| db1120 | core | x1 |
| db1121 | core | s4 |
| db1122 | core | s2 |
| db1123 | core | s3 |
| db1124:3311 | labsdb | s1 |
| db1124:3313 | labsdb | s3 |
| db1124:3315 | labsdb | s5 |
| db1124:3318 | labsdb | s8 |
| db1125:3312 | labsdb | s2 |
| db1125:3314 | labsdb | s4 |
| db1125:3316 | labsdb | s6 |
| db1125:3317 | labsdb | s7 |
| db1126 | core | s8 |
| db1127 | core | x1 |
| db1128 | misc | m3 |
| db1129 | core | s2 |
| db1130 | core | s5 |
| db1131 | core | s6 |
| db1132 | misc | m2 |
| db1133 | misc | m5 |
| db1134 | core | s1 |
| db1135 | misc | m1 |
| db1136 | core | s7 |
| db1137 | core | x1 |
| db1138 | core | s4 |
| db1139:3311 | dbstore | s1 |
| db1139:3316 | dbstore | s6 |
| db1140:3312 | dbstore | s2 |
| db1140:3320 | dbstore | x1 |
| db2071 | core | s1 |
| db2072 | core | s1 |
| db2073 | core | s4 |
| db2074 | core | s3 |
| db2075 | core | s5 |
| db2076 | core | s6 |
| db2077 | core | s7 |
| db2078:3321 | misc | m1 |
| db2078:3322 | misc | m2 |
| db2078:3323 | misc | m3 |
| db2078:3325 | misc | m5 |
| db2079 | core | s8 |
| db2080 | core | s8 |
| db2081 | core | s8 |
| db2082 | core | s8 |
| db2083 | core | s8 |
| db2084:3314 | core | s4 |
| db2084:3315 | core | s5 |
| db2085:3311 | core | s1 |
| db2085:3318 | core | s8 |
| db2086:3317 | core | s7 |
| db2086:3318 | core | s8 |
| db2087:3316 | core | s6 |
| db2087:3317 | core | s7 |
| db2088:3311 | core | s1 |
| db2088:3312 | core | s2 |
| db2089:3315 | core | s5 |
| db2089:3316 | core | s6 |
| db2090 | core | s4 |
| db2091:3312 | core | s2 |
| db2091:3314 | core | s4 |
| db2092 | core | s1 |
| db2093 | misc | tendril |
| db2094:3311 | labsdb | s1 |
| db2094:3313 | labsdb | s3 |
| db2094:3315 | labsdb | s5 |
| db2094:3318 | labsdb | s8 |
| db2095:3312 | labsdb | s2 |
| db2095:3314 | labsdb | s4 |
| db2095:3316 | labsdb | s6 |
| db2095:3317 | labsdb | s7 |
| db2096 | core | x1 |
| db2097:3311 | dbstore | s1 |
| db2097:3316 | dbstore | s6 |
| db2098:3312 | dbstore | s2 |
| db2098:3313 | dbstore | s3 |
| db2099:3314 | dbstore | s4 |
| db2099:3315 | dbstore | s5 |
| db2100:3317 | dbstore | s7 |
| db2100:3318 | dbstore | s8 |
| db2101:3320 | dbstore | x1 |
| db2102 | test | test-s1 |
| db2103 | core | s1 |
| db2104 | core | s2 |
| db2105 | core | s3 |
| db2106 | core | s4 |
| db2107 | core | s2 |
| db2108 | core | s2 |
| db2109 | core | s3 |
| db2110 | core | s4 |
| db2111 | core | s5 |
| db2112 | core | s1 |
| db2113 | core | s5 |
| db2114 | core | s6 |
| db2115 | core | x1 |
| db2116 | core | s1 |
| db2117 | core | s6 |
| db2118 | core | s7 |
| db2119 | core | s4 |
| db2120 | core | s7 |
| db2121 | core | s7 |
| db2122 | core | s7 |
| db2123 | core | s5 |
| db2124 | core | s6 |
| db2125 | core | s2 |
| db2126 | core | s2 |
| db2127 | core | s3 |
| db2128 | core | s5 |
| db2129 | core | s6 |
| db2130 | core | s1 |
| db2131 | core | x1 |
| db2132 | core | m1 |
| db2133 | core | m2 |
| db2134 | core | m3 |
| db2135 | core | m5 |
| dbstore1003:3311 | dbstore | s1 |
| dbstore1003:3315 | dbstore | s5 |
| dbstore1003:3317 | dbstore | s7 |
| dbstore1004:3312 | dbstore | s2 |
| dbstore1004:3313 | dbstore | s3 |
| dbstore1004:3314 | dbstore | s4 |
| dbstore1005:3316 | dbstore | s6 |
| dbstore1005:3318 | dbstore | s8 |
| dbstore1005:3320 | dbstore | x1 |
| dbstore1005:3350 | dbstore | staging |
| es1011 | core | es2 |
| es1012 | core | es1 |
| es1013 | core | es2 |
| es1014 | core | es3 |
| es1015 | core | es2 |
| es1016 | core | es1 |
| es1017 | core | es3 |
| es1018 | core | es1 |
| es1019 | core | es3 |
| es1020 | core | es4 |
| es1021 | core | es4 |
| es1022 | core | es4 |
| es1023 | core | es5 |
| es1024 | core | es5 |
| es1025 | core | es5 |
| es2011 | core | es1 |
| es2012 | core | es1 |
| es2013 | core | es1 |
| es2014 | core | es2 |
| es2015 | core | es2 |
| es2016 | core | es2 |
| es2017 | core | es3 |
| es2018 | core | es3 |
| es2019 | core | es3 |
| es2020 | core | es4 |
| es2021 | core | es4 |
| es2022 | core | es4 |
| es2023 | core | es5 |
| es2024 | core | es5 |
| es2025 | core | es5 |
| labsdb1009 | labsdb | s1 |
| labsdb1009 | labsdb | s2 |
| labsdb1009 | labsdb | s3 |
| labsdb1009 | labsdb | s4 |
| labsdb1009 | labsdb | s5 |
| labsdb1009 | labsdb | s6 |
| labsdb1009 | labsdb | s7 |
| labsdb1009 | labsdb | s8 |
| labsdb1010 | labsdb | s1 |
| labsdb1010 | labsdb | s2 |
| labsdb1010 | labsdb | s3 |
| labsdb1010 | labsdb | s4 |
| labsdb1010 | labsdb | s5 |
| labsdb1010 | labsdb | s6 |
| labsdb1010 | labsdb | s7 |
| labsdb1010 | labsdb | s8 |
| labsdb1011 | labsdb | s1 |
| labsdb1011 | labsdb | s2 |
| labsdb1011 | labsdb | s3 |
| labsdb1011 | labsdb | s4 |
| labsdb1011 | labsdb | s5 |
| labsdb1011 | labsdb | s6 |
| labsdb1011 | labsdb | s7 |
| labsdb1011 | labsdb | s8 |
| labsdb1012 | labsdb | s1 |
| labsdb1012 | labsdb | s2 |
| labsdb1012 | labsdb | s3 |
| labsdb1012 | labsdb | s4 |
| labsdb1012 | labsdb | s5 |
| labsdb1012 | labsdb | s6 |
| labsdb1012 | labsdb | s7 |
| labsdb1012 | labsdb | s8 |
| labservices1001 | labsdb | labservices |
| labservices1002 | labsdb | labservices |
| labtestservices2001 | labsdb | labtestservices |
| pc1007 | parsercache | pc1 |
| pc1008 | parsercache | pc2 |
| pc1009 | parsercache | pc3 |
| pc1010 | parsercache | pc1 |
| pc2007 | parsercache | pc1 |
| pc2008 | parsercache | pc2 |
| pc2009 | parsercache | pc3 |
| pc2010 | parsercache | pc1 |
+---------------------+-------------+-----------------+
257 rows in set (0.00 sec)