[Wikidata-bugs] [Maniphest] [Updated] T203709: Schema change for adding indexes of ct_tag_id
Marostegui added a comment. I know realised why the change was "gone" from all the eqiad s8 hosts except db1071, db1087,db1124 and labs. The reason is that the rest of the hosts were recloned from codfw (where the change wasn't deployed) as part of T206743: S8 replication issues leading to rows missing during eqiad -> codfw switch (Was: "A few lexemes disappeared")TASK DETAILhttps://phabricator.wikimedia.org/T203709EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: Addshore, Stashbot, Marostegui, Tgr, Anomie, TTO, Catrope, Aklapper, gerritbot, Ladsgroup, CucyNoiD, Nandana, NebulousIris, Banyek, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Rayssa-, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, D3r1ck01, Jonas, MGChecker, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Jay8g, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T203709: Schema change for adding indexes of ct_tag_id
gerritbot added a project: Patch-For-Review. TASK DETAILhttps://phabricator.wikimedia.org/T203709EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, gerritbotCc: Addshore, Stashbot, Marostegui, Tgr, Anomie, TTO, Catrope, Aklapper, gerritbot, Ladsgroup, CucyNoiD, Nandana, NebulousIris, Banyek, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Rayssa-, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, D3r1ck01, Jonas, MGChecker, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Jay8g, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T203709: Schema change for adding indexes of ct_tag_id
Addshore added a comment. @Marostegui Do we have an ETA on these indexes being re added so that we can resolve T208846 ?TASK DETAILhttps://phabricator.wikimedia.org/T203709EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, AddshoreCc: Addshore, Stashbot, Marostegui, Tgr, Anomie, TTO, Catrope, Aklapper, gerritbot, Ladsgroup, Nandana, Banyek, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Jonas, MGChecker, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Jay8g, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T203709: Schema change for adding indexes of ct_tag_id
Addshore added a parent task: T208846: Start reading from change_tag_def on wikidatawiki. TASK DETAILhttps://phabricator.wikimedia.org/T203709EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, AddshoreCc: Stashbot, Marostegui, Tgr, Anomie, TTO, Catrope, Aklapper, gerritbot, Ladsgroup, Nandana, Banyek, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Jonas, MGChecker, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Jay8g, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Updated] T203709: Schema change for adding indexes of ct_tag_id
Ladsgroup added a comment. It's not done in s8 eqiad causing this T207313: Some administrative and log actions on Wikidata take longer than 60 seconds and time out on Wikidata: wikiadmin@10.64.48.172(wikidatawiki)> show index from change_tag; +++--+--+-+---+-+--++--++-+---+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +++--+--+-+---+-+--++--++-+---+ | change_tag | 0 | PRIMARY |1 | ct_id | A | 222003497 | NULL | NULL | | BTREE | | | | change_tag | 0 | change_tag_rc_tag|1 | ct_rc_id| A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_rc_tag|2 | ct_tag | A | 222003497 | NULL | NULL | | BTREE | | | | change_tag | 0 | change_tag_log_tag |1 | ct_log_id | A |1060 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_log_tag |2 | ct_tag | A | 41210 | NULL | NULL | | BTREE | | | | change_tag | 0 | change_tag_rev_tag |1 | ct_rev_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_rev_tag |2 | ct_tag | A | 222003497 | NULL | NULL | | BTREE | | | | change_tag | 1 | change_tag_tag_id|1 | ct_tag | A | 30971 | NULL | NULL | | BTREE | | | | change_tag | 1 | change_tag_tag_id|2 | ct_rc_id| A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id|3 | ct_rev_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id|4 | ct_log_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id |1 | ct_tag_id | A | 33591 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id |2 | ct_rc_id| A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id |3 | ct_rev_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id |4 | ct_log_id | A | 222003497 | NULL | NULL | YES | BTREE | | | +++--+--+-+---+-+--++--++-+---+ 15 rows in set (0.00 sec) (Compare it with enwiki): wikiadmin@10.64.32.115(enwiki)> show index from change_tag; ++++--+-+---+-+--++--++-+---+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | ++++--+-+---+-+--++--++-+---+ | change_tag | 0 | PRIMARY|1 | ct_id | A |56055095 | NULL | NULL | | BTREE | | | | change_tag | 0 | change_tag_rc_tag_id |1 | ct_rc_id| A |56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_rc_tag_id |2 | ct_tag_id | A |56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_log_tag_id |1 | ct_log_id | A | 2242203 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_log_tag_id |2 | ct_tag_id | A | 50363 | NULL |
[Wikidata-bugs] [Maniphest] [Updated] T203709: Schema change for adding indexes of ct_tag_id
Stashbot added a comment.Restricted Application added a project: Wikidata. Mentioned in SAL (#wikimedia-operations) [2018-10-01T05:07:23Z] Deploy schema change on s1 codfw msater - T203709TASK DETAILhttps://phabricator.wikimedia.org/T203709EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui, StashbotCc: Stashbot, Marostegui, Tgr, Anomie, TTO, Catrope, Aklapper, gerritbot, Ladsgroup, Nandana, Banyek, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Jonas, MGChecker, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Jay8g, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
