[00:05:09] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Decommission `civi-data-translate` extension - https://phabricator.wikimedia.org/T325698 (10Eileenmcnaughton) [00:06:27] (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/869858 [00:06:38] (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/869858 (owner: 10Eileen) [00:10:42] !log + fc0536195a12df9bc7a896f77db6b2c8e609352e Check for correct fin type name in hasEndowment [00:10:43] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [00:19:43] (03Merged) 10jenkins-bot: Update dev EOY templates with Endowment Gift fin type [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/869856 (https://phabricator.wikimedia.org/T325693) (owner: 10Ejegg) [00:27:49] 10Fundraising-Backlog, 10fundraising-tech-ops: Make slow query log visible to non-fr-ops staff (fr-tech staff) - https://phabricator.wikimedia.org/T325689 (10Dwisehaupt) We currently have the imfile input for rsyslog watching the slow log via the following template: ` rsyslog::collector::imfile { 'mysql_sl... [01:08:36] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Endowment donations not separated from Annual Fund donations in End Of Year Thank You Receipt - https://phabricator.wikimedia.org/T325693 (10Cstone) Hi @NNgu-WMF this should be fixed. Could you see if you can see separate Endowment lines on your end? [01:57:30] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Endowment donations not separated from Annual Fund donations in End Of Year Thank You Receipt - https://phabricator.wikimedia.org/T325693 (10TSkaff) I tried and it looks good, that was super fast @Cstone! [01:59:46] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Mix up with Norwegian BokMals - https://phabricator.wikimedia.org/T325708 (10Eileenmcnaughton) [02:05:50] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Endowment donations not separated from Annual Fund donations in End Of Year Thank You Receipt - https://phabricator.wikimedia.org/T325693 (10NNgu-WMF) Thank you thank you @Cstone! [02:54:01] 10Fundraising-Backlog, 10FR-Civi-Dedupe, 10fr-donorservices: Civi dedupe merge lost donation 12/20/22 - https://phabricator.wikimedia.org/T325696 (10Eileenmcnaughton) @MBeat33 - this is the only donation that looks like it was associated with 48555617 https://civicrm.wikimedia.org/civicrm/contact/view/cont... [03:06:55] 10Fundraising-Backlog, 10FR-Civi-Dedupe, 10fr-donorservices: Civi dedupe merge lost donation 12/20/22 - https://phabricator.wikimedia.org/T325696 (10MBeat33) 05Open→03Resolved a:03MBeat33 Thanks for finding that @Eileenmcnaughton. I might have missed the year of that contrib before the merge, so I'm so... [08:23:55] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Mix up with Norwegian BokMals - https://phabricator.wikimedia.org/T325708 (10TomaszGorski) Hello @Eileenmcnaughton, Thank you! I can confirm that the template in [[ https://civicrm.wikimedia.org/civicrm/admin/messageTemplates?reset=1#/edit?id=310&lang=n... [08:25:22] (03CR) 10CI reject: [V: 04-1] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/870218 (owner: 10L10n-bot) [09:36:42] (03CR) 10Raimond Spekking: [C: 03+2] "false positive" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/870218 (owner: 10L10n-bot) [12:21:21] hi fr-tech! [15:22:37] 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, 10FR-dlocal: High Level Documentation for Dlocal - https://phabricator.wikimedia.org/T324498 (10jgleeson) [x] Create a new payment processor page [x] Links to the integrations documentation [x] Links to the test console and live consol... [15:25:31] 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, 10FR-dlocal: High Level Documentation for Dlocal - https://phabricator.wikimedia.org/T324498 (10jgleeson) Diagrams added in {T324621} [18:10:32] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Endowment donations not separated from Annual Fund donations in End Of Year Thank You Receipt - https://phabricator.wikimedia.org/T325693 (10TSkaff) Just one thing I noticed; it doesn't work in non-English languages, but if this is something we can edit i... [18:14:48] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Endowment donations not separated from Annual Fund donations in End Of Year Thank You Receipt - https://phabricator.wikimedia.org/T325693 (10Cstone) Hi @TSkaff we updated all the language templates. Only the English language one had the code to show endow... [18:16:53] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Endowment donations not separated from Annual Fund donations in End Of Year Thank You Receipt - https://phabricator.wikimedia.org/T325693 (10Ejegg) >>! In T325693#8485187, @TSkaff wrote: > Just one thing I noticed; it doesn't work in non-English languages... [18:20:19] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Endowment donations not separated from Annual Fund donations in End Of Year Thank You Receipt - https://phabricator.wikimedia.org/T325693 (10Ejegg) Hmm, that {$index} is a little funny too. The numbering is across the entire set of donations, so a person... [18:21:06] fr-tech I half-way want to fix that {$index} thing to avoid possible confusion, but it would require more edits to all the templates [18:21:23] https://phabricator.wikimedia.org/T325693#8485214 [18:22:07] I would just have the controller class present two different lists of donations to the template so the template didn't have to do the filtering [18:24:17] seems worthwhile based on the potential issue described [18:38:50] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Endowment donations not separated from Annual Fund donations in End Of Year Thank You Receipt - https://phabricator.wikimedia.org/T325693 (10TSkaff) Oh thank you both, this makes sense. I'll note this info in case Amy's team ever wants to expand into oth... [21:10:54] 10Fundraising-Backlog, 10FR-Japan, 10fr-donorservices: Japan Form Variations for Testing for Q3 - https://phabricator.wikimedia.org/T322793 (10TSkaff) [21:18:28] (03PS1) 10Ejegg: EOY Email: use correct locale for donation amount [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/870724 [21:18:43] ok eileen ^^^ is the locale fix [21:19:06] ejegg: ok - we should pull it onto staging & test there I guess [21:19:20] we can still re-use the 'make' can't we [21:24:47] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Mix up with Norwegian BokMals - https://phabricator.wikimedia.org/T325708 (10Eileenmcnaughton) 05Open→03Resolved a:03Eileenmcnaughton Thanks @TomaszGorski - it's gone [21:25:46] 10Fundraising Sprint Wibbly Wobbly Timey Wimey, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Unplanned-Sprint-Work: Mix up with Norwegian BokMals - https://phabricator.wikimedia.org/T325708 (10Eileenmcnaughton) [21:30:46] (03CR) 10CI reject: [V: 04-1] EOY Email: use correct locale for donation amount [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/870724 (owner: 10Ejegg) [21:38:26] (03PS2) 10Ejegg: EOY Email: use correct locale for donation amount [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/870724 [21:41:27] 10Wikimedia-Fundraising-Banners, 10Wikipedia-iOS-App-Backlog: Updated message for 2022 English fundraising in iOS app - https://phabricator.wikimedia.org/T325690 (10spatton) [21:41:53] 10Wikimedia-Fundraising-Banners, 10Wikipedia-iOS-App-Backlog: Updated message for 2022 English fundraising in iOS app - https://phabricator.wikimedia.org/T325690 (10spatton) Noting that I've updated my original task with new markup for shorter messages in each country. [21:42:51] 10Wikimedia-Fundraising-Banners, 10Wikipedia-Android-App-Backlog (Android Release FY2022-23): Updated message for 2022 English fundraising in Android app - https://phabricator.wikimedia.org/T325691 (10spatton) [21:43:01] 10Wikimedia-Fundraising-Banners, 10Wikipedia-Android-App-Backlog (Android Release FY2022-23): Updated message for 2022 English fundraising in Android app - https://phabricator.wikimedia.org/T325691 (10spatton) Noting that I've updated my original task with new markup for shorter messages in each country. [22:07:06] 10Fundraising-Backlog, 10FR-Japan, 10fr-donorservices: Japan Form Variations for Testing for Q3 - https://phabricator.wikimedia.org/T322793 (10Ejegg) Hi @CDenes_WMF sorry I didn't see the question before. Yes, for the parts of the form that we control (i.e. not the input type of the expiration date) we would... [22:08:29] ok eileen lemme get that on to staging and run again [22:09:28] ooh, that's new: fatal: detected dubious ownership in repository at '/srv/org.wikimedia.civicrm' [22:09:40] though it then says how to work around it [22:10:39] ok, got that pulled down [22:11:29] will now run another batch of 100 [22:12:05] and... exception [22:12:41] RuntimeException: Cannot instantiate malformed locale: en [22:13:02] ug [22:13:21] of course - we fixed those on prod.... [22:13:36] is that a contact with 'en' as their lang & is it still that on prod? [22:13:53] maybe I should run an update to sync langs on staging with prod? [22:14:05] oh yep [22:14:14] let's see, probably fixed on prod [22:15:26] yep, fixed on prod [22:15:29] won't be quick but running [22:15:30] UPDATE civicrm_contact stag INNER JOIN civicrm.civicrm_contact prod ON stag.id = prod.id SET stag.preferred_language = prod.preferred_language ; [22:15:48] sure, sounds good [22:15:50] - I doubt extra filters will speed that up much [22:15:58] so just went with it - my est 30-40 mins [22:37:32] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Look at creating job to clear tmp dir in Civi - https://phabricator.wikimedia.org/T176691 (10Eileenmcnaughton) [22:38:12] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Look at creating job to clear tmp dir in Civi - https://phabricator.wikimedia.org/T176691 (10Eileenmcnaughton) Just noting as of now the oldest file in this dir is Nov 21 06:30 & disk seems cheerful. [22:39:32] I guess we can maybe close this one https://phabricator.wikimedia.org/T239678 - looks like we 'did some stuff' - oh & it's for 2019 BE [22:40:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1202 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdev1001&service=check_mysql [22:41:46] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Deadlocks due to soft credit search/report - https://phabricator.wikimedia.org/T244527 (10Eileenmcnaughton) 05Open→03Resolved a:03Eileenmcnaughton Closing this as at some point we fixed it - the code lines are associated with Bug: T284196 but it loo... [22:45:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1489 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdev1001&service=check_mysql [22:45:31] cstone: we got this fixed didn't we? https://phabricator.wikimedia.org/T277115 [22:45:42] dwisehaupt: ^^ would be a query I'm doing on staging [22:45:53] im going to say yes because i have not seen any emoji chaos in a long time [22:46:07] I'm gonna close it, along with 2019 q speed [22:47:16] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Database can now support emjois but our dedupe script can't - https://phabricator.wikimedia.org/T277115 (10Eileenmcnaughton) 05Open→03Resolved a:03Eileenmcnaughton Pretty sure this got fixed along the way - these stopped & Christine 🚂 has not create... [22:48:13] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Big english queue speeds - https://phabricator.wikimedia.org/T239678 (10Eileenmcnaughton) 05Open→03Resolved a:03Eileenmcnaughton These phabs are kinda year-specific - we look at queue speed every-year so the 2019 one can be resolved [22:48:40] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Japan: clean up name order for Japanese donors in the civi database - https://phabricator.wikimedia.org/T264338 (10Eileenmcnaughton) 05Open→03Resolved a:03Eileenmcnaughton We did this [22:53:49] cstone: last gasp of your train ^^ [22:54:00] eileen: coolthanks. i have ack'd the alert in victorops. [22:54:14] maybe christine 🚂 is why my id is so low [22:54:18] been doinating forever [22:54:18] :-) [22:54:40] ejegg: that update is done now [22:55:18] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 3221422 Threads: 19 Questions: 538514590 Slow queries: 720641 Opens: 2346241194 Flush tables: 1 Open tables: 200 Queries per second avg: 167.166 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 44 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdev1001&service=check_mysql [22:59:41] thanks eileen [22:59:46] will run another batch [23:01:52] So even with the partial batch before we had gotten some with comma-decimals, and they were consistent using that patch [23:02:47] dang [23:03:22] I'll give it a go on my local [23:08:00] ok, the batch ran fine this time [23:08:14] eileen: no, not dang at all, sorry if I was unclear [23:08:45] there were some it_IT emails in the first batch, and the formatting should be e.g. 1,50 [23:09:02] and with that patch it was indeed formatted correctly both in the total and the individual donations [23:09:17] anyway, i'mma spot check a few more from this batch [23:09:22] but so far so good [23:13:43] ejegg: ok - I can +2 then [23:13:48] great :) [23:14:00] (03CR) 10Eileen: [C: 03+2] EOY Email: use correct locale for donation amount [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/870724 (owner: 10Ejegg) [23:20:25] 10Fundraising-Backlog, 10FR-Email: Click-tracking in Acoustic - https://phabricator.wikimedia.org/T316573 (10EWilfong_WMF) Click-tracking for the links.email.wikimedia.org subdomain is available now in Acoustic. Thanks for everyone's help in getting this completed! [23:25:58] (03Merged) 10jenkins-bot: EOY Email: use correct locale for donation amount [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/870724 (owner: 10Ejegg) [23:27:16] (03PS1) 10Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/870735 [23:27:22] (03CR) 10Ejegg: [C: 03+2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/870735 (owner: 10Ejegg) [23:41:41] !log civicrm upgraded from d80f9550 to e3405a4e [23:41:43] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [23:41:55] ok, I'mma head on out of here [23:42:01] have a good break all! [23:47:41] (03CR) 10Ejegg: [C: 04-1] "This is coming along, just a couple more little things to consider" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/868161 (https://phabricator.wikimedia.org/T324271) (owner: 10Wfan) [23:56:29] 10Fundraising Sprint Nyan cats for everyone, 10Fundraising-Backlog, 10fundraising-tech-ops: map out a civicrm.log_% table data expiration/delete strategy - https://phabricator.wikimedia.org/T257232 (10Eileenmcnaughton) I am going through old tickets around this topic & collating links to them. It seems wort...