[00:39:51] Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Patch-For-Review: Ingenico transactions stuck at 600 without fraud scores - https://phabricator.wikimedia.org/T239769 (Ejegg) OK, most of the ones from the 5th and 6th which did not involve the user clicking... [00:42:02] Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Patch-For-Review: Ingenico transactions stuck at 600 without fraud scores - https://phabricator.wikimedia.org/T239769 (Ejegg) @EMartin are you still seeing a lot of these? Of the three causes I've seen, two d... [00:42:49] Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Patch-For-Review: Ingenico transactions stuck at 600 without fraud scores - https://phabricator.wikimedia.org/T239769 (EMartin) Elliott, I was thinking about this....I am actively settling some of these orpha... [00:44:07] Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Patch-For-Review: Ingenico transactions stuck at 600 without fraud scores - https://phabricator.wikimedia.org/T239769 (EMartin) No, I only saw 3 orphans today out of 68 which I notated in the task. As the vo... [02:19:54] (CR) Cstone: [C: +2] Quit redundantly setting SQL text [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/554953 (owner: Ejegg) [02:20:29] (Merged) jenkins-bot: Quit redundantly setting SQL text [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/554953 (owner: Ejegg) [02:25:39] (CR) Cstone: [C: +2] "Looks good, simulated the timeout and it retried." [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/554990 (owner: Ejegg) [02:26:29] (CR) Cstone: [C: +2] getChartData takes a success callback [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/555536 (owner: Ejegg) [02:27:16] (Merged) jenkins-bot: getChartData takes a success callback [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/555536 (owner: Ejegg) [02:27:18] (Merged) jenkins-bot: Retry on gateway timeout [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/554990 (owner: Ejegg) [02:52:24] (CR) Cstone: [C: +2] "Worked well when restarting the server." [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/555593 (owner: Ejegg) [02:52:59] (Merged) jenkins-bot: Redirect to start on session loss in data query [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/555593 (owner: Ejegg) [02:58:04] (CR) Cstone: [C: +2] Convert donation-age to use getChartData [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/555599 (owner: Ejegg) [02:58:38] (Merged) jenkins-bot: Convert donation-age to use getChartData [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/555599 (owner: Ejegg) [02:59:57] (CR) Cstone: [C: +2] Convert totals-earned-chart to use getChartData [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/555602 (owner: Ejegg) [03:00:30] (Merged) jenkins-bot: Convert totals-earned-chart to use getChartData [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/555602 (owner: Ejegg) [03:02:58] (CR) Cstone: [C: +2] Cancel bg query loop when donation-age cleans up [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556434 (owner: Ejegg) [03:03:32] (Merged) jenkins-bot: Cancel bg query loop when donation-age cleans up [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556434 (owner: Ejegg) [03:08:31] thanks for all that CR cstone! [03:08:38] I'll just get those out now [03:08:54] np it worked well locally [03:10:25] Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Patch-For-Review: Recurring payment merchant reference ids are truncated when over .9 - https://phabricator.wikimedia.org/T240272 (Cstone) The fix to the affected recurring donations has been deployed. @MBeat33 in case you get any more e... [03:11:16] Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Patch-For-Review: Ingenico transactions stuck at 600 without fraud scores - https://phabricator.wikimedia.org/T239769 (Ejegg) > Am I clouding the picture for you at all while you try to diagnose this? Thanks... [03:12:07] cstone if you feel like refactoring the heck out of dash, please feel free! [03:12:48] the worst of it is the mix between bootstrap (for dismissing modals, and maybe some other click handling), knockout, and jquery DOM manipulation [03:12:49] hah okay [03:13:04] so we probably need to add some angular in there [03:13:22] :P [03:14:03] all the libraries [03:14:39] im gona head out, have a good night! [03:14:43] you too! [03:16:17] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/556514 [03:16:40] (CR) Ejegg: [C: +2] Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/556514 (owner: Ejegg) [03:17:15] (Merged) jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/556514 (owner: Ejegg) [03:25:43] !log updated fundraising internal dashboard from 3917f7d9dc to c1ded3c473 [03:25:48] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [03:28:14] Fundraising Dash, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog: dash widgets making extraneous requests - https://phabricator.wikimedia.org/T181590 (Ejegg) p:Triage→Low a:Ejegg [03:28:44] Fundraising Dash, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog: dash widgets making extraneous requests - https://phabricator.wikimedia.org/T181590 (Ejegg) Oh hey, https://gerrit.wikimedia.org/r/556434 should have fixed the second of these issues. [03:31:31] Fundraising Dash: Confusion around widget saving - https://phabricator.wikimedia.org/T93971 (Ejegg) still confusing, almost 5 years later! [03:32:57] Fundraising Dash, § Fundraising Sprint Abba, § Fundraising Sprint Beastie Boys, Patch-For-Review: Dash: Allow settings/filters to be saved for each user - https://phabricator.wikimedia.org/T86095 (Ejegg) Open→Resolved a:Ejegg >>! In T86095#1258767, @atgo wrote: > @ejegg @pizzzacat is... [03:34:04] aww, look at all those old 5-digit dash tasks [03:34:49] ...and look how many are still legitimately unresolved :( [03:36:48] Fundraising Dash: Handle time ranges for chart data client-side - https://phabricator.wikimedia.org/T86841 (Ejegg) Open→Resolved a:Ejegg This seems done [03:37:32] (Abandoned) Ejegg: Center-align card radio buttons on mobile [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/453316 (owner: Ejegg) [03:57:01] Fundraising-Backlog, FR-Ingenico, MediaWiki-extensions-DonationInterface, Recurring-Donations: Revisit monthlyConvert setup API calls - https://phabricator.wikimedia.org/T240523 (Ejegg) [04:23:10] Fundraising Dash, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog: dash widgets making extraneous requests - https://phabricator.wikimedia.org/T181590 (Ejegg) Also, the X-by-Y one seems to be making a bogus request on first load to /data/x-by-y?group=undefined [04:29:27] Fundraising Dash, Fundraising-Backlog: /data should return non-200 status when SQL or filter error exists - https://phabricator.wikimedia.org/T240524 (Ejegg) [07:28:38] !log process-control config revision is ad8bec977d [07:28:43] eileen: Failed to log message to wiki. Somebody should check the error logs. [08:40:27] !log process-control config revision is 4d25b656e2 [08:40:32] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [11:12:12] PROBLEM - check_redis on frqueue1001 is CRITICAL: CRITICAL: recurring is 2098 2000 - REDIS 3.2.6 on 127.0.0.1:6379 has 1 databases (db0) with 10 keys, up 146 days 9 hours - memory use is 3.39M (peak 20.40M, 0.08% of max, fragmentation 2.05%), connected_slaves is 2, donations is 210, jobs is 0, jobs-adyen is 0, jobs-paypal is 1, payments-antifraud is 0, payments-init is 36, pending is 2, refund is 0, unsubscribe is 8 [11:17:12] PROBLEM - check_redis on frqueue1001 is CRITICAL: CRITICAL: recurring is 2286 2000 - REDIS 3.2.6 on 127.0.0.1:6379 has 1 databases (db0) with 9 keys, up 146 days 9 hours - memory use is 3.33M (peak 20.40M, 0.08% of max, fragmentation 2.01%), connected_slaves is 2, donations is 156, jobs is 0, jobs-adyen is 0, jobs-paypal is 2, payments-antifraud is 0, payments-init is 0, pending is 3, refund is 0, unsubscribe is 12 [11:22:12] PROBLEM - check_redis on frqueue1001 is CRITICAL: CRITICAL: recurring is 2196 2000 - REDIS 3.2.6 on 127.0.0.1:6379 has 1 databases (db0) with 11 keys, up 146 days 9 hours - memory use is 3.41M (peak 20.40M, 0.09% of max, fragmentation 2.05%), connected_slaves is 2, donations is 103, jobs is 0, jobs-adyen is 0, jobs-paypal is 1, payments-antifraud is 100, payments-init is 44, pending is 1, refund is 0, unsubscribe is 16 [11:27:12] PROBLEM - check_redis on frqueue1001 is CRITICAL: CRITICAL: recurring is 2380 2000 - REDIS 3.2.6 on 127.0.0.1:6379 has 1 databases (db0) with 11 keys, up 146 days 9 hours - memory use is 3.65M (peak 20.40M, 0.08% of max, fragmentation 1.88%), connected_slaves is 2, donations is 212, jobs is 0, jobs-adyen is 0, jobs-paypal is 1, payments-antifraud is 21, payments-init is 1, pending is 2, refund is 0, unsubscribe is 24 [11:28:36] ACKNOWLEDGEMENT - check_redis on frqueue1001 is CRITICAL: CRITICAL: recurring is 2380 2000 - REDIS 3.2.6 on 127.0.0.1:6379 has 1 databases (db0) with 11 keys, up 146 days 9 hours - memory use is 3.65M (peak 20.40M, 0.08% of max, fragmentation 1.88%), connected_slaves is 2, donations is 212, jobs is 0, jobs-adyen is 0, jobs-paypal is 1, payments-antifraud is 21, payments-init is 1, pending is 2, refund is 0, unsubscribe is 24 Jef [13:42:12] RECOVERY - check_redis on frqueue1001 is OK: OK: REDIS 3.2.6 on 127.0.0.1:6379 has 1 databases (db0) with 11 keys, up 146 days 12 hours - memory use is 3.31M (peak 20.40M, 0.08% of max, fragmentation 2.04%), connected_slaves is 2, donations is 278, jobs is 0, jobs-adyen is 1, jobs-paypal is 0, payments-antifraud is 42, payments-init is 54, pending is 0, recurring is 1458, refund is 1, unsubscribe is 56 [15:17:08] Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Patch-For-Review: Recurring payment merchant reference ids are truncated when over .9 - https://phabricator.wikimedia.org/T240272 (MBeat33) @Cstone thank you for the fix and the metrics [15:33:57] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Recurring-Donations: Should we send recurring payment notifications to the donations queue - https://phabricator.wikimedia.org/T240581 (Ejegg) [16:35:05] (PS1) Ejegg: Add filter for 'Is Recurring' [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556727 [16:35:28] fr-tech ^^^ will give us the ability to make dash graphs specific to recurring contributions [16:35:34] I'd love to put it up today if possible [16:36:02] and it's actually really simple to add a filter! [16:36:09] Just 9 lines of config in one file [17:30:32] (PS1) Ejegg: Send error codes in data route [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556745 (https://phabricator.wikimedia.org/T240524) [17:35:18] Fundraising Dash, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Patch-For-Review: /data should return non-200 status when SQL or filter error exists - https://phabricator.wikimedia.org/T240524 (Ejegg) p:Triage→Low a:Ejegg [17:51:13] (PS3) Ejegg: EOY Summary: use autoconverted html for plaintext [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556433 (https://phabricator.wikimedia.org/T240298) [17:57:59] Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Recurring-Donations: Should we send recurring payment notifications to the donations queue - https://phabricator.wikimedia.org/T240581 (DStrine) [18:04:24] (CR) XenoRyet: [C: +2] "Looks clean, does what it says on the tin." [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556727 (owner: Ejegg) [18:04:32] Fundraising-Backlog: We need a way to test our payments forms without submitting real donations - https://phabricator.wikimedia.org/T240219 (DStrine) I think we have addressed @jbolorinos-ctr 's concerns for the moment. @spatton there are a few options that could help testing. easier, short term: 1.) you... [18:05:09] (Merged) jenkins-bot: Add filter for 'Is Recurring' [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556727 (owner: Ejegg) [18:07:53] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/556752 [18:09:26] (CR) Ejegg: [C: +2] Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/556752 (owner: Ejegg) [18:10:07] (Merged) jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/556752 (owner: Ejegg) [18:13:49] !log updated fundraising internal dashboard from c1ded3c473 to cc6d5cdde7 [18:13:54] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [18:19:01] shoot, using that is recurring in a group by is misleading [18:19:05] let's see [18:19:31] I think we can apply the labels when we get the data back [18:41:07] Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Patch-For-Review: Ingenico transactions stuck at 600 without fraud scores - https://phabricator.wikimedia.org/T239769 (EMartin) current examples are far fewer as of 12.10 volume which was reduced only 3 out o... [19:19:11] oh huh, there's another issue with grouping by contribution status [19:19:16] i'll fix that while I'm at it [19:19:36] ejegg: dwisehaupt the slowness on the benevity import is actually incremental - we will need to reload triggers on that table & exclude microsoft & google [19:19:51] oh fun! [19:20:01] well, just that table shouldn't take too long, right? [19:20:04] it should only require a brief q stop but will need Jeff or Dallas to do it [19:20:13] we just need to make sure nothing writes to it meanwhile [19:20:19] yeah, a q stop [19:20:26] TBH a full trigger reload only takes milliseconds [19:20:32] but just the one table feels safer [19:29:26] (PS1) Eileen: Exclude major matching gifts donors from totals calc [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556775 (https://phabricator.wikimedia.org/T236977) [19:40:32] (PS1) Umherirrender: Remove pre RecentChange::getQueryInfo code [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/556781 [19:44:15] (PS1) Ejegg: Add display values for groupings [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556784 [19:44:30] ejegg: that should do it ^^ - I'm still testing locally but we would deploy when reviewed because it only allows me to generate the new trigger [19:44:47] eileen: did a little digging to further my learning, and i think disabling the queues involves disabling all (of some) of the jobs in process-control. does that sound correct? [19:45:01] dwisehaupt: yep [19:45:06] (CR) jerkins-bot: [V: -1] Add display values for groupings [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556784 (owner: Ejegg) [19:45:20] we have a bash script in the process control dir that generates a commit to disable them all [19:45:33] cool. that all happens in the localsettings repo, so that could be done without jeff or me. [19:45:45] at least that's my understanding. [19:45:56] eileen: I guess we probably don't have any individual contacts with nickname 'Google' or 'Microsoft' ? [19:46:13] fr-tech I'm going to run some errands. I'll be out for a slightly longer lunch today [19:46:13] dwisehaupt: for sure - the thing we need one of you for is just to reload the trigger [19:46:32] ejegg: that crossed my mind but I figured I'd pick it up when committing the trigger if so [19:47:03] ah, ok. [19:47:15] i misread that, sure we can do the reload. [19:50:13] eileen: heh, ok [19:51:31] Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog: investigate unintended recurring from December 2019 - https://phabricator.wikimedia.org/T240242 (XenoRyet) Ok, I've found the issue with my queries and fixed 'em up. I am seeing the monthly convert cancels now,... [19:53:27] ejegg: ok my local tests on it are good - I forgot I had to manually load the sql or set the setting so it loads automatically [19:53:42] (PS2) Ejegg: Add display values for groupings [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556784 [19:54:26] (CR) Jforrester: [C: +2] Remove pre RecentChange::getQueryInfo code [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/556781 (owner: Umherirrender) [19:55:05] eileen: sure, the update looks straightforward [19:55:14] (PS2) Ejegg: Exclude major matching gifts donors from totals calc [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556775 (https://phabricator.wikimedia.org/T236977) (owner: Eileen) [19:55:19] (CR) Ejegg: [C: +2] Exclude major matching gifts donors from totals calc [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556775 (https://phabricator.wikimedia.org/T236977) (owner: Eileen) [19:58:19] (Merged) jenkins-bot: Remove pre RecentChange::getQueryInfo code [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/556781 (owner: Umherirrender) [19:58:33] fr-tech here's a follow-up for the dash recurring filter: https://gerrit.wikimedia.org/r/556784 [19:58:44] looking [19:59:07] there's a variable rename in there, so the diff is a bit noisy [19:59:19] 10-4 [19:59:27] but it fixes what was a completely broken group-by on contribution status [19:59:36] (PS1) Eileen: Follow up fix on https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/civicrm/+/556335/ [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/556791 [19:59:42] and gives nice human labels to the IsRecurring group by [20:00:09] ejegg: also this https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/civicrm/+/556791/ - error I made picked up by upstream reviewer [20:01:09] (CR) Ejegg: [C: +2] "D'oh! Sorry I didn't catch that the first time around. Nice we've got backup reviewers on this core stuff." [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/556791 (owner: Eileen) [20:01:40] (CR) Eileen: "Well I can't feel bad about getting it wrong if you missed it :-)" [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/556791 (owner: Eileen) [20:01:44] (Merged) jenkins-bot: Exclude major matching gifts donors from totals calc [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556775 (https://phabricator.wikimedia.org/T236977) (owner: Eileen) [20:02:04] man, now I really want to be able to rename my dash boards [20:03:37] lessee what that would take [20:05:08] well, /board/:id route already accepts PUT to save [20:05:14] guess it's just UI missing? [20:06:01] (CR) XenoRyet: [C: +2] Add display values for groupings [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556784 (owner: Ejegg) [20:06:35] (Merged) jenkins-bot: Add display values for groupings [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556784 (owner: Ejegg) [20:06:57] thanks XenoRyet [20:08:38] (PS1) Eileen: CiviCRM Submodule commit [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556792 [20:08:58] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/556793 [20:10:17] (CR) Eileen: [C: +2] CiviCRM Submodule commit [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556792 (owner: Eileen) [20:10:46] (CR) Ejegg: [C: +2] Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/556793 (owner: Ejegg) [20:11:36] (Merged) jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/556793 (owner: Ejegg) [20:14:38] !log updated fundraising internal dashboard from cc6d5cdde7 to 1105bf1796 [20:14:42] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [20:16:30] (Merged) jenkins-bot: CiviCRM Submodule commit [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556792 (owner: Eileen) [20:19:24] (PS1) Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/556799 [20:19:32] (CR) Eileen: [C: +2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/556799 (owner: Eileen) [20:22:25] !log civicrm revision changed from 8c8aa0e6d3 to 2043c27a0e, config revision is 4d25b656e2 [20:22:29] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [20:24:17] ooh, weird, looking at the recurring donations by day graph I see ingenico, paypal_ec, and 'undefined' [20:24:38] something's still not quite right, dang it [20:25:32] hmm, coming back as 'null' [20:25:40] let's see what the SQL generated is [20:26:20] ahh, dang, it's using the payments_initial table to get the gateway [20:27:05] so that graph is way less useful than it could be :( [20:28:04] lemme see if I can get it using wmf_contribution_extra for the gateway name [20:29:41] fundraising-tech-ops: refactor drush install - https://phabricator.wikimedia.org/T240499 (Jgreen) >>! In T240499#5733535, @Eileenmcnaughton wrote: > Composer? Yeah, that looks like the preferred approach these days. [20:31:11] ok, adding new joins is a teeny bit trickier than just adding a column, but not so bad [20:34:08] man, it's using payments-initial for currency and amount too [20:38:28] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog: FRUEC: Detailed comparison of events in old and new log files for banner impres... - https://phabricator.wikimedia.org/T236834 [21:03:47] ooh, dash is conflating USD amount and original amount. That's no good [21:04:42] alright, let's try to untangle that [21:26:48] (PS1) Eileen: Updated triggers. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556816 (https://phabricator.wikimedia.org/T236977) [21:27:17] ejegg: I just put up the triggers update - how do you think we should schedule running it dwisehaupt [21:27:45] let's see, how are we for traffic & ty delay right now? [21:27:47] (PS1) Zoranzoki21: Move sql files into the sql/ directory [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556817 [21:28:09] looks like we're OK to turn things off for 5 min or so without anyone getting worried [21:28:49] (CR) jerkins-bot: [V: -1] Move sql files into the sql/ directory [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556817 (owner: Zoranzoki21) [21:29:43] eileen: ejegg: let me do a little prep work of capturing the existing triggers and i'll be ready. [21:30:11] i am clear until ~4pm PST. [21:31:00] (PS2) Zoranzoki21: Move sql files into the sql/ directory [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556817 [21:31:32] (CR) jerkins-bot: [V: -1] Move sql files into the sql/ directory [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556817 (owner: Zoranzoki21) [21:32:11] (PS3) Zoranzoki21: Move sql files into the sql/ directory [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556817 [21:32:36] ok that sounds good - well if you double check https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/+/556816/ ejegg then I'll deploy it & then just wait for dwisehaupt to be ready [21:33:19] (PS1) Ejegg: Add filters from wmf_contribution_extra [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556819 [21:33:51] (CR) jerkins-bot: [V: -1] Add filters from wmf_contribution_extra [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556819 (owner: Ejegg) [21:37:28] eileen: that's a pretty substantial change to the contribution_triggers file [21:38:01] ejegg: because it was out of date [21:38:10] the other one is more recent [21:38:34] they wind up the same - but I thought the contribution_triggers file had the better name [21:47:37] ok, cool [21:48:27] (PS2) Ejegg: Add filters from wmf_contribution_extra [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/556819 [21:49:43] (CR) Ejegg: [C: +2] "Contact IDs check out, syntax looks good." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556816 (https://phabricator.wikimedia.org/T236977) (owner: Eileen) [21:50:48] Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Recurring-Donations: Should we send recurring payment notifications to the donations queue - https://phabricator.wikimedia.org/T240581 (Ejegg) p:Triage→Normal a:Ejegg [21:56:02] (Merged) jenkins-bot: Updated triggers. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/556816 (https://phabricator.wikimedia.org/T236977) (owner: Eileen) [22:02:09] (PS1) Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/556826 [22:11:54] (CR) Eileen: [C: +2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/556826 (owner: Eileen) [22:25:13] (PS1) Ejegg: WIP send recurring payments to donations queue [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/556829 (https://phabricator.wikimedia.org/T240581) [22:29:41] (CR) Eileen: [C: +2] "recheck" [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/556826 (owner: Eileen) [22:32:53] (CR) Jforrester: [C: +2] Move sql files into the sql/ directory [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556817 (owner: Zoranzoki21) [22:33:10] !log civicrm revision changed from 2043c27a0e to ad2303ef72, config revision is 4d25b656e2 [22:33:15] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [22:35:54] (Merged) jenkins-bot: Move sql files into the sql/ directory [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556817 (owner: Zoranzoki21) [22:48:21] !log process-control config revision is d195531033 jobs temporarily disabled [22:48:25] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [22:51:38] (PS1) Zoranzoki21: Remove jshint and update package.json [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556832 (https://phabricator.wikimedia.org/T195542) [22:52:11] PROBLEM - check_mysql on frdb1003 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) [22:55:18] (CR) Jforrester: [C: +2] Remove jshint and update package.json [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556832 (https://phabricator.wikimedia.org/T195542) (owner: Zoranzoki21) [22:55:47] Fundraising Sprint YAMLton, the Musical, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Recurring-Donations, Patch-For-Review: Should we send recurring payment notifications to the donations queue - https://phabricator.wikimedia.org/T240581 (Ejegg) So there is indeed some recurring-speci... [22:57:11] RECOVERY - check_mysql on frdb1003 is OK: Uptime: 627843 Threads: 1 Questions: 329457175 Slow queries: 388 Opens: 899 Flush tables: 1 Open tables: 668 Queries per second avg: 524.744 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [22:57:49] (Merged) jenkins-bot: Remove jshint and update package.json [extensions/ContributionTracking] - https://gerrit.wikimedia.org/r/556832 (https://phabricator.wikimedia.org/T195542) (owner: Zoranzoki21) [23:18:46] well, I'm not going to dive into changing the core import logic right now :P [23:19:12] think that recurring to donations queue diversion will have to wait