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

2021-02-22 Thread Lucas_Werkmeister_WMDE 
Lucas_Werkmeister_WMDE closed subtask T274091: DBQueryError: BIGINT 
UNSIGNED value is out of range on 
wikidatawiki.wb_changes_dispatch.chd_seen as Resolved.

TASK DETAIL
  https://phabricator.wikimedia.org/T273874

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui, Lucas_Werkmeister_WMDE
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

2021-02-07 Thread Marostegui 
Marostegui updated the task description.

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

2021-02-07 Thread Marostegui 
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,

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

2021-02-07 Thread Marostegui 
Marostegui updated the task description.

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

2021-02-07 Thread Marostegui 
Marostegui closed this task as "Resolved".
Marostegui added a comment.


  All done

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

2021-02-07 Thread Marostegui 
Marostegui updated the task description.

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

2021-02-07 Thread Marostegui 
Marostegui added a comment.


  `wikidatawiki`
  
# ./section s8   | while read host port; do echo "$host:$port" ;  mysql.py 
-h$host:$port  wikidatawiki -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',
dbstore1005.eqiad.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db2100.codfw.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db2094.codfw.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db2091.codfw.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db2086.codfw.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db2085.codfw.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db2084.codfw.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db2083.codfw.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db2082.codfw.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db2081.codfw.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db2080.codfw.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db2079.codfw.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1154.eqiad.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db1126.eqiad.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1124.eqiad.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1116.eqiad.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1114.eqiad.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db.eqiad.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db1109.eqiad.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1104.eqiad.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
db1101.eqiad.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db1099.eqiad.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db1092.eqiad.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
db1087.eqiad.wmnet:3306
  `chd_seen` int(10) unsigned NOT NULL DEFAULT '0',
clouddb1020.eqiad.wmnet:3318
  `chd_seen` int(10) unsigned NOT NULL DEFAULT 0,
clouddb1016.eqiad.wmnet:3318
  `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

2021-02-05 Thread Marostegui 
Marostegui updated the task description.

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

2021-02-05 Thread Marostegui 
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

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

2021-02-05 Thread Marostegui 
Marostegui updated the task description.

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

2021-02-05 Thread Marostegui 
Marostegui added a comment.


  Wikis:
  
#cat dblists/wikibaserepo.dblist  | grep -v "#"
commonswiki
testcommonswiki
testwikidatawiki
wikidatawiki

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

2021-02-05 Thread Marostegui 
Marostegui claimed this task.

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

2021-02-04 Thread Marostegui 
Marostegui triaged this task as "Medium" priority.
Marostegui moved this task from Triage to Ready on the DBA board.

TASK DETAIL
  https://phabricator.wikimedia.org/T273874

WORKBOARD
  https://phabricator.wikimedia.org/project/board/1060/

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

2021-02-04 Thread Lucas_Werkmeister_WMDE 
Lucas_Werkmeister_WMDE updated the task description.

TASK DETAIL
  https://phabricator.wikimedia.org/T273874

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
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

2021-02-04 Thread Lucas_Werkmeister_WMDE 
Lucas_Werkmeister_WMDE created this task.
Lucas_Werkmeister_WMDE added projects: Wikidata, Technical-Debt, 
wdwb-tech-focus (backlog), Wikidata-Campsite (Wikidata-Campsite-Iteration-∞), 
DBA, Blocked-on-schema-change.

TASK DESCRIPTION
  1. The **`ALTER TABLE`**s to run: 
https://gerrit.wikimedia.org/g/mediawiki/extensions/Wikibase/+/master/repo/sql/mysql/archives/patch-wb_changes_dispatch-make-chd_seen-unsigned.sql
 (Gerrit change )
  2. **Where** to run those changes: **`wikibaserepo` dblist**, i.e. 
`commonswiki`, `testcommonswiki`, `testwikidatawiki`, `wikidatawiki`
  3. **When** to run those changes: at **any time** (not blocked on a code 
change); column is not expected to overflow within a year
  4. If the schema change **is backwards compatible**: **yes**, no code change 
needed
  5. If the schema change **has been tested already** on some of the test/beta 
wikis: change was automatically deployed to Beta, without problems as far as I 
can tell (column is unsigned now, change dispatching still works)
  6. If it involves new columns or tables: no, so no labs replica changes are 
needed
  
  The affected table, `wb_changes_dispatch`, is expected to have less than 1000 
rows: one row per wiki.

TASK DETAIL
  https://phabricator.wikimedia.org/T273874

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
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