[00:00:08] recurring_gc_jobs_required > 6000 [00:00:57] SELECT MAX(COUNT) FROM (SELECT count(*) 'count' FROM civicrm.civicrm_contribution_recur [00:01:04] WHERE trxn_id LIKE 'RECURRING GLOBALCOLLECT%' AND next_sched_contribution_date IS NOT NULL [00:01:11] AND next_sched_contribution_date != 1 GROUP BY DATE_FORMAT(next_sched_contribution_date, '%d')) t [00:01:21] that's the query the metric is based on ^^^ [00:01:43] Jeff_Green: so the gc jobs q is hung? [00:02:00] oh I think I know [00:02:00] I'm not sure what it means, really :-( [00:02:18] I think that query is a protector so we can't double charge [00:02:37] ie. we had a situation once where we charged twice very close together due to a bug [00:02:51] ok [00:03:10] I think we should get a phab logged & then you can quiet the alerts & I'll take a look [00:03:21] I think it's non-urgent but will look into it [00:03:31] ok cool, do you want to do the phab part or shall I? [00:03:54] or is that query a check we have a job to run [00:04:15] well - if you can put what you know into a Phab I'll dig [00:04:33] we run that query from a nagios collector script on frdb1001 [00:04:45] Is there a link to that in a repo [00:05:01] it's in the frack puppet repo [00:05:38] ok - on second thoughts I think it means that we haven't been charging credit cards aggressively enough :-) [00:05:51] ha [00:06:22] but either way I think it's not going to be so urgent that you need to stay on it today [00:06:47] cool [00:07:06] but if you can stick the info you have into a phab that would be … phab [00:07:12] will do [00:12:41] Fundraising Tech Backlog: check_recurring_gc_jobs_required > 6000 - https://phabricator.wikimedia.org/T183882#3866101 (Jgreen) [00:13:28] revised analysis - we have too many people donating on a recurring basis [00:13:51] Fundraising Tech Backlog: check_recurring_gc_jobs_required > 6000 - https://phabricator.wikimedia.org/T183882#3866111 (Jgreen) Here's the query corresponding to the metric: SELECT MAX(COUNT) FROM (SELECT count(*) 'count' FROM civicrm.civicrm_contribution_recur WHERE trxn_id LIKE 'RECURRING GLOBALCOLLECT%'... [00:14:10] https://phabricator.wikimedia.org/T183882 [00:14:35] thanks [00:15:10] and icinga is ack'd [00:15:15] cool [00:15:36] that's all there is to be done now? [00:15:47] yep - I'll keep looking because I'm working [00:15:58] but at this stage I think it's an incorrect alert [00:16:16] designed to warn of unreasonably high recurring donation load [00:16:24] in case it's a miscalculation [00:16:32] ok, cool [00:16:52] I'm gonna head out, but I'm home if anything needs doing, just SMS [02:24:09] Fundraising Tech Backlog: check_recurring_gc_jobs_required > 6000 - https://phabricator.wikimedia.org/T183882#3866101 (Eileenmcnaughton) **==tldr;==** The alerts were caused by alerts based on out-of-date thresholds. We have seen a big growth in recurrings and need to increase the thresholds. **Steps requir... [02:56:52] Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Different currencies for Benevity import - https://phabricator.wikimedia.org/T182808#3835068 (Eileenmcnaughton) @LeanneS I just tested & I think this is OK on staging. Maybe it's best if w... [03:24:49] (CR) Eileen: [C: 1] "This can't hurt but I had a go at breaking that function in a unit test (below) and totally failed to find a way to break it / get this re" [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/399884 (https://phabricator.wikimedia.org/T182737) (owner: Ejegg) [04:05:41] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Fix to unsubscribe screen - emails not displaying when contacts not found - https://phabricator.wikimedia.org/T183884#3866212 (Eileenmcnaughton) [04:07:19] (PS1) Eileen: Fix for secondary emails on unsubscribe email page [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/401426 (https://phabricator.wikimedia.org/T183884) [10:38:25] Wikimedia-Fundraising-Campaigns (FY Q2 Oct-Dec 2017), Wikimedia-CentralNotice-Administration (Q4-2017): WMF Fundraising 2017-18 - Big English banners - https://phabricator.wikimedia.org/T170260#3866620 (Pcoombe) Open>Resolved [14:14:14] Fundraising Tech Backlog: check_recurring_gc_jobs_required > 6000 - https://phabricator.wikimedia.org/T183882#3867107 (Jgreen) > # I need help to find where the code is that sets this alert. We should perhaps double it? It's configured in the puppet role class for the host, which is generally where we con... [14:26:13] morning fr-tech [15:24:04] o/ [15:31:02] ejegg: cwd hey :) [15:31:29] hi AndyRussG ! [15:31:53] tell me, do people wear yellow underpants on the outside for new year's good luck in Mexico too? [15:33:06] seems like an interesting time to join the conversation... [15:33:15] hi fr-tech :) [15:33:27] ejegg: definitely not [15:33:35] hi jgleeson ! [15:33:41] jgleeson: hey :) [15:33:53] Heh, ok, guess it's an Andean thing [15:34:22] Folks had yellow everything for luck, but the underpants seemed the strangest [15:34:32] and I guess it happens in both Colombia and Peru [15:34:48] superman-like outside pants? [15:35:00] And if you're hoping for love, use red instead of yellow [15:35:01] ejegg: heh wow never heard of that. Most stores were closed yesterday, though [15:35:14] hmmm no we don't get that either [15:35:21] at least not here in Mexico City [15:35:24] jgleeson: yep, pretty much [15:35:34] AndyRussG: how about grapes? [15:35:51] ejegg: don't think so.... [15:36:05] in Colombia and Peru you also eat 12 grapes on new year's eve, and make a wish with each one [15:36:22] I read that was a tradition somewhere yeah, didn't know it was there [15:36:39] more fun than resolutions! [15:36:46] the only NYE celebrations I normally went to here were with the family of my ex [15:36:57] firecrackers were a thing [15:37:14] grapes would've been preferable tho [15:37:35] oh man, so many firecrackers [15:37:41] and for christmas too! [15:38:55] here there's a thing called "posadas", which are basically pre-Christmas parties [15:39:16] that have piñatas, which are also to be had on NYE [15:39:55] ooh, fun! Not sure if private parties have those here, I just saw what was going on in the streets [16:10:24] heh I was gonna say I hate parties, but in fact I'm just out of coffee ;p [16:15:22] oh hey, there's a bunch of stuff in the deployment backlog! [16:17:36] jgleeson: feel like doing a SmashPig IPN listener deploy? [16:18:00] sure! [16:18:07] cool. [16:18:15] it's basically the same process as with crm [16:18:31] merge master into deployment, deleting tests [16:18:44] update vendor [16:18:50] commit that update [16:19:22] then when deployment is all set in gerrit, do a fundraising_code_update [16:19:31] and an rsync_blaster [16:19:42] with project name SmashPig (note caps) [16:19:54] and watch the log payments-listener-smashpig [16:20:47] just gonna checkout smashpig, it appears I haven't used it on my new machine [16:20:55] ok, cool [16:25:00] Ah, lemme refresh my memory on the deploy order for the last Amazon change [16:25:38] jgleeson: ah, we should deploy the DonationInterface change first [16:25:40] I've merged in the changes deployment [16:25:48] on smashpig [16:26:00] OK, cool, any complications? [16:26:33] I can do the donationInterface deploy [16:26:37] actually isn't there a neat little git log command we use for the commit message? [16:26:54] no complications, just the deleted test conflict which we expect [16:27:03] in my .bash_aliases: [16:27:05] alias deploylog='git log --oneline --no-merges --reverse deployment..master | cat' [16:27:32] awesome [16:27:44] I'll add that now [16:33:36] (PS1) Ejegg: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/401536 [16:33:47] (CR) Ejegg: [C: 2] Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/401536 (owner: Ejegg) [16:34:09] jgleeson: another fun alias: [16:34:20] alias cplus2='ssh -p 29418 gerrit.wikimedia.org gerrit review --code-review +2' [16:34:31] uses the ssh interface to gerrit code review [16:34:45] (Merged) jenkins-bot: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/401536 (owner: Ejegg) [16:34:54] you use it thusly: cplus2 6ddd13bb7 [16:35:11] to give a C+2 to that sha [16:35:52] heh nice :) [16:36:45] just fixing my git config for git review [16:38:15] (PS1) Jgleeson: Merge branch 'master' into deployment [wikimedia/fundraising/SmashPig] (deployment) - https://gerrit.wikimedia.org/r/401537 [16:38:39] hmm that's not right [16:38:50] no? [16:38:51] let me see what went wrong [16:39:02] looks OK to me at first glance [16:43:30] actually, maybe it is ok. I was not expecting to only see the test deletion file change. I expected to see all the files I merged in. However it looks like I can change the 'diff against' option [16:43:48] ah yeah, that's just the gerrit convention for merges [16:44:06] it only shows the resolved conflicts [16:50:31] okay just had a look over the code to familiarise myself with it. As it's already approved in this scenario, would we normally just +2 the code in preparation for the deployment? [16:52:24] jgleeson: yeah, exactly [16:52:37] the +2 here is basically saying 'the merge looks good' [16:56:49] hmm [16:57:30] (PS1) Ejegg: Update DonationInterface submodule [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/401539 [16:57:35] ssh gerrit command sending back Permission denied (publickey). [16:57:37] (CR) Ejegg: [C: 2] Update DonationInterface submodule [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/401539 (owner: Ejegg) [16:57:39] strange [16:57:49] jgleeson oh right [16:58:01] I think I have something in my .ssh/config for that [16:58:32] (CR) Jgleeson: [C: 2] Merge branch 'master' into deployment [wikimedia/fundraising/SmashPig] (deployment) - https://gerrit.wikimedia.org/r/401537 (owner: Jgleeson) [16:58:36] Host gerrit.wikimedia.org [16:58:42] PreferredAuthentications publickey [16:58:54] IdentityFile ~/.ssh/ [16:59:17] User [16:59:33] (Merged) jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/SmashPig] (deployment) - https://gerrit.wikimedia.org/r/401537 (owner: Jgleeson) [17:00:29] great, brb 1 minute [17:02:45] (Merged) jenkins-bot: Update DonationInterface submodule [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/401539 (owner: Ejegg) [17:05:53] !log updated payments-wiki from e91db27108 to 40145892e7 [17:06:03] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [17:09:33] good mornfternoon dstrine [17:09:45] lol hi ejegg [17:09:45] Fundraising-Backlog, FR-Ingenico: Ingenico audit wobble? 12/20 transactions not in Civi - https://phabricator.wikimedia.org/T183934#3867839 (MBeat33) [17:09:50] what time is it for you? [17:10:07] just past noon [17:10:14] ok cool [17:14:30] I'm guessing everything went ok. Looks like we had a solid NYE according to the dash [17:14:39] yeah! [17:14:47] I don't see any bugs in analysis that look particularly troubling [17:15:11] eileen and Jeff_Green tackled a spurious warning thing (she sent an email with deets) [17:15:14] ejegg, is adding eval `ssh-agent` to .xprofile what you use to avoid having to run it for each window? [17:15:46] jgleeson: I never had to do anything like that, I guess the default profile in debian already has something like that [17:15:48] ejegg: yeah I saw. [17:15:49] lemme see [17:16:33] the last thing that might continue to bug us is the larger than normal unintentional recurring charges [17:17:12] I wonder if we need to do anything in the morning or February 1st? [17:17:34] or at least know that we'll have a high level of transactions [17:17:36] i don't think so [17:17:39] ok [17:17:57] jeff changed the thresholds, which should be good for a while to come [17:19:32] jgleeson: ah, in /etc/X11/Xsession.options I see this: [17:19:40] use-ssh-agent [17:20:13] cool. got it working now, ubuntu uses .profile [17:20:22] rockin [17:20:41] I deployed the DonationInterface bit of the Amazon change [17:20:49] seems to have not broken normal flow [17:21:20] we'll have to wait for another TransactionTimedOut auth to see that it's actually doing the expected in that error condition [17:25:51] what server does smashpig sit on? [17:26:01] thulium [17:26:25] i almost never log on there - i just read the log from frlog1001 [17:35:37] should I only be deploying from frpm1001 ? [17:36:17] sorry, I've assumed I need to ssh to the server smashpig is on to deploy the update [17:36:55] jgleeson: yeah all deploying should happen from frpm1001 [17:37:15] thanks [17:37:55] jgleeson: you can check out the code for fundraising_code_update and rsync_blaster if you want [17:38:10] there are helpful options to both that should explain the approach [17:45:44] ejegg, should I reduce the donations being processed per run as I have done for the crm update? [17:46:28] jgleeson: nope, no need for that here [17:46:44] the IPN listener processes each message as it comes in [17:47:40] so there's no real control from our side besides going to the processor consoles and turning off messages [17:47:45] but we almost never do that [17:48:06] jgleeson: oh shoot, do we need a vendor update? [17:48:26] or was the only change to composer.lock for the phpunit version? [17:50:16] jgleeson: did you see the question about vendor? [17:51:04] no, I was just about to ask a question about that myself [17:51:55] once I update the smashpig vendor lib, do we need to update projects also which have smashpig as a dependency? [17:54:38] would it help if we did this over vc? [17:54:52] is that doable for you? [17:57:03] jgleeson: lemme see [17:57:25] jgleeson: so, we don't have to worry about the other projects right now [17:57:50] the ones that depend on SmashPig do it by pulling it in via composer [17:58:15] so when we update the SmashPig version in those projects it'll also update any dependencies [17:59:07] I wasn't aware that SmashPig was both a "running" project and a dependency library [17:59:15] so I was a little confused [17:59:25] yeah, it's a bit funny [17:59:52] when we 'deploy' SmashPig, that just affects the standalone checkout of it [17:59:55] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: pull numbers on manual merges - https://phabricator.wikimedia.org/T183943#3868069 (DStrine) [18:00:04] where it works as a notification listener [18:01:44] ok, so now I think I now need to composer install on the checkout of smashpig on frpm1001 to pull in any changes from composer.lock? [18:02:02] jgleeson: ah, no, that's handled in gerrit too [18:02:13] so in your local checkout, on the deployment branch [18:02:43] first make sure the vendor submodule is sane [18:03:07] if git status says there are changes, you can just nuke the dir and git submodule update --init [18:03:30] then from the SmashPig dir, composer install --no-dev [18:03:42] cd into the vendor dir and commit all the changes [18:03:51] put that up for review and rubber-stamp it [18:04:12] ahh [18:04:12] ok [18:04:26] then cd back into the SmashPig dir, git add vendor, git commit, git review, c+2 [18:04:42] installing [18:05:47] hi XenoRyet ! [18:05:59] Greetings [18:11:21] I don't appear to have any changes in vendor [18:11:37] I don't know if ya'll were going crazy or not, but great job on another successful (afaict) fundraising end of year. Thank you. [18:12:05] post the composer install, on-top of the latest checkout of the smashpig vendor submodule [18:12:07] thanks greg-g ! [18:12:29] jgleeson: oh, so maybe there really was just the phpunit change? [18:12:56] greg-g: this year was pretty darn sane from the tech side, fortunately! [18:13:35] got some real payoff from the last couple years of attacking tech debt [18:13:52] \o/ [18:13:59] :) [18:16:40] the last update was nov 14th [18:16:50] and according to gerrit, the only change is phpunit [18:17:26] jgleeson: ok, great, no need for the submodule dance [18:17:48] cool! [18:18:41] okay so now I can proceed to the update, blast and log? [18:19:00] actually, I'll tail the log first [18:20:54] yeah, tailing the log is good :) [18:30:12] !log Updating Smashpig from 45aa62650c to ab7802d5b3 [18:30:22] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [18:30:43] log looks normal [18:31:01] payments-listener-smashpig, that is [18:36:11] cool, cool [19:03:12] (CR) Ejegg: [C: 2] Fix for secondary emails on unsubscribe email page [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/401426 (https://phabricator.wikimedia.org/T183884) (owner: Eileen) [19:13:38] (Merged) jenkins-bot: Fix for secondary emails on unsubscribe email page [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/401426 (https://phabricator.wikimedia.org/T183884) (owner: Eileen) [19:23:26] Fundraising-Backlog: Remove ccogdill from Large Donation Bot emails - https://phabricator.wikimedia.org/T183977#3868778 (CCogdill_WMF) [19:23:41] Fundraising-Backlog: Remove ccogdill from Large Donation Bot emails - https://phabricator.wikimedia.org/T183977#3868788 (CCogdill_WMF) p:Triage>Normal [19:25:33] Fundraising-Backlog: Make phab tasks for Kafkatee changes - https://phabricator.wikimedia.org/T183978#3868789 (DStrine) [19:26:14] Fundraising-Backlog: Fill out SAQ-a form for 2018 - https://phabricator.wikimedia.org/T183979#3868798 (DStrine) [19:26:30] Fundraising-Backlog: Fill out SAQ-A form for 2018 - https://phabricator.wikimedia.org/T183979#3868808 (DStrine) [19:30:50] woohoo! centralnotice analytics lib is working, can now print nice graphs in jupyter :D [20:16:52] looks like spamazon switched ips again [20:16:58] :-) [20:17:16] cwd - can you tell me where I would see the puppet code with the gc_recurring line in it? [20:18:17] eileen: sure one sec [20:19:18] eileen: modules/role/manifests/fundraising_database.pp [20:19:33] heheh spamazon [20:26:57] cwd - is it this repo ? https://gerrit.wikimedia.org/r/operations/puppet [20:33:42] AndyRussG: meeting? [20:54:50] Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Patch-For-Review: set dash default to 51 million - https://phabricator.wikimedia.org/T183157#3869226 (Eileenmcnaughton) a:Ejegg [20:54:57] Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Patch-For-Review: set dash default to 51 million - https://phabricator.wikimedia.org/T183157#3845409 (Eileenmcnaughton) Open>Resolved [20:55:17] Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Civimail bounce processing failing - https://phabricator.wikimedia.org/T181934#3869229 (Eileenmcnaughton) Open>Resolved [20:55:50] Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Fr-CiviCRM-dedupe-FY2017/18: Let dedupe run on orgs - https://phabricator.wikimedia.org/T181089#3869233 (Eileenmcnaughton) Ok meeting discussed & change noticed - setting to resolved [20:55:58] Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Fr-CiviCRM-dedupe-FY2017/18: Let dedupe run on orgs - https://phabricator.wikimedia.org/T181089#3869234 (Eileenmcnaughton) Open>Resolved [20:56:38] Fundraising Sprint Vaporwerewolf, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: New Civi Import - https://phabricator.wikimedia.org/T172423#3869237 (Eileenmcnaughton) Will put this to resolved now & if new issues come up when it's... [20:56:43] Fundraising Sprint Vaporwerewolf, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: New Civi Import - https://phabricator.wikimedia.org/T172423#3869238 (Eileenmcnaughton) Open>Resolved [21:18:46] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog: Make phab tasks for Kafkatee changes - https://phabricator.wikimedia.org/T183978#3869340 (DStrine) [21:18:48] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog: Remove ccogdill from Large Donation Bot emails - https://phabricator.wikimedia.org/T183977#3869341 (DStrine) [21:18:50] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: pull numbers on manual merges - https://phabricator.wikimedia.org/T183943#3869342 (DStrine) [21:18:52] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, FR-Ingenico: Ingenico audit wobble? 12/20 transactions not in Civi - https://phabricator.wikimedia.org/T183934#3869343 (DStrine) [21:18:54] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Fix to unsubscribe screen - emails not displaying when contacts not found - https://phabricator.wikimedia.org/T183884#3869344 (DStrine) [21:18:56] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, FR-Amazon, and 3 others: Amazon errors showing up as [Object object] - https://phabricator.wikimedia.org/T183477#3869345 (DStrine) [21:18:58] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog: Document severity of the various forms of outage - https://phabricator.wikimedia.org/T183293#3869348 (DStrine) [21:19:00] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog: Add formatting capabilities (?) to Details field of an Activity - https://phabricator.wikimedia.org/T183389#3869347 (DStrine) [21:19:02] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, FR-Ingenico, Fr-Ingenico-integration_2017-18: reassess tasks leading up to internal test in ingenico reintegration - https://phabricator.wikimedia.org/T183290#3869349 (DStrine) [21:19:05] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, FR-Amazon, FR-Smashpig, and 3 others: Deal better with Amazon auth/capture timing out - https://phabricator.wikimedia.org/T183429#3869346 (DStrine) [21:19:07] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog: Bugfix: Prometheus serving old data in the absence of new data, to Grafana - https://phabricator.wikimedia.org/T183275#3869350 (DStrine) [21:19:09] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, FR-Ingenico: Close all old and unresolved GC orders - https://phabricator.wikimedia.org/T183190#3869351 (DStrine) [21:19:11] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Patch-For-Review, Unplanned-Sprint-Work: Failing job AntifraudQueueConsumer.php on risk_score format - https://phabricator.wikimedia.org/T183102#3869353 (DStrine) [21:19:13] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Patch-For-Review: Bugfix: remove duplicate Prometheus metric keys output from DonationStats .prom file output - https://phabricator.wikimedia.org/T183153#3869352 (DStrine) [21:19:15] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Different currencies for Benevity import - https://phabricator.wikimedia.org/T182808#3869354 (DStrine) [21:19:18] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, MediaWiki-extensions-DonationInterface, Patch-For-Review: Fatal error in Amount formatting - https://phabricator.wikimedia.org/T182737#3869355 (DStrine) [21:19:21] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, FR-Amazon, and 3 others: Amazon gateway - crash on getCaptureDetails failiure? - https://phabricator.wikimedia.org/T182735#3869356 (DStrine) [21:19:23] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog: Check alpha channel docs for "show stopper" issues - https://phabricator.wikimedia.org/T182032#3869360 (DStrine) [21:19:26] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: make a wiki page for CN status codes - https://phabricator.wikimedia.org/T181652#3869363 (DStrine) [21:19:29] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Stat1005 BH data issue? - https://phabricator.wikimedia.org/T181811#3869362 (DStrine) [21:19:32] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, and 3 others: Amazon pay: cross-domain issue in mobile safari - https://phabricator.wikimedia.org/T180845#3869365 (DStrine) [21:19:34] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, Patch-For-Review: thank you letter update - https://phabricator.wikimedia.org/T181093#3869364 (DStrine) [21:19:36] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Uptight Piano, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Winter Wanderland, Fundraising-Backlog: Track rate of new donations added to civicrm by the donations queue cons... - https://phabricator.wikimedia.org/T179214#3869368 [21:19:38] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Winter Wanderland, Fundraising-Backlog: Track fundraising failmail volume in prometheus - https://phabricator.wikimedia.org/T179704#3869367 (DStrine) [21:19:40] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Uptight Piano, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Winter Wanderland, Fundraising-Backlog: Prometheus: Add seconds diff metric report [donation message enqueued =... - https://phabricator.wikimedia.org/T179173#3869369 [21:19:43] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Winter Wanderland, Fundraising-Backlog, and 5 others: Amazon code should allow specifiying proxy parameters in configuration - https://phabricator.wikimedia.org/T180168#3869366 (DStrine) [21:19:46] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Uptight Piano, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Winter Wanderland, and 2 others: CentralNotice: Consolidate typical analytics queries (for example, for impression r... - https://phabricator.wikimedia.org/T178930#3869370 [21:19:48] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Uptight Piano, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Winter Wanderland, and 5 others: Adyen jobs should retry at least once on connect failure - https://phabricator.wikimedia.org/T177893#3869371 (DStrine) [21:21:58] the irony [21:21:59] * wikibugs has quit (Excess Flood) [21:22:01] :) [21:32:17] :-) [21:34:00] dstrine are you still doing the columns thing to the board? [21:36:38] oh oops [21:36:40] one second [21:37:14] done [21:37:20] thx [21:39:23] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog: Remove ccogdill from Large Donation Bot emails - https://phabricator.wikimedia.org/T183977#3868778 (Eileenmcnaughton) a:Eileenmcnaughton [21:39:32] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: pull numbers on manual merges - https://phabricator.wikimedia.org/T183943#3868069 (Eileenmcnaughton) Open>Resolved a:Eileenmcnaughton [21:39:48] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: pull numbers on manual merges - https://phabricator.wikimedia.org/T183943#3868069 (Eileenmcnaughton) Resolved>Open [21:41:15] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog: Add formatting capabilities (?) to Details field of an Activity - https://phabricator.wikimedia.org/T183389#3851761 (Eileenmcnaughton) a:Eileenmcnaughton [21:55:28] just a note that I'm doing a slow query on staging in case of alerts [21:57:35] signing off for tonight [21:57:40] have a good day all [21:57:43] bye for nwoi [21:57:47] bye for now* [21:57:53] seeya jgleeson [21:58:07] ok I got a pony-shaped earth on phab [21:58:16] Hope that is to everyone's liking [21:59:45] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog: Remove ccogdill from Large Donation Bot emails - https://phabricator.wikimedia.org/T183977#3869732 (Eileenmcnaughton) The url for this is admin/config/large_donation/configure I've removed you from the two levels you were on - $500+ & $9... [22:01:28] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog: Remove ccogdill from Large Donation Bot emails - https://phabricator.wikimedia.org/T183977#3869743 (CCogdill_WMF) Thanks! [22:09:23] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog: Remove ccogdill from Large Donation Bot emails - https://phabricator.wikimedia.org/T183977#3869766 (Eileenmcnaughton) great - as long as you don't get any more over the next few days we can close [23:30:48] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: pull numbers on manual merges - https://phabricator.wikimedia.org/T183943#3870005 (Eileenmcnaughton) I created a temp table to query... ``` CREATE TABLE merge_activities ( KEY `year` (`year`), K... [23:37:44] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: pull numbers on manual merges - https://phabricator.wikimedia.org/T183943#3870028 (Eileenmcnaughton) With that table in place I can get ``` SELECT year, month, display_name, count(*) as count ->... [23:38:34] Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: pull numbers on manual merges - https://phabricator.wikimedia.org/T183943#3870029 (Eileenmcnaughton) Note the contacts merged by me have generally been done using the batch merge jobs through the UI (the... [23:50:05] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Figure out a way to increase gateway time outs on import jobs - https://phabricator.wikimedia.org/T181688#3870071 (Eileenmcnaughton) Leanne just hit it again - I found this https://stackoverflow.com/questions/18740635/nginx-upstream-timed-out-110-conne... [23:51:44] dstrine: nice pony! [23:51:55] :) [23:52:24] I'm trying to think what is a good earthly pony sound, but nothing comes to mind [23:53:29] eileen: thanks for the quick turn around :) T183943 [23:53:29] T183943: pull numbers on manual merges - https://phabricator.wikimedia.org/T183943 [23:54:28] I still don't know how to use temp tables. I'm supposed to be able to. I might play with your query to figure that out. [23:54:42] dstrine: I can up the points of T178930 from 2 to 4, right? [23:54:42] T178930: CentralNotice: Consolidate typical analytics queries (for example, for impression rates) into a library - https://phabricator.wikimedia.org/T178930 [23:54:42] dstrine: let me know if there is more breakdown I can do for you - I figured you would want it fairly raw [23:55:10] I created that table as a 'normal' table, not a temp - so it's still on staging [23:55:22] I think this is great. if I'm able to rerun this on my own that'll be all I need [23:55:27] cool [23:55:29] oh ok [23:55:47] I was surprised by how low the manual merge numbers actually are tbh [23:56:31] although they don't necessarily feel low! [23:56:51] where you see NULL that is an automated one [23:59:31] I note Rosie did a tonne in Jan last year - but I think this Jan MG are already pretty much up to date