Marostegui added a comment.
`testcommonswiki` and `commonswiki` # ./section s4 | while read host port; do echo "$host:$port" ; mysql.py -h$host:$port testcommonswiki -e "show create table wb_changes_dispatch\G" | grep -i chd_seen | grep -v KEY;done labsdb1012.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', labsdb1011.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', labsdb1010.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', labsdb1009.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', dbstore1004.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2140.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2139.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2138.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2137.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2136.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2119.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2110.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db2106.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2099.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db2095.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db2090.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db2073.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1160.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1155.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1150.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1149.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1148.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1147.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1146.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1145.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1144.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1143.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1142.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1141.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1138.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1125.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1121.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1081.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', clouddb1019.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, clouddb1015.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, # ./section s4 | while read host port; do echo "$host:$port" ; mysql.py -h$host:$port commonswiki -e "show create table wb_changes_dispatch\G" | grep -i chd_seen | grep -v KEY;done labsdb1012.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', labsdb1011.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', labsdb1010.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', labsdb1009.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', dbstore1004.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2140.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2139.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2138.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2137.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2136.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2119.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2110.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db2106.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db2099.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db2095.codfw.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db2090.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db2073.codfw.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1160.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1155.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1150.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1149.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1148.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1147.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1146.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1145.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1144.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1143.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1142.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1141.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, db1138.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1125.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1121.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', db1081.eqiad.wmnet:3306 `chd_seen` int(10) unsigned NOT NULL DEFAULT '0', clouddb1019.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, clouddb1015.eqiad.wmnet:3314 `chd_seen` int(10) unsigned NOT NULL DEFAULT 0, TASK DETAIL https://phabricator.wikimedia.org/T273874 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui Cc: Ladsgroup, Aklapper, Addshore, Lucas_Werkmeister_WMDE, Devnull, LSobanski, Akuckartz, Iflorez, darthmon_wmde, alaa_wmde, DannyS712, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, _jensen, rosalieper, Scott_WUaS, Jonas, Izno, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Rxy, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs