[Wikidata-bugs] [Maniphest] T273874: Make wb_changes_dispatch.chd_seen unsigned in production

Marostegui Sun, 07 Feb 2021 22:19:02 -0800

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

[Wikidata-bugs] [Maniphest] T273874: Make wb_changes_dispatch.chd_seen unsigned in production

Reply via email to