[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-09-14T05:29:02Z] Synchronized wmf-config/db-codfw.php: Repool db2050 - T189101 (duration: 00m 49s)TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Marostegui added a comment. Table imported on testwikidatawiki on eqiad hosts: root@db1075.eqiad.wmnet[testwikidatawiki]> show create table wbqc_constraints; +--+--- | Table| Create Table +--+--- | wbqc_constraints | CREATE TABLE `wbqc_constraints` ( `constraint_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `constraint_guid` varbinary(255) NOT NULL, `pid` int(11) NOT NULL, `constraint_type_qid` varbinary(255) NOT NULL, `constraint_parameters` blob, PRIMARY KEY (`constraint_id`), UNIQUE KEY `wbqc_constraints_guid_uniq` (`constraint_guid`), KEY `wbqc_constraints_pid_index` (`pid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=binary |TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-09-14T05:16:51Z] Synchronized wmf-config/db-codfw.php: Depool db2050 - T189101 (duration: 00m 49s)TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-09-14T05:16:59Z] Stop replication in sync on db1075 and db2050 - T189101TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
gerritbot added a comment. Change 460470 merged by jenkins-bot: [operations/mediawiki-config@master] db-codfw.php: Depool db2050 https://gerrit.wikimedia.org/r/460470TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
gerritbot added a comment. Change 460470 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/mediawiki-config@master] db-codfw.php: Depool db2050 https://gerrit.wikimedia.org/r/460470TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Marostegui added a comment. The table has been imported in eqiad hosts. root@neodymium:/home/marostegui# mysql.py -hdb1071 wikidatawiki -e "show create table wbqc_constraints\G" *** 1. row *** Table: wbqc_constraints Create Table: CREATE TABLE `wbqc_constraints` ( `constraint_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `constraint_guid` varbinary(63) NOT NULL, `pid` int(11) NOT NULL, `constraint_type_qid` varbinary(25) NOT NULL, `constraint_parameters` blob, PRIMARY KEY (`constraint_id`), UNIQUE KEY `wbqc_constraints_guid_uniq` (`constraint_guid`), KEY `wbqc_constraints_pid_index` (`pid`) ) ENGINE=InnoDB AUTO_INCREMENT=22320 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-09-13T13:03:32Z] Synchronized wmf-config/db-codfw.php: Repool db2085:3318 - T189101 (duration: 00m 49s)TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-09-13T12:55:15Z] Stop db1071 (s8 eqiad master) and db2085:3318 in sync - T189101TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-09-13T12:54:50Z] Synchronized wmf-config/db-codfw.php: Depool db2085:3318 - T189101 (duration: 00m 49s)TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
gerritbot added a comment. Change 460342 merged by jenkins-bot: [operations/mediawiki-config@master] db-codfw.php: Depool db2085:3318 https://gerrit.wikimedia.org/r/460342TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
gerritbot added a comment. Change 460342 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/mediawiki-config@master] db-codfw.php: Depool db2085:3318 https://gerrit.wikimedia.org/r/460342TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
gerritbot added a comment. Change 457363 merged by Marostegui: [operations/puppet@production] filtered_tables: Add constraint_id column https://gerrit.wikimedia.org/r/457363TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: gerritbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Salgo60, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Marostegui added a comment. I have done this on codfw (testwikidatawiki and wikidatawiki). So once eqiad is passive we will reimport the tables there and we'll be able to close this task. This is how the table looks like now: root@db2045.codfw.wmnet[wikidatawiki]> show create table wbqc_constraints\G *** 1. row *** Table: wbqc_constraints Create Table: CREATE TABLE `wbqc_constraints` ( `constraint_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `constraint_guid` varbinary(63) NOT NULL, `pid` int(11) NOT NULL, `constraint_type_qid` varbinary(25) NOT NULL, `constraint_parameters` blob, PRIMARY KEY (`constraint_id`), UNIQUE KEY `wbqc_constraints_guid_uniq` (`constraint_guid`), KEY `wbqc_constraints_pid_index` (`pid`) ) ENGINE=InnoDB AUTO_INCREMENT=20911 DEFAULT CHARSET=binaryTASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Salgo60, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-09-03T07:39:43Z] Deploy schema change on s8.wikidatawiki on codfw master - T189101TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: StashbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Salgo60, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-09-03T07:34:29Z] Deploy schema change on s3.testwikidatawiki on codfw master - T189101TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: StashbotCc: Stashbot, jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Salgo60, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
gerritbot added a comment. Change 457363 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/puppet@production] filtered_tables: Add constraint_id column https://gerrit.wikimedia.org/r/457363TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: gerritbotCc: jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Salgo60, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Marostegui added a comment. Thanks! We will try to get this done today or tomorrow!TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Salgo60, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
gerritbot added a comment. Change 456607 merged by jenkins-bot: [mediawiki/extensions/WikibaseQualityConstraints@master] Make index on constraint_guid unique https://gerrit.wikimedia.org/r/456607TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: gerritbotCc: jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, merbst, LawExplorer, Salgo60, Lewizho99, Maathavan, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
gerritbot added a comment. Change 456607 had a related patch set uploaded (by Lucas Werkmeister (WMDE); owner: Lucas Werkmeister (WMDE)): [mediawiki/extensions/WikibaseQualityConstraints@master] Make index on constraint_guid unique https://gerrit.wikimedia.org/r/456607TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: gerritbotCc: jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, merbst, LawExplorer, Salgo60, Agabi10, Luke081515, Wikidata-bugs, Lydia_Pintscher, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
jcrespo added a comment. Please if you could give this a lot of priority, because if we miss this "train" (switchover) we could be waiting for a full extra year. Thanks. PK changes are not easy to do normally.TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: jcrespoCc: jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, merbst, LawExplorer, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Lucas_Werkmeister_WMDE added a comment. constraint_guid should be kept. The SQL patch above re-adds the index on it, but not the UNIQUE constraint, so we’ll have to fix that. Thanks!TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Lucas_Werkmeister_WMDECc: jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, merbst, LawExplorer, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
jcrespo added a comment. @Lucas_Werkmeister_WMDE What is the plan with constraint_guid? Will you drop it? Shouldn't it keep the UNIQUE constraint while it is in use (and by extension, the index)? We need a quick answer if this is to be done in September.TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: jcrespoCc: jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, merbst, LawExplorer, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Marostegui added a comment. Just an update: we might go for a DC failover during Q1. Still to be confirmed, but if it is the case, we could try to go for the approach described at: T189101#4031549TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, merbst, LawExplorer, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Lucas_Werkmeister_WMDE added a comment. Okay, thanks :) waiting for that seems totally okay to me.TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Lucas_Werkmeister_WMDECc: Marostegui, Ladsgroup, Aklapper, Jonas, thiemowmde, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Ladsgroup added a comment. WMF fiscal and annual year starts from July, so it's April-June thing and not October-December. The DC failovers happens around June-July all the time.TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: Marostegui, Ladsgroup, Aklapper, Jonas, thiemowmde, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T189101: Deploy schema change for adding numeric primary key to wbqc_constraints table
Marostegui added a comment. This is not an easy change as it needs to be done directly on the master, or otherwise ids will not match. The table is pretty small (23M on disk - 16224 rows) so it can probably be done directly on the master. I would still prefer to go for the approach we took for other similar changes like: change_tag, tag_summary and watchlist tables which is: Do the alter on codfw Wait for the DC failover Reimport the tables on eqiad. I prefer that approach because: -It is not an urgent request and failover might be happening on Q4, so not far away from now. I prefer avoid doing such changes (adding auto_inc columns) directly on the master and getting it replicated thru all the replication chain if there is an alternative way. TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Marostegui, Ladsgroup, Aklapper, Jonas, thiemowmde, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
