[00:12:59] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Continuous-Integration-Config, Release-Engineering-Team (Kanban): Enable CI jobs on the new CiviCRM repos - https://phabricator.wikimedia.org/T118604#3450882 (Eileenmcnaughton) We have some repos that hold the uncompiled code- but in the end I'v... [00:21:14] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Allow live server to access silverpop via firewall - https://phabricator.wikimedia.org/T170883#3450886 (Eileenmcnaughton) Resolved>Open Hey @Jgreen I'm still getting curl time outs & packet drops in syslog :-( [01:05:06] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query on live - https://phabricator.wikimedia.org/T171021#3451027 (Eileenmcnaughton) [04:04:06] (PS1) Eileen: [WIP] CiviCRM 4.7.23 [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/366186 [04:14:04] (CR) jerkins-bot: [V: -1] [WIP] CiviCRM 4.7.23 [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/366186 (owner: Eileen) [04:25:03] (PS1) Eileen: CiviCRM submodule update [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/366192 [04:25:12] (CR) Eileen: [C: 2] CiviCRM submodule update [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/366192 (owner: Eileen) [04:36:41] (Merged) jenkins-bot: CiviCRM submodule update [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/366192 (owner: Eileen) [13:04:11] (PS2) Mepps: Move message cleaning function to base test [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366158 (owner: Ejegg) [13:04:16] (CR) Mepps: [C: 2] Move message cleaning function to base test [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366158 (owner: Ejegg) [13:06:05] (Merged) jenkins-bot: Move message cleaning function to base test [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366158 (owner: Ejegg) [14:10:38] ejegg ppena: has paypal's legacy flow changed? I don't recall it looking like this before today https://www.dropbox.com/s/swb730vz5tyi7vk/Screenshot%202017-07-19%2015.09.01.png?dl=0 [14:29:53] (PS2) Mepps: Make getLogMatches static [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366161 (owner: Ejegg) [14:30:00] (CR) Mepps: [C: 2] Make getLogMatches static [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366161 (owner: Ejegg) [14:32:41] (Merged) jenkins-bot: Make getLogMatches static [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366161 (owner: Ejegg) [14:53:53] pcoombe interesting - I hadn't heard about the update [14:58:19] (PS21) Ejegg: Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) [14:59:50] hi fr-tech! [15:00:29] (CR) jerkins-bot: [V: -1] Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [15:00:32] hi ejegg! [15:00:56] whatup [15:01:23] hi mepps and cwd, how's it going? [15:01:44] ejegg, not bad, looking at your pr's and working on test for getPaymentAttempts [15:01:49] you? [15:02:11] going pretty good! [15:02:49] just trying to get those last form load tests passing [15:03:10] and rebasing the ingenico stuff on top of the paypal log patch to get the new testing capabilities [15:03:35] looks like eileen's been active - I should take a look at her SilverPop stuff again too [15:04:50] thanks for looking at those PRs [15:06:44] (CR) Ejegg: "thanks lego, I'll take a look at that XML format!" [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/285228 (owner: Awight) [15:07:01] wife just got a banner on enwiki... are we starting like really early this year? [15:07:27] (PS4) Mepps: Standardize pending queue message and logging in API [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366159 (https://phabricator.wikimedia.org/T167923) (owner: Ejegg) [15:07:30] (CR) Mepps: [C: 2] Standardize pending queue message and logging in API [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366159 (https://phabricator.wikimedia.org/T167923) (owner: Ejegg) [15:07:49] cwd it's a one hour pretest right now [15:07:54] I guess it's working! [15:09:12] ah word [15:09:19] she was like "i should donate" [15:09:22] so yep! [15:09:43] (Merged) jenkins-bot: Standardize pending queue message and logging in API [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366159 (https://phabricator.wikimedia.org/T167923) (owner: Ejegg) [15:15:43] nice, no snags in the payment processing, I hope! [15:29:12] (PS4) Mepps: WIP Get HostedCheckout Status and Payment Attempts [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/365667 (https://phabricator.wikimedia.org/T163948) [15:30:28] (CR) jerkins-bot: [V: -1] WIP Get HostedCheckout Status and Payment Attempts [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/365667 (https://phabricator.wikimedia.org/T163948) (owner: Mepps) [15:30:29] helloooooooo fr-tech [15:30:54] ejegg see failing tests above ^^ any suggestions? i think it's probably the use of a mock object [15:30:54] Helllooooo nurse [15:31:04] mepps taking a look [15:31:10] i mean, hi AndyRussG ! [15:31:40] :) [15:31:41] * AndyRussG Googles to make up for lack of normal cultural knowledge [15:31:58] mepps it's passing locally? [15:32:03] (CR) Mepps: "See one comment" (1 comment) [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) (owner: Ejegg) [15:32:05] Hmm I guess "googles" the verb isn't capitalized [15:32:07] ejegg nope [15:32:23] ejegg i posted it to ask for help [15:32:26] AndyRussG: got to get up to date on your vaudeville [15:34:17] (CR) Ejegg: PayPal EC recurring: initial charge is part of subscription (1 comment) [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) (owner: Ejegg) [15:36:08] (PS5) Ejegg: PayPal EC recurring: initial charge is part of subscription [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) [15:36:28] (PS5) Mepps: WIP Get HostedCheckout Status and Payment Attempts [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/365667 (https://phabricator.wikimedia.org/T163948) [15:37:06] ejegg see above--it works if i just create a subclass [15:37:30] oh weird [15:37:41] sorry, about to test locally [15:38:13] (PS6) Ejegg: WIP Enable PHP_CodeSniffer, fix complaints [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/285228 (owner: Awight) [15:39:37] (CR) jerkins-bot: [V: -1] WIP Enable PHP_CodeSniffer, fix complaints [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/285228 (owner: Awight) [15:41:10] Fundraising Sprint Murphy's Lawyer, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Easy: Clone button for CN campaigns - https://phabricator.wikimedia.org/T91078#3452834 (AndyRussG) a:AndyRussG [15:46:40] mepps oh right, trying to mock an abstract class does seem weird [15:46:43] so... [15:46:48] (CR) Mepps: "One more question!" (1 comment) [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) (owner: Ejegg) [15:47:46] also, mocking the class under test can't be right [15:48:02] so let's either make it a concrete class and just new() it up [15:48:21] or add the test to the test file for one of the existing subclasses [15:49:51] i guess we can make it concrete but it seems like it was abstract for a reason [15:50:36] i don't think it makes sense to test it under any other subclass because that seems like bad organization to me [15:51:25] (CR) Ejegg: PayPal EC recurring: initial charge is part of subscription (1 comment) [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) (owner: Ejegg) [15:51:53] hmm, what /is/ the best practice for testing abstract base functionality? [15:52:23] i have a better fix! [15:53:05] (PS6) Mepps: Get HostedCheckout Status and Payment Attempts [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/365667 (https://phabricator.wikimedia.org/T163948) [15:53:20] ejegg ^^ -- reading documentation FTW [15:54:26] heh, just came across that same getMock... on Stack Overflow! [15:54:53] ejegg: for SoS we should mention the Translate ext. issue... Just mentioning before I forget ;) [15:55:07] Hellooooooooo Translate extension [15:55:09] AndyRussG: thanks, will do! [15:55:14] thx! [15:55:26] lemme put that in the notes right now, in fact [15:55:27] yeah i found it here: https://phpunit.de/manual/current/en/test-doubles.html#test-doubles.mocking-traits-and-abstract-classes [15:55:38] fr-tech any other notes or requests for other teams? [15:56:44] ejegg: T170968 is the bug for the underlying problem, and T170591 is the CN issue it's causing :) [15:56:45] T170968: Translate: Large number of rows affected when rebuilding message index, causing DB timeouts - https://phabricator.wikimedia.org/T170968 [15:56:45] T170591: WMDE banners failing to save - Timing out on save - https://phabricator.wikimedia.org/T170591 [15:56:58] thx again [15:58:28] (CR) Mepps: PayPal EC recurring: initial charge is part of subscription (1 comment) [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) (owner: Ejegg) [16:00:50] Hmmm maybe stashbot usage style guide should dictate just one bug mentioned per IRC message [16:05:20] Hey, no queue warnings for this one hour test [16:05:45] I'd guess because the old PayPal integration only sends messages from the IPN listener, not from the frontend [16:17:25] (CR) Ejegg: "works great, just a couple little things inline. Unfortunately still lots of spaces instead of tabs, too :(" (3 comments) [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/365667 (https://phabricator.wikimedia.org/T163948) (owner: Mepps) [16:21:41] (PS7) Mepps: Get HostedCheckout Status and Payment Attempts [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/365667 (https://phabricator.wikimedia.org/T163948) [16:33:19] mepps any reason for calling the method getPaymentAttempts instead of getPaymentStatus? [16:36:23] ejegg i just changed it but it was based on your language in https://phabricator.wikimedia.org/T163948 [16:36:51] (PS8) Mepps: Get HostedCheckout and Payment Status [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/365667 (https://phabricator.wikimedia.org/T163948) [16:40:22] ah, cool [16:43:55] (PS7) Ejegg: WIP Enable PHP_CodeSniffer, fix complaints [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/285228 (owner: Awight) [16:44:50] (CR) jerkins-bot: [V: -1] WIP Enable PHP_CodeSniffer, fix complaints [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/285228 (owner: Awight) [16:46:42] (PS22) Ejegg: Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) [16:49:10] (CR) jerkins-bot: [V: -1] Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [16:49:26] grr, navigation bugs in latest phpstorm [16:49:45] when you open a second project, ctrl-shift-n to jump to file is broken [16:49:51] and I use that ALL THE TIME [16:57:08] ctrl-shift-R in Eclipse [16:57:30] (not that I would actually recommend it if it's not something you're already used to...) [16:57:53] heh, i've used it a bunch for java [16:58:04] but I'm enjoying phpstorm a lot more [16:58:07] Hmmm [16:59:43] Yeah hmm I do try to avoid non-libre software... Maybe I'm too set in my ways on that [16:59:53] Probably Java is the only thing keeping Eclipse alive [17:00:06] How did you find Netbeans compared to phpstorm for php? [17:01:15] it was OK, I forget which features made me switch to phpstorm [17:01:20] Hmmm [17:01:51] with eclipse I just kept getting weird java ui bugs or total IDE freezeups [17:01:53] The php plug-in for Eclipse is OK, does outlines, you can click on methods and class references to go to definitions, etc [17:01:57] hmmm [17:02:11] direct download or from dist repo? [17:02:31] phpstorm? direct download, installed in /usr/local [17:02:57] and there's a page on officewiki with instructions to get the gratis licenses [17:03:30] Eclipse... mmm, using version downloaded from site... A few years ago I had some UI issues and had to tweak a config file, but this time I haven't had to [17:04:05] oh, for eclipse I ended up using the direct download 'cause the deb was super old at the time [17:04:15] yeah [17:04:36] I'm like, it works, but maybe I'm still in the cave [17:04:47] and just can't imagine the outside [17:05:09] hey, you seem to produce pretty damn clean code with what you're using [17:05:47] * awight feebly waves tattered #vimftw banner from the '80s, backed by little to no empirical evidence [17:07:04] hheheh /me blushes... ejegg awight u both do fantasmic CR with phpstorm/vim [17:07:22] Yea one day I should try vim [17:07:41] * ejegg leans defensively on his crutch [17:07:42] I once knew Emacs but Eclipse was miles better for Java [17:08:25] Java does seem to involve thousands of lines of boiler refactoring to make the smallest of changes [17:09:16] heheh yea you to sometimes wear the "Generate code" menu item thin ;P [17:09:31] vim has a learning curve a mile wide, then when you're "learned" it turns out your only superpower is that you can edit files on remote servers even if the dialup is crappy [17:09:51] 14.4k ftw [17:10:33] eclipse is cool cos if someone pays us enough, we can write visual modeling plugins... [17:10:54] phpstorm is haxor cos russia [17:11:01] I guess those are more expensive on vim [17:11:10] * awight feigns to understand other peoples [17:11:28] hmm? [17:11:31] yes noone can pay us enough to gvim [17:12:36] oh hey, Prague not Rossia [17:12:38] cos russia? [17:12:47] ah, jetbrains hq [17:12:59] hear they got purty building there too [17:14:07] https://en.wikipedia.org/wiki/Dancing_House [17:14:16] Perfectly safe. [17:14:22] (PS23) Ejegg: Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) [17:14:39] ooh, cool! [17:14:51] damn! [17:15:09] hope the roof leaks less than other Gehry buildings [17:15:25] * awight falls into rabbithole https://en.wikipedia.org/wiki/JetBrains_MPS [17:15:42] ejegg: lol really? nice backstory [17:16:05] the Stata Center at MIT had lots of leakage issues [17:16:15] I think maybe the disney concert hall in L.A. too [17:16:46] http://nymag.com/daily/intelligencer/2007/11/frank_gehry.html [17:17:48] vs http://noticingnewyork.blogspot.com.co/2009/03/gehry-leaks.html [17:19:12] (CR) jerkins-bot: [V: -1] Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [17:19:20] golden closing line, "If he says it doesn’t leak, it doesn’t leak!" [17:19:52] ejegg my smashpig patch is updated and ready for review again [17:22:01] right on mepps, I'm trying to test it against the sandbox site [17:22:42] and i had one more comment on your other patch--just saying that let's make explicit why we're making a "silly" change in the comments for those who come after (probably future us!) [17:22:59] it seems like dedupe is in shred mode [17:23:18] could it be due to db lag from the BE test? [17:25:10] cwd probably [17:26:26] iirc we turned it off during last BE? [17:26:52] mepps ok, I can add more detail [17:27:38] grr, CI tests still failing with 'disabled gateway'. ????? [17:27:58] cwd yeah, that sounds right [17:28:11] I think we only ran the major gifts dedupe [17:30:15] PROBLEM - check_mysql on frdb2001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1343 [17:35:15] RECOVERY - check_mysql on frdb2001 is OK: Uptime: 700970 Threads: 1 Questions: 15849563 Slow queries: 3866 Opens: 4305 Flush tables: 1 Open tables: 601 Queries per second avg: 22.610 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [17:48:49] (CR) Ejegg: [C: 2] "Looks good!" (1 comment) [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/365667 (https://phabricator.wikimedia.org/T163948) (owner: Mepps) [17:50:19] (Merged) jenkins-bot: Get HostedCheckout and Payment Status [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/365667 (https://phabricator.wikimedia.org/T163948) (owner: Mepps) [18:00:59] Fundraising-Backlog, MediaWiki-General-or-Unknown, MediaWiki-extensions-CentralNotice, Mobile: Provide a way to show notifications to mobile users comparable to Sitenotice/annonnotice - https://phabricator.wikimedia.org/T138572#3453402 (DStrine) [18:27:43] Fundraising-Backlog, MediaWiki-General-or-Unknown, MediaWiki-extensions-CentralNotice, MinervaNeue, Mobile: Provide a way to show notifications to mobile users comparable to Sitenotice/annonnotice - https://phabricator.wikimedia.org/T138572#3453565 (JMinor) [18:28:25] (PS6) Ejegg: PayPal EC recurring: initial charge is part of subscription [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) [18:28:31] (CR) Ejegg: "OK mepps, added even more detail to the comment" [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) (owner: Ejegg) [18:29:19] (CR) Mepps: [C: 2] "Great! Thanks for the details." [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) (owner: Ejegg) [18:29:56] thanks mepps, I'll put those changes up on prod and try out a donation [18:30:16] awesome [18:30:40] ejegg where should i go next with ingenico? need help with DI or is there more to be done in SP? [18:31:57] The DI stuff definitely needs a lot of work [18:32:15] also, ejegg should i deploy my crm change? not sure where the repo is with eileen's work [18:32:38] but if you want to do one more piece in SP, we'd have all the API calls we need to do a one-time payment [18:33:09] mepps is master very far from deployment in crm? [18:33:22] I think there shouldn't be much undeployed [18:34:42] mepps this is the ticket for the other API calls we'll want for one-time payments: https://phabricator.wikimedia.org/T163952 [18:34:53] (Merged) jenkins-bot: PayPal EC recurring: initial charge is part of subscription [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364903 (https://phabricator.wikimedia.org/T170478) (owner: Ejegg) [18:35:13] (PS24) Ejegg: Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) [18:35:32] mepps or if you can help figure out why the tests think the gateway is disabled ^^^ [18:35:38] I'd love some help with that [18:38:00] (PS1) Ejegg: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/366305 [18:42:24] (PS1) Ejegg: Update DonationInterface submodule [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/366306 [18:42:45] (CR) Ejegg: [C: 2] Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/366305 (owner: Ejegg) [18:42:57] (CR) Ejegg: [C: 2] Update DonationInterface submodule [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/366306 (owner: Ejegg) [18:52:05] ejegg could it not be looking at the right version of smashpig? [18:52:13] hmm [18:53:13] seems like other stuff would break if that was the issue [18:53:57] also, I may have made a bad assumption with that paypal recurring fix :( [18:54:09] Looks like we're not getting a transaction ID back [18:55:54] I guess the transaction ID field in the CreateRecurringPaymentsProfile response refers to an 'Initial non-recurring payment' [18:57:34] (Merged) jenkins-bot: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/366305 (owner: Ejegg) [18:57:37] (Merged) jenkins-bot: Update DonationInterface submodule [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/366306 (owner: Ejegg) [18:59:03] So the code that's up there now will do the right thing by getting all the payments associated with the same subscription ID [18:59:37] BUT: it'll send a malformed message to the donations queue with a missing gateway txn ID [19:00:01] instead, I think we should send a subscr_start message to the recurring queue [19:00:08] with just the recurring profile ID [19:05:54] hmm, or just let the listener handle that whole part, like it does for legacy paypal [19:08:14] yeah, that seems likt the thing to do [19:21:47] (PS25) Mepps: Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [19:21:59] ejegg ignore that commit- just trying to debug right now [19:22:12] cool [19:27:20] (CR) Mepps: "recheck" [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [19:30:05] PROBLEM - check_mysql on frdb2001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1824 [19:30:37] do you know why the build doesn't seem to be running ejegg? [19:33:02] AndyRussG: meeting? [19:35:15] PROBLEM - check_mysql on frdb2001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2124 [19:35:31] dstrine: oops, one sec! [19:36:58] (CR) jerkins-bot: [V: -1] Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [19:38:07] !log disabled civicrm dedupe job [19:38:17] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [19:40:15] PROBLEM - check_mysql on frdb2001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1682 [19:41:19] random question -- does anyone know the command to import mysql query results as a tsv onto your own machine? the command I used to use isn't working :( [19:44:47] oops, I think I wrote the batch bit wrong... might have figured it out! [19:45:15] RECOVERY - check_mysql on frdb2001 is OK: Uptime: 708770 Threads: 1 Questions: 16069814 Slow queries: 3866 Opens: 4476 Flush tables: 1 Open tables: 601 Queries per second avg: 22.672 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [19:53:09] (PS26) Mepps: Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [19:57:27] (CR) jerkins-bot: [V: -1] Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [20:02:07] Fundraising Sprint Murphy's Lawyer, Fundraising-Backlog: SQL challenge: Mailing and donation data - https://phabricator.wikimedia.org/T169591#3454031 (Ejegg) Open>Resolved a:Ejegg Feel free to re-open if those queries aren't quite right! [20:03:57] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query on live - https://phabricator.wikimedia.org/T171021#3454053 (DStrine) p:Triage>Normal [20:06:37] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Investigate if there is a problem with on_hold usage for Silverpop - https://phabricator.wikimedia.org/T170357#3454075 (DStrine) Open>Invalid [20:07:13] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Investigate if there is a problem with on_hold usage for Silverpop - https://phabricator.wikimedia.org/T170357#3454078 (Eileenmcnaughton) @LeanneS said they don't use on_hold as a temporary status (@CCogdill_WMF ) [20:10:20] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops: Allow live server to access silverpop via firewall - https://phabricator.wikimedia.org/T170883#3454106 (Jgreen) Open>Resolved fixed [20:11:09] Fundraising-Backlog: Revoke AWight's donatewiki account - https://phabricator.wikimedia.org/T168430#3454111 (Ejegg) a:Pcoombe @Pcoombe looks like you have admin there. Want to delete AWight (WMF) (and maybe promote me to admin?) [20:14:18] Fundraising-Backlog: Revoke AWight home IP from PSP whitelists - https://phabricator.wikimedia.org/T168451#3454148 (DStrine) @awight could you provide more info? [20:19:47] Fundraising Sprint Far Beer, Fundraising Sprint Gondwanaland Reunification Engine, Fundraising Sprint Homebrew Hadron Collider, Fundraising Sprint Ivory Tower Defense Games, and 6 others: Errors in CiviCRM dedupe screen - https://phabricator.wikimedia.org/T160571#3454181 (DStrine) [20:19:49] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Find and Merge Duplicate Contacts function isn't working in Civi - https://phabricator.wikimedia.org/T165615#3454183 (DStrine) [20:23:16] Fundraising Sprint Kickstopper, Fundraising Sprint Murphy's Lawyer, Fundraising-Backlog, FR-ActiveMQ, and 4 others: Epic: Reconcile SmashPig and DonationInterface configuration - https://phabricator.wikimedia.org/T143831#3454207 (DStrine) [20:25:45] Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, Fundraising-Backlog, FR-PayPal-ExpressCheckout, and 2 others: Stop using kludgy workaround for PayPal EC recurring - https://phabricator.wikimedia.org/T170478#3454216 (DStrine) [20:25:48] Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: Optimize filesystem access in thank_you email job - https://phabricator.wikimedia.org/T170435#3454219 (DStrine) [20:25:50] Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, and 2 others: "Thank-you Sent" field auto populating date - https://phabricator.wikimedia.org/T170440#3454218 (DStrine) [20:25:52] Fundraising Sprint Loose Lego Carpeting, Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, Fundraising-Backlog, and 2 others: Add ability for MG to import to Primary address type - https://phabricator.wikimedia.org/T169025#3454220 (DStrine) [20:25:54] Fundraising Sprint Loose Lego Carpeting, Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, Fundraising-Backlog, and 2 others: CentralNotice: Add controls to purge banner content in Varnish for a specific language - https://phabricator.wikimedia.org/T168673#3454222 (DStrine) [20:25:56] Fundraising Sprint Kickstopper, Fundraising Sprint Loose Lego Carpeting, Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, and 4 others: PayPal EC dead session error - https://phabricator.wikimedia.org/T167923#3454223 (DStrine) [20:25:58] Fundraising Sprint Kickstopper, Fundraising Sprint Loose Lego Carpeting, Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, and 2 others: process-control should not crash on bad utf-8 from stdout or stderr - https://phabricator.wikimedia.org/T167849#3454224 (DStrine) [20:26:00] Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, Fundraising-Backlog, FR-Ingenico, and 3 others: Implement Ingenico Connect API calls to get payment status - https://phabricator.wikimedia.org/T163948#3454226 (DStrine) [20:26:04] Fundraising Sprint Judgement Suspenders, Fundraising Sprint Kickstopper, Fundraising Sprint Loose Lego Carpeting, Fundraising Sprint Murphy's Lawyer, and 2 others: Compile list of systems we depend on and should check all the time - https://phabricator.wikimedia.org/T163509#3454229 (DStrine) [20:26:06] Fundraising Sprint Loose Lego Carpeting, Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, Fundraising-Backlog, and 4 others: Implement Ingenico Connect API call to create hosted payment - https://phabricator.wikimedia.org/T163946#3454227 (DStrine) [20:26:09] Fundraising Sprint Ivory Tower Defense Games, Fundraising Sprint Judgement Suspenders, Fundraising Sprint Kickstopper, Fundraising Sprint Loose Lego Carpeting, and 7 others: Move already-encapsulated useful classes into SmashPig - https://phabricator.wikimedia.org/T163868#3454228 (DStrine) [20:26:11] Fundraising Sprint Kickstopper, Fundraising Sprint Loose Lego Carpeting, Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, and 4 others: Reflect all unsubscribes via Silverpop in CiviCRM - https://phabricator.wikimedia.org/T161760#3454230 (DStrine) [20:26:13] Fundraising Sprint Gondwanaland Reunification Engine, Fundraising Sprint Homebrew Hadron Collider, Fundraising Sprint Ivory Tower Defense Games, Fundraising Sprint Judgement Suspenders, and 8 others: retrieve the text/ html and statistics data for m... - https://phabricator.wikimedia.org/T161758#3454231 [20:26:16] Fundraising Sprint Murphy's Lawyer, Fundraising Sprint N 2017, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Easy: Clone button for CN campaigns - https://phabricator.wikimedia.org/T91078#3454233 (DStrine) [20:26:21] Fundraising Sprint Baudelaire Bowdlerizer, Fundraising Sprint Costlier Alternative, Fundraising Sprint Deferential Equations, Fundraising Sprint English Cuisine, and 14 others: Purge Varnish cache when a banner is saved - https://phabricator.wikimedia.org/T154954#3454232 (DStrine) [20:27:44] (PS27) Mepps: Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [20:28:28] (PS2) Ejegg: Update transactions for django 1.6+ [wikimedia/fundraising/tools/DjangoBannerStats] - https://gerrit.wikimedia.org/r/358419 (https://phabricator.wikimedia.org/T162504) [20:28:30] (PS2) Ejegg: Correct default log path, make TEMPLATE_DIRS an array [wikimedia/fundraising/tools/DjangoBannerStats] - https://gerrit.wikimedia.org/r/358420 [20:28:32] (PS2) Ejegg: Remove web app bits of DjangoBannerStats [wikimedia/fundraising/tools/DjangoBannerStats] - https://gerrit.wikimedia.org/r/358424 [20:30:18] (CR) jerkins-bot: [V: -1] Add Ingenico Connect gateway based on GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/364143 (https://phabricator.wikimedia.org/T163946) (owner: Ejegg) [20:52:37] Fundraising-Backlog: Revoke AWight home IP from PSP whitelists - https://phabricator.wikimedia.org/T168451#3454297 (awight) Thanks for the ping! My home addy is `173.228.0.0/16` [20:57:48] mepps https://phabricator.wikimedia.org/T163952 [21:46:55] (PS1) Ejegg: WIP use INITAMT for first payment [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/366472 (https://phabricator.wikimedia.org/T170478) [21:57:18] !log re-enabled CiviCRM de-dupe job [21:57:28] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:58:40] have a good night and a good Thursday. See y'all friday!