[06:35:08] 10Blocked-on-schema-change, 10MediaWiki-Change-tagging, 10User-Ladsgroup: Drop change_tag.ct_tag column in production - https://phabricator.wikimedia.org/T210713 (10Marostegui) @Ladsgroup I think I will start with s6 (frwiki, jawiki and ruwiki). As the holidays time is approaching, I think I am going to alte... [06:41:10] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review, 10Schema-change: Dropping page.page_counter on wmf databases - https://phabricator.wikimedia.org/T86338 (10Marostegui) [06:41:20] 10Blocked-on-schema-change, 10DBA, 10MediaWiki-Database, 10Scoring-platform-team, and 2 others: Schema change for rc_this_oldid index - https://phabricator.wikimedia.org/T202167 (10Marostegui) [06:41:35] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review, 10Schema-change: Dropping page.page_counter on wmf databases - https://phabricator.wikimedia.org/T86338 (10Marostegui) [06:41:50] 10Blocked-on-schema-change, 10DBA, 10MediaWiki-Database, 10Scoring-platform-team, and 2 others: Schema change for rc_this_oldid index - https://phabricator.wikimedia.org/T202167 (10Marostegui) [07:34:56] 10Blocked-on-schema-change, 10DBA, 10MediaWiki-Database, 10Scoring-platform-team, and 2 others: Schema change for rc_this_oldid index - https://phabricator.wikimedia.org/T202167 (10Marostegui) [07:35:03] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review, 10Schema-change: Dropping page.page_counter on wmf databases - https://phabricator.wikimedia.org/T86338 (10Marostegui) [07:41:40] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review, 10Schema-change: Dropping page.page_counter on wmf databases - https://phabricator.wikimedia.org/T86338 (10Marostegui) s3 eqiad progress [] labsdb1011 [] labsdb1010 [] labsdb1009 [] dbstore1002 [] db1124 [] db1123 [] db1095 [] db1078 [] db1077 [] db1075 [07:41:44] 10Blocked-on-schema-change, 10DBA, 10MediaWiki-Database, 10Scoring-platform-team, and 2 others: Schema change for rc_this_oldid index - https://phabricator.wikimedia.org/T202167 (10Marostegui) s3 eqiad progress [] labsdb1011 [] labsdb1010 [] labsdb1009 [] dbstore1002 [] db1124 [] db1123 [] db1095 [] db107... [08:16:53] 10DBA, 10Wikimedia-Site-requests: Global rename of Massimo Telò → Teseo: supervision needed - https://phabricator.wikimedia.org/T209488 (10Banyek) Aye, I am here, noted [08:18:41] 10DBA, 10Wikimedia-Site-requests: Global rename of Massimo Telò → Teseo: supervision needed - https://phabricator.wikimedia.org/T209488 (101997kB) Can we start? [08:26:44] 10DBA, 10Wikimedia-Site-requests: Global rename of Massimo Telò → Teseo: supervision needed - https://phabricator.wikimedia.org/T209488 (10Banyek) @1997kB I'd say we should stick to the date on the calendar event [08:34:42] 10DBA, 10Analytics, 10Analytics-Kanban, 10Data-Services, and 3 others: Create materialized views on Wiki Replica hosts for better query performance - https://phabricator.wikimedia.org/T210693 (10Banyek) We didn't talked about this so far, but these views doesn't ask for having proper indexes? [09:25:00] 10DBA, 10Wikimedia-Site-requests: Global rename of Massimo Telò → Teseo: supervision needed - https://phabricator.wikimedia.org/T209488 (10Banyek) the progress url for rename is: https://meta.wikimedia.org/wiki/Special:GlobalRenameProgress/Teseo [09:49:13] 10DBA, 10Wikimedia-Site-requests: Global rename of Massimo Telò → Teseo: supervision needed - https://phabricator.wikimedia.org/T209488 (101997kB) 05Open→03Resolved a:03Banyek Successfully finished. Thanks! [10:22:03] 10Blocked-on-schema-change, 10DBA, 10MediaWiki-Database, 10Scoring-platform-team, and 2 others: Schema change for rc_this_oldid index - https://phabricator.wikimedia.org/T202167 (10Marostegui) [10:22:15] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review, 10Schema-change: Dropping page.page_counter on wmf databases - https://phabricator.wikimedia.org/T86338 (10Marostegui) [12:12:18] 10Blocked-on-schema-change, 10MediaWiki-Change-tagging, 10User-Ladsgroup: Drop change_tag.ct_tag column in production - https://phabricator.wikimedia.org/T210713 (10Ladsgroup) >>! In T210713#4822891, @Marostegui wrote: > @Ladsgroup I think I will start with s6 (frwiki, jawiki and ruwiki). As the holidays tim... [13:27:15] 10Blocked-on-schema-change, 10MediaWiki-Change-tagging, 10User-Ladsgroup: Drop change_tag.ct_tag column in production - https://phabricator.wikimedia.org/T210713 (10Marostegui) Yeah - I will run everything that is on that patch :) [13:29:31] 10DBA: Check GTID, consistency options and notifications across the fleet - https://phabricator.wikimedia.org/T211973 (10Marostegui) [13:29:44] 10DBA: Check GTID, consistency options and notifications across the fleet - https://phabricator.wikimedia.org/T211973 (10Marostegui) p:05Triage→03Normal [13:40:21] 10DBA: Check GTID, consistency options and notifications across the fleet - https://phabricator.wikimedia.org/T211973 (10Marostegui) The following hosts didn't have GTID enabled: ` db1124.eqiad.wmnet:3318 db2034.codfw.wmnet:3306 db2035.codfw.wmnet:3306 db2039.codfw.wmnet:3306 db2040.codfw.wmnet:3306 db2043.codfw... [13:41:47] 10DBA: Check GTID, consistency options and notifications across the fleet - https://phabricator.wikimedia.org/T211973 (10Marostegui) [13:51:40] 10DBA: Check GTID, consistency options and notifications across the fleet - https://phabricator.wikimedia.org/T211973 (10Marostegui) The following hosts do not have sync_binlog and trx_commit enabled (and they should): [] db2052.codfw.wmnet:3306 s5 master [] db2051.codfw.wmnet:3306 s4 master [] db2048.codfw.wmne... [13:51:51] 10DBA: Check GTID, consistency options and notifications across the fleet - https://phabricator.wikimedia.org/T211973 (10Marostegui) [14:00:55] 10DBA: Check GTID, consistency options and notifications across the fleet - https://phabricator.wikimedia.org/T211973 (10Marostegui) db2068 had one check (s7 lag - only that one) with notifications disabled. I have reenabled it. db1095 had one check (s3 lag - only that one) with notifications disabled. I have re... [14:01:07] 10DBA: Check GTID, consistency options and notifications across the fleet - https://phabricator.wikimedia.org/T211973 (10Marostegui) [16:14:47] 10DBA: Check GTID, consistency options and notifications across the fleet - https://phabricator.wikimedia.org/T211973 (10Marostegui) GTID enabled on db2039 (s6). After that a compare.py on frwiki.revision, jawiki.revision and ruwiki.revision revealed no differences. I also checked the logs where the slave was st... [16:15:31] ^ I will be enabling GTID next week, please coordinate with me before doing schema changes, to make sure we don't step on each other toes [16:20:02] kk [16:20:10] on monday O [16:20:16] on monday I'll be full of meetings [16:20:24] Tuesday I'll be out [16:21:08] I'll be log off soon for the weekend - if you don't have something for me [20:48:36] 10DBA, 10Analytics, 10Analytics-Kanban, 10Data-Services, and 3 others: Create materialized views on Wiki Replica hosts for better query performance - https://phabricator.wikimedia.org/T210693 (10Milimetric) @Banyek are you asking whether the views should have indices? I'm not sure for the cloud users use... [23:21:13] 10DBA, 10Analytics, 10Analytics-Kanban, 10Data-Services, and 3 others: Create materialized views on Wiki Replica hosts for better query performance - https://phabricator.wikimedia.org/T210693 (10bd808) >>! In T210693#4824836, @Milimetric wrote: > I'm not sure for the cloud users use case, you'd have to loo...