[04:38:47] 10DBA, 03Community-Tech-Sprint, 13Patch-For-Review: Create a maintenance script for populating the local_user_id and global_user_id fields in the centralauth localuser table - https://phabricator.wikimedia.org/T142503#2747512 (10kaldari) 05Open>03Resolved [06:36:48] 10DBA: Test InnoDB compression - https://phabricator.wikimedia.org/T139055#2747582 (10Marostegui) As part of T146261 I am now compressing the whole `enwiki` database in dbstore2001. I will post back the results here. [07:43:00] 07Blocked-on-schema-change, 10DBA: Apply change_tag and tag_summary primary key schema change to Wikimedia wikis - https://phabricator.wikimedia.org/T147166#2747638 (10Marostegui) db2034: ``` root@neodymium:/home/marostegui/git/software/dbtools# mysql -hdb2034.codfw.wmnet enwiki -e "show create table tag_summ... [07:46:05] 10DBA: codfw: Fix S4 commonswiki.templatelinks partitions - https://phabricator.wikimedia.org/T149079#2747639 (10Marostegui) db2051 finished: ``` root@neodymium:/home/marostegui/git# mysql -hdb2051.codfw.wmnet commonswiki -e "show create table templatelinks\G" *************************** 1. row *****************... [07:52:46] 10DBA: codfw: Fix S4 commonswiki.templatelinks partitions - https://phabricator.wikimedia.org/T149079#2747643 (10Marostegui) db2065 is now running. I believe we'd also need to fix the following eqiad hosts: ``` db1059 (api) db1064 (vslow, dump) db1068 (api) ``` [08:15:53] 10DBA: Fix PK on S5 dewiki.revision - https://phabricator.wikimedia.org/T148967#2747694 (10Marostegui) The ALTER is now running on db2045 [08:28:54] 10DBA, 10MediaWiki-Special-pages, 13Patch-For-Review: Filtering Special:NewPages by page size - https://phabricator.wikimedia.org/T12817#2747716 (10TTO) 05Open>03Resolved a:03TTO Only took 9 years to get 100 lines of new code into MediaWiki... [08:29:19] ^ :o [08:31:40] 10DBA, 10MediaWiki-Special-pages, 07User-notice: Filtering Special:NewPages by page size - https://phabricator.wikimedia.org/T12817#2747725 (10matej_suchanek) [09:20:52] 07Blocked-on-schema-change, 10DBA: Apply change_tag and tag_summary primary key schema change to Wikimedia wikis - https://phabricator.wikimedia.org/T147166#2747811 (10Marostegui) db2048 ``` *************************** 1. row *************************** Table: tag_summary Create Table: CREATE TABLE `ta... [10:01:14] jynus: I am ready if you are [10:01:32] I am already there [10:01:45] ah ok [10:04:05] jynus: one more question re https://phabricator.wikimedia.org/T148988 in your suggestion ct_site_namespace_title is not Unique, but in my original plan it is, do have any comments about making it UNIQUE once more? [10:34:43] Also, there are many cases, probably 99%, where the normalisation has no effect "House" -> "House", not sure if that changes any thoughts at all [11:43:23] 10DBA, 06Operations, 10ops-codfw: db2011 disk media errors - https://phabricator.wikimedia.org/T149099#2748026 (10Marostegui) a:05jcrespo>03Marostegui [11:47:45] PRIMARY KEY (cgti_site, cgti_namespace, cgti_title) <--- PK implies unique [11:47:55] addshore^ [11:48:40] addshore, as it will not be the case for all rows, we cannot make any assuption [11:49:35] the idea is identify keys with unique ids so that they do not repat n times in text form [11:58:49] jynus: site, namespace title would be unique! [11:59:22] addshore, yes, I just said Primary key implies unique [11:59:52] or if it is not a PK [11:59:57] set it as such [12:00:02] okay! [12:00:34] I'm currently having a look at a different schema, still got to look at the main select query but I think it may work quite nicely. [12:00:37] https://www.irccloud.com/pastebin/AUoCsqP9/ [12:27:01] 10DBA, 10Cognate, 10Wikidata, 15User-Addshore, 03WMDE-QWERTY-Team-Board: Initial Cognate DB review - https://phabricator.wikimedia.org/T148988#2748089 (10Addshore) [13:55:17] jynus: https://tendril.wikimedia.org/report/slow_queries?host=db1092&user=&schema=&qmode=eq&query=&hours=72 [13:55:27] That's the impact of T147748 :) [13:55:30] T147748: Large number of CategoryMembershipChangeJob::run updates are failing - https://phabricator.wikimedia.org/T147748 [13:55:40] Change got deployed yesterday [13:55:47] nice :-) [14:13:48] 10DBA: Fix PK on S5 dewiki.revision - https://phabricator.wikimedia.org/T148967#2748337 (10Marostegui) db2045 is finished. ``` root@neodymium:/home/marostegui/git/software/dbtools# mysql -hdb2045.codfw.wmnet dewiki -e "show create table revision\G" *************************** 1. row ***************************... [14:46:03] 10DBA: Fix PK on S5 dewiki.revision - https://phabricator.wikimedia.org/T148967#2748416 (10Marostegui) The ALTER is now running on db2052 [15:16:28] 10DBA, 06Labs, 10Labs-Infrastructure, 06Operations: Create maintain-views user for labsdb1001 and labsdb1003 - https://phabricator.wikimedia.org/T148560#2748504 (10chasemp) @Marostegui I'm of the opinion at the moment that reworking the definer could be a more nuanced bit of work itself. Honestly, no idea... [15:24:01] 10DBA, 06Labs, 10Labs-Infrastructure, 06Operations: Create maintain-views user for labsdb1001 and labsdb1003 - https://phabricator.wikimedia.org/T148560#2748518 (10jcrespo) > Then the path forward I think is to keep both the VIEWMASTER and MAINTAINVIEWS users with SUPER privs and to use the MAINTAINVEWS us... [15:25:40] 10DBA, 06Labs, 10Labs-Infrastructure, 06Operations: Create maintain-views user for labsdb1001 and labsdb1003 - https://phabricator.wikimedia.org/T148560#2748524 (10jcrespo) Also, there is a labsdbadmin user already existing, which was tasked to do maintenance (create users), maybe that should be the one us... [15:36:09] 10DBA, 06Labs, 10Labs-Infrastructure, 06Operations: Create maintain-views user for labsdb1001 and labsdb1003 - https://phabricator.wikimedia.org/T148560#2748568 (10chasemp) >>! In T148560#2748518, @jcrespo wrote: >> Then the path forward I think is to keep both the VIEWMASTER and MAINTAINVIEWS users with S... [15:46:42] jynus: ping-diddly-ing do you have a minute to talk about https://phabricator.wikimedia.org/T148560? I was hoping to sync up on where you want to be, I'm not sure if I'm being argumentative or not there, but mainly I'm good w/ what you guys are most comfortable w/ but we may be missing each other in intention [15:47:03] I want to have that minute, chasemp let's schedule a meeting [15:47:10] but not today sorry :-( [15:47:30] cool no worries, it's not urgent at all [15:47:39] I'll drop a quick cal invite on you both for later? [15:47:50] if possible tomorrow [15:47:53] kk [15:47:57] if not, next week [17:18:57] 10DBA: codfw: Fix S4 commonswiki.templatelinks partitions - https://phabricator.wikimedia.org/T149079#2749168 (10Marostegui) db2065 is now done ``` MariaDB MARIADB db2065.codfw.wmnet commonswiki > show create table templatelinks; +---------------+-----------------------------------------------------------------... [17:20:07] 10DBA: codfw: Fix S4 commonswiki.templatelinks partitions - https://phabricator.wikimedia.org/T149079#2749171 (10Marostegui) The only pending one in codfw is the master (db2019) and then the other two servers in eqiad [19:57:54] 10DBA, 06Operations: dbtree broken - https://phabricator.wikimedia.org/T149357#2749783 (10Krenair) [20:09:11] 10DBA, 06Operations: dbtree broken - https://phabricator.wikimedia.org/T149357#2749852 (10Krenair) was https://gerrit.wikimedia.org/r/#/c/239568/ [20:33:20] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), and 2 others: CirrusSearch SQL query for locating pages for reindex performs poorly - https://phabricator.wikimedia.org/T147957#2749984 (10debt) p:05Triage>03Normal