[00:55:35] eileen: maybe not, i will get that hooked up tomorrow [00:55:59] cwd ok cool [02:25:35] (PS1) Eileen: Stock CiviCRM 5.6 as at commit 0ab5c4c [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/457782 [02:25:37] (PS1) Eileen: Apply our patches to 5.6 rc [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/457783 [04:04:45] (PS1) Eileen: Add Caching to Civitoken [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457803 (https://phabricator.wikimedia.org/T202446) [04:19:32] (CR) Eileen: "As an aside - there is no difference in speed between this & current civi from my testing" [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/457783 (owner: Eileen) [04:19:44] (PS2) Ejegg: WIP: Opt-in queue consumer [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/456517 (https://phabricator.wikimedia.org/T200576) [04:23:54] (CR) jerkins-bot: [V: -1] WIP: Opt-in queue consumer [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/456517 (https://phabricator.wikimedia.org/T200576) (owner: Ejegg) [04:34:30] (PS1) Eileen: WIP try a shorter trigger range [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457805 [04:41:33] (CR) jerkins-bot: [V: -1] WIP try a shorter trigger range [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457805 (owner: Eileen) [04:45:50] (PS1) Eileen: WIP try no triggers [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457807 [04:52:28] (CR) jerkins-bot: [V: -1] WIP try no triggers [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457807 (owner: Eileen) [06:11:59] Fundraising Sprint Queue is pronounced GJif, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: investigate if year summary field are slowing queue - https://phabricator.wikimedia.org/T202446 (Eileenmcnaughton) Am doing performance testing - it got derailed by silverpop job sta... [06:13:28] (PS1) Eileen: WIP hack custom php data return [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457817 [06:18:41] (CR) jerkins-bot: [V: -1] WIP hack custom php data return [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457817 (owner: Eileen) [06:24:24] (CR) Eileen: "It's a typo - you would have spotted it in 2 seconds after a break from your screen" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/456517 (https://phabricator.wikimedia.org/T200576) (owner: Ejegg) [09:44:17] Fundraising-Backlog: icingawm is missing from #wikimedia-fundraising channel - https://phabricator.wikimedia.org/T202314 (elukey) Not super familiar with IRC so I am going to ask forgiveness in advance for the stupid questions :) I am trying to make `icinga-vm` re-join #wikimedia-analytics, but I don't have... [10:19:59] Fundraising-Backlog: icingawm is missing from #wikimedia-fundraising channel - https://phabricator.wikimedia.org/T202314 (elukey) Found a way to +e *!*@einsteinium.wikimedia.org, and then restarted ircecho, worked :) Thanks to @Paladox for the help! [10:21:07] Fundraising-Backlog: icingawm is missing from #wikimedia-fundraising channel - https://phabricator.wikimedia.org/T202314 (Paladox) probably want to whitelist the other icinga-wm host too in case it's switched over. [11:14:27] (Abandoned) Zfilipin: WIP The first sample Selenium test in Node.js [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/443093 (https://phabricator.wikimedia.org/T180223) (owner: Zfilipin) [12:48:34] Fundraising-Backlog, fundraising-tech-ops: Test Redis caching on Civi staging - https://phabricator.wikimedia.org/T202936 (Jgreen) >>! In T202936#4553935, @Ejegg wrote: > @cwdent or @Jgreen, looks like we'll need php-redis installed on all the civi boxen to make this work Done! [13:40:51] morningsies! [14:01:51] hi fr-tech did you figure out the hosted checkout id bug yesterday [14:01:58] it may have been my patch... [14:17:22] mepps it happened before we deployed your patch [14:17:53] oh okay i read the chats as if it was right after--then i got disconnected from irc [14:18:28] ah [14:18:50] i'd guess it's repated to the empty POSTs [14:18:57] *related [14:19:15] but I haven't looked into either [14:21:14] hey mepps, sorry I couldn't reply before the car hire firm I'm using in cyprus called and it was a bad line [14:21:22] hey ejegg, AndyRussG :) [14:21:27] no problem jgleeson [14:21:29] jgleeson: :) [14:21:48] hi jgleeson, AndyRussG [14:21:56] ;) [14:22:05] jgleeson: so, no car? :( [14:22:12] I guess better it's a bad line than a bad car [14:22:51] unless it's a brake line [14:22:54] Ah they called [14:22:57] I think we've got one... the car I booked is no longer available so I had to switch to another car [14:23:13] car hire is super expensive! [14:23:13] upgrade? [14:23:13] mmm... good luck! [14:23:19] yeah it is [14:23:31] unfortunately not ejegg, downgrade actually but should be good enough! [14:23:55] cyprus hire companies don't seem to have the typical sales mentality [14:24:16] it's pretty much, you're lucky you're getting one that starts [14:24:20] :) [14:24:30] heh, oh man. [14:24:56] i guess being an island they have plenty of salt air to corrode the old cars [14:25:26] we've got a lot of luggage so originally I was asking for something like an SUV or similar with good space but they just told me there's now none available (after I booked it..) but they've got a people carrier bus thing we can use [14:25:31] so not a lot of cheap beaters on the market [14:26:14] so I guess I could make up some of the fee by offering a taxi ride from the airport in the 7 seater we're gonna get... considering there's only 3 of us :) [14:26:27] heh [14:27:01] https://grafana.wikimedia.org/dashboard/db/frtechmail-dashboard?orgId=1&from=now%2Fw&to=now [14:27:24] i am thinking the increase() function is not the best choice for "sporadic" problems [15:01:09] Wikimedia-Fundraising, Security-Team, Goal: Goal: Security engineering support for FrTech PCI - https://phabricator.wikimedia.org/T109086 (chasemp) Open>declined [15:18:55] Fundraising-Backlog: test and deploy payments-listener Debian Stretch / PHP 7 - https://phabricator.wikimedia.org/T197887 (Jgreen) [15:22:21] Fundraising-Backlog, fundraising-tech-ops: Can I get a DB refresh on staging - https://phabricator.wikimedia.org/T203205 (cwdent) Open>Resolved [15:23:41] Fundraising-Backlog, fundraising-tech-ops: Doc update: probably delete this page - https://phabricator.wikimedia.org/T198739 (cwdent) Open>declined Not getting traction at this time [15:26:18] Fundraising-Backlog, fundraising-tech-ops: Re-activate staging access for Adam - https://phabricator.wikimedia.org/T198347 (cwdent) The project is done, shall we remove this access? [15:27:44] (CR) Ejegg: [C: -1] "Looks like 3 files are duplicated here" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457702 (owner: Eileen) [15:27:57] (PS2) Ejegg: Disable globalcollect_audit (& uninstall) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457732 (owner: Eileen) [15:28:08] (CR) Ejegg: [C: 2] "Thanks!" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457732 (owner: Eileen) [15:30:18] Fundraising-Backlog, fundraising-tech-ops: fundraising monitoring fixes (EPIC) - https://phabricator.wikimedia.org/T197892 (cwdent) [15:31:08] fundraising-tech-ops, monitoring, Epic: [Epic] overhaul fundraising cluster monitoring - https://phabricator.wikimedia.org/T91508 (cwdent) [15:31:09] Fundraising-Backlog, fundraising-tech-ops: Fundraising queues missing prometheus data since 4/26 - https://phabricator.wikimedia.org/T193456 (cwdent) Open>Resolved a:cwdent Looks like this was fixed around 7/1 [15:32:33] Fundraising-Backlog, Security-Data-Mapping, Documentation: FR Tech Data Map - https://phabricator.wikimedia.org/T133236 (chasemp) Open>declined Based on age and activity I'm closing, please reopen if that is incorrect :) [15:34:09] Fundraising-Backlog, fundraising-tech-ops: Enable Content Security Policy on payments-wiki and donate-wiki - https://phabricator.wikimedia.org/T190183 (cwdent) p:Normal>High Bumping priority because it seems likely payments on Debian 9 is going to fail PCI scans the same way the listener did in T... [15:35:16] (Merged) jenkins-bot: Disable globalcollect_audit (& uninstall) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457732 (owner: Eileen) [15:35:50] (CR) Ejegg: [C: -1] "Breaks behavior when config setting not set" (1 comment) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457803 (https://phabricator.wikimedia.org/T202446) (owner: Eileen) [17:02:32] fundraising-tech-ops: replace betelgeuse, for it is ancient - https://phabricator.wikimedia.org/T203484 (Jgreen) [17:03:25] Fundraising-Backlog, fundraising-tech-ops: Re-activate staging access for Adam - https://phabricator.wikimedia.org/T198347 (awight) @cwdent Please do :-) [17:17:17] PROBLEM - check_puppetrun on frdev1001 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 5 minutes ago with 1 failures. Failed resources (up to 3 shown): User[awight] [17:22:17] RECOVERY - check_puppetrun on frdev1001 is OK: OK: Puppet is currently enabled, last run 1 minute ago with 0 failures [18:42:05] PROBLEM - Host frpig1001 is DOWN: CRITICAL - Network Unreachable (208.80.155.15) [18:43:39] hey AndyRussG, would now be a good time to have a quick chat about FRUEC related things :) ? [18:46:12] jgleeson: mmmm maybeeee [18:46:22] I kinda was hoping to finish a couple things before sprink planning.... [18:46:40] maybe afterwards then if that works for you? [18:46:55] jgleeson: ok....! that's a bit late for you tho? [18:47:03] tomorrow morning also works.... [18:47:14] I'm just finishing up the inline documentation and comments [18:47:25] so actually the main scripts will be ready for review! [18:48:30] Fundraising-Backlog: test and deploy payments-listener Debian Stretch / PHP 7 - https://phabricator.wikimedia.org/T197887 (ayounsi) [18:48:33] ummm I'm around until 10 my time but yeah we might more time. Tomorrow works for me too [18:49:04] I'll push up the latest patch working for landing pages [18:49:28] and then we can discuss the combined tomorrow :) [18:49:49] btw, I've been testing FRUEC myself and everything has been working for me [18:50:06] e.g. new landing page stuff and cli args [18:50:40] jgleeson: ah ok great! [18:50:42] cool! [18:51:37] this is the change, right? https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/FRUEC/+/456016/ [18:55:01] no, that's not the latest version. I'll push now [18:55:03] sorry! [18:57:35] fundraising-tech-ops: replace betelgeuse, for it is ancient - https://phabricator.wikimedia.org/T203484 (Jgreen) [18:58:05] jgleeson: ah no worries... but I mean, I'll look for the new stuff there, no? [18:58:14] yep! [18:58:44] ok cool thx!! [19:00:55] (PS3) Ejegg: WIP: Opt-in queue consumer [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/456517 (https://phabricator.wikimedia.org/T200576) [19:02:30] RECOVERY - Host frpig1001 is UP: PING OK - Packet loss = 0%, RTA = 0.34 ms [19:03:46] (PS5) Jgleeson: Backend Stats Comparison Script [wikimedia/fundraising/FRUEC] - https://gerrit.wikimedia.org/r/456016 (https://phabricator.wikimedia.org/T198752) [19:04:56] hmm looks like my own help text needs updaring [19:04:59] updating [19:08:36] (CR) jerkins-bot: [V: -1] WIP: Opt-in queue consumer [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/456517 (https://phabricator.wikimedia.org/T200576) (owner: Ejegg) [19:13:11] Fundraising-Backlog: Renew ccogdill's civicrm SSL cert - https://phabricator.wikimedia.org/T203495 (CCogdill_WMF) [19:13:25] Fundraising-Backlog: Renew ccogdill's civicrm SSL cert - https://phabricator.wikimedia.org/T203495 (CCogdill_WMF) p:Triage>Normal [19:20:08] (PS6) Jgleeson: Backend Stats Comparison Script [wikimedia/fundraising/FRUEC] - https://gerrit.wikimedia.org/r/456016 (https://phabricator.wikimedia.org/T198752) [19:30:47] (PS3) AndyRussG: Inline doc and comments [wikimedia/fundraising/FRUEC] - https://gerrit.wikimedia.org/r/457275 (https://phabricator.wikimedia.org/T195594) [19:38:15] Fundraising Sprint Queue is pronounced GJif, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Fix blank no_thank_you - https://phabricator.wikimedia.org/T97684 (Ejegg) Open>Resolved [19:39:37] Fundraising Sprint Queue is pronounced GJif, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Default value for no_thank_you on "New Contribution" UI - https://phabricator.wikimedia.org/T202415 (Ejegg) Open>Resolved [19:39:55] Fundraising Sprint Queue is pronounced GJif, Fundraising-Backlog, MW-1.32-release-notes (WMF-deploy-2018-08-28 (1.32.0-wmf.19)), Patch-For-Review: Donation form does not save revised email address after card # entered - https://phabricator.wikimedia.org/T201962 (Ejegg) Open>Resolved [19:45:26] Fundraising-Backlog, Epic: Update EventLogging schema for CentralNotice - https://phabricator.wikimedia.org/T203499 (AndyRussG) p:Triage>Normal [19:46:25] (PS2) Eileen: Move tivy theme out of drupal managed themes dir (needs drupal patch at same time [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457702 [19:47:08] (CR) Eileen: "ejegg fixed" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457702 (owner: Eileen) [19:52:44] Fundraising-Backlog, Epic: Investigate missing country and language fields on LandingPage events. - https://phabricator.wikimedia.org/T203501 (AndyRussG) p:Triage>Normal [19:56:41] (PS2) Eileen: Add Caching to Civitoken [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457803 (https://phabricator.wikimedia.org/T202446) [19:57:20] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/457980 [19:57:49] (CR) Ejegg: [C: 2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/457980 (owner: Ejegg) [19:57:55] (CR) Eileen: "good spotting ejegg - fixed" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457803 (https://phabricator.wikimedia.org/T202446) (owner: Eileen) [20:00:34] (Merged) jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/457980 (owner: Ejegg) [20:02:47] Fundraising-Backlog, fundraising-tech-ops: Enable Content Security Policy on payments-wiki and donate-wiki - https://phabricator.wikimedia.org/T190183 (Ejegg) We should be able to get the full list of external domains and resources nailed down. [20:05:18] !log updated CiviCRM from 1330df3064 to 7bde3d0ab2 [20:05:22] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [20:10:57] Fundraising Sprint Gravity wasn't always this pushy, Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint Junebugs prefer July, and 9 others: Ingenic... - https://phabricator.wikimedia.org/T190098 [20:11:19] Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Owls, and 3 others: DB schemas (production changes and test DB) and SQL commands ... - https://phabricator.wikimedia.org/T196564 [20:11:52] Fundraising Sprint Pluto is still a planet, Fundraising-Backlog, Fr-Ingenico-integration_2017-18: implement IDEAL in new ingenico integration - https://phabricator.wikimedia.org/T201626 (DStrine) [20:12:14] !log rolled CiviCRM back to 1330df3064 [20:12:18] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [20:16:04] Fundraising Sprint Gravity wasn't always this pushy, Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint Junebugs prefer July, and 9 others: Ingenic... - https://phabricator.wikimedia.org/T190098 [20:17:59] Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Naming Sprints Is Not Important, and 9 others: Create Ingenico orphan rectifier m... - https://phabricator.wikimedia.org/T163949 [20:20:36] (CR) Ejegg: [C: 2] Add Caching to Civitoken [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457803 (https://phabricator.wikimedia.org/T202446) (owner: Eileen) [20:20:53] (PS3) Ejegg: Add Caching to Civitoken [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457803 (https://phabricator.wikimedia.org/T202446) (owner: Eileen) [20:21:36] Fundraising-Backlog, fundraising-tech-ops: Renew ccogdill's civicrm SSL cert - https://phabricator.wikimedia.org/T203495 (DStrine) [20:23:17] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Unable to make edits from Summary Screen - https://phabricator.wikimedia.org/T203266 (DStrine) [20:27:34] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Activities tab- multi select option for exclude filter - https://phabricator.wikimedia.org/T203057 (DStrine) [20:28:11] Fundraising-Backlog: Pre form help option - https://phabricator.wikimedia.org/T203056 (Eileenmcnaughton) We deployed an update yesterday from upstream - can you check it now @NNichols [20:32:24] Fundraising-Backlog, Fr-CentralNotice-Caching, MediaWiki-extensions-CentralNotice: CentralNotice: Occasional unexplained missing banner messages - https://phabricator.wikimedia.org/T158261 (DStrine) [20:37:37] Fundraising Sprint R 2018, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Unable to make edits from Summary Screen - https://phabricator.wikimedia.org/T203266 (DStrine) [20:37:39] Fundraising Sprint R 2018, Fundraising-Backlog, Fr-Ingenico-integration_2017-18, Recurring-Donations: Ingenico Recurring: Card rejection is not a cause for failmail - https://phabricator.wikimedia.org/T203291 (DStrine) [20:37:41] Fundraising Sprint R 2018, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi: did script delete a contact's email address? - https://phabricator.wikimedia.org/T203198 (DStrine) [20:37:43] Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Owls, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, and 3 others: Investigate why Ingenico donation did not recur on 6/14 - https://phabricator.wikimedia.org/T199331 (DStrine) [20:37:45] Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, Fundraising-Backlog, Unplanned-Sprint-Work: Inserting Images into Civi mail - https://phabricator.wikimedia.org/T202330 (DStrine) [20:37:47] Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: investigate if year summary field are slowing queue - https://phabricator.wikimedia.org/T202446 (DStrine) [20:37:50] Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Banner previews occasionally fail to load - https://phabricator.wikimedia.org/T200853 (DStrine) [20:37:52] Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Corporate Gift selection for Engage instance - https://phabricator.wikimedia.org/T201883 (DStrine) [20:37:54] Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Thank You email for Stripe Import - https://phabricator.wikimedia.org/T202099 (DStrine) [20:37:56] Fundraising Sprint Owls, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, and 2 others: Import log files not including all skipped rows - https://phabricator.wikimedia.org/T200031 (DStrine) [20:37:58] Fundraising Sprint Fhabricator is spelled with an "F", Fundraising Sprint Gravity wasn't always this pushy, Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Ivory and eggshell white are the same color, and 10 o... - https://phabricator.wikimedia.org/T189613 [20:38:00] Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Naming Sprints Is Not Important, and 6 others: New scripts to ingress data from K... - https://phabricator.wikimedia.org/T195594 [20:38:03] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Bermuda Rhombus (where things disappear then reappear), Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, and 1... - https://phabricator.wikimedia.org/T178930 [20:38:05] Fundraising Sprint Owls, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, and 3 others: slow anonymous save - https://phabricator.wikimedia.org/T199753 (DStrine) [20:38:07] Fundraising Sprint Gravity wasn't always this pushy, Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint Junebugs prefer July, and 10 others: Ingenic... - https://phabricator.wikimedia.org/T190098 [20:38:09] Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, Fundraising-Backlog, Wikimedia-log-errors: ErrorException from line 79 of FundraisingMessageGroup.php: PHP Warning: Invalid argument: function: not a valid callback array - https://phabricator.wikimedia.org/T202579 (DStrine) [20:38:11] Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Owls, and 4 others: DB schemas (production changes and test DB) and SQL commands ... - https://phabricator.wikimedia.org/T196564 [20:38:13] Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Owls, and 4 others: Write a specification for mapping banner/landing page impressi... - https://phabricator.wikimedia.org/T196563 [20:38:16] Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, Fundraising-Backlog, MediaWiki-extensions-DonationInterface, Patch-For-Review: Use Composer merge plugin for payments-wiki - https://phabricator.wikimedia.org/T185547 (DStrine) [20:38:18] Fundraising Sprint R 2018, Fundraising-Backlog, Epic: Update EventLogging schema for CentralNotice - https://phabricator.wikimedia.org/T203499 (DStrine) [20:38:20] Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, Fundraising-Backlog, and 2 others: Create opt-IN page for fundraisingEmailUnsubscribe, consume messages - https://phabricator.wikimedia.org/T200576 (DStrine) [20:38:22] Fundraising Sprint Owls, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, and 2 others: Queries and maybe scripts to verify equivalence of data in new-Kafka-pipeline-testing and pgehres prod... - https://phabricator.wikimedia.org/T198752 [20:38:25] Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, Fundraising-Backlog, and 3 others: Deal with Ingenico Connect code 300620: MerchantReference XXXX already exists - https://phabricator.wikimedia.org/T201773 (DStrine) [20:38:27] Fundraising Sprint Owls, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, and 2 others: Mailing data double counting in CiviCRM? - https://phabricator.wikimedia.org/T200240 (DStrine) [20:38:29] Fundraising Sprint Owls, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint R 2018, and 3 others: civi: report filter for total USD within a time period - https://phabricator.wikimedia.org/T151271 (DStrine) [20:38:31] Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Naming Sprints Is Not Important, and 10 others: Create Ingenico orphan rectifier ... - https://phabricator.wikimedia.org/T163949 [21:01:34] (PS7) Jgleeson: WIP: Backend Stats Comparison Script [wikimedia/fundraising/FRUEC] - https://gerrit.wikimedia.org/r/456016 (https://phabricator.wikimedia.org/T198752) [21:10:00] (PS8) Jgleeson: WIP: Backend Stats Comparison Script [wikimedia/fundraising/FRUEC] - https://gerrit.wikimedia.org/r/456016 (https://phabricator.wikimedia.org/T198752) [21:11:02] g'night fr-tech! [21:13:59] Just looking at the sprint & we have this phab about the inline images - https://phabricator.wikimedia.org/T202330 - in the done column. I feel later converstations took place & we can maybe close or should I check with Nora [21:14:35] Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Raw data can give you salmonella, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: FY17-18 total not reflected in WMF Donor section - https://phabricator.wikimedia.org/T202102 (Eileenmcnaughton) @LeanneS is this OK to close? [21:15:08] Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Raw data can give you salmonella, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Corporate Gift selection for Engage instance - https://phabricator.wikimedia.org/T201883 (Eileenmcnaughton) @LeanneS is this... [21:52:47] Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Raw data can give you salmonella, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Corporate Gift selection for Engage instance - https://phabricator.wikimedia.org/T201883 (LeanneS) @Eileenmcnaughton Yep! Tha... [22:09:03] Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Raw data can give you salmonella, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: Corporate Gift selection for Engage instance - https://phabricator.wikimedia.org/T201883 (Eileenmcnaughton) Open>Resol... [22:11:28] I just did drush cvapi System.flush on live - hopefully that will kill those failmails on omnimail [22:25:10] Fundraising-Backlog: test and deploy payments-listener Debian Stretch / PHP 7 - https://phabricator.wikimedia.org/T197887 (Jgreen) [22:25:17] Fundraising-Backlog: test and deploy payments-listener Debian Stretch / PHP 7 - https://phabricator.wikimedia.org/T197887 (Jgreen) this is done! [22:31:05] fundraising-tech-ops, Operations, ops-eqiad: decommission thulium.frack.eqiad.wmnet - https://phabricator.wikimedia.org/T203520 (Jgreen) [22:33:32] fundraising-tech-ops: rename saiph.frack.codfw.wmnet to frpig2001.frack.codfw.wmnet and reimage with Debian Stretch - https://phabricator.wikimedia.org/T203521 (Jgreen) [22:46:51] eileen: oops, I had only done a drush cc all. thanks for that! [22:47:18] ejegg: I’m not seeing what I want to see perf-wise on Redis :-( https://docs.google.com/spreadsheets/d/15-nE-TNcicO64HcioutKMhTHypeS6EHJQFHpadKIZk4/edit#gid=0 [22:55:15] looking [22:56:06] oh jeez, worse than db caching? [22:58:37] eileen: how bout if we comment out the lastDonation stuff in wmf_civicrm.module 3445--3449 [22:58:41] ? [22:58:55] ejegg: yeah I’ll try that & triggers but they are not duplicates [22:59:12] I also wonder if we can improve Redis caching performance ‘somehow’ [23:00:17] ah, the triggers are doing something different for the last donation date / amount / currency? [23:00:48] oh, the triggers would only work for USD, right? [23:00:48] yeah it’s an issue around what is in what table [23:01:01] the good thing is the tests are valid whatever way we go [23:01:20] big jump hacking out that line though [23:02:23] shoot. We could use the triggers for USD and the php for other currencies, I guess [23:03:01] I think it’s more about joining on another table - but I think maybe the triggers could unpack ‘source’ rather than php doing that & then writing to a different table & us picking that up [23:03:35] yeah, that sounds worth pursuing [23:07:55] (CR) Eileen: "Triggers look like" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/457805 (owner: Eileen) [23:08:58] I’m trying tinkering on the triggers now [23:09:22] we have to bear in mind that donor data makes up some percentage of the data we are storing so it should have some cost [23:12:42] well, that php totals line does look pretty expensive [23:22:16] ejegg: yeah [23:22:44] my gut says Redis ‘can do better’ than it has in my initial efforts [23:23:04] just looking at the query log, the drupal registry traffic is overwhelming. would be nice to put that in redis! [23:23:17] hmm interesting [23:23:23] I was gonna look at query log too [23:23:59] trying to find a balance between doing what needs doing before code freeze & not going too far down this since I think David has other priorities [23:24:35] right, i'm just afraid of what'll happen if we get to thanksgiving with the same kind of queue backups we've been seeing in the one hour tests [23:24:56] (and really hoping there would be some silver bullet in the caching!) [23:30:26] (PS1) Eileen: Try campaigns no watchdog(wip) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/458078 [23:32:17] Hmm, it would be great to be able to suppress the "UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.contact_id" that happens after each related-table insert [23:33:00] ejegg: yeah - we maybe can but if you look in the s/sheet that is def down the list on impact [23:33:56] ah, you already tried that? [23:34:05] actually no now I htink about it [23:34:15] I tried ‘no logging’ but I think that still survives [23:34:22] I can try a more thorough no logging [23:37:23] ejegg: did you deploy that update from earlier today? [23:37:47] ah, I did, then I rolled it back since we got a mysterious failmail. [23:37:55] Let me try re-deploying [23:39:38] oh yeah - on the call [23:40:21] ooh, we're duplicating the insert into wmf_contribution_extra for some reason [23:41:03] that can't help [23:44:28] !log updated civicrm from 1330df3064 to 7bde3d0ab2 [23:44:32] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log