Marostegui added a comment.
I have altered `testwikidatawiki` (the connection errors are hosts that are
down for maintenance and will get the schema change once mysql is started again)
# ./section s3 | while read host port; do echo "$host:$port" ; mysql.py
-h$host:$port testwikidatawiki -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:3313
`chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db2127.codfw.wmnet:3306
`chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db2109.codfw.wmnet:3306
`chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db2105.codfw.wmnet:3306
`chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db2098.codfw.wmnet:3313
`chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db2094.codfw.wmnet:3313
`chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db2074.codfw.wmnet:3306
`chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1175.eqiad.wmnet:3306
`chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db1171.eqiad.wmnet:3313
`chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1166.eqiad.wmnet:3306
`chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db1157.eqiad.wmnet:3306
ERROR 2002 (HY000): Can't connect to MySQL server on 'db1157.eqiad.wmnet'
(115)
db1154.eqiad.wmnet:3313
`chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db1124.eqiad.wmnet:3313
`chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1123.eqiad.wmnet:3306
`chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1112.eqiad.wmnet:3306
`chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1075.eqiad.wmnet:3306
ERROR 2002 (HY000): Can't connect to MySQL server on 'db1075.eqiad.wmnet'
(115)
clouddb1017.eqiad.wmnet:3313
`chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
clouddb1013.eqiad.wmnet:3313
`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
