[00:05:30] (PS9) Eileen: Add api & test for target smart import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/530976 [00:06:54] I've got to run an errand, but I promise I'll review that import later! [00:08:46] (PS10) Eileen: Add api & test for target smart import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/530976 [01:19:58] (PS11) Eileen: Add api & test for target smart import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/530976 [02:29:22] Fundraising Sprint Princess Mongodb, Fundraising Sprint Quick and the Deadlocked, Fundraising-Backlog, FR-Ingenico, and 2 others: Legacy GlobalCollect: don't generate order IDs starting with 4 or 7 - https://phabricator.wikimedia.org/T230809 (Ejegg) p:Triage→High a:Ejegg [02:32:20] Fundraising Sprint Quick and the Deadlocked, Fundraising-Backlog, Patch-For-Review: Contribution Recur records created via updonate should attach to original contact - https://phabricator.wikimedia.org/T230744 (Ejegg) p:Triage→Normal a:Ejegg [02:52:30] Fundraising Sprint Quick and the Deadlocked, Fundraising-Backlog: Create new error page for payment cancel, restyle Ingencio hosted cancel button - https://phabricator.wikimedia.org/T224063 (Ejegg) p:Triage→Normal [02:59:47] Fundraising Sprint Quick and the Deadlocked, Fundraising-Backlog, Wikimedia-Fundraising, MediaWiki-extensions-DonationInterface, Accessibility: Labels for payments form fields - https://phabricator.wikimedia.org/T169795 (Ejegg) If we want to A/B test this via variants, it may be easiest to us... [03:03:44] Fundraising-Backlog: PayTM for India not functioning - https://phabricator.wikimedia.org/T230625 (Ejegg) Want to test it a bit via this variant link before we turn it on for all users? https://payments.wikimedia.org/index.php?title=Special:AstroPayGateway&appeal=JimmyQuote&payment_method=bt&recurring=&usela... [03:05:45] Fundraising-Backlog, MW-1.34-notes (1.34.0-wmf.20; 2019-08-27): Add PayTM to Dlocal India form - https://phabricator.wikimedia.org/T230170 (Ejegg) As noted on T230625, this can be tested via a link with variant=paytm for now, then once we're sure it's solid we can add it back for all users (so as not to... [03:06:28] (PS12) Eileen: Add api & test for target smart import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/530976 [03:07:41] Fundraising-Backlog: Enable Visa, Mastercard, Amex, and JCB for Adyen in Ireland - https://phabricator.wikimedia.org/T230621 (Ejegg) [03:23:14] eileen that test isn't supposed to actually find the tsv by magic, right? [03:24:36] oh, i was looking at the api test [03:25:15] hmm, I get failures in the other tests locally as well saying API (TargetSmart, import) does not exist [03:25:23] lemme try flushing caches [03:28:09] oh heh, probably my alternate-db-for-pphpunit setup [03:28:16] need to enable the ext on that one too [03:29:04] hmm, nope [03:29:40] well shoot, the code all looks good [03:29:55] I just can't run the dang tests [03:30:18] Want to add that dir to the root phpunit.xml? [03:30:50] So I can at least see that it works on a fresh install [03:31:34] ejegg: oh hey, I forgot to ask, feel like re-plus-two-ing this one? https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CentralNotice/+/530004/9 [03:32:02] oh sure, I'll give it a nudge. [03:32:05] It didn't merge because some CI flakiness that seemed to work on the second time around [03:32:11] thanks much!!!! [03:32:44] (CR) Ejegg: "Still just as beautiful as the first time I laid eyes on it..." [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/530004 (https://phabricator.wikimedia.org/T229126) (owner: AndyRussG) [03:34:52] ejegg: hahahaha [03:35:19] :) [03:36:43] ejegg: what's this all words and no action? [03:37:09] hmm, zuul still not budging? [03:37:30] huh, tumbleweeds over at https://integration.wikimedia.org/zuul/ [03:37:32] no you forgot la poderosa +2 [03:37:39] (CR) Ejegg: [C: +2] Require edit token for previewing banners via Special:BannerLoader [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/530004 (https://phabricator.wikimedia.org/T229126) (owner: AndyRussG) [03:37:44] Oh, hah [03:37:52] there it is! [03:38:23] :) ¡¡Chido!! thanks much [03:38:24] ring for the ol finger as it were [03:38:38] ooh, that must be a mexicanism [03:38:50] one of my favs [03:39:03] It's like chévere [03:41:12] Hehe, that's definitely one of my favs [03:41:56] I was using it for a month up and down argentina before someone told me it was a Colombianism [03:42:31] (Merged) jenkins-bot: Require edit token for previewing banners via Special:BannerLoader [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/530004 (https://phabricator.wikimedia.org/T229126) (owner: AndyRussG) [03:42:36] whoa, mecato is local too? [03:42:50] What word do you use for 'snack' or 'junk food'? [03:43:27] ejegg: botana [03:43:30] what's mecato? [03:43:43] snack / junk food [03:43:50] ah ok right [03:43:56] hmm yeah never heard of it [03:43:56] botana is totally new to me! [03:44:15] junk food a secas would be comida chatarra [03:44:41] 'a secas' ? [03:44:48] by itself [03:44:53] ohhhh [03:45:07] that may be universal, just something i missed learning [03:45:11] I guess like dry, like with no sauce [03:45:14] hmmm no idea [03:45:23] i like it tho [03:45:45] yeee languages are fun eh? [03:46:11] totally! [03:46:55] duolingo is my main procrastination these days... set myself up trying to learn german from portuguese for maximum confusion [03:47:15] ohh that sounds like fun [03:47:23] fortunately portuguese is extremely close to spanish [03:48:19] well, I oughtta get off to bed... [03:48:29] hasta mañana! [03:48:31] Btw working: https://meta.wikimedia.beta.wmflabs.org/wiki/Special:CentralNoticeBanners/edit/Dual_Banner_Mockup [03:48:45] (CR) jenkins-bot: Require edit token for previewing banners via Special:BannerLoader [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/530004 (https://phabricator.wikimedia.org/T229126) (owner: AndyRussG) [03:48:46] (You gotta log in tho) [03:50:00] ohhh damn! we broke the not-logged-in view [03:50:32] ohhh... for preview-on-wiki, huh? [03:50:38] yeah [03:50:44] sorry s/we/I/ [03:50:47] shoot, that's a totally legitimate use case [03:50:53] erk [03:51:00] it shows the error message [03:51:23] dang, I'm not seeing the error message nor the preview, and I'm logged in [03:51:32] oh, I guess I've lost my CNadmin on beta? [03:51:49] wait, no, it lets me save [03:52:03] yeah try private window [03:52:26] why does the ajax call come back with mw.centralNotice.adminUi.bannerEditor.handleBannerLoaderError("⧼centralnotice-preview-loader-permissions-error⧽"); [03:52:29] ? [03:52:30] Something odd with the i18n messages, too, probably just not all copied over yet [03:52:53] right, but if it lets me save I wonder why it throws the perms error at all [03:53:13] hummm that is really bizarre [03:53:23] Maybe hard reload the page? A token issue? [03:53:28] huh, tried again and got mw.centralNotice.adminUi.bannerEditor.handleBannerLoaderError("You are not authorized to preview banners, or your edit token has expired. Please try logging in again or reloading the page."); [03:53:34] reloading again [03:53:53] Worked this time! [03:54:00] Ah ok nice! [03:54:07] And you can edit and preview? [03:54:41] yep! [03:54:50] ok [03:55:06] same-page and new-page both showing my unsaved changes [03:55:24] Hmm I wonder if you can get a banner into an uneditable state by creating a banner with some weird unbalanced tags [03:55:39] hehe, might just be possible [03:55:56] such that the actual edit form gets messed up right away when the preview is injected [03:55:58] iframes? [03:56:18] yeah I guess? [03:56:20] i think that's what the ad world uses to sandbox potentially busted html [03:56:27] mmmm right [03:56:57] eileen: I still can't run the unit tests on the import patch, but I like all the code [03:57:15] Sounds like it's worth +2ing and worrying about the tests later? [04:00:14] (CR) Ejegg: [C: +2] "Looks ready to try out! Want to add the tests to the main phpunit.xml?" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/530976 (owner: Eileen) [04:00:22] ok, g'night! [04:00:34] ejegg|away: ps unbalanced tags do nothing: https://meta.wikimedia.beta.wmflabs.org/wiki/Special:CentralNoticeBanners/edit/PreviewTest [04:00:48] oh nice [04:00:53] yeee [04:05:11] (Merged) jenkins-bot: Add api & test for target smart import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/530976 (owner: Eileen) [04:10:13] Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Banner preview: fix banner editor for users without CN admin rights - https://phabricator.wikimedia.org/T230857 (AndyRussG) [05:17:00] 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 Winter Wanderland, and 2 others: make a wiki page for CN st... - https://phabricator.wikimedia.org/T181652 [05:23:40] 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, Fundraising-Backlog, and 2 others: CentralNotice: Ca... - https://phabricator.wikimedia.org/T160819 [05:24:40] (PS1) Eileen: Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 [05:26:45] (PS1) Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/531338 [05:27:40] (CR) Eileen: [C: +2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/531338 (owner: Eileen) [05:28:45] !log civicrm revision changed from 0d1b7f107a to d7370a9d0b, config revision is 58cd6b7ae6 [05:28:51] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [05:29:47] (CR) jerkins-bot: [V: -1] Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 (owner: Eileen) [05:34:30] (PS2) Eileen: Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 [05:34:37] 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 3 ... - https://phabricator.wikimedia.org/T183293 [05:36:34] Fundraising Sprint Bermuda Rhombus (where things disappear then reappear), Fundraising-Backlog, MediaWiki-extensions-CentralNotice: pull data for unique campaigns last year - https://phabricator.wikimedia.org/T185175 (AndyRussG) [05:37:01] (CR) jerkins-bot: [V: -1] Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 (owner: Eileen) [05:45:27] (PS3) Eileen: Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 [05:47:48] (CR) jerkins-bot: [V: -1] Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 (owner: Eileen) [08:34:10] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising Sprint Quick and the Deadlocked, and 2 others: Create batch job wrapping target smart import allowing us to schedule it - https://phabricator.wikimedia.org/T228714 (Eileenmcnau... [08:53:29] (CR) jenkins-bot: Localisation updates from https://translatewiki.net. [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/531373 (owner: L10n-bot) [13:05:57] (CR) Jgleeson: [C: +1] "This makes sense to me and saves the merging at another time." (1 comment) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531017 (https://phabricator.wikimedia.org/T230744) (owner: Ejegg) [13:36:18] Fundraising-Backlog: PayPal bug? Donation processes when PP screen says I will have a chance to review transaction - https://phabricator.wikimedia.org/T230928 (CCogdill_WMF) [14:51:18] (PS3) Krinkle: Only register adminUI modules on the CN infra wiki (e.g. Meta-Wiki) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/531223 (https://phabricator.wikimedia.org/T221805) [14:51:26] (CR) jerkins-bot: [V: -1] Only register adminUI modules on the CN infra wiki (e.g. Meta-Wiki) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/531223 (https://phabricator.wikimedia.org/T221805) (owner: Krinkle) [14:51:30] (CR) jerkins-bot: [V: -1] Only register adminUI modules on the CN infra wiki (e.g. Meta-Wiki) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/531223 (https://phabricator.wikimedia.org/T221805) (owner: Krinkle) [14:53:35] (CR) Cstone: "On the test question, it is passing for me locally." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531017 (https://phabricator.wikimedia.org/T230744) (owner: Ejegg) [15:06:31] Friends, can I ask if there is active work to redo the banner impressions pipeline again? I thought I remember hearing about this at Wikimania... [15:10:09] hey awight ! [15:10:52] :) Glad to see you made it back [15:11:23] awight, AndyRussG has developed a successor to the legacy DjangoBannerStats tool. https://phabricator.wikimedia.org/T195594 [15:11:51] the successor is affectionately knows as FRUEC [15:12:03] known* [15:13:32] jgleeson: Classy acronym as can be expected :-) [15:14:12] I think it stands for "fundraising update events consumer" [15:14:41] Fundraising Sprint A series of unfortunate event handlers, Fundraising Sprint Bert and Ernie's Excellent Adventure, Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint King Kong vs. Mozilla, and 20 others: New scripts to ingress data fro... - https://phabricator.wikimedia.org/T195594 [15:14:53] ah I was close.., https://github.com/AndrewGreen/fr_user_event_consumer [15:17:09] From the source, it seems to be using the kafkatee logfile output. Well vanquishing Django is a worthy goal in itself! [15:19:44] yeah that sounds right [15:19:58] ah I never did much with Django but it was always one I wish I used more [15:22:36] It's one of those magic frameworks [15:22:45] IMO, RoR is the thing to use if u want magic [15:23:05] gotta run, thanks for the help tracking this down! [15:23:16] bye for now! [15:30:05] oh shoot, just missed him [15:33:35] fr-tech what news for scrum of scrums? [15:33:40] (sorry to ask so late) [15:35:52] none from me ejegg ! [15:41:55] ejegg thanks, nothing here! [15:42:18] k, I mentioned you have that new pipeline ready and might reach out to some other team to help get it deployed [15:42:53] and I put in the notes that the banner preview feature might be going out [16:19:42] (PS3) Jgleeson: WIP: Break out existing shared consumer drush jobs into indivdual jobs for each consumers. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/529413 (https://phabricator.wikimedia.org/T227805) [16:25:21] (CR) jerkins-bot: [V: -1] WIP: Break out existing shared consumer drush jobs into indivdual jobs for each consumers. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/529413 (https://phabricator.wikimedia.org/T227805) (owner: Jgleeson) [16:51:44] Fundraising Sprint Men In Slack, Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, and 2 others: Andy: estimate old tasks - https://phabricator.wikimedia.org/T226552 (DStrine) Open→Resolved [17:09:50] Fundraising-Backlog: test test - https://phabricator.wikimedia.org/T230943 (DStrine) [17:20:18] Wikimedia-Fundraising-Banners: Don't offer monthly suggestion when country doesn't support upsell - https://phabricator.wikimedia.org/T230944 (Pcoombe) [17:23:50] Wikimedia-Fundraising-Banners: Desktop large - fix legend numbers when frequency options hidden - https://phabricator.wikimedia.org/T230945 (Pcoombe) [17:42:08] PROBLEM - check_mysql on frdb2001 is CRITICAL: Slave IO: Connecting Slave SQL: Yes Seconds Behind Master: (null) [17:47:08] RECOVERY - check_mysql on frdb2001 is OK: Uptime: 1656522 Threads: 1 Questions: 26753372 Slow queries: 579657 Opens: 29585334 Flush tables: 1 Open tables: 200 Queries per second avg: 16.150 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [17:53:07] Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Epic: Investigation: Create Preference Center for donors to manage email subscription preferences - https://phabricator.wikimedia.org/T125272 (DStrine) [17:54:27] Fundraising Sprint Princess Mongodb, Fundraising-Backlog, Epic: Investigation: Create Preference Center for donors to manage email subscription preferences - https://phabricator.wikimedia.org/T125272 (DStrine) I pulled this out of the sprint due to availability of some people and the fact that we're... [18:25:36] sorry fr-tech, my router got unhappy [18:25:46] maybe overheated? [18:26:41] hmm, mosh connection restored but dns lookups still failing for meet [18:29:47] ah that sucks ejegg [18:30:29] hmmm maybe an isp thing? [18:31:47] maybe [18:33:10] I have to drop off now but maybe we could do a round 2 on this when your internet is feel better? [18:33:19] ok, cool! [18:33:34] feeling* [18:33:47] we've got some notes of that talk here https://etherpad.wikimedia.org/p/fr-tech-talk [18:34:42] just at the point you froze up ejegg, I was wondering whether we could introduce a new contribution_status to indicate our new state [18:35:09] looks like civi stores things like that in the civicrm_option_group/value tables [18:35:57] currently the available states are 'Completed' [18:35:57] 'Pending' [18:35:57] 'Cancelled' [18:35:57] 'Failed' [18:35:57] 'In Progress' [18:35:58] 'Overdue' [18:36:00] 'Refunded' [18:36:02] 'Partially paid' [18:36:04] 'Pending refund' [18:36:06] 'Chargeback' [18:36:08] 'Settled' [18:36:10] 'Paid' [18:36:12] oops [18:36:51] adding a new one there might be a more "seamless" way to add in the flag although I'm not sure if that's how we'd normally do this [18:37:36] hmm, so we're trying to converge to core's use of those statuses [18:37:55] I'd be loathe to mess with that field [18:38:26] ah ok so that isn't the type of thing people can add custom states to [18:39:35] possible, but not recommended [18:39:45] ah ok lets avoid that then [18:40:12] I did in the core BAO classes that they relie on string values in that option group remaining unchanged [18:40:26] rely* [18:41:04] simplest possibility would be a custom field, but since it would be the first one related to the contribution_recur table [18:41:19] it would have a slight performance impact on recur-related stuff [18:41:45] (PS4) Jgleeson: WIP: Break out existing shared consumer drush jobs into indivdual jobs for each consumers. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/529413 (https://phabricator.wikimedia.org/T227805) [18:47:53] (CR) jerkins-bot: [V: -1] WIP: Break out existing shared consumer drush jobs into indivdual jobs for each consumers. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/529413 (https://phabricator.wikimedia.org/T227805) (owner: Jgleeson) [18:50:35] Fundraising-Backlog, Fr-CiviCRM-dedupe-FY2017/18: Civi: harmonize dedupe Navigation menu and Nav Menu edit screen - https://phabricator.wikimedia.org/T230731 (MBeat33) Looks like these menus have synched up since Monday, they show the same # of queries in both places. [18:55:09] (CR) Ejegg: "Thanks for the CR, Jack! I think we can assume that'll return a value if we have a contribution_id in the contribution_tracking row." (1 comment) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531017 (https://phabricator.wikimedia.org/T230744) (owner: Ejegg) [18:58:48] ok, seem to have connectivity back [20:01:28] Fundraising-Backlog: Middle name and initial appearing in first or last name fields causing lots of manual dedupe - https://phabricator.wikimedia.org/T230954 (DStrine) [20:06:04] (PS4) Eileen: Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 [20:06:06] (PS1) Eileen: Add wrapper for scheduling import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531547 [20:08:35] (CR) jerkins-bot: [V: -1] Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 (owner: Eileen) [20:10:09] (PS2) Eileen: Add wrapper for scheduling import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531547 [20:13:14] (PS3) Eileen: Add wrapper for scheduling import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531547 [20:21:19] (PS4) Eileen: Add wrapper for scheduling import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531547 [20:30:21] (PS5) Eileen: Add wrapper for scheduling import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531547 [20:30:57] Fundraising Sprint A series of unfortunate event handlers, Fundraising Sprint Bert and Ernie's Excellent Adventure, Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint King Kong vs. Mozilla, and 20 others: New scripts to ingress data fro... - https://phabricator.wikimedia.org/T195594 [20:33:24] ejegg: I put up a light weight wrapper api just to track the file offset https://gerrit.wikimedia.org/r/#/c/wikimedia/fundraising/crm/+/531547/ - I'm having trouble with the tests sadly - I think apiv4 is not loaded 'soon enough' or something. It's test related not code related [20:40:50] the tests work for you locally, then? [20:41:12] (PS5) Eileen: Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 [20:41:13] (PS1) Eileen: comment to see if this is tripping [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531553 [20:41:31] ejegg: yes [20:41:43] I think I need to refresh my local Civi install. Been at least a year with this pair of dbs [20:42:16] :-) yeah i did it recently-ish I think with the civibuild command [20:43:24] (CR) jerkins-bot: [V: -1] Add target smart to tests [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531337 (owner: Eileen) [20:43:52] (CR) jerkins-bot: [V: -1] comment to see if this is tripping [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531553 (owner: Eileen) [20:45:20] (CR) Cstone: [C: +2] "Looks good and tests are passing locally for me. Pushing this through so Jack doesn't have to destroy his vagrant setup." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531017 (https://phabricator.wikimedia.org/T230744) (owner: Ejegg) [20:47:31] ejegg: the test is weird but I'm a bit reluctant to dive too much locally before doing the civi upgrade because it might go away with the later apiv4 code [20:48:01] The code is all on staging & I've done some tests there [20:50:48] (Merged) jenkins-bot: Recurring consumer looks up contact via ct_id [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531017 (https://phabricator.wikimedia.org/T230744) (owner: Ejegg) [20:56:33] thanks for the CR cstone [20:58:57] np Jack did most of the work [20:59:07] Fundraising-Backlog: Civi: small # of PayPal contribs listed twice - https://phabricator.wikimedia.org/T230956 (MBeat33) [21:01:15] ok, I'mma do it. Backing up the dbs and blowing them away [21:04:23] big step :-) [21:05:54] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising Sprint Princess Mongodb, Fundraising Sprint Quick and the Deadlocked, and 3 others: Update our csv import library in drupal - https://phabricator.wikimedia.org/T228711 (Eileenmcnaughton) Open→Resolved [21:05:56] Fundraising Sprint Never Ending Query, Fundraising Sprint Office  , Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Update data on staging - https://phabricator.wikimedia.org/T228710 (Eileenmcnaughton) [21:06:48] (PS6) Ejegg: Add wrapper for scheduling import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531547 (owner: Eileen) [21:07:05] (CR) Ejegg: [C: +2] "Looks pretty straightforward!" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531547 (owner: Eileen) [21:08:09] ejegg: so once Leanne confirms the 100 or so I did yesterday I'm ready to schedule the first file 500k [21:08:09] do you or dstrine know if any banners or emails will be causing load? [21:09:10] eileen: for now it's just the Wednesday tests i think [21:09:20] ok [21:09:48] looks like an india pre-test on the 27th [21:10:02] then nothing else big till Sept 2 [21:12:23] (Merged) jenkins-bot: Add wrapper for scheduling import [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/531547 (owner: Eileen) [21:12:48] cool ejegg is this good to go out [21:12:48] + 6f9122c2e305e1515e947bd6bdbe3458a488619a Recurring consumer looks up contact via ct_id [21:12:48] [21:13:46] (PS1) Eileen: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/531563 [21:13:55] it's in that ^^ merge commit [21:22:13] eileen: yep! [21:22:21] sorry for the delay [21:24:02] no worries I'll deploy it [21:24:34] (CR) Eileen: [C: +2] Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/531563 (owner: Eileen) [21:35:11] Fundraising Sprint Princess Mongodb, Fundraising Sprint Quick and the Deadlocked, Fundraising-Backlog: Look into CSP changes in core - https://phabricator.wikimedia.org/T229607 (Ejegg) Had a meeting with the security team today, where we determined that there will not be any changes coming from them... [21:40:11] ejegg: just looking at silverpop export & there are some issues with joins :-( [21:41:47] oh no! [21:41:49] left joins throwing out aggregates :-( [21:42:00] (CR) Eileen: [C: +2] "recheck" [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/531563 (owner: Eileen) [21:42:22] gotta go buy a bike pump, but I should be back soon [21:42:45] ok [21:44:22] !log civicrm revision changed from d7370a9d0b to ab2a9b264b, config revision is 58cd6b7ae6 [21:44:27] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:45:01] Fundraising Sprint Quick and the Deadlocked, Fundraising-Backlog: Contribution Recur records created via updonate should attach to original contact - https://phabricator.wikimedia.org/T230744 (Eileenmcnaughton) @Ejegg this maybe goes to the deployed column now? [22:04:53] (PS31) Vedmaka Wakalaka: Campaign fallback [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/517931 (https://phabricator.wikimedia.org/T124969) [22:05:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:07:19] opps I'm doing big queries on staging [22:10:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:14:50] (CR) Vedmaka Wakalaka: "> Patch Set 30:" (2 comments) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/517931 (https://phabricator.wikimedia.org/T124969) (owner: Vedmaka Wakalaka) [22:15:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:20:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:25:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:30:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:35:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:40:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:45:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:50:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:54:45] (PS11) Ejegg: Convert fr tools to python 3 [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/520350 (https://phabricator.wikimedia.org/T197805) [22:54:47] (PS4) Ejegg: SafeConfigParser -> ConfigParser [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/520669 (https://phabricator.wikimedia.org/T197805) [22:55:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [22:56:27] (CR) Ejegg: "PS11 fixes up the FundraiserStatisticsGenerator scripts. Note that the only one in use is fundstatgen.py. Still, all have been tested and " [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/520350 (https://phabricator.wikimedia.org/T197805) (owner: Ejegg) [23:00:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:05:01] Fundraising Sprint Quick and the Deadlocked, Fundraising-Backlog, Wikimedia-Fundraising, MediaWiki-extensions-DonationInterface, Accessibility: Labels for payments form fields - https://phabricator.wikimedia.org/T169795 (Ejegg) a:Ejegg [23:05:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:10:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:15:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:20:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:25:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:29:30] (PS1) Eileen: Add some timings to queries [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/531578 [23:29:33] (PS1) Eileen: Remove order by that seems no longer required [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/531579 [23:30:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:32:07] (Abandoned) Eileen: Remove order by that seems no longer required [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/531579 (owner: Eileen) [23:35:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:40:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:45:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:50:14] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) [23:55:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null)