[00:11:09] RECOVERY - check_mysql on frdb2004 is OK: Uptime: 1721694 Threads: 5 Questions: 209877042 Slow queries: 1021 Opens: 454138 Open tables: 1453 Queries per second avg: 121.901 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2004&service=check_mysql [00:11:13] RECOVERY - check_mysql on frdb2005 is OK: Uptime: 1724207 Threads: 5 Questions: 210250924 Slow queries: 1081 Opens: 454747 Open tables: 1440 Queries per second avg: 121.940 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2005&service=check_mysql [00:16:13] RECOVERY - check_mysql on frdb1006 is OK: Uptime: 723108 Threads: 10 Questions: 98968336 Slow queries: 1178018 Opens: 193460 Open tables: 2442 Queries per second avg: 136.865 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb1006&service=check_mysql [00:23:19] RECOVERY - check_mysql on frdb1004 is OK: Uptime: 1653878 Threads: 5 Questions: 191300473 Slow queries: 1846 Opens: 430991 Open tables: 1467 Queries per second avg: 115.667 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb1004&service=check_mysql [00:28:05] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for dadedoyin - https://phabricator.wikimedia.org/T416420 (10Dwisehaupt) 03NEW [00:28:05] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for tgorski - https://phabricator.wikimedia.org/T416421 (10Dwisehaupt) 03NEW [00:28:06] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for dallas - https://phabricator.wikimedia.org/T416422 (10Dwisehaupt) 03NEW [00:28:09] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for avargas - https://phabricator.wikimedia.org/T416423 (10Dwisehaupt) 03NEW [00:28:11] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for ejegg - https://phabricator.wikimedia.org/T416424 (10Dwisehaupt) 03NEW [00:28:12] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for nngu - https://phabricator.wikimedia.org/T416425 (10Dwisehaupt) 03NEW [00:28:14] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for shust - https://phabricator.wikimedia.org/T416426 (10Dwisehaupt) 03NEW [00:28:15] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for ewhite - https://phabricator.wikimedia.org/T416427 (10Dwisehaupt) 03NEW [00:28:19] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for lwadleigh - https://phabricator.wikimedia.org/T416428 (10Dwisehaupt) 03NEW [00:55:57] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for dallas - https://phabricator.wikimedia.org/T416422#11581598 (10Dwisehaupt) certificate renewed and certificate and password placed in home directory on frpm. [01:03:17] (03CR) 10Cstone: [C:03+2] Address currency conversion rows, take 2 [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236111 (https://phabricator.wikimedia.org/T414531) (owner: 10Eileen) [01:03:50] (03Merged) 10jenkins-bot: Address currency conversion rows, take 2 [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236111 (https://phabricator.wikimedia.org/T414531) (owner: 10Eileen) [01:04:33] (03CR) 10Cstone: [C:03+2] Ignore 'Other' (T9900 code) from TRR files [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236377 (https://phabricator.wikimedia.org/T414531) (owner: 10Eileen) [01:05:00] (03Merged) 10jenkins-bot: Ignore 'Other' (T9900 code) from TRR files [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236377 (https://phabricator.wikimedia.org/T414531) (owner: 10Eileen) [01:29:48] (03PS5) 10Eileen: WIP Trustly Reconciliation [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) [01:30:20] (03CR) 10CI reject: [V:04-1] WIP Trustly Reconciliation [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) (owner: 10Eileen) [01:35:08] (03PS6) 10Eileen: WIP Trustly Reconciliation [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) [01:35:35] (03CR) 10CI reject: [V:04-1] WIP Trustly Reconciliation [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) (owner: 10Eileen) [01:38:41] (03PS7) 10Eileen: Trustly Reconciliation/ Audit addition [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) [02:05:59] (03PS3) 10Esanders: eslint: Fix max-len warnings [extensions/CentralNotice] - 10https://gerrit.wikimedia.org/r/1219567 [02:06:02] (03CR) 10Ejegg: [C:03+2] eslint: Fix max-len warnings (031 comment) [extensions/CentralNotice] - 10https://gerrit.wikimedia.org/r/1219567 (owner: 10Esanders) [02:06:22] (03PS3) 10Esanders: eslint: Fix no-done-fail warnings [extensions/CentralNotice] - 10https://gerrit.wikimedia.org/r/1219568 [02:10:12] (03CR) 10CI reject: [V:04-1] eslint: Fix no-done-fail warnings [extensions/CentralNotice] - 10https://gerrit.wikimedia.org/r/1219568 (owner: 10Esanders) [02:10:43] (03Merged) 10jenkins-bot: eslint: Fix max-len warnings [extensions/CentralNotice] - 10https://gerrit.wikimedia.org/r/1219567 (owner: 10Esanders) [02:16:10] 06Fundraising-Backlog: Content update for 1st and 2nd recurring failure email - https://phabricator.wikimedia.org/T416435 (10Cstone) 03NEW [02:16:26] 06Fundraising-Backlog: Content update for 1st and 2nd recurring failure email - https://phabricator.wikimedia.org/T416435#11581718 (10Cstone) [02:16:32] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11581719 (10Cstone) [02:17:10] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11581721 (10Cstone) @MSuijkerbuijk_WMF @AMJohnson sorry to cause confusion with the content.... [02:19:32] 06Fundraising-Backlog: Content update for 1st? and 2nd recurring failure email - https://phabricator.wikimedia.org/T416435#11581737 (10Cstone) [02:25:26] 06Fundraising-Backlog: Content update for 1st? and 2nd recurring failure email - https://phabricator.wikimedia.org/T416435#11581753 (10Cstone) [02:26:44] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11581756 (10Cstone) [02:27:47] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11581761 (10Cstone) [02:28:41] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11581762 (10Cstone) [02:28:42] ok maybe ill stop spamming [02:29:11] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11581763 (10Cstone) [02:47:06] (03PS1) 10Cstone: Fix where sequence number was lost when sent from the UI [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236393 (https://phabricator.wikimedia.org/T365488) [02:53:33] (03CR) 10Lars SG: [C:03+2] Reapply "Update to CiviCRM 6.11rc" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1226961 (owner: 10Eileen) [02:55:01] (03PS1) 10Cstone: Update smash-pig to v1.2.1.3 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236397 [02:55:15] (03CR) 10Cstone: [C:03+2] Update smash-pig to v1.2.1.3 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236397 (owner: 10Cstone) [03:02:40] * ejegg can't wait to tag version 1312 [03:04:18] i was having a great time with 1.1.1.1 but then Jack bumped it to 1.2 :) [03:05:40] ejegg: im looking at moving those maintence scripts over to the standalone smashpig what does error_reporting=32767 mean [03:05:59] oh man, I knew that for like 5 minutes one time [03:06:09] haha [03:06:14] E_ALL [03:06:28] i.e. very verbose php-level error reporting [03:06:38] ahh hah okay [03:07:16] i thought it was our number but i see phps number [03:11:50] (03Merged) 10jenkins-bot: Reapply "Update to CiviCRM 6.11rc" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1226961 (owner: 10Eileen) [03:12:19] ejegg: i pushed up that change to frpm if you want to check, I didnt change the error levels with them [03:12:22] (03PS1) 10Ejegg: WIP send double opt-in email during TY BatchSend [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236398 (https://phabricator.wikimedia.org/T416198) [03:12:46] sure, will take a look [03:16:05] they look good cstone [03:16:32] i'm going to leave that double opt-in send thing as a WIP for now, gotta get to bed [03:16:35] see ya! [03:16:43] thanks ejegg|away [03:17:38] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, and 2 others: Send double opt-in email template after donation for donors in Italy and Austria - https://phabricator.wikimedia.org/T416198#11581786 (10Ejegg) a:03Ejegg [03:17:48] (03PS8) 10Eileen: Trustly Reconciliation/ Audit addition [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) [03:18:16] (03CR) 10CI reject: [V:04-1] Trustly Reconciliation/ Audit addition [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) (owner: 10Eileen) [03:18:21] (03Merged) 10jenkins-bot: Update smash-pig to v1.2.1.3 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236397 (owner: 10Cstone) [03:29:26] (03PS9) 10Eileen: Trustly Reconciliation/ Audit addition [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) [03:29:59] (03CR) 10CI reject: [V:04-1] Trustly Reconciliation/ Audit addition [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) (owner: 10Eileen) [03:30:10] (03PS2) 10Lars SG: Refine checks for 0 or 2+ organization matches in imports [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1235422 (https://phabricator.wikimedia.org/T415295) [03:30:56] (03PS10) 10Eileen: Trustly Reconciliation/ Audit addition [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236100 (https://phabricator.wikimedia.org/T415135) [03:31:59] (03PS1) 10Eileen: Trustly audit /reconciliation processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236400 (https://phabricator.wikimedia.org/T415135) [03:34:17] (03PS2) 10Eileen: Trustly audit /reconciliation processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236400 (https://phabricator.wikimedia.org/T415135) [03:34:58] (03CR) 10CI reject: [V:04-1] WIP send double opt-in email during TY BatchSend [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236398 (https://phabricator.wikimedia.org/T416198) (owner: 10Ejegg) [03:39:24] (03PS1) 10Eileen: Upgrading wikimedia/smash-pig (v1.2.1.2 => v1.2.1.3) [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1236401 [03:39:34] (03CR) 10Eileen: [C:03+2] Upgrading wikimedia/smash-pig (v1.2.1.2 => v1.2.1.3) [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1236401 (owner: 10Eileen) [03:39:58] (03PS1) 10Eileen: Update smash-pig to v1.2.1.3 [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1236402 [03:40:07] (03CR) 10Eileen: [C:03+2] Update smash-pig to v1.2.1.3 [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1236402 (owner: 10Eileen) [03:48:12] !log * civicrm upgraded from 14c7b7e7 to 8aa9274a [03:48:12] 4:48 PM [03:48:12] * config revision changed from 3b1c3440 to 3fb583f0 [03:48:13] Logged the message at https://wikitech.wikimedia.org/wiki/Fundraising/SAL [03:56:19] (03CR) 10CI reject: [V:04-1] Trustly audit /reconciliation processor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236400 (https://phabricator.wikimedia.org/T415135) (owner: 10Eileen) [04:00:48] (03Merged) 10jenkins-bot: Upgrading wikimedia/smash-pig (v1.2.1.2 => v1.2.1.3) [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1236401 (owner: 10Eileen) [04:42:15] (03PS1) 10Eileen: Add new needs attention batch status [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236406 [05:08:52] cstone: if you get a chance I'm kinda hoping to get an updated download of the paypal grants [05:08:58] im back down eileen [05:10:11] er back now [05:10:18] what timeframe do you want? [05:10:23] or i dont ermember if that one had the datepicker [05:11:04] oh right 2 months [05:14:03] yeah - I mean I want to see what happened since last time [05:14:21] i guess i dont remember waht i did last time, was it just the max time? [05:15:08] ok i found the download [05:15:39] theres 1 since then [05:16:23] and its pending [05:17:16] i emailed it eileen [05:29:18] (03PS1) 10Eileen: Update batch status as we validate [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236480 (https://phabricator.wikimedia.org/T415626) [05:31:25] arg sorry cstone it's the last week of Jan I'm really interest in - there are ones that are supposedly on 23 Jan that were not in last week [05:31:35] ooh interesting let me grab that [05:32:30] i dont see any different but will send [05:36:46] it's so mysterious - we got 10 * 500 from Vanguard on 23 Jan but there is only 3 we were supposedly paid out on that date + 1 sort of then-ish [05:38:41] oh there are some in the payments part & they even have transaction code but not the ones in the files AFAIK 4BX109386F049793E [05:43:40] ok that must be it - shame the trxn id doesn't seem to mean anything [05:44:25] in the payments part like in the non grant files? [05:45:10] yeah & oddly when I searched for one & found the contact & no donation - will have to ask Melanie [05:54:35] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11581855 (10NNgu-WMF) @MSuijkerbuijk_WMF Does this mean the currently active Recurring React... [05:56:23] eileen: i have a token question or can screenshare real quick to ask [06:05:39] ah its late, okay giving up on that for tonight ^ [06:40:46] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07FR-Audience-Dev: Donor Segment and Status update when Recurring Status changes - https://phabricator.wikimedia.org/T415319#11581919 (10NNgu-WMF) Thanks @MSuijkerbuijk_WMF ! [06:56:13] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11581925 (10MSuijkerbuijk_WMF) @NNgu-WMF No, it means that we might need to adjust the timing... [09:27:41] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, and 3 others: Populating both_funds_latest_donation_source field - https://phabricator.wikimedia.org/T379700#11582271 (10MSuijkerbuijk_WMF) We can do loop it into other work - we want to do s... [13:43:19] 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, and 3 others: Automate some Direct Mail white mail coding - https://phabricator.wikimedia.org/T386031#11583279 (10RLewis) @Lars this is great, thanks so much for the update. [13:57:57] 10fundraising-tech-ops, 06DC-Ops, 06Infrastructure-Foundations, 10ops-eqiad, 06SRE: Eqiad: Fr-tech expansion - https://phabricator.wikimedia.org/T403035#11583332 (10cmooney) In terms of the moves here, what makes sense from the netops point of view is to tackle in this order: # Move both pfw1 units ## C... [14:53:27] (03PS7) 10Ejegg: Add API4 MatchingGiftPolicies.fetch and .sync [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1204993 (https://phabricator.wikimedia.org/T410052) [15:00:23] (03PS2) 10Ejegg: On contact update use better name case [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1235403 (https://phabricator.wikimedia.org/T407659) [15:01:10] (03CR) 10Ejegg: "thanks for the CR Eileen, changed in PS3" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1235403 (https://phabricator.wikimedia.org/T407659) (owner: 10Ejegg) [15:33:01] (03CR) 10Damilare Adedoyin: [C:04-1] "From what I understood on that slack thread, it seems Gravy is looking to do this on all methods (not just SEPA). The condition added in t" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236286 (https://phabricator.wikimedia.org/T416330) (owner: 10Jgleeson) [15:40:44] jgleeson|skrun ^ I think we need to confirm this with gravy before merging it in as it could cause discrepancies between methods. Apologies if you already planned to do so earlier. [15:42:41] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10FR-Donor-portal, 06FR-donorrelations, and 2 others: PDF Civi receipts - feature request - https://phabricator.wikimedia.org/T368671#11583929 (10Lars) [15:43:19] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, 13FR-MGFE, 0725 Dec Q3 Planning: Share address and email between DAF and DAF owner when importing donations - https://phabricator.wikimedia.org/T411639#11583930 (10Lars) [15:43:39] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, 13FR-MGFE: Civi much slower than usual! - https://phabricator.wikimedia.org/T402837#11583934 (10Lars) [15:43:50] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, and 2 others: Add global Do not contact button to contact summary - https://phabricator.wikimedia.org/T404989#11583935 (10Lars) [15:44:01] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, 13FR-MGFE: Re-opt-in contacts in Acoustic when re-opted-in in Civi - https://phabricator.wikimedia.org/T416377#11583936 (10Lars) [15:44:14] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: Add preference or tag for donors to be added to direct mail - https://phabricator.wikimedia.org/T416379#11583937 (10Lars) [15:44:25] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, 13FR-MGFE: Addtional fundraising frequency / timing tags in Civi / Acoustic - https://phabricator.wikimedia.org/T416381#11583938 (10Lars) [15:44:35] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, 13FR-MGFE, 07FR-Audience-Dev: Add both_funds_native_total_previous_cy to CiviCRM & Acoustic - https://phabricator.wikimedia.org/T414373#11583940 (10Lars) [15:44:46] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, 13FR-MGFE: Add link in Zendesk to contact in CiviCRM - https://phabricator.wikimedia.org/T415378#11583943 (10Lars) [15:44:58] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, 13FR-MGFE: Civi Unsubscribe Description Not Updating - https://phabricator.wikimedia.org/T409478#11583944 (10Lars) [15:49:13] 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, and 4 others: Automate some Direct Mail white mail coding - https://phabricator.wikimedia.org/T386031#11583954 (10Lars) [15:49:24] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: Links in Email reminders broken - https://phabricator.wikimedia.org/T147118#11583955 (10Lars) [15:49:35] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, 13FR-MGFE: Show if a contact is receiving SMS on Civi contact record and show sent SMS - https://phabricator.wikimedia.org/T416382#11583956 (10Lars) [15:49:50] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, 13FR-MGFE: Handle Third-Party Donation Emails as Secondary with Source Tracking - https://phabricator.wikimedia.org/T414538#11583967 (10Lars) [15:50:15] 14Fundraising Sprint Cheese String Theory, 14Fundraising Sprint Discworld reformatted as ntfs, 14Fundraising Sprint e^🥧👀=yum, 06Fundraising-Backlog, and 5 others: Civi Searchkit should allow user to export list to acoustic - https://phabricator.wikimedia.org/T301514#11583974 (10Lars) [15:50:33] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE, 0725 Dec Q3 Planning: Create config UI for Civi extension version of large donation notifications - https://phabricator.wikimedia.org/T391388#11583979 (10Lars) [15:50:46] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE, 0725 Dec Q3 Planning: Major Gifts Events Related - Importing Activities at the same time when new importing contacts - https://phabricator.wikimedia.org/T254751#11583980 (10Lars) [15:50:57] 14Fundraising Sprint Michelin Star, 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 13FR-MGFE, and 2 others: Major Gifts + segmentation framework - do softcredits show up OK - https://phabricator.wikimedia.org/T392034#11583981 (10Lars) [15:51:10] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, and 2 others: Search kit fields for pledges - https://phabricator.wikimedia.org/T361635#11583982 (10Lars) [15:51:21] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, and 3 others: Automate - MGGO appeal update - https://phabricator.wikimedia.org/T406662#11583986 (10Lars) [15:51:38] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 10FR-Donation-Processing, and 2 others: On batch import, auto add soft credit & auto share addresses - https://phabricator.wikimedia.org/T408449#11583990 (10Lars) [15:51:54] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06FR-donorrelations, 13FR-MGFE: Adyen daily audit file check - how to process transactions >12k - https://phabricator.wikimedia.org/T399034#11583992 (10Lars) [15:52:40] 06Fundraising-Backlog, 07fundraising-supporter-opt-in, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, and 2 others: Civi: expand 'deceased' checkbox to cover all outreach methods - https://phabricator.wikimedia.org/T383717#11583993 (10Lars) [15:52:45] 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: Edit Civi Grant Deadline reminder email message - https://phabricator.wikimedia.org/T150862#11583994 (10Lars) [15:52:54] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: Allow DR & MGFE leads to edit contact layouts in CiviCRM - https://phabricator.wikimedia.org/T407909#11583995 (10Lars) [15:53:07] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: Splitting Organization Contacts in Civi that are Workplace Giving and Restricted Funds - https://phabricator.wikimedia.org/T364978#11583996 (10Lars) [15:53:16] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: New fields for last donation amount in Civi - https://phabricator.wikimedia.org/T324371#11583997 (10Lars) [15:53:32] 06Fundraising-Backlog, 13FR-MGFE: Customizing required tokens in Civimail for endowment - https://phabricator.wikimedia.org/T380938#11583998 (10Lars) [15:53:44] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: Establish way to test how many civimails are about to be sent out - https://phabricator.wikimedia.org/T352137#11584002 (10Lars) [15:53:52] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: Change order of Actions available in Advanced Search results - https://phabricator.wikimedia.org/T142619#11584005 (10Lars) [15:54:01] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: A tool to evaluate and fix donor-entered data - https://phabricator.wikimedia.org/T137498#11584006 (10Lars) [15:54:12] 06Fundraising-Backlog, 10FR-endowment, 13FR-MGFE: Endowment Gift Summary Current Fiscal Year Report - https://phabricator.wikimedia.org/T261896#11584007 (10Lars) [15:54:22] 06Fundraising-Backlog, 13FR-MGFE: Process to archive and save an out of date mailing address - https://phabricator.wikimedia.org/T135552#11584008 (10Lars) [15:54:33] 06Fundraising-Backlog, 13FR-MGFE: Improve UI for primary mailing address - https://phabricator.wikimedia.org/T113996#11584011 (10Lars) [15:54:43] 06Fundraising-Backlog, 13FR-MGFE: Add Report Criteria to exported report data - https://phabricator.wikimedia.org/T113978#11584012 (10Lars) [15:54:50] 06Fundraising-Backlog, 13FR-MGFE: Activities have lost color coding ability - https://phabricator.wikimedia.org/T221565#11584014 (10Lars) [16:02:06] (03PS2) 10Ejegg: Send double opt-in email during TY BatchSend [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236398 (https://phabricator.wikimedia.org/T416198) [16:06:01] (03PS3) 10Ejegg: Send double opt-in email during TY BatchSend [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236398 (https://phabricator.wikimedia.org/T416198) [16:07:20] (03PS4) 10Ejegg: Send double opt-in email during TY BatchSend [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236398 (https://phabricator.wikimedia.org/T416198) [16:10:21] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2526Q3 maintenance window - https://phabricator.wikimedia.org/T364185#11584093 (10Dwisehaupt) [16:10:51] (03PS1) 10Ejegg: Set target_contact_id on Double Opt-In activities [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236771 [16:19:44] (03PS2) 10Ejegg: Set target_contact_id on Double Opt-In activities [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236771 (https://phabricator.wikimedia.org/T407017) [16:25:15] (03CR) 10Jgleeson: [C:03+2] "makes sense!" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236771 (https://phabricator.wikimedia.org/T407017) (owner: 10Ejegg) [16:30:16] (03CR) 10Jgleeson: "Did you read the right Slack thread :D. CB starts with "Hi all, we are reaching out to share an upcoming technical refinement to our Adyen" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236286 (https://phabricator.wikimedia.org/T416330) (owner: 10Jgleeson) [16:30:28] damilare: ^ [16:35:12] (03CR) 10Jgleeson: [C:03+2] Reformat applePayHelper JS [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1236350 (owner: 10Ejegg) [16:38:26] thanks for the CR jgleeson [16:38:35] np [16:38:53] (03CR) 10Damilare Adedoyin: [C:04-1] "Jgleeson I did read the slack thread as I said in my previous comment. My concern is that we are not updating the backend_processor_txn_id" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236286 (https://phabricator.wikimedia.org/T416330) (owner: 10Jgleeson) [16:39:32] I'm look at the other one. I thinking about asking you to add back in the "// suspected 'dad' scenario so use shipping contact" comment ejegg :D [16:40:05] oh hah [16:40:22] right, I was going to flip that last one back to the billing contact first [16:41:19] are you able to test the top commit in that chain? It seems to work fine on my macbook tester account [16:41:34] I need to find the lightning cable for my test iphone [16:45:40] (03CR) 10Jgleeson: "Ah ok, but he doesn't say he is changing the other methods in this change. He says this is changing to align with the others (implying the" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236286 (https://phabricator.wikimedia.org/T416330) (owner: 10Jgleeson) [16:46:19] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for nngu - https://phabricator.wikimedia.org/T416425#11584240 (10Dwisehaupt) certificate renewed and sent via email. password sent via sms. [16:49:23] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for rmurthy - https://phabricator.wikimedia.org/T416278#11584250 (10Dwisehaupt) certificate renewed and sent via email. password sent via sms. [16:55:27] I was gonna test on my mac tbh ejegg I haven't used the iphone for a while and definitely dont have any test payment methods set up on that [16:55:44] we need iphone people for that :) cough damilare [16:56:21] lol sure I can help with the testing [16:59:38] (03CR) 10Jgleeson: [C:03+1] "LGTM. I'll let an iphone tester confirm!" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1236355 (owner: 10Ejegg) [17:00:15] 06Fundraising-Backlog, 06Fundraising-Tech-Roadmap, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE, 0725 Dec Q3 Planning: Request for improvement to prospecting system to track moves management - https://phabricator.wikimedia.org/T386961#11584265 (10Lars) [17:00:48] (03PS3) 10Ejegg: Set target_contact_id on Double Opt-In activities [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236771 (https://phabricator.wikimedia.org/T416018) [17:01:22] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations, 13Patch-For-Review: DR should be able to add double opt in activities - https://phabricator.wikimedia.org/T416018#11584271 (10Ejegg) a:03Ejegg [17:06:14] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Gravy dlocal audit failed to find two dlocal foreign currency donation. - https://phabricator.wikimedia.org/T416290#11584285 (10AnnWF) [17:28:55] (03PS5) 10Ejegg: Show errors for missing Apple Pay name fields [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1235876 (https://phabricator.wikimedia.org/T407033) [17:28:55] (03PS3) 10Ejegg: Reformat applePayHelper JS [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1236350 [17:28:55] (03PS3) 10Ejegg: Fix some edge cases for Apple Pay name selection [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1236355 [17:30:27] 06Fundraising-Backlog, 06FR-donorrelations, 07fr-current-sprint, 07payments-orchestration: Handle Gravy Paypal Chargebacks and Refunds from the resolution center - https://phabricator.wikimedia.org/T405404#11584362 (10Damilare) [17:32:02] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 0725 Dec Q3 Planning: Create Recurring Upgrade and Recurring Downgrade activities when completed by DR through CiviCRM UI - https://phabricator.wikimedia.org/T409097#11584365 (10Lars) Also check into what happens with a... [17:32:33] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 0725 Dec Q3 Planning: Create Recurring Upgrade and Recurring Downgrade activities when completed by DR through CiviCRM UI - https://phabricator.wikimedia.org/T409097#11584366 (10Damilare) [17:39:07] 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, 07fr-acoustic, 07fr-current-sprint: Update SMS documentation - https://phabricator.wikimedia.org/T409520#11584381 (10Damilare) [17:51:49] (03PS1) 10Lars SG: Only get target contacts for double opt in activities [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1236793 (https://phabricator.wikimedia.org/T416018) [18:03:47] (03CR) 10Ejegg: [C:03+2] Only get target contacts for double opt in activities [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1236793 (https://phabricator.wikimedia.org/T416018) (owner: 10Lars SG) [18:05:35] (03Merged) 10jenkins-bot: Only get target contacts for double opt in activities [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1236793 (https://phabricator.wikimedia.org/T416018) (owner: 10Lars SG) [18:09:18] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Consider CiviCRM Log Export extension - https://phabricator.wikimedia.org/T416504 (10Lars) 03NEW [18:12:11] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Consider CiviCRM Log Export extension - https://phabricator.wikimedia.org/T416504#11584536 (10greg) [18:21:20] (03PS3) 10Lars SG: Refine checks for 0 or 2+ organization matches in imports [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1235422 (https://phabricator.wikimedia.org/T415295) [18:28:49] (03PS1) 10Lars SG: Add target contact to existing double opt in activities [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236796 (https://phabricator.wikimedia.org/T416018) [18:44:52] (03PS1) 10Lars SG: Add target contact when creating double opt in activities [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236800 (https://phabricator.wikimedia.org/T416018) [18:46:26] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11584723 (10Lars) @Cstone Mariana has ok-ed removing the year from the source, so that's one... [18:49:42] (03CR) 10Wfan: [C:03+2] "Awesome, it show the error in the apple pay area~" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1235876 (https://phabricator.wikimedia.org/T407033) (owner: 10Ejegg) [19:00:47] (03Merged) 10jenkins-bot: Show errors for missing Apple Pay name fields [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1235876 (https://phabricator.wikimedia.org/T407033) (owner: 10Ejegg) [19:01:08] (03Merged) 10jenkins-bot: Reformat applePayHelper JS [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1236350 (owner: 10Ejegg) [19:15:56] (03PS1) 10Ejegg: Get missing country from latest donation [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1236807 (https://phabricator.wikimedia.org/T410924) [19:16:15] thanks wfan ! [19:17:04] np [19:17:15] (03CR) 10Ejegg: "oops, i was also doing this in I878993f3ce8274464bac524cc32d62fb8473001c" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236800 (https://phabricator.wikimedia.org/T416018) (owner: 10Lars SG) [19:20:29] (03CR) 10Damilare Adedoyin: [C:03+2] "Thanks for all the work on this. Looks good to me. Hopefully Gravy would standardise the `payment_service_transaction_id` field and make i" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236286 (https://phabricator.wikimedia.org/T416330) (owner: 10Jgleeson) [19:20:59] (03Merged) 10jenkins-bot: Handle Gravy SEPA payment_service_transaction_id change [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1236286 (https://phabricator.wikimedia.org/T416330) (owner: 10Jgleeson) [19:21:01] ty damilare ! [19:21:21] np! thanks for the work on it as well!! [19:23:03] my current understanding is that if that code were to go out now, it wouldn't change anything, since the ID is the same in both places we store it. I'll confirm that, though, to make sure. (that will ease the worries of cstone) [19:23:37] hah my worries were eased 10 mins to that tech talk :P [19:23:43] into* [19:24:02] :) [19:29:12] yea currently it doesn't change [19:31:25] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13Patch-For-Review: Select most recent donation country when adding country to silverpop_missing_countries - https://phabricator.wikimedia.org/T410924#11584904 (10Ejegg) Trying the timing of the query for the last coup... [19:35:37] (03CR) 10Eileen: [C:03+2] On contact update use better name case [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1235403 (https://phabricator.wikimedia.org/T407659) (owner: 10Ejegg) [19:36:04] (03CR) 10CI reject: [V:04-1] Get missing country from latest donation [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1236807 (https://phabricator.wikimedia.org/T410924) (owner: 10Ejegg) [19:40:24] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations: Improve automated deduping - https://phabricator.wikimedia.org/T416403#11584917 (10Lars) [19:40:37] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations: Improve automated deduping - https://phabricator.wikimedia.org/T416403#11584918 (10Lars) [19:48:09] oh dang that join made the test time out? [19:48:30] let's see if it's just as bad using a where clause [19:51:49] hmm, just the same [19:57:15] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations: Search indicator no longer spins to show search in progress in Deduper - https://phabricator.wikimedia.org/T403539#11584954 (10Lars) [19:57:55] (03Merged) 10jenkins-bot: On contact update use better name case [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1235403 (https://phabricator.wikimedia.org/T407659) (owner: 10Ejegg) [19:58:02] thanks eileen [19:58:23] ejegg: no worries - it's a little erg copying but so was the alternative [20:01:02] 14Fundraising Sprint Michelin Star, 03Fundraising Sprint: Ball pit, 14Fundraising Sprint: Vixen, 06Fundraising-Backlog, and 2 others: 2nd Recurring Failure Email in Civi - https://phabricator.wikimedia.org/T365488#11584981 (10NNgu-WMF) @MSuijkerbuijk_WMF I took a look at the Reactivation Journey that has b... [20:11:58] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2526Q3 maintenance window - https://phabricator.wikimedia.org/T364185#11585000 (10Dwisehaupt) [20:12:27] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2526Q3 maintenance window - https://phabricator.wikimedia.org/T364185#11585002 (10Dwisehaupt) [20:13:05] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 10fundraising-tech-ops: FR-Tech FY2526Q3 maintenance window - https://phabricator.wikimedia.org/T364185#11585003 (10Dwisehaupt) [20:40:28] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13FR-MGFE: Links in Email reminders broken - https://phabricator.wikimedia.org/T147118#11585053 (10Lars) 05Open→03Resolved a:03Lars [20:46:46] 14Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Test out, maybe implement new scheduled communication functionality - https://phabricator.wikimedia.org/T369109#11585065 (10Lars) Anyone remember what we wanted to use this for — or should I just close this up? [21:06:29] (03PS1) 10Eileen: WIP Batch Reference spec [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236825 [21:07:23] 10fundraising-tech-ops, 06DC-Ops, 06Infrastructure-Foundations, 10ops-eqiad, 06SRE: Eqiad: Fr-tech expansion - https://phabricator.wikimedia.org/T403035#11585115 (10RobH) [21:08:43] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations: Add address standardization to Civi for US postal addresses - https://phabricator.wikimedia.org/T416376#11585119 (10Lars) See also {T372109} [21:08:59] (03PS1) 10Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1236826 [21:09:21] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 06FR-donorrelations: Give monthly donors the option to receive monthly receipts - https://phabricator.wikimedia.org/T416383#11585122 (10Lars) See also {T410922} [21:09:28] 10fundraising-tech-ops, 06DC-Ops, 06Infrastructure-Foundations, 10ops-eqiad, 06SRE: Eqiad: Fr-tech expansion - https://phabricator.wikimedia.org/T403035#11585124 (10RobH) [21:09:40] 10fundraising-tech-ops, 06DC-Ops, 06Infrastructure-Foundations, 10ops-eqiad, 06SRE: Eqiad: Fr-tech expansion - https://phabricator.wikimedia.org/T403035#11585125 (10RobH) [21:10:00] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1236826 (owner: 10Eileen) [21:10:10] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Add both_funds_first_native_currency and both_funds_first_native_amount to Acoustic export - https://phabricator.wikimedia.org/T407392#11585127 (10Lars) @MSuijkerbuijk_WMF @NNgu-WMF Do we still want these fields? [21:11:28] oh the afform scanner maybe is slow locally because of debug? [21:11:40] (03CR) 10Damilare Adedoyin: [C:03+2] "Thanks for all the work on this and code comments explaining the approach taken. Tested and LGTM!" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1236355 (owner: 10Ejegg) [21:11:46] 06Fundraising Tech Chaos Holding Pen, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Problem upgrading CiviCRM with cv - https://phabricator.wikimedia.org/T395977#11585134 (10Lars) 05Open→03Declined Have not seen this, I'm going to close it up and we can re-open if it comes up again. [21:11:59] ejegg: yeah that can mess with cache grind [21:12:12] but the number of calls is still igh [21:12:18] PROBLEM - check_redis on frqueue2002 is CRITICAL: CRITICAL: jobs-paypal is 11074 10000 - REDIS 7.0.15 on 127.0.0.1:6379 has 1 databases (db0) with 22 keys, up 20 days 22 hours - memory use is 277.13M (peak 706.03M, 3.61% of max, fragmentation 1.07%), connected_slaves is 3, donations is 624, jobs is 0, jobs-adyen is 0, jobs-dlocal is 0, jobs-gravy is 2, payments-antifraud is 4, payments-init is 5, pending is 0, recurring is 249, refund is [21:12:18] scribe is 1 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frqueue2002&service=check_redis [21:12:57] will turn it off and try again [21:16:20] still somewhat slow to load the searchkit page [21:16:24] lemme get a cachegrind [21:17:18] PROBLEM - check_redis on frqueue2002 is CRITICAL: CRITICAL: jobs-paypal is 11263 10000 - REDIS 7.0.15 on 127.0.0.1:6379 has 1 databases (db0) with 21 keys, up 20 days 22 hours - memory use is 277.56M (peak 706.03M, 3.62% of max, fragmentation 1.07%), connected_slaves is 3, donations is 837, jobs is 0, jobs-adyen is 0, jobs-dlocal is 0, jobs-gravy is 4, payments-antifraud is 5, payments-init is 6, pending is 0, recurring is 0, refund is 0 [21:17:18] ribe is 1 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frqueue2002&service=check_redis [21:18:37] wow, how is that file 3x as big? [21:19:15] oh, maybe with debug off there are fewer separate requests? [21:20:08] PROBLEM - check_coworker on civi1002 is CRITICAL: PROCS CRITICAL: 1 process with args php /srv/coworker/bin/coworker https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=civi1002&service=check_coworker [21:21:11] ^^^ those alerts are expected and acked/downtime added. [21:21:37] ACKNOWLEDGEMENT - check_redis on frqueue2002 is CRITICAL: CRITICAL: jobs-paypal is 11263 10000 - REDIS 7.0.15 on 127.0.0.1:6379 has 1 databases (db0) with 21 keys, up 20 days 22 hours - memory use is 277.56M (peak 706.03M, 3.62% of max, fragmentation 1.07%), connected_slaves is 3, donations is 837, jobs is 0, jobs-adyen is 0, jobs-dlocal is 0, jobs-gravy is 4, payments-antifraud is 5, payments-init is 6, pending is 0, recurring is 0, ref [21:21:37] unsubscribe is 1 Dwisehaupt known https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frqueue2002&service=check_redis [21:22:10] (03PS1) 10Eileen: Update triggers [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236829 [21:22:13] !log civicrm upgraded from 8aa9274a to dd10342d [21:22:14] Logged the message at https://wikitech.wikimedia.org/wiki/Fundraising/SAL [21:23:41] (03Merged) 10jenkins-bot: Fix some edge cases for Apple Pay name selection [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1236355 (owner: 10Ejegg) [21:27:14] (03CR) 10CI reject: [V:04-1] WIP Batch Reference spec [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236825 (owner: 10Eileen) [21:28:23] (03PS2) 10Eileen: Update triggers [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236829 [21:33:08] (03PS3) 10Eileen: Update triggers [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236829 [21:35:38] (03PS1) 10Ejegg: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - 10https://gerrit.wikimedia.org/r/1236833 [21:35:44] (03CR) 10Ejegg: [C:03+2] Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - 10https://gerrit.wikimedia.org/r/1236833 (owner: 10Ejegg) [21:40:08] (03Merged) 10jenkins-bot: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - 10https://gerrit.wikimedia.org/r/1236833 (owner: 10Ejegg) [21:41:51] (03CR) 10Dwisehaupt: [C:03+2] Update triggers [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236829 (owner: 10Eileen) [21:41:54] (03CR) 10Dwisehaupt: [V:03+2 C:03+2] Update triggers [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236829 (owner: 10Eileen) [21:44:46] (03PS1) 10Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1236839 [21:45:05] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1236839 (owner: 10Eileen) [21:46:51] !log civicrm upgraded from dd10342d to 4c2870c5 [21:46:52] Logged the message at https://wikitech.wikimedia.org/wiki/Fundraising/SAL [21:51:22] !log payments-wiki upgraded from a09a4f8f to 93e0d03f [21:51:22] Logged the message at https://wikitech.wikimedia.org/wiki/Fundraising/SAL [21:54:37] (03PS2) 10Ejegg: Get missing country from latest donation [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1236807 (https://phabricator.wikimedia.org/T410924) [21:56:28] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13Patch-For-Review: Select most recent donation country when adding country to silverpop_missing_countries - https://phabricator.wikimedia.org/T410924#11585270 (10Ejegg) OK, the ungrouped 'INSERT / ON DUPLICATE KEY UPD... [21:59:23] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog: Add Gravy [Orchestrator|Processor] structured logs layer - https://phabricator.wikimedia.org/T416525 (10jgleeson) 03NEW [21:59:25] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog: Create GravyApiTimingTrait - https://phabricator.wikimedia.org/T416526 (10jgleeson) 03NEW [21:59:28] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog: Update Gravy Api.php to use new trait - https://phabricator.wikimedia.org/T416527 (10jgleeson) 03NEW [21:59:29] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog: Add GravyApiTimingTraitTest - https://phabricator.wikimedia.org/T416528 (10jgleeson) 03NEW [22:00:08] RECOVERY - check_coworker on civi1002 is OK: PROCS OK: 1 process with args php /srv/coworker/bin/coworker https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=civi1002&service=check_coworker [22:00:24] 06Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for dadedoyin - https://phabricator.wikimedia.org/T416420#11585309 (10Dwisehaupt) certificate renewed and certificate and password files placed in user home directory on frpm. [22:01:38] oh right [22:01:50] I marked them as done so it imported them as resolved [22:03:38] fr-tech, I wanted to share how one might use story mapping to describe technical features. I've used one here for the updates to the [orchestrator|processor] logging updates. It's pretty intuitive, but essentially the trick is treating a system or caller as the user. https://storymaps.io/rhkshlde [22:10:47] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 13Patch-For-Review: Add Gravy [Orchestrator|Processor] structured logs layer - https://phabricator.wikimedia.org/T416525#11585361 (10jgleeson) I also need to add a small update to the existing log tag builder to indicate an empty first cell for the non-g... [22:13:47] 03Fundraising Sprint: Ball pit, 06Fundraising-Backlog, 13Patch-For-Review: Add Gravy [Orchestrator|Processor] structured logs layer - https://phabricator.wikimedia.org/T416525#11585375 (10jgleeson) [22:14:46] (03CR) 10CI reject: [V:04-1] Get missing country from latest donation [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/1236807 (https://phabricator.wikimedia.org/T410924) (owner: 10Ejegg) [22:21:44] 06Fundraising-Backlog, 07fr-combowiki: Investigate: On-wiki donations using native HTML5 Payment Request API - https://phabricator.wikimedia.org/T415586#11585427 (10AKanji-WMF) [22:32:16] RECOVERY - check_redis on frqueue2002 is OK: OK: REDIS 7.0.15 on 127.0.0.1:6379 has 1 databases (db0) with 17 keys, up 20 days 23 hours - memory use is 267.77M (peak 706.03M, 3.50% of max, fragmentation 1.07%), connected_slaves is 3, donations is 810, jobs is 0, jobs-adyen is 0, jobs-dlocal is 0, jobs-gravy is 0, jobs-paypal is 4626, payments-antifraud is 0, payments-init is 2, pending is 0, recurring is 307, refund is 0, unsubscribe is [22:32:16] /icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frqueue2002&service=check_redis [22:32:45] fr-tech, if you happen to tag a new version of smashpig tonight, could you leave out https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/SmashPig/+/1236286 please. I haven't had a chance to do a full SEPA end-to-end test with it to confirm it doesn't break anything. I forgot about it, so I'll pick it up in the morning! Thanks [23:12:59] (03PS1) 10Eileen: Avoid trailing whitespace in triggers [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1236853 [23:14:42] I think this will help with the triggers readability https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1236853 [23:47:46] !log donorwiki upgraded from 53bfb05b to 93e0d03f [23:47:47] Logged the message at https://wikitech.wikimedia.org/wiki/Fundraising/SAL [23:49:56] (03PS2) 10Eileen: WIP Batch Reference spec [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236825 [23:49:56] (03PS1) 10Eileen: 403 = scream [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236857 [23:50:14] (03PS2) 10Eileen: 403 = scream [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236857 [23:51:50] (03CR) 10Cstone: [V:03+2 C:03+2] 403 = scream [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1236857 (owner: 10Eileen) [23:52:55] (03PS1) 10Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1236858 [23:53:23] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1236858 (owner: 10Eileen) [23:56:43] !log civicrm upgraded from 4c2870c5 to 000dd548 [23:56:44] Logged the message at https://wikitech.wikimedia.org/wiki/Fundraising/SAL