[00:26:34] (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/928688 [00:26:56] (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/928688 (owner: 10Eileen) [00:28:13] (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/928688 (owner: 10Eileen) [00:29:03] (03PS3) 10Eileen: Data Axle project - List pull from Civi [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928649 (https://phabricator.wikimedia.org/T336891) (owner: 10Wfan) [00:29:16] wfan: that rebase you did was conflicted - I just fixed [00:31:00] !log civicrm upgraded from 6f64e77d to 158896cc [00:31:01] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [00:31:22] (03CR) 10CI reject: [V: 04-1] Data Axle project - List pull from Civi [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928649 (https://phabricator.wikimedia.org/T336891) (owner: 10Wfan) [00:33:02] (03PS4) 10Eileen: Data Axle project - List pull from Civi [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928649 (https://phabricator.wikimedia.org/T336891) (owner: 10Wfan) [00:41:11] 10Fundraising Sprint Highway to Hello World, 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising-Backlog: CT-to-Civi-Phase 2 - drop the drupal contribution_tracking table - https://phabricator.wikimedia.org/T334542 (10Eileenmcnaughton) [00:43:00] 10Fundraising Sprint Highway to Hello World, 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising-Backlog: CT-to-Civi-Phase 2 - drop the drupal contribution_tracking table - https://phabricator.wikimedia.org/T334542 (10Eileenmcnaughton) [00:43:02] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10MediaWiki-extensions-DonationInterface: Move contribution_tracking out of drupal db - https://phabricator.wikimedia.org/T158010 (10Eileenmcnaughton) [00:43:54] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10MediaWiki-extensions-DonationInterface: [Epic] Contribution tracking reform - https://phabricator.wikimedia.org/T158009 (10Eileenmcnaughton) [00:44:02] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising-Backlog, 10Epic: Scope contribution tracking - https://phabricator.wikimedia.org/T182030 (10Eileenmcnaughton) [00:44:54] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Fr-drupal-upgrade-2021: Convert contribution tracking module to an extension - https://phabricator.wikimedia.org/T270665 (10Eileenmcnaughton) [00:45:06] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising-Backlog, 10Epic: Scope contribution tracking - https://phabricator.wikimedia.org/T182030 (10Eileenmcnaughton) [00:46:27] 10Fundraising-Backlog, 10FR-Smashpig: Track more stages of the donation funnel - https://phabricator.wikimedia.org/T149746 (10Eileenmcnaughton) @Ejegg this phab has a 7-year-itch. Do we think it's worth keeping open in it's current state - chances are the intention is captured elsewhere [00:47:25] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising-Backlog, 10Epic: Scope contribution tracking - https://phabricator.wikimedia.org/T182030 (10Eileenmcnaughton) [00:55:16] ok trying to run your upgrade on staging wfan - just kicked it off [00:57:27] thanks eileen! [00:57:58] then we can have the data https://civicrm.wikimedia.org/civicrm/search#/display/Data_Axel_export_contacts [01:01:51] cool! [01:02:03] it's still running - just need to see how slow it is.... [01:05:39] looks like it finished on staging - so about 10 mins [01:06:37] unlike my'quick' one which is still running (the saving grace being low use tables) [01:07:16] is 10 mins acceptable? or we need to merge during manintancnce window? [01:07:55] I think it would be OK if we take queues down & run later in the day - maybe I will do it once you are off - I just need to check the groups created on staging [01:16:10] cool, thanks :) [01:22:57] I'm gonna have to kill my query & try something else :-( [01:23:38] wasn't insane on staging but TBH there was no actual data to update - I just thought the select on prod + the update on staging would 'prove it' [01:32:20] (03CR) 10Eileen: [C: 03+2] "This took about 10 mins on staging & the results look OK to me - unfortunately my Upgrade patch had to be killed so this won't succeed unt" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928649 (https://phabricator.wikimedia.org/T336891) (owner: 10Wfan) [01:34:03] (03PS1) 10Eileen: Fix upgrade to use a temporary table [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928695 (https://phabricator.wikimedia.org/T337051) [01:41:45] ok - so status is [01:41:45] - I +2d wfan's patch BUT [01:41:45] - I had to kill my upgrade cos it was still running & now have a patch in review to upgrade it with the help of a temp table [01:41:46] Unfortunately the issue with my upgrade code is blocking on wfan's [01:45:02] (03Merged) 10jenkins-bot: Data Axle project - List pull from Civi [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928649 (https://phabricator.wikimedia.org/T336891) (owner: 10Wfan) [02:40:05] 10fundraising-tech-ops, 10DC-Ops, 10SRE, 10ops-eqiad: Q3:rack/setup/install frav1003 - https://phabricator.wikimedia.org/T334400 (10Papaul) @Dwisehaupt it looks the server doesn't exist on the switch ` papaul@fasw-c-eqiad# run show interfaces descriptions | match frav100* ge-0/0/17 up up f... [05:28:55] (03CR) 10Wfan: [C: 03+2] Fix upgrade to use a temporary table [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928695 (https://phabricator.wikimedia.org/T337051) (owner: 10Eileen) [05:41:54] (03Merged) 10jenkins-bot: Fix upgrade to use a temporary table [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928695 (https://phabricator.wikimedia.org/T337051) (owner: 10Eileen) [05:48:22] (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/928697 [05:50:06] (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/928697 (owner: 10Eileen) [05:52:43] !log config revision changed from 8b71fa7a to 97c57848 [05:52:43] disable jobs to run update [05:52:44] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [05:53:32] !log civicrm upgraded from 158896cc to 5bbed553 [05:53:34] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [06:01:10] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: DM Appeal Missing in Civi - https://phabricator.wikimedia.org/T337051 (10Eileenmcnaughton) @RLewis I've run that update - hopefully they are back now (I haven't done any QA yet) [06:02:43] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: DM Appeal Missing in Civi - https://phabricator.wikimedia.org/T337051 (10Eileenmcnaughton) OK - I spot checked 1 & he looked OK [06:06:33] !log config 97c57848 -> 6f4a9d19 restart jobs [06:06:34] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [06:07:12] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10Eileenmcnaughton) @AnnWF - I ran that update script [09:29:46] 10Fundraising-Backlog, 10Documentation: Complete Adyen Checkout documentation to include donation statuses for all stages/permutations - https://phabricator.wikimedia.org/T316583 (10Aklapper) a:05AndyRussG→03None Removing inactive task assignee (@ Fundraising: please do so as part of your offboarding steps... [09:29:48] 10Fundraising Sprint Technical debt house of horrors, 10Fundraising-Backlog, 10fundraising sprint Parallel processing roller coaster, 10fundraising sprint Quantum Leapfrog, and 3 others: Catch Adyen Checkout API errors on the DI side - https://phabricator.wikimedia.org/T288830 (10Aklapper) a:05AndyRussG→... [09:30:06] 10Fundraising-Backlog, 10MediaWiki-extensions-CentralNotice, 10Patch-For-Review, 10Security, 10User-revi: &banner causes CSP warning - https://phabricator.wikimedia.org/T199055 (10Aklapper) a:05AndyRussG→03None Removing inactive task assignee (@ Fundraising: please do so as part of your offboarding s... [11:44:35] (03PS6) 10Damilare Adedoyin: Handle submission of new recurring upgrade form [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/928066 (https://phabricator.wikimedia.org/T335796) [12:57:47] 10fundraising-tech-ops, 10Infrastructure Security, 10Infrastructure-Foundations: Migrate jgreen out of the ops group and into the fr-tech-admins group - https://phabricator.wikimedia.org/T336231 (10Jgreen) Re. Fundraising exim mail aliases, I started the process to migrate those to GSuite here T338607. [13:42:51] (03PS1) 10Damilare Adedoyin: White list RecurUpgrade Special Page in Email Pref Center [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/928847 [14:10:08] 10Fundraising Sprint Technical debt house of horrors, 10Fundraising-Backlog, 10fundraising sprint Parallel processing roller coaster, 10fundraising sprint Quantum Leapfrog, and 3 others: Catch Adyen Checkout API errors on the DI side - https://phabricator.wikimedia.org/T288830 (10AKanji-WMF) @Cstone do you... [14:29:35] 10fundraising-tech-ops, 10FR-Email: Update Acoustic Unsubscribe landing page domain to be served by a secure wikimedia.org domain - https://phabricator.wikimedia.org/T336000 (10EWilfong_WMF) @Dwisehaupt - thank you for the DNS update. Here is the CSR that can be used to generate the certificate. -----BEGIN C... [15:14:38] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Jgreen) [15:19:39] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Jgreen) [15:22:37] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Jgreen) [15:37:30] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Jgreen) [15:45:08] awww [15:46:29] AndyRussG|vol: indeed [15:47:39] Jeff_Green: ehh welp so it goes ;) thanks for dealing with all that [15:48:18] it feels almost like I've graduated from High School or University hehe [15:50:18] :) [15:50:27] yeah, sorry you have to see all the notifications on top of everything [15:51:44] uff, just got a call from my daughter who is at school and not feeling well so I've gotta go fetch her, back in a bit [16:02:42] Jeff_Green: hope she feels better soon!! also it's actually fine, and also thanks so much for the sympathy and support! [16:07:53] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Fr-drupal-upgrade-2021: Determine maturity of Civi-standalone - https://phabricator.wikimedia.org/T337337 (10XenoRyet) [16:35:20] PROBLEM - check_puppetrun on civi1001 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 3 minutes ago with 1 failures. Failed resources (up to 3 shown): User[andyrussg] https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=civi1001&service=check_puppetrun [16:39:03] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10AnnWF) >>! In T336891#8917006, @Eileenmcnaughton wrote: > @AnnWF - I ran that update script Thanks Eileen! The final version I have download... [16:40:20] RECOVERY - check_puppetrun on civi1001 is OK: OK: Puppet is currently enabled, last run 27 seconds ago with 0 failures https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=civi1001&service=check_puppetrun [16:51:53] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Jgreen) [17:14:10] (03PS1) 10Damilare Adedoyin: Update RecurringQueueConsumer to handle donation upgrades [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928885 (https://phabricator.wikimedia.org/T335827) [17:19:02] (03PS7) 10Damilare Adedoyin: Handle submission of new recurring upgrade form [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/928066 (https://phabricator.wikimedia.org/T335796) [17:19:09] (03CR) 10CI reject: [V: 04-1] Update RecurringQueueConsumer to handle donation upgrades [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928885 (https://phabricator.wikimedia.org/T335827) (owner: 10Damilare Adedoyin) [17:20:01] (03PS10) 10Damilare Adedoyin: Create recurring upgrade form [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/927178 (https://phabricator.wikimedia.org/T335795) [17:20:10] (03CR) 10CI reject: [V: 04-1] Handle submission of new recurring upgrade form [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/928066 (https://phabricator.wikimedia.org/T335796) (owner: 10Damilare Adedoyin) [17:20:12] (03PS8) 10Damilare Adedoyin: Handle submission of new recurring upgrade form [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/928066 (https://phabricator.wikimedia.org/T335796) [17:22:10] (03CR) 10jenkins-bot: Handle submission of new recurring upgrade form [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/928066 (https://phabricator.wikimedia.org/T335796) (owner: 10Damilare Adedoyin) [17:23:15] (03PS2) 10Damilare Adedoyin: Update RecurringQueueConsumer to handle donation upgrades [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928885 (https://phabricator.wikimedia.org/T335827) [17:23:52] (03PS11) 10Damilare Adedoyin: Create recurring upgrade form [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/927178 (https://phabricator.wikimedia.org/T335795) [17:24:01] (03CR) 10CI reject: [V: 04-1] Update RecurringQueueConsumer to handle donation upgrades [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928885 (https://phabricator.wikimedia.org/T335827) (owner: 10Damilare Adedoyin) [17:26:23] (03CR) 10Damilare Adedoyin: "recheck" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/928885 (https://phabricator.wikimedia.org/T335827) (owner: 10Damilare Adedoyin) [17:27:14] 10Fundraising-Backlog, 10IP Masking, 10MediaWiki-extensions-CentralNotice: Update Fundraising Tech-owned products that may be affected by IP Masking - https://phabricator.wikimedia.org/T326943 (10greg) >>! In T326943#8703087, @Ejegg wrote: > Still, we should raise these questions to the rest of the fundraisi... [18:15:51] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Jgreen) [18:19:03] damilare: did you still want to talk about that recurring id? [18:28:41] hey cstone, I'm just wrapping up for the day. Could we do Monday instead? thanks! [18:29:15] yeah no worries at all I know its late there! have a good weekend [18:29:17] damilare: ^ [18:29:27] thanks Christin! [18:29:35] Christine* [18:43:43] (03PS12) 10Wfan: Clean payment submethods and add missing payment images [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/911839 (https://phabricator.wikimedia.org/T335388) [18:47:24] (03PS1) 10Wfan: Update carnet from carnet_credit [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/928894 (https://phabricator.wikimedia.org/T335388) [18:47:48] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Dwisehaupt) [18:59:19] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Dwisehaupt) [19:05:34] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10AndyRussG_volunteer) Heyy thanks for all this work! > [x] superset Hmmm quick question: might it still be possible/worthwhile to preserve the experimental seasonality dashboard on Advancement Su... [19:07:48] (03PS13) 10Wfan: Clean payment submethods and add missing payment images [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/911839 (https://phabricator.wikimedia.org/T335388) [19:12:16] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10Dwisehaupt) @AndyRussG_volunteer The dashboard is still in place. All that we have done is disabled your account access. Thanks for bringing it up. [19:13:48] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: DM Appeal Missing in Civi - https://phabricator.wikimedia.org/T337051 (10MDemosWMF) @Eileenmcnaughton I'm not seeing the Annual Fund Appeal 2022 - Mailing DMA in the drop down as a selection [19:17:45] (03PS14) 10Wfan: Clean payment submethods and add missing payment images [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/911839 (https://phabricator.wikimedia.org/T335388) [19:19:26] 10fundraising-tech-ops: Deactivate fundraising accounts for andyrussg - https://phabricator.wikimedia.org/T338075 (10AndyRussG_volunteer) >>! In T338075#8919302, @Dwisehaupt wrote: > @AndyRussG_volunteer The dashboard is still in place. All that we have done is disabled your account access. Thanks for bringing i... [19:36:49] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10MDemosWMF) Thanks @AnnWF and @Eileenmcnaughton! Just want to confirm we have all of the 6 segments I listed above included in the list. I see... [20:17:38] (03CR) 10Cstone: [C: 03+2] Update carnet from carnet_credit [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/928894 (https://phabricator.wikimedia.org/T335388) (owner: 10Wfan) [20:18:12] (03Merged) 10jenkins-bot: Update carnet from carnet_credit [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/928894 (https://phabricator.wikimedia.org/T335388) (owner: 10Wfan) [20:18:28] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Adyen Audit - manually settled transactions not being imported into civi with the nightly audit file - https://phabricator.wikimedia.org/T325415 (10Cstone) a:05AnnWF→03Cstone [21:04:17] (03PS15) 10Wfan: Clean payment submethods and add missing payment images [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/911839 (https://phabricator.wikimedia.org/T335388) [21:28:46] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10AnnWF) Hi @MDemosWMF, Eileen already run the upgrade on production so segment 1 and 6 also got contacts imported therefore all 6 segments ar... [21:49:02] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10MDemosWMF) Great, that sounds good. Could we also include the CID as a field in the export? I would like to wait for @ERoden-WMF to sign-off... [22:14:20] 10Fundraising Sprint Last Christmas I gave you my donation, 10Fundraising-Backlog: Data Axle project - List pull from Civi - https://phabricator.wikimedia.org/T336891 (10AnnWF) >>! In T336891#8919904, @MDemosWMF wrote: > Great, that sounds good. Could we also include the CID as a field in the export? I would l... [23:15:42] wfan: just read the back & forth on the Data export - good work - looks like you have it pretty close to sorted [23:18:34] eileen, yeah, needs to get the final sign off, just the download spreadsheet very slow, still processing, what do we usually do, like break them down to different batches? [23:19:01] so the download spreadsheet IS working? just slow? [23:22:05] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: DM Appeal Missing in Civi - https://phabricator.wikimedia.org/T337051 (10Eileenmcnaughton) @MDemosWMF this is one of the contacts we re-added it to - https://civicrm.wikimedia.org/civicrm/contact/view/contribution?reset=1&action=update&id=80415917&cid=192... [23:22:09] Downloading... for like 1+ hr is that normal? [23:24:25] yeah - it's a lot of rows - if it actually does get there then that's prob not worth putting more dev time into - I have a feeling a patch was merged upstream to speed that up though [23:31:07] I am just open that tab and see if it will done today, and it's would be nice to have a upstream patch to speed up this, if we do not have that patch probably worth a phab ticket haha [23:43:40] yeah - I mean we will get it next upgrade anyway if it is merged upstream -