[04:46:36] 10DBA, 10Wikimedia-Site-requests: Global rename of [REDACTED] → Renamed user mou89p43twvqcvm8ut9w3: supervision needed - https://phabricator.wikimedia.org/T226971 (10Oshwah) @DannyS712 - Is this done by clicking on "protect as security issue"? That appears to be only used for security-related vulnerabilities a... [05:11:10] 10DBA, 10Operations: Decommission db1061-db1073 - https://phabricator.wikimedia.org/T217396 (10Marostegui) [05:21:50] 10DBA, 10OTRS, 10Operations, 10Operations-Software-Development, and 2 others: Failover m2 master db1065 to db1132 - https://phabricator.wikimedia.org/T226952 (10Marostegui) >>! In T226952#5295368, @Marostegui wrote: > Note: db2044 needs upgrading This was done [05:29:47] 10DBA, 10MediaWiki-API, 10Performance: list=logevents slow for users with last log action long time ago - https://phabricator.wikimedia.org/T71222 (10Marostegui) 05Stalled→03Resolved a:03Anomie [05:31:08] 10DBA, 10MediaWiki-API, 10Performance, 10User-Marostegui: list=logevents slow for users with last log action long time ago - https://phabricator.wikimedia.org/T71222 (10Marostegui) a:05Anomie→03None [05:34:36] 10DBA, 10MediaWiki-API, 10Performance, 10User-Marostegui: list=logevents slow for users with last log action long time ago - https://phabricator.wikimedia.org/T71222 (10Marostegui) a:03Anomie [05:41:03] 10DBA, 10MediaWiki-Configuration, 10Operations, 10Patch-For-Review: Data model for dbconfig - https://phabricator.wikimedia.org/T197531 (10Marostegui) @Joe @CDanis is this task still valid? [06:36:34] 10DBA, 10MediaWiki-Configuration, 10Operations, 10Patch-For-Review: Data model for dbconfig - https://phabricator.wikimedia.org/T197531 (10Volans) 05Open→03Resolved a:03Volans The data model is now part of the software and will evolve with it, wikitech documentation will be provided for it. I'm resol... [06:36:40] 10DBA, 10MediaWiki-Configuration, 10Operations, 10Patch-For-Review, and 2 others: Create tool to handle the state of database configuration in MediaWiki in etcd - https://phabricator.wikimedia.org/T197126 (10Volans) [06:37:26] is https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/520737 still needed? [06:37:45] nop [06:37:56] (I wasn't even aware of it!) [06:38:15] but 'db1087' => 100, was not normally there [06:39:14] true, I will fix that [06:39:18] should be 1 [06:39:27] maybe I can set both main hosts to 500? [06:39:40] I have made some changes to that already today [06:39:49] check the latest version [06:39:52] on noc [06:40:01] the latest version is on the left [06:40:12] I have rebased on top of HEAD [06:40:13] but yeah, both main should be 500 and db1087 should be 1 [06:41:08] like this? https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/520737/4/wmf-config/db-eqiad.php [06:41:43] yep [06:41:54] let me deploy then [06:42:49] great! [06:43:01] so I like to revert changes [06:43:08] because it minimizes mistakes [06:43:17] even if it requires manual rebase [06:43:36] but that is just me [06:44:11] I can restart the other 1.38 eqiad hosts, if you want me to [06:46:16] 10DBA, 10MediaWiki-Configuration, 10Operations, 10Patch-For-Review, and 2 others: Create tool to handle the state of database configuration in MediaWiki in etcd - https://phabricator.wikimedia.org/T197126 (10Volans) All patches for v1 of dbconfig are merged, including the ones to make a new conftool releas... [06:52:34] 10DBA, 10Wikimedia-Site-requests: Global rename of [REDACTED] → Renamed user mou89p43twvqcvm8ut9w3: supervision needed - https://phabricator.wikimedia.org/T226971 (10DannyS712) Not sure, but @Aklapper would know how to set a custom visibility policy [10:33:02] I don't have much sense of style, suggestions welcome: https://phab.wmfusercontent.org/file/data/ue3ksn4mmo4mixlgqc4w/PHID-FILE-okpnar4tck7gsnnhcl76/Screenshot_20190705_123222.png [10:33:39] The only thing I would put is db2058 at the same level as the rest of the slaves, as after all it is a normal replica [10:33:57] eh? [10:33:58] Otherwise it can look like db2058 replicates from db1085, no? [10:34:01] data is fake [10:34:14] on the fake data, that is the case :-D [10:34:21] ok then [10:34:57] maybe I can make the + blue [10:35:21] maybe color both dcs in a different way [10:35:28] interesting [10:35:43] but they don't have colors, so what, a background or something? [10:36:24] yeah, not sure if possible, just something visually different if possible, as it would be a quick way to identify them (other than the hostname) [10:36:52] or I can make cross-dc links a different color [10:37:01] that'd would help [10:37:23] I think a bit of color is nice, but I don't want to go too far with it [10:37:26] Not sure if possible, you tell me, can you print whether a host is using STATEMENT or ROW? [10:37:37] sure [10:38:06] I can show how they are configured, but not sure if it is applied [10:38:19] I think that's good [10:55:30] https://phab.wmfusercontent.org/file/data/em4uwapv6hf4xymhq2wb/PHID-FILE-f55bzayvl64u324itr3c/Screenshot_20190705_125503.png [10:58:26] nice! [10:59:04] not sure if also 2066 should have the pink colour [10:59:10] as it is a slave in another dc [10:59:14] I won't work more for now on formatting, we can change it later [10:59:19] sure [10:59:24] yeah, but "what is other dc?" [10:59:27] very nice already [10:59:59] the pink means something concrete with is "replication goves over WAN" [10:59:59] another dc meaning all the hosts in the same DC having the same colour [11:00:15] same DC as? [11:00:40] as it's master [11:00:45] its local master [11:00:56] I'm going for lunch we can keep discussing later [11:00:57] all instances are on the same dc as its local master [11:01:00] :-D [11:01:20] 2066 isn't on the same DC as 1067 [11:01:26] that's my point [13:00:41] 10DBA, 10Data-Services: Compress and defragment tables on labsdb hosts - https://phabricator.wikimedia.org/T222978 (10Marostegui) In order to cause less disruption to the service I am trying a different approach with labsdb1009. I am compressing around 50k tables from almost 700 wikis which are smaller than 10... [13:12:07] 10DBA, 10Wikimedia-Site-requests: Global rename of [REDACTED] → Renamed user mou89p43twvqcvm8ut9w3: supervision needed - https://phabricator.wikimedia.org/T226971 (10Urbanecm) The term "security issue" is used in quite broad meaning, basically everything that should be non-public at any given time. You can use... [14:14:11] 10DBA, 10Core Platform Team (MCR), 10Multi-Content-Revisions (Tech Debt), 10Schema-change: Once MCR is deployed, drop the rev_text_id, rev_content_model, and rev_content_format fields from the revision table - https://phabricator.wikimedia.org/T184615 (10WDoranWMF) [15:07:59] 10DBA, 10Operations, 10ops-codfw: db2097 (codfw s1&s6 source backups) mariadb@s6 *process* (10.1.39) crashed on 2019-06-08 - https://phabricator.wikimedia.org/T225378 (10Papaul) Your request is being worked on under reference number 5339905554 Status: Case is generated and in Progress Product description: H... [15:27:46] 10DBA, 10MediaWiki-Database, 10Core Platform Team (Security, stability, performance and scalability (TEC1)), 10Core Platform Team Kanban (Done with CPT), and 2 others: Slow query ApiQueryRevisions on enwiki - https://phabricator.wikimedia.org/T224017 (10WDoranWMF) [15:32:12] https://phab.wmfusercontent.org/file/data/g5eij3n2yow2g4vfkhoa/PHID-FILE-zmyiodgte2pcygxmxhd7/Screenshot_20190705_173135.png [15:50:28] <3 nice work! super useful!! [15:50:37] well done jynus [15:51:54] <3 [16:06:05] 10DBA, 10Operations, 10ops-codfw: db2097 (codfw s1&s6 source backups) mariadb@s6 *process* (10.1.39) crashed on 2019-06-08 - https://phabricator.wikimedia.org/T225378 (10Papaul) Will be receiving the DIMM on Monday [16:39:29] 10DBA, 10MediaWiki-API, 10Core Platform Team (Security, stability, performance and scalability (TEC1)), 10Core Platform Team Kanban (Waiting for Review), and 2 others: Certain ApiQueryRecentChanges::run api query is too slow, slowing down dewiki - https://phabricator.wikimedia.org/T149077 (10WDoranWMF) @da... [16:39:44] 10DBA, 10MediaWiki-API, 10Core Platform Team (Security, stability, performance and scalability (TEC1)), 10Core Platform Team Kanban (Clinic Duty Team), and 2 others: Certain ApiQueryRecentChanges::run api query is too slow, slowing down dewiki - https://phabricator.wikimedia.org/T149077 (10WDoranWMF) [16:47:20] 10DBA, 10Operations, 10ops-codfw: db2097 (codfw s1&s6 source backups) mariadb@s6 *process* (10.1.39) crashed on 2019-06-08 - https://phabricator.wikimedia.org/T225378 (10Papaul) Dear Mr Papaul Tshibamba, Hewlett Packard Enterprise Reference Number: 5339905554 STATUS: Customer Self Repair Part has been ship... [17:14:47] 10DBA, 10Wikimedia-Site-requests: Global rename of [REDACTED] → Renamed user mou89p43twvqcvm8ut9w3: supervision needed - https://phabricator.wikimedia.org/T226971 (10Aklapper) This is not a Security issue and there is no "broad meaning". "Edit Task" above offers to restrict the task view policy. [17:23:43] 10DBA, 10Wikimedia-Site-requests: Global rename of [REDACTED] → Renamed user mou89p43twvqcvm8ut9w3: supervision needed - https://phabricator.wikimedia.org/T226971 (10Urbanecm) >>! In T226971#5309609, @Aklapper wrote: > This is not a Security issue and there is no "broad meaning". "Edit Task" above offers to re... [18:08:40] 10DBA, 10Wikimedia-Site-requests: Global rename of [REDACTED] → Renamed user mou89p43twvqcvm8ut9w3: supervision needed - https://phabricator.wikimedia.org/T226971 (10Aklapper) Ah, thanks. What should the view policy of this task be exactly then? [19:26:02] Hello! Can anybody tell me if and how I can (read-only)-access the database of de.wikipedia.beta.wmflabs.org? [19:37:40] 10DBA, 10MediaWiki-General-or-Unknown, 10Core Platform Team Kanban (Clinic Duty Team): Investigate query planning in MariaDB 10 - https://phabricator.wikimedia.org/T85000 (10WDoranWMF) [21:36:01] 10DBA, 10Wikimedia-Site-requests: Global rename of [REDACTED] → Renamed user mou89p43twvqcvm8ut9w3: supervision needed - https://phabricator.wikimedia.org/T226971 (10Peachey88) NDA only would probably be the easiest