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

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

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

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,

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

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

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

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,

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

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,

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

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,

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

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)

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

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,

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

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

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

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,

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

Marostegui added a comment. Wikis: #cat dblists/wikibaserepo.dblist | grep -v "#" commonswiki testcommonswiki testwikidatawiki wikidatawiki TASK DETAIL https://phabricator.wikimedia.org/T273874 EMAIL PREFERENCES

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

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,

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

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

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

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,

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

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: