[00:01:01] awight: np! [00:01:37] ejegg: heheh ^ yeah also see if u like hiving like that... Mmm pandas has a bunch of stats functions also [00:01:47] (I was gonna ping u too but u were afk) [00:02:18] cool, I'd like to try that! [00:02:22] A spike to investigate a spike... Isn't that like Phabricator cannibalism? [00:02:33] I felt funny about it [00:02:37] could catch kuri [00:02:56] also, I should add hive to the training matrix: https://www.mediawiki.org/w/index.php?title=Fundraising_tech/Training [00:03:08] Ah good call [00:03:08] +1 [00:04:04] I'm gonna... scroll saw some christmas ornaments for a minute. back in 30 [00:06:39] sounds fun! [00:08:55] back later! [00:09:39] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: en6C_dsk_FR campaign: Bucket D behind in impressions - https://phabricator.wikimedia.org/T152662#2858939 (AndyRussG) Thanks much!! :) Checking Hive data for today, for that campaign, I these numbers for ba... [00:11:51] Gotta afk a bit! [00:43:45] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, FR-Email: Investigate reported banners/emails after donation - https://phabricator.wikimedia.org/T152744#2858852 (Ejegg) a:Ejegg [00:45:57] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, FR-Email: Investigate reported banners/emails after donation - https://phabricator.wikimedia.org/T152744#2859047 (Ejegg) I requested browser and add-on details from donors that continue to see banners,... [01:00:21] good evening all! [01:23:54] AndyRussG|bassoo: Cool! I can just create my own db, I see [01:24:20] Those are some yummy digestive queries you've written there, thanks again! [04:24:27] Fundraising Sprint Testing on Production, Fundraising Sprint Unbreaking Now, Fundraising Sprint Value Subtracting, Fundraising Sprint Waiting for Godot, and 5 others: CentralNotice: Relay banner loading issues in beacon/impression - https://phabricator.wikimedia.org/T149107#2859243 (AndyRussG) K... [16:46:53] (CR) Hashar: "Commented merely for the sake of it :} numpy/scipy will be cached by CI eventually." (1 comment) [wikimedia/fundraising/stats] - https://gerrit.wikimedia.org/r/324774 (owner: Awight) [16:48:51] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, FR-Email: Investigate reported banners/emails after donation - https://phabricator.wikimedia.org/T152744#2858852 (AndyRussG) Maybe we can verify this in Hive, also? As the number of people who donated i... [17:13:01] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi unresponsive for Engage in evenings - https://phabricator.wikimedia.org/T152786#2860090 (LeanneS) [17:22:04] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Spike: Impressions abnormally low for Ireland - https://phabricator.wikimedia.org/T152650#2856086 (AndyRussG) Just some random ideas about stuff to check... Maybe lock for lack of correspondence between the... [17:24:18] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi unresponsive for Engage in evenings - https://phabricator.wikimedia.org/T152786#2860127 (DStrine) @LeanneS is checking if this was just one day or if this occurs at the same time every day. [18:00:02] fr-tech: "Cheshire-Puss," she began, "would you tell me, please, which [18:00:02] way I ought to go from here?" [18:00:03] "That depends a good deal on where you want to get to," said [18:00:03] the Cat. [18:00:03] "I don't care much where--" said Alice. [18:00:03] "Then it doesn't matter which way you go," said the Cat. [18:00:03] -- Lewis Carroll, "Alice's Adventures in Wonderland" (1865) [18:00:04] -- discuss. [18:09:20] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Unplanned-Sprint-Work: Investigate implementing android and apple pay close together - https://phabricator.wikimedia.org/T152419#2860187 (XenoRyet) Full Apple Pay and/or Android pay will require a switch to Adyen's 'certified API' rather than... [18:13:32] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Unplanned-Sprint-Work: Investigate implementing android and apple pay close together - https://phabricator.wikimedia.org/T152419#2860192 (DStrine) @XenoRyet thanks for this. If we move to the certified API, what will this do to the other ady... [18:15:53] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Unplanned-Sprint-Work: Investigate implementing android and apple pay close together - https://phabricator.wikimedia.org/T152419#2860205 (Ppena) Thanks for the update @XenoRyet! My 2 cents is that making the donor add any extra information... [18:17:08] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Unplanned-Sprint-Work: Investigate implementing android and apple pay close together - https://phabricator.wikimedia.org/T152419#2860206 (XenoRyet) @DStrine If we're doing things the right way, we'd update them to use the new API on the back... [18:18:41] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi unresponsive for Engage in evenings - https://phabricator.wikimedia.org/T152786#2860207 (LeanneS) Update from Engage that it also happened on Monday afternoon: "This happened on Monday (12/5) around 4:20 PM. We worked in the system until 6:00 P... [18:20:49] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Unplanned-Sprint-Work: Investigate implementing android and apple pay close together - https://phabricator.wikimedia.org/T152419#2860210 (XenoRyet) I'll also stack my two cents with @Ppena's. The HPP solution seems unlikely to be worth it in... [18:23:04] fr-tech aarg had to move venue following internet bleah [18:23:12] Is anyone doing tech-talk? [18:23:32] Also, I feel like I missed how we divvy'd up current CN taskz [18:30:36] Also, I moved T149107 to "Done"... Hoping for feedback before actually closing, tho :) thx!! [18:30:36] T149107: CentralNotice: Relay banner loading issues in beacon/impression - https://phabricator.wikimedia.org/T149107 [18:56:41] fr-tech just fyi my connection continues to flake like the dry crust of leftover pie. Changing venue didn't help... apparently it's a problem with the main ISP in the whole neighbourhood... If u ping and I don't answer, and something is urgent, pls call! thx!!! [19:01:49] dstrine: do you know which of these tasks I should be diving into? T152650 T152741 ? [19:01:49] T152741: Spike: Investigate huge spike in StaleCampaignException messages since Dec 8 - https://phabricator.wikimedia.org/T152741 [19:01:49] T152650: Spike: Impressions abnormally low for Ireland - https://phabricator.wikimedia.org/T152650 [19:02:18] I think awight started on T152741, so I guess the other? [19:06:08] Fundraising Sprint Waiting for Godot, Fundraising-Backlog: Items from 2016-12-07 retrospective - https://phabricator.wikimedia.org/T152796#2860367 (ggellerman) [19:17:48] AndyRussG: is T152741 more dangerous/severe? [19:17:48] T152741: Spike: Investigate huge spike in StaleCampaignException messages since Dec 8 - https://phabricator.wikimedia.org/T152741 [19:20:16] dstrine: unknown... I just know that awight started looking into it. Dunno if he did or not on the other one [19:22:02] do you think T152741 just annoying to us or could it be donor facing? [19:24:11] dstrine: wort case, means lost impressions, just like the Irish one [19:24:57] I suppose if I'd have to choose, I'd guess that the low impressions questions for Ireland has a greater risk of being bad [19:25:00] But that could be totally off [19:25:33] I don't think donors would notice anything in either, just less potential ones would get bannered [19:25:41] why dont you take ireland then [19:25:45] K! [19:27:30] thanks for checking! [19:27:54] :) [19:29:05] Also dstrine ggellerman_ ejegg[m] what do you think about doings standup by e-mail today? cw d, XenoRye t and awight are out, ejegg's IRC sez he's away, and my Internet connection has been very gassy.... [19:30:24] Dylan said he'd be back for standup. We can call you in. [19:30:40] dstrine: K :) [19:30:44] I need to talk about apple/android for sure [19:31:45] K [19:35:41] Hey fr-tech. Is there some slick way we can find out how many fundraising banners we served in total in November and December, going back to 2011? [19:35:50] (muahaha) [19:37:54] K4-713: I doubt analytics keeps weblogs like that... [19:38:29] We should keep impression counts. [19:38:32] Ourselves. [19:38:50] They're definitely not raw logs. [19:38:51] Maybe looking at old reports we made each year? [19:38:56] Hmm. [19:39:15] yep good point :) [19:39:39] I know we used to keep things in the pgehres database, but at some point we should have cut over to something else. [19:43:01] isn't pgehres still active? [19:43:13] then there was faulkner for older stuff, but I think we finally took that offline [19:43:17] To some degree, yes. [19:43:29] But I don't think it's the main source for anything anymore. [19:43:51] It would have info for some of the older years, I'm sure. [19:45:04] where else would it be? fredge? [19:46:35] Nah. I just thought we had a less awful way to store and retrieve banner impression data these days. [19:46:39] I may be totally wrong. [19:49:35] i dunno. pgehres definitely has new data though, it's up to 2016-12-09 19:30:00 in the bannerimpressions table [19:49:59] K4-713: right, pgehres! [19:50:15] Yes, we can get better data from Hive, which is why I wasn't thinking much about pgehrs [19:50:25] But it is still used by fr-online a lot, infact [19:50:36] Aha, okay. [19:50:47] So, we probably have data back as far as that thing goes. [19:50:54] P.S. the internet contection has been going onn and off, sorry if I'm not responsive... [19:50:59] Do you happen to know if we outlined the schema somewhere, like collab? [19:51:10] Hmmm [19:51:10] Or, do I just have to go in there and DESCRIBE everything? [19:53:10] K4-713: https://www.mediawiki.org/wiki/Fundraising_tech/Database_schema#pgehres_database [19:53:16] (dunno how current that is...) [19:53:45] As you know, it's a bit funky [19:54:03] I'm happy it's only a bit. [19:55:41] might a medium-sized bit [19:55:48] might be [20:09:52] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Spike: Impressions abnormally low for Ireland - https://phabricator.wikimedia.org/T152650#2856086 (AndyRussG) a:AndyRussG [20:20:16] cwd just trying out the dash vagrant patch [20:20:33] dstrine: for T152650, do you know if cps sent us more specific data on the suspected Irish? I just see the mention in Max's e-mail, and a tidbit on page 8 of monitor_BE_2016-12-06_144-168h-1.pdf and monitor_BE_2016-12-06_0-168h-1.pdf, which Max sent 07/12/16 12:13 AM [20:20:33] T152650: Spike: Impressions abnormally low for Ireland - https://phabricator.wikimedia.org/T152650 [20:21:24] cwd have you got it running? I think we need to merge https://gerrit.wikimedia.org/r/326012 and https://gerrit.wikimedia.org/r/326007 [20:23:40] AndyRussG: nope not that I know of [20:24:22] K thx! [20:24:50] somehow I missed several emails from max. I haven't read through all of it yet [20:32:30] in fr-online [20:33:28] the reports look good! I guess a more thorough review would involve reading thru code, like codereviewish... Which I don't think we have time fore [20:34:21] My main observation so far is that I'd wish to see more info on the source of data from each chart (i.e., which data points come from BH, which from beacon/imrpession), maybe more technical definitions of data stuff as footnotes [22:39:32] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, FR-Email: Investigate reported banners/emails after donation - https://phabricator.wikimedia.org/T152744#2860819 (Ejegg) The proportion does seem to be increasing, so it's not failing for everyone. Mayb... [22:40:49] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, FR-Email: Investigate reported banners/emails after donation - https://phabricator.wikimedia.org/T152744#2860820 (Ejegg) The person who reported getting an email after donating says that it was within a...