[02:12:44] <wikibugs>	 10DBA, 10MediaWiki-Change-tagging, 10Schema-change: change_tag table needs redesign - https://phabricator.wikimedia.org/T164167#3331066 (10Ladsgroup) >>! In T164167#3328004, @Catrope wrote: >  > What's confusing to me is that `tag_summary` is no longer used as an aggregate; instead a `GROUP_CONCAT()` is used...
[04:39:15] <wikibugs>	 10DBA, 10Labs, 10Labs-Infrastructure: Database upgrade MariaDB 10: Metadata access in INFORMATION_SCHEMA causes complete blocks - https://phabricator.wikimedia.org/T71182#3331214 (10bd808) a:05Springle>03None
[04:39:24] <wikibugs>	 10DBA, 10Labs, 10Labs-Infrastructure: Database upgrade MariaDB 10:  Discrepancies  with logging table on different wikis - https://phabricator.wikimedia.org/T71127#3331215 (10bd808) a:05Springle>03None
[05:29:31] <wikibugs>	 10DBA, 10Operations, 10Wikimedia-Site-requests: Rename user "Mlpearc" to "FlightTime" on Central Auth - https://phabricator.wikimedia.org/T166028#3331237 (10Marostegui) Sorry @MarcoAurelio that was almost 10:30pm our time :-(
[05:39:46] <wikibugs>	 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s2 - https://phabricator.wikimedia.org/T166205#3331238 (10Marostegui)
[05:55:33] <wikibugs>	 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s4 - https://phabricator.wikimedia.org/T166206#3331244 (10Marostegui)
[07:07:43] <wikibugs>	 10DBA: DROP OAI-related tables - https://phabricator.wikimedia.org/T139342#3331324 (10Marostegui)
[08:21:32] <wikibugs>	 10DBA, 10Operations, 10Wikimedia-Site-requests: Rename user "Mlpearc" to "FlightTime" on Central Auth - https://phabricator.wikimedia.org/T166028#3331397 (10MarcoAurelio) Being handled in a minute.
[08:26:17] <godog>	 jynus: yeah I was thinking on how to audit what tools might be affected by the tasks mentioned
[08:53:37] <wikibugs>	 10DBA, 10Operations, 10Wikimedia-Site-requests: Rename user "Mlpearc" to "FlightTime" on Central Auth - https://phabricator.wikimedia.org/T166028#3331434 (10MarcoAurelio) 05Open>03Resolved p:05Triage>03Normal a:03MarcoAurelio Global rename is now done. Thanks to @Marostegui for his help during the...
[09:30:55] <wikibugs>	 10DBA, 10Scoring-platform-team, 10articlequality-modeling, 10artificial-intelligence: [Discuss] Hosting the monthly article quality dataset on labsDB - https://phabricator.wikimedia.org/T146718#3331512 (10Marostegui) We believe that if you want the service to be up soon, the best option is to place it on t...
[11:57:01] <wikibugs>	 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s4 - https://phabricator.wikimedia.org/T166206#3331928 (10Marostegui) @chasemp @bd808 the ALTER table finished on labsdb1001 and it is already in sync with the master, so I am going to start w...
[12:01:10] <wikibugs>	 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s4 - https://phabricator.wikimedia.org/T166206#3331950 (10Marostegui) I will start the alter on labsdb1003 Monday instead.
[13:15:49] <wikibugs>	 10DBA: DROP OAI-related tables - https://phabricator.wikimedia.org/T139342#3332111 (10Marostegui)
[15:06:35] <jynus>	 I've uploaded the 10.1.24 packages on my home on install1002
[15:06:53] <marostegui>	 good, I will get them for my virtual machine
[15:28:15] <marostegui>	 when you tested myloader, did you loaded compressed tables?
[15:28:26] <jynus>	 no
[15:28:55] <marostegui>	 Right, it is taking almost 10 hours to load 125G - compressed tables
[15:30:04] <jynus>	 how much percentage is that of the total?
[15:30:27] <jynus>	 half?
[15:30:45] <marostegui>	 So dewiki is 125G compressed, and it still loading it (almost done, only two tables left)
[15:31:19] <marostegui>	 For wikidata, I will test loading it with Antelope file format in one of the hosts, and will leave Barracuda on the other one, to see if it has some effect
[15:31:22] <jynus>	 that is a lot, maybe more threads can be used if cpu is not maximized?
[15:31:36] <marostegui>	 yes, that definitely
[15:31:49] <marostegui>	 I will use probably 12 threads (instead of 8)
[15:33:09] <marostegui>	 it must be the compression, that was the only difference between db1095 and labsdbXX
[15:56:47] <bd808>	 marostegui: thanks for the ping about the next batch of s4 updates
[15:57:29] <marostegui>	 bd808: Sure! jaime told me you guys asked him yesterday, sorry for the trouble. I will do labsdb1003 on Monday
[15:59:39] <bd808>	 *nod* the "trouble" is mostly just knowing what's going on when people ask. most of the time when we can tell them that there is reason they understand
[16:01:31] <marostegui>	 Sure - will ping you guys for the future big alters (lots of them coming)
[16:01:53] <marostegui>	 Do you want me to ping you and chase on the tickets or the whole team?
[16:02:00] <marostegui>	 Whatever works better for you guys
[16:04:11] <chasemp>	 marostegui: I think we have a legit team tag now
[16:04:15] <chasemp>	 looking
[16:04:19] <chasemp>	 #csteam should get it tho
[16:04:43] <chasemp>	 oh nope
[16:04:49] <chasemp>	 https://phabricator.wikimedia.org/project/manage/2773/
[16:04:59] <chasemp>	 #wmcs-team
[16:05:02] <marostegui>	 Ah :)
[16:05:14] <volans>	 so easy to remember eh? who can I blame for it? :-P
[16:05:19] <marostegui>	 haha
[16:05:31] <volans>	 bd808: is it you? :-P
[16:05:32] <chasemp>	 we aim for eventual consistency not pleasant reading :D
[16:06:39] <chasemp>	 marostegui: protip you can actually add #wmcs-team to CC on tasks iirc
[16:06:52] <chasemp>	 rather than the project field
[16:06:57] <chasemp>	 slight difference in behavior
[16:07:01] <volans>	 the official name is cloud-services-team, wmcs-team, is just an alias hashtag
[16:07:13] <chasemp>	 yes
[16:07:34] <volans>	 that makes more sense, if I start typing cloud something should come up ;)
[16:08:06] <marostegui>	 chasemp: true! just saw it, will do next time then :)
[16:08:10] <marostegui>	 thanks for the tip!
[16:10:29] <bd808>	 volans: what did I do this time?
[16:10:55] <jynus>	 #csteam ?
[16:11:12] <volans>	 bd808: #wmcs-team but then I discovered is just an alias
[16:11:23] <jynus>	 are you on counter striike 1.6 or global offensive?
[16:11:29] <volans>	 so I can still find things typing #cloud ;)
[16:12:28] <bd808>	 counter strike! I sit in a high corner and snipe because I'm a jerk like that
[16:22:22] <godog>	 I remember playing a wolfstein "realistic" mod years ago until my gpu at the time could no longer run the latest version at decent fps, good times
[16:27:19] <wikibugs>	 10DBA, 10Analytics-Kanban, 10Operations, 10ops-eqiad, 10User-Elukey: db1046 BBU looks faulty - https://phabricator.wikimedia.org/T166141#3332904 (10elukey) @Cmjohnson sorry to ping :) Any idea if we have a spare BBU for db1046?
[16:29:28] <wikibugs>	 10DBA, 10Analytics-Kanban, 10Operations, 10ops-eqiad, 10User-Elukey: db1046 BBU looks faulty - https://phabricator.wikimedia.org/T166141#3332932 (10Cmjohnson) @elukey. Yes, I have another decommissioned r510 to take it from.  Ping you in a hour or so to replace
[16:32:00] <jynus>	 I think I am going to disconnect before eventlogging crashes
[16:32:25] <volans>	 rotfl
[16:41:42] <wikibugs>	 10DBA, 10Analytics-Kanban, 10Operations, 10ops-eqiad, 10User-Elukey: db1046 BBU looks faulty - https://phabricator.wikimedia.org/T166141#3332986 (10elukey) @Cmjohnson thanks! Would it be possible to do the swap next week? Since this is an important DB I'd need to coordinate my team and Jaime/Manuel first.
[17:04:33] <wikibugs>	 10DBA, 10Labs: Labs database replica drift - https://phabricator.wikimedia.org/T138967#3333050 (10bd808) Cross-post from {T166091}:  ```SELECT pl_namespace, pl_title FROM page JOIN pagelinks ON pl_from = page_id WHERE page_namespace=0 AND page_title="Ajinkya_Rahane" AND pl_title LIKE "Ankit%"; +--------------+...
[17:04:45] <wikibugs>	 10DBA, 10Labs: Labs database replica drift - https://phabricator.wikimedia.org/T138967#3333056 (10bd808)
[17:04:48] <wikibugs>	 10DBA, 10Labs: Labs database corruption - https://phabricator.wikimedia.org/T166091#3285070 (10bd808)
[17:09:39] <wikibugs>	 10DBA, 10Scoring-platform-team, 10articlequality-modeling, 10artificial-intelligence: [Discuss] Hosting the monthly article quality dataset on labsDB - https://phabricator.wikimedia.org/T146718#3333073 (10Halfak) A late assessment is better than never! Woot! I'll get it hosted on the old labsdbs ASAP.  Tha...
[17:35:58] <wikibugs>	 10DBA, 10Labs, 10Tool-Labs: s51127__dewiki_lists (merlbot) database using 13G on labsdb1001 (enwiki) - https://phabricator.wikimedia.org/T133325#2228208 (10Luke081515) Merl is inactive since about one year. The crontabs have been commented out one year ago. My first suggestion would be: create a dump, so tha...
[22:45:05] <wikibugs>	 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata, 10Patch-For-Review, and 2 others: Usage tracking: record which statement group is used - https://phabricator.wikimedia.org/T151717#3334295 (10Hall1467) @Ladsgroup: I believe this is the only related open patch right now: https://gerrit.wikimedia.org...