[05:42:37] <wikibugs>	 10Blocked-on-schema-change, 10MediaWiki-Database, 10Patch-For-Review: Add a primary key to l10n_cache - https://phabricator.wikimedia.org/T146591 (10Marostegui)
[05:42:39] <wikibugs>	 10DBA, 10Schema-change: Schema change to drop default from externallinks.el_index_60 - https://phabricator.wikimedia.org/T197891 (10Marostegui)
[06:43:48] <_joe_>	 hey dbas, the techcom wants to schedule for an IRC meeting https://phabricator.wikimedia.org/T20493, and I think your thoughts could be important
[06:44:01] <_joe_>	 either on ticket, or at the IRC meeting
[06:45:52] <marostegui>	 Any idea when the meeting will be?
[06:46:28] <marostegui>	 I guess we also need mediawiki-platform there
[06:46:50] <_joe_>	 mediawiki-platform is 30% of the techcom :D
[06:46:55] <marostegui>	 XDDD
[06:47:00] <_joe_>	 I think tentatively next wednesday
[06:47:16] <marostegui>	 Yeah, I was referring to someone like anomie as he's been doing lots of work on the archive table lately
[06:47:29] <_joe_>	 look out for the tech radar email
[06:48:22] <marostegui>	 srure
[06:48:38] <marostegui>	 sure
[08:02:12] <jynus>	 _joe_: that is one of the few items that dbas are in sync with platform, and they fully get our proposals (or already had those in mind)
[08:04:27] <_joe_>	 jynus: well the last comment on that ticket is from 2009, and daniel kinzler was asking explicitly for a feedback from you people :)
[08:04:39] <jynus>	 sure
[08:04:53] <jynus>	 I think we just agree on the idea
[08:05:02] <jynus>	 it is the implementation that will not be easy
[08:09:18] <_joe_>	 specifically, daniel was worried that introducing this new flag would make the queries for special:contributions more taxing, for instance
[08:12:29] <jynus>	 and he is right
[08:13:11] <jynus>	 but a) those queries already have issues and b) there is no magic solution- literaly iterate on things until we are happy
[08:13:53] <jynus>	 we will need different indexes, and probably different partitioning
[08:51:38] <jynus>	 so I want to reimage today db2052 (codfw s5 master), db2040 (codfw s7 master) or db2045 (codfw s8 master)
[08:51:53] <jynus>	 I will likely won't do all
[08:52:01] <jynus>	 which ones don't bother you?
[08:53:05] <marostegui>	 no one :)
[08:53:08] <marostegui>	 you can do them all
[08:53:17] <marostegui>	 Not touching codfw today
[08:53:24] <jynus>	 ok, beacase they are masters I will be doing one at a time
[08:53:34] <jynus>	 because if one fails, it will get messy
[08:53:39] <marostegui>	 yeah
[08:56:47] <jynus>	 I see db2052 on downtime, do you know why?
[08:57:12] <marostegui>	 yeah, I executed a long alter yesterday
[08:57:19] <jynus>	 ok, thanks
[08:57:19] <marostegui>	 and downtime it for a day, as I didn't know how long it would take
[08:57:26] <jynus>	 just making sure there was nothing else running
[08:57:28] <jynus>	 it is ok
[08:57:30] <marostegui>	 nope, all finished
[08:57:49] <marostegui>	 you are good to go
[08:58:06] <jynus>	 BTW, I saw some disabled replication checks on codfw
[08:58:29] <marostegui>	 maybe left overs from something?
[08:58:37] <jynus>	 I think it was on s4
[08:59:00] <jynus>	 I will reenable them if I see them disabled rather than on downtime (on codfw)
[08:59:05] <marostegui>	 yeah
[08:59:09] <marostegui>	 Probably leftovers
[08:59:14] <marostegui>	 From something I guess
[09:01:41] <jynus>	 I just realized it is thursdat, we have a meeting today and I am bothering you unecessarely, sorry
[09:01:57] <marostegui>	 you are not bothering me at all!
[09:02:06] <marostegui>	 better to share all these things when they are seen
[09:02:16] <marostegui>	 just in case
[09:02:17] <marostegui>	 :)
[10:34:24] <wikibugs>	 10Blocked-on-schema-change, 10MediaWiki-Change-tagging, 10MediaWiki-Database, 10Patch-For-Review: Schema change for ct_tag_id field to change_tag - https://phabricator.wikimedia.org/T195193 (10Ladsgroup) Thank you!
[15:25:00] <wikibugs>	 10DBA, 10MediaWiki-Database, 10MW-1.32-release-notes (WMF-deploy-2018-06-26 (1.32.0-wmf.10)), 10Multi-Content-Revisions (MCR-SDC phase 1), and 2 others: Rising lock wait timeout SQL errors upon 1.32.0-wmf.10 group1 deployment - https://phabricator.wikimedia.org/T198350 (10Marostegui) +1 to get it closed
[17:03:50] <jynus>	 no more db2* hosts with jessie :-)
[17:28:35] <marostegui>	 jynus: well done!!
[18:34:38] <wikibugs>	 10DBA, 10MediaWiki-API, 10MediaWiki-Database, 10MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), and 3 others: ApiQueryExtLinksUsage::run query has crazy limit - https://phabricator.wikimedia.org/T59176 (10Anomie)
[18:34:40] <wikibugs>	 10DBA, 10MediaWiki-API, 10MediaWiki-Database, 10MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), and 3 others: ApiQueryExtLinksUsage::run query has crazy limit - https://phabricator.wikimedia.org/T59176 (10Anomie) Yes. I forgot there was a checklist in here.