[00:00:40] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1097562 [00:01:37] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1097562 (owner: 10Eileen) [00:02:27] (03PS2) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1097562 [00:19:27] (03CR) 10Eileen: "resubmit" [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1097562 (owner: 10Eileen) [00:20:19] (03Merged) 10jenkins-bot: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1097562 (owner: 10Eileen) [00:20:34] (03CR) 10Cstone: [C:03+2] Remove legacy entityType declaration [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1092408 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [00:20:58] (03CR) 10Cstone: [C:03+2] "farwell getWithHell" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094573 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [00:21:13] !log civicrm upgraded from 190ea417 to eec961a3 [00:21:16] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [00:21:34] (03CR) 10Cstone: [C:03+2] Test data fix [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094575 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [00:22:07] where does omnihell go when it dies [00:25:06] cstone: hmm good question - one might assume it had already hit the lower depths of hades [00:25:23] it overflows to omniheaven? [00:25:34] i need to finish making dinner and ill be back for the rest of the patches [00:46:05] cstone: I'll look at that - may relate to what I deployed [00:46:32] that failmail I mean [00:49:35] (03Merged) 10jenkins-bot: Remove legacy entityType declaration [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1092408 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [00:49:37] (03Merged) 10jenkins-bot: Remove Omnihell test setup [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094573 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [00:49:38] (03Merged) 10jenkins-bot: Test data fix [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094575 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [01:01:09] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 13Patch-For-Review: Fix "The 'timeZoneOffset' field is invalid" bug - https://phabricator.wikimedia.org/T380741#10355994 (10AKanji-WMF) p:05Triage→03Medium [01:41:28] 06Fundraising-Backlog, 07payments-orchestration: Save PayerID for gravy paypal - https://phabricator.wikimedia.org/T380588#10356030 (10AKanji-WMF) [02:13:12] (03PS1) 10Eileen: Fix for failure for forgetme screen to load [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1097582 [02:23:16] (03CR) 10Cstone: [C:03+2] "rip" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094574 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [02:23:44] (03CR) 10Cstone: [C:03+2] Fully remove omnihell setting [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094577 (owner: 10Eileen) [02:24:04] (03CR) 10Cstone: [C:03+2] Reformat code [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094578 (owner: 10Eileen) [02:24:31] (03CR) 10Cstone: [C:03+2] Ensure statics are reset between tests [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094617 (owner: 10Eileen) [02:24:45] cstone: it's probably worth getting this out in case -https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1097582 - that type error was what I hit when I pushed out the MailingStats entity patch & while it's probably unrelated to me hitting it locally it *might* be hitable on prod [02:25:30] also - do you think mis-spelling confusion is on brand? https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1097528 [02:26:17] haha very on brand [02:27:26] (03CR) 10Cstone: [C:03+2] "naming is hard" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1097528 (https://phabricator.wikimedia.org/T374720) (owner: 10Eileen) [02:28:18] :-0 [02:30:28] cstone: maybe on the throttling we should change it from looking back 5 mins to just 1 [02:31:01] it runs every 3 minutes [02:31:06] I was thinking that if we are trying to 'sneak in when there is a gap' then maybe we miss the chance by waiting 5 mins [02:31:25] i guess i dont even know how its magicing is it looking at the log files? [02:31:33] or the queue [02:32:52] cstone: grep isSiteBusy [02:34:03] ah okay nice [02:36:08] hmm was 500 just picked cause we had to pick a limit? [02:37:55] yeah I think that feels right [02:38:11] we have never really done any work to figure out the best value [02:43:41] ill look at our logs from last week cause that was high traffic [02:46:25] (03Merged) 10jenkins-bot: Remove omnihell call [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094574 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [02:46:27] (03Merged) 10jenkins-bot: Fully remove omnihell setting [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094577 (owner: 10Eileen) [02:46:58] donations queue runs every 3 minutes except from like 55 to 00 then sleepy runs every hour in that spot [02:47:03] (03Merged) 10jenkins-bot: Reformat code [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094578 (owner: 10Eileen) [02:47:04] (03Merged) 10jenkins-bot: Ensure statics are reset between tests [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1094617 (owner: 10Eileen) [02:48:18] hmm - & would sleepy cause lots of donation noise too - or would it just be the aging out of the main queue stopping coworker running in those 5 [02:51:56] checking one run that just happened we did 604 in 1 minute and 7 seconds [02:56:31] (03Merged) 10jenkins-bot: Relabel new fields to reduce confusiong [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1097528 (https://phabricator.wikimedia.org/T374720) (owner: 10Eileen) [02:56:43] i think eileen we could at least bring it down to 3 maybe 2? [03:00:14] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-donorservices: Possible issue with the civi snooze - https://phabricator.wikimedia.org/T376959#10356134 (10Eileenmcnaughton) @bsisolak the IP would be 208.80.155.17 [03:00:22] looks like peak times from that 24 hour tests were like ~600 a run [03:00:27] there were a couple 800s [03:00:56] oh i take that back the 800s are our paypal recurrings [03:06:24] oh sorry eileen talking everywhere haha [03:06:51] i dont know if we would ever hit 500 in 1 minute , if we wanted to drop the time maybe drop the checking to like 300 in 1 minute? [03:07:13] cstone: yeah - I was thinking more like pro-rata [03:07:28] ie rather than 500 in 5 mins 100 in 1 min [03:07:34] that way it would age out quicker [03:11:54] yeah i think 100 in 1 min is fine and we could probably make it higher [03:11:58] like 200 in 1? [03:13:16] (03CR) 10Cstone: [C:03+2] "makes sense" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1097582 (owner: 10Eileen) [03:15:36] cstone: well I'd rather change incrementally [03:15:54] yeah [03:16:05] I think for dedupe it is in the process control - but shall we change just coworker first [03:16:31] yeah can see if it explodes? [03:16:40] yeah [03:16:49] I'm really tempted just to run this sql now https://phabricator.wikimedia.org/T380804#10356149 [03:23:49] (03CR) 10Cstone: [C:03+2] "looks good, upgrader worked locally" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1092955 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [03:34:04] hmm what is paypal doing [03:35:45] (03Merged) 10jenkins-bot: Fix for failure for forgetme screen to load [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1097582 (owner: 10Eileen) [03:45:02] (03Merged) 10jenkins-bot: Add report_id field to civicrm_mailing_stat [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1092955 (https://phabricator.wikimedia.org/T361621) (owner: 10Eileen) [03:49:57] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-donorservices: Possible issue with the civi snooze - https://phabricator.wikimedia.org/T376959#10356158 (10bsisolak) Thanks. Opening a ticket now. Did this API call get updated for a Flexible Database type? [03:57:30] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-donorservices: Possible issue with the civi snooze - https://phabricator.wikimedia.org/T376959#10356160 (10Eileenmcnaughton) I feel like we concluded it didn't need an update? I can't see anything in the change log that says I was wrong about that [04:01:41] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-donorservices: Possible issue with the civi snooze - https://phabricator.wikimedia.org/T376959#10356165 (10bsisolak) I wonder if that was wrong, as UpdateRecipient is the call used, correct? https://developer.goacoustic.com/acoustic-campaign/refer... [04:18:07] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-donorservices: Possible issue with the civi snooze - https://phabricator.wikimedia.org/T376959#10356175 (10Eileenmcnaughton) It's actually calling `addRecipient` ` 'groupIdentifier' => array_keys($groupIdentifier), 'email' => $emai... [04:23:18] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-donorservices: Possible issue with the civi snooze - https://phabricator.wikimedia.org/T376959#10356179 (10Eileenmcnaughton) Ok - I was right both times - it calls CREATE and then UPDATE for create it passes the email in sync fields and... [04:25:55] 03Fundraising Sprint: wwwwwwwwwwwwwww(), 06Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity, and 2 others: Non Campaign Emails in Database - https://phabricator.wikimedia.org/T361621#10356181 (10Eileenmcnaughton) @JMando we are looking at pushing the change from staging to prod tomorrow -... [13:14:41] 03Fundraising Sprint: wwwwwwwwwwwwwww(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 07fr-acoustic: Populating both_funds_latest_donation_source field - https://phabricator.wikimedia.org/T379700#10357468 (10IAckerman-WMF) Yes, thanks! [14:41:53] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 06Privacy Engineering, 10Wikimedia-Site-requests, and 4 others: Add app.goacoustic.com to wikipedia.org Content Security Policy (CSP) - https://phabricator.wikimedia.org/T380232#10357887 (10acooper) Update: We are hoping the CSP can be reduced to a mu... [16:20:11] (03PS1) 10Damilare Adedoyin: Add fallback for Fundraiseup transactions using the original UTM parameters (i.e utm_*) [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098080 [16:20:34] (03CR) 10CI reject: [V:04-1] Add fallback for Fundraiseup transactions using the original UTM parameters (i.e utm_*) [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098080 (owner: 10Damilare Adedoyin) [16:20:53] (03PS2) 10Damilare Adedoyin: Add fallback for Fundraiseup transactions using the original UTM parameters (i.e utm_*) [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098080 [16:21:23] (03CR) 10CI reject: [V:04-1] Add fallback for Fundraiseup transactions using the original UTM parameters (i.e utm_*) [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098080 (owner: 10Damilare Adedoyin) [16:21:32] (03PS3) 10Damilare Adedoyin: Add fallback for Fundraiseup transactions using the original UTM parameters (i.e utm_*) [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098080 [16:26:13] frtech please I need review on this before tonight's FRUP imports. Some transactions came in with the old utm_* prefix, so this patch ^^ adds a fallback just in case [16:26:47] the exports are currently mapped to use the wmf_* prefix by default. [16:33:13] looking damilare [16:33:37] btw I only get pings for the 'fr-tech' string and not frtech. I'm not sure about other folks alert config tho [16:34:09] thanks jgleeson [16:43:58] damilare: I'm curious why we have 'UTM medium' and 'original UTM Medium' in the export fields. Could we rename the newest one WMF medium for clarity? [16:44:58] yh I wanted to see if using the same name would populate the field on fundraiseup dashboard also [16:45:04] yh let me change that [16:45:38] it didn't I'd update that [16:52:33] (03PS4) 10Damilare Adedoyin: Add fallback for Fundraiseup transactions using the original UTM parameters (i.e utm_*) [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098080 [16:53:12] thanks jgleeson I've updated the patch [16:53:26] thanks damilare looking now [16:55:15] damilare: what's the 'Original' in that field name referring to? [16:55:26] the one that was just mapped to WMF [16:56:29] the "Original *" columns were the real "utm_*" parameters [16:56:54] I mapped it in the template myself to show the difference [16:57:08] https://dashboard.fundraiseup.com/AVLMPSRU/exports/VLF3VWYL [16:58:05] I'm not close to this issue but my understanding is that the bug you're fixing is that, alongside the new wmf_* params, we are still getting URLs with the old utm_* params, so we need to expect both? [16:58:18] yep [16:58:51] so right now, the parser is checking for utm* fields, and if it is empty it'd check for wmf_* fields [16:59:30] do you want to get on a quick call [16:59:54] the naming might have confused you [16:59:58] and in the previous state, your patch was expecting a report mapping including UTM * and Original UTM *, with the latter containing the new WMF fields? [17:00:34] yeah, my question is, why were the new fields called Original [17:00:41] and subsequently renamed to WMF [17:00:59] shouldn't the original stay in tact if we now want to preserve the UTM param option [17:01:44] firstly, I named the field "Original*", wasn't a FRUP given. [17:02:07] the Fields that were UTM * were infact the wmf_* fields [17:03:04] I mapped those in the template on Fundraiseup thinking it would help Fundraiseup show the wmf details in the dashboard like they would for the missing utm_'s [17:03:23] makes sense [17:04:20] I did that yesterday, but since you brought it up, I went to see if it did show up on the dashboard. However, it didn't, instead they showed up in the custom fields details as wmf_* [17:04:50] so there was no point using the UTM * name for wmf_* fields [17:05:05] gothca [17:05:09] so I took your advise and named them according [17:05:22] gotcha* [17:05:41] yeah I was wondering why we'd go from Orignal to new with the other one left after looking at this https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/SmashPig/+/1098080/3..4/PaymentProviders/Fundraiseup/Audit/DonationsImport.php [17:06:12] I think I understand why that is now [17:06:56] yea I appreciate that part would be confusing without the context [17:08:39] (03CR) 10Jgleeson: [C:03+2] "LGTM! thanks for walking me through the implementation also!" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098080 (owner: 10Damilare Adedoyin) [17:09:00] thanks jgleeson [17:09:07] np [17:09:12] (03Merged) 10jenkins-bot: Add fallback for Fundraiseup transactions using the original UTM parameters (i.e utm_*) [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098080 (owner: 10Damilare Adedoyin) [17:09:45] damilare: today I did a search over a years worth of logs for some of the missing IDs in your list here and I also couldn't find anything https://phabricator.wikimedia.org/T378634#10312631 [17:10:20] are those ch_* IDs using a format generating by FrUP? [17:10:28] no they are stripe ids [17:10:29] generated * [17:10:32] ahhhh [17:10:50] they may be major gift or another offline channel [17:10:59] ok i guess since we only process stripe payments offline it's possible there could be no logs anywhere [17:11:24] yea my thoughts exactly, FRUP is the only online channel that uses stripe [17:32:04] (03PS1) 10Jgleeson: Improve exception message in PayPal validator [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098098 [17:32:32] (03CR) 10CI reject: [V:04-1] Improve exception message in PayPal validator [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098098 (owner: 10Jgleeson) [17:35:01] (03PS2) 10Jgleeson: Improve exception message in PayPal validator [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1098098 [17:56:10] 06Fundraising-Backlog, 10FR-Email, 13Patch-For-Review, 07PHP 8.1 support, 07Wikimedia-production-error: FundraisingEmailUnsubscribe doesn't pass tests in PHP 8.1 - https://phabricator.wikimedia.org/T357593#10358746 (10Krinkle) [17:59:44] 06Fundraising-Backlog, 10FR-Email, 13Patch-For-Review, 07PHP 8.1 support, 07Wikimedia-production-error: FundraisingEmailUnsubscribe doesn't pass tests in PHP 8.1 - https://phabricator.wikimedia.org/T357593#10358747 (10Krinkle) [18:08:55] (03PS1) 10Damilare Adedoyin: Merge branch 'master' into deployment [wikimedia/fundraising/SmashPig] (deployment) - 10https://gerrit.wikimedia.org/r/1098109 [18:12:44] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Increase batch entry size limit - https://phabricator.wikimedia.org/T380305#10358836 (10MDemosWMF) Batch 1133 is on hold right now since we can't commit it, you can see it in the log with 142 lines. [18:13:26] (03PS1) 10Damilare Adedoyin: Update SmashPig to v0.8.24 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1098110 [18:14:08] (03CR) 10Damilare Adedoyin: [C:03+2] Merge branch 'master' into deployment [wikimedia/fundraising/SmashPig] (deployment) - 10https://gerrit.wikimedia.org/r/1098109 (owner: 10Damilare Adedoyin) [18:14:32] (03Merged) 10jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/SmashPig] (deployment) - 10https://gerrit.wikimedia.org/r/1098109 (owner: 10Damilare Adedoyin) [18:20:02] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Fundraiseup donations imported without attribution - https://phabricator.wikimedia.org/T380766#10358846 (10Damilare) This is to confirm that attribution for Fundraiseup transactions from 21st of November till date using the wmf_* fields have now been upda... [18:37:21] (03CR) 10CI reject: [V:04-1] Update SmashPig to v0.8.24 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1098110 (owner: 10Damilare Adedoyin) [18:40:40] (03PS2) 10Damilare Adedoyin: Update SmashPig to v0.8.24 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1098110 [19:08:01] 06Fundraising-Backlog, 10fundraising-tech-ops: Superset set up access for Bree Ryan - https://phabricator.wikimedia.org/T379112#10359018 (10Dwisehaupt) [19:08:08] 06Fundraising-Backlog, 10FR-Email, 13Patch-For-Review, 07PHP 8.1 support, 07Wikimedia-production-error: FundraisingEmailUnsubscribe doesn't pass tests in PHP 8.1 - https://phabricator.wikimedia.org/T357593#10359022 (10Jdforrester-WMF) If this is now a production error, it should be a blocker to wider 8.1... [19:08:26] 06Fundraising-Backlog, 10FR-Email, 13Patch-For-Review, 07PHP 8.1 support, 07Wikimedia-production-error: FundraisingEmailUnsubscribe doesn't pass tests in PHP 8.1 - https://phabricator.wikimedia.org/T357593#10359024 (10Jdforrester-WMF) [19:08:45] (03CR) 10Damilare Adedoyin: [C:03+2] Update SmashPig to v0.8.24 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1098110 (owner: 10Damilare Adedoyin) [19:13:25] 06Fundraising-Backlog, 10fundraising-tech-ops: Superset set up access for Bree Ryan - https://phabricator.wikimedia.org/T379112#10359069 (10Dwisehaupt) [19:14:00] 06Fundraising-Backlog, 10fundraising-tech-ops: Superset set up access for Bree Ryan - https://phabricator.wikimedia.org/T379112#10359075 (10Dwisehaupt) Received verification that certificate install went well and login works for superset. [19:17:02] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1098121 [19:19:26] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1098121 (owner: 10Eileen) [19:22:53] !log civicrm upgraded from eec961a3 to 59d340cd [19:22:55] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [19:29:11] 03Fundraising Sprint: wwwwwwwwwwwwwww(), 06Fundraising-Backlog, 10FR-Tech-Analytics, 10FR-tech-data-integrity, 07fr-acoustic: Non Campaign Emails in Database - https://phabricator.wikimedia.org/T361621#10359139 (10Eileenmcnaughton) @JMando per comments - I pushed out this change to get multiple rows in t... [19:34:09] (03Merged) 10jenkins-bot: Update SmashPig to v0.8.24 [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1098110 (owner: 10Damilare Adedoyin) [19:47:11] PROBLEM - check_mysql on frdb1003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb1003&service=check_mysql [19:52:11] RECOVERY - check_mysql on frdb1003 is OK: Uptime: 594228 Threads: 9 Questions: 752878987 Slow queries: 149 Opens: 7751 Open tables: 1696 Queries per second avg: 1266.986 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb1003&service=check_mysql [19:56:55] (03PS1) 10Damilare Adedoyin: Update SmashPig to v0.8.24 [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1098127 [19:57:59] (03PS1) 10Damilare Adedoyin: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1098128 [20:34:37] 03Fundraising Sprint: wwwwwwwwwwwwwww(), 06Fundraising-Backlog, 07fr-acoustic, 07fr-direct-mail: Direct mail returns not linked to Acoustic - https://phabricator.wikimedia.org/T378717#10359471 (10EMartin) + Ilse for awareness [20:35:51] (03CR) 10Damilare Adedoyin: [C:03+2] Update SmashPig to v0.8.24 [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1098127 (owner: 10Damilare Adedoyin) [20:51:31] 03Fundraising Sprint: wwwwwwwwwwwwwww(), 06Fundraising-Backlog, 07fr-acoustic, 07fr-direct-mail: Direct mail returns not linked to Acoustic - https://phabricator.wikimedia.org/T378717#10359573 (10MDemosWMF) I will be coming to fortnightly tomorrow to discuss with @Eileenmcnaughton now that we have the files. [20:53:30] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Increase batch entry size limit - https://phabricator.wikimedia.org/T380305#10359574 (10AKanji-WMF) Let's add this to the convo tomorrow during Civifortnightly [20:58:37] 03Fundraising Sprint: wwwwwwwwwwwwwww(), 06Fundraising-Backlog, 07FR-Imports, 07Unplanned-Sprint-Work: Checking for code bottlenecks to improve speed of imports - https://phabricator.wikimedia.org/T376337#10359584 (10AKanji-WMF) This is on the agenda for us to discuss tomorrow with @MDemosWMF at civifortni... [20:58:45] (03Merged) 10jenkins-bot: Update SmashPig to v0.8.24 [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1098127 (owner: 10Damilare Adedoyin) [21:00:08] (03CR) 10Damilare Adedoyin: [C:03+2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1098128 (owner: 10Damilare Adedoyin) [21:13:32] (03Merged) 10jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1098128 (owner: 10Damilare Adedoyin) [21:22:55] (03PS16) 10Jforrester: FundraiserSubscriptionPage::getTemplateParams: Fix errors on PHP 8.1 [extensions/FundraisingEmailUnsubscribe] - 10https://gerrit.wikimedia.org/r/1003549 (https://phabricator.wikimedia.org/T357593) [21:23:13] (03CR) 10Jforrester: "Not sure who to tag in FR-Tech for this?" [extensions/FundraisingEmailUnsubscribe] - 10https://gerrit.wikimedia.org/r/1003549 (https://phabricator.wikimedia.org/T357593) (owner: 10Jforrester) [21:23:25] !log SmashPig upgraded from 131e92a5 to 79b463b4 [21:23:28] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:24:59] !log civicrm upgraded from 59d340cd to 3b1ed162 [21:25:01] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:31:52] 10fundraising-tech-ops, 10BDC-Implementation, 06Data-Platform-SRE, 06Privacy Engineering, and 2 others: [minIO] Investigate packaging, install, security monitoring. - https://phabricator.wikimedia.org/T367123#10359676 (10Dwisehaupt) minio cli packaged and installed via puppet on the analytics_io hosts. [22:18:16] 06Fundraising-Backlog: Civimail users require permissions - review required - https://phabricator.wikimedia.org/T380935 (10AKanji-WMF) 03NEW [22:27:09] PROBLEM - check_mysql on frdb1003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb1003&service=check_mysql [22:31:28] 06Fundraising-Backlog: Civimail users require permissions - review required - https://phabricator.wikimedia.org/T380935#10359925 (10Eileenmcnaughton) Note this was one of Nora's projects [22:32:09] RECOVERY - check_mysql on frdb1003 is OK: Uptime: 603828 Threads: 9 Questions: 769433664 Slow queries: 149 Opens: 8040 Open tables: 1778 Queries per second avg: 1274.259 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb1003&service=check_mysql [22:34:05] 06Fundraising-Backlog: Customizing required tokens in Civimail for endowment - https://phabricator.wikimedia.org/T380938 (10AKanji-WMF) 03NEW [23:31:38] hmm we don't already pass through phones to Acoustic - so that is a problem I hadn't picked up on until now [23:34:33] 03Fundraising Sprint: wwwwwwwwwwwwwww(), 06Fundraising-Backlog, 07fr-acoustic: Export phone numbers to Acoustic - https://phabricator.wikimedia.org/T380946 (10Eileenmcnaughton) 03NEW