[00:01:17] nice... I think we're really close to vagrant provision giving us a working dash [00:01:45] just need to exec bower install after npm install [00:02:10] and can get rid of that 'force' and the recurse submodules = false [00:02:18] (Merged) jenkins-bot: Support both node-syslog and modern-syslog [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326012 (https://phabricator.wikimedia.org/T99869) (owner: Ejegg) [00:02:44] awesome [00:03:07] i will hook that up shortly...dog ran away (normal occurrence) [00:07:41] oh man, guess you get plenty of exercise [00:08:53] gotta put a fence up... [00:12:38] (PS1) Ejegg: Remove double-listed node-syslog [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326857 [00:15:10] (CR) Paladox: [C: 1] Remove double-listed node-syslog [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326857 (owner: Ejegg) [00:16:13] AndyRussG: Did you ever run into a... jammed table in Hive? [00:16:26] I have a small table which I'm unable to query for some reason [00:16:31] Hive only does honey'd tables [00:16:35] ANALYZE TABLE t152741_sessions compute statistics; [00:16:39] INFO : Table awight.t152741_sessions stats: [numFiles=27, numRows=690, totalSize=673182, rawDataSize=672492] [00:16:48] awight: no never, but I jut got a out-of-memory error in Hive [00:16:53] it's no bigger than a bee larva [00:16:59] 27 files for 690 rows, huh? [00:17:04] Py4JJavaError: An error occurred while calling o52.sql. [00:17:05] : java.lang.OutOfMemoryError: GC overhead limit exceeded [00:17:20] wat, I was able to select from the cmdline [00:17:21] um [00:17:32] maybe something else blew up and a few other things flew about [00:17:34] AndyRussG: I always run it like, HADOOP_HEAPSIZE=2048 beeline [00:17:48] awight: that's for beeline? [00:17:53] I wonder if I can do that for ipython [00:17:57] aah [00:18:59] so I was running beeline wrongly [00:19:10] hmm? [00:19:22] Too crooked ;) [00:20:30] that was silly. I failed to pass my query as a commandline argument, so it was just sitting there waiting for me to type invisible text [00:21:15] ejegg: i can't find a usable bower in the vagrant box [00:21:42] cwd oh i thought it was a node module, oops [00:21:48] Isn't it installed via npm? [00:21:51] do we need to add a puppet module for that? [00:22:07] ah, let me add that to package.json [00:24:54] how to decide whether something fits better in npm or puppet... [00:25:08] iono [00:25:20] but we've already got gulp in the devDependencies [00:25:58] (PS1) Ejegg: Require bower for dev in package.json [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326861 [00:26:53] awight: glad it was resolved! [00:27:44] cwd added bower to devDeps ^^ [00:28:16] cool, trying out [00:28:20] which I guess automatically get installed if you don't specify --production [00:32:35] (PS1) Ejegg: Remove dev dependencies [wikimedia/fundraising/dash/node_modules] - https://gerrit.wikimedia.org/r/326863 [00:33:56] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Spike: Spike: Investigate huge spike in StaleCampaignException messages since Dec 8 - https://phabricator.wikimedia.org/T152741#2866886 (awight) I accidentally destroyed the record of my work, but... I... [00:34:13] AndyRussG: ^ good news! [00:34:15] it's not us [00:35:54] awight: ahh fantasmic :) [00:36:26] I was suspicious it was evidence of a bug with campaign start/stop times, which I thought (hoped?) might be responsible for triggering the CN outages on Dec. 1 and 2 at mysterious times...... [00:37:02] (CR) Cdentinger: [C: 2] Require bower for dev in package.json [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326861 (owner: Ejegg) [00:37:29] hehe, regrettably, it's not a bug [00:37:35] :( [00:37:41] Is there an emoticon for irony? [00:38:17] :-} [00:38:25] Folks, I'm feeling really under the weather and need to drop off for a little while. I hope to be back in 1-2 hrs... dstrine I think I have a way to poke at googleweblight that'll help us solve it...... I'll try when I'm back later [00:38:29] awight: cool! [00:38:30] good question /o\ [00:38:36] (PS1) Ejegg: Remove unused js libs in require.config [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326864 [00:38:43] :{ [00:38:43] AndyRussG: relax, if that's possible! [00:38:49] There must be some unicode char [00:38:49] feel better! [00:38:50] AndyRussG: feel better. thanks for looking into that. [00:38:54] awight: ejegg dstrine thanks! [00:38:57] :) [00:39:02] (Merged) jenkins-bot: Require bower for dev in package.json [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326861 (owner: Ejegg) [00:41:14] (PS1) Ejegg: Remove extraneous bower modules [wikimedia/fundraising/dash/src/bower_modules] - https://gerrit.wikimedia.org/r/326866 [00:42:12] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, FR-PayPal-ExpressCheckout, FR-Paypal, FR-WMF-Audit: Update audit parser for PayPal Express Checkout - https://phabricator.wikimedia.org/T134605#2866919 (awight) I'm concerned there might not be a way to distinguish EC recurring charge... [00:43:35] (PS3) Awight: Change gateway for Express Checkout [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/325818 (https://phabricator.wikimedia.org/T134605) [00:44:18] Fundraising-Backlog, FR-PayPal-ExpressCheckout, Epic: Epic: Distinguish PayPal legacy vs. Express Checkout transactions - https://phabricator.wikimedia.org/T138013#2866936 (awight) [00:44:47] (PS3) Awight: Rudiments of arbitrary campaigns [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/324634 (https://phabricator.wikimedia.org/T151820) (owner: Ejegg) [00:48:27] (CR) Awight: [C: 2] Rudiments of arbitrary campaigns [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/324634 (https://phabricator.wikimedia.org/T151820) (owner: Ejegg) [00:49:23] (CR) Awight: Make campaign an observable (1 comment) [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326021 (owner: Ejegg) [00:49:28] (PS2) Awight: Make campaign an observable [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326021 (owner: Ejegg) [00:49:30] (Merged) jenkins-bot: Rudiments of arbitrary campaigns [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/324634 (https://phabricator.wikimedia.org/T151820) (owner: Ejegg) [00:50:28] (PS1) Ejegg: Update c3js and bootstrap-timepicker [wikimedia/fundraising/dash/src/bower_modules] - https://gerrit.wikimedia.org/r/326867 [00:50:30] (CR) Awight: [C: 2] Make campaign an observable [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326021 (owner: Ejegg) [00:50:55] glad to have you back in gerrit, awight! [00:50:59] (CR) Awight: [C: 2] Remove unused js libs in require.config [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326864 (owner: Ejegg) [00:51:19] (CR) Awight: [C: 2] Remove double-listed node-syslog [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326857 (owner: Ejegg) [00:51:37] (Merged) jenkins-bot: Make campaign an observable [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326021 (owner: Ejegg) [00:51:38] what was the problem? [00:52:15] (CR) Awight: Clean up .gitignore (1 comment) [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/325985 (owner: Ejegg) [00:52:56] (Merged) jenkins-bot: Remove unused js libs in require.config [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326864 (owner: Ejegg) [00:53:03] cwd: T152640 it wasn't so bad ;) [00:53:03] T152640: Cannot log into Gerrit as of recent upgrade - https://phabricator.wikimedia.org/T152640 [00:53:05] (Merged) jenkins-bot: Remove double-listed node-syslog [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/326857 (owner: Ejegg) [00:56:23] vagrant provision is crashing my laptop [00:57:12] I'mma try deploying the campaign fix [00:59:16] (CR) Ejegg: [C: 2] Update c3js and bootstrap-timepicker [wikimedia/fundraising/dash/src/bower_modules] - https://gerrit.wikimedia.org/r/326867 (owner: Ejegg) [01:04:32] ugh, bower install returns 1 on provision, 0 when i do it [01:04:57] gotta be environment vars [01:05:11] take a look at what they set in the npm::install task [01:05:48] nothing i can see, and i'm doing it from the vagrant box [01:06:17] npm::install uses "directory" and exec uses "cwd" -- assuming that's an implementation detail [01:06:31] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/326869 [01:06:33] (PS1) Ejegg: Revert "REVERT ON DEPLOYMENT: remove submodules" [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/326870 [01:06:35] (PS1) Ejegg: Update bower_modules and run gulp [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/326871 [01:07:06] (CR) Ejegg: [C: 2] Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/326869 (owner: Ejegg) [01:07:09] (CR) Ejegg: [C: 2] Revert "REVERT ON DEPLOYMENT: remove submodules" [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/326870 (owner: Ejegg) [01:07:15] (CR) Ejegg: [C: 2] Update bower_modules and run gulp [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/326871 (owner: Ejegg) [01:08:09] cwd is it a path thing? [01:08:43] what does 'which bower' give you? [01:09:11] huh, also, I see the npm::install task runs it with --no-bin-links [01:09:34] (Merged) jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/326869 (owner: Ejegg) [01:09:36] (Merged) jenkins-bot: Revert "REVERT ON DEPLOYMENT: remove submodules" [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/326870 (owner: Ejegg) [01:09:38] (Merged) jenkins-bot: Update bower_modules and run gulp [wikimedia/fundraising/dash] (deployment) - https://gerrit.wikimedia.org/r/326871 (owner: Ejegg) [01:10:06] k, here goes deploy [01:10:07] i'm specifying the path and it finds the binary, but says it returns 1 [01:10:22] no output? [01:11:29] (CR) Ejegg: [V: 2 C: 2] Update c3js and bootstrap-timepicker [wikimedia/fundraising/dash/src/bower_modules] - https://gerrit.wikimedia.org/r/326867 (owner: Ejegg) [01:12:59] nothing useful, even with debug [01:13:02] /vagrant/srv/fundraising-dash/node_modules/bower/bin/bower install returned 1 instead of one of [0] [01:13:48] but when i go in there and do it, it returns 0 [01:14:23] !log updated fundraising dashboard from 7ce4f03da78fe0469727033db8d514e9596dd9ac to 040557d08b476283df7c2e243c71ce4043ffe7c8 [01:14:30] jeez [01:14:35] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [01:14:47] that's super unhelpful [01:15:36] cwd maybe? https://pgib.me/blog/2015/01/12/bower-from-puppet/ [01:20:45] ok, fr-tech, I'm going to head out for the night [01:21:10] Fundraising Dash, Fundraising Sprint Waiting for Godot, Fundraising-Backlog: dash does not respect the cutoff value - https://phabricator.wikimedia.org/T152138#2867015 (Ejegg) Open>Resolved Deployed, seems to be working! [01:29:09] out! [01:48:10] Fundraising Sprint Testing on Production, Fundraising Sprint Unbreaking Now, Fundraising Sprint Value Subtracting, Fundraising Sprint Waiting for Godot, and 3 others: Civi: restore the 'unsubscribe from spam' option to Main menu - https://phabricator.wikimedia.org/T147571#2867035 (MBeat33) Many t... [02:19:35] (PS1) Eileen: Fix unsubscribe screen to hide results when data changes. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/326883 (https://phabricator.wikimedia.org/T147571) [17:09:18] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: spike: list new round of common dedupe conflicts - https://phabricator.wikimedia.org/T153019#2866661 (DStrine) p:Triage>Normal [17:09:28] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: add link to large donation bot emails - https://phabricator.wikimedia.org/T153020#2869433 (DStrine) p:Triage>Normal [17:49:35] (CR) Ejegg: [C: 2] Remove dev dependencies [wikimedia/fundraising/dash/node_modules] - https://gerrit.wikimedia.org/r/326863 (owner: Ejegg) [17:50:37] (CR) Awight: "for tha win!" [wikimedia/fundraising/dash/node_modules] - https://gerrit.wikimedia.org/r/326863 (owner: Ejegg) [17:51:06] (CR) Ejegg: [C: 2] "Nice optimization!" [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/326381 (owner: Eileen) [17:51:35] (PS2) Ejegg: Remove extraneous bower modules [wikimedia/fundraising/dash/src/bower_modules] - https://gerrit.wikimedia.org/r/326866 [17:51:47] (CR) Ejegg: [V: 2 C: 2] Remove extraneous bower modules [wikimedia/fundraising/dash/src/bower_modules] - https://gerrit.wikimedia.org/r/326866 (owner: Ejegg) [17:55:31] (PS2) Ejegg: Clean up .gitignore [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/325985 [17:55:50] (Merged) jenkins-bot: CRM-19752 Fix slow query on contribution search. [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/326381 (owner: Eileen) [17:57:07] (CR) Ejegg: [V: 2 C: 2] Remove dev dependencies [wikimedia/fundraising/dash/node_modules] - https://gerrit.wikimedia.org/r/326863 (owner: Ejegg) [18:00:02] fr-tech: Money cannot buy [18:00:03] The fuel of love [18:00:03] but is excellent kindling. [18:00:03] To the man-in-the-street, who, I'm sorry to say, [18:00:03] Is a keen observer of life, [18:00:03] The word intellectual suggests right away [18:00:03] A man who's untrue to his wife. [18:00:04] -- W. H. Auden, "Collected Shorter Poems" [18:00:04] -- discuss. [18:04:30] * awight gets over the loneliness [18:39:08] awight: hey!! if u'd like to tech-talk, a comment or two on T152602 might be fun [18:39:16] do u have stuff I could rubber-duck for? [18:39:41] I don't have much besides the above to discuss... though once I pull more data for the Ireland ouch-age, I might [18:39:45] https://phabricator.wikimedia.org/T152602 [18:41:56] AndyRussG: we are in there now, feel free to join! [19:16:32] https://phabricator.wikimedia.org/diffusion/MW/browse/master/resources/src/startup.js$34 [19:17:24] oh that's it, then! [19:17:36] But I don't see where they filter [19:18:09] ah it's just the regex [19:19:16] I think I understand why the-wub's fix didn't work--the .js runs on the GWL server, so the host is still the original website [19:19:26] But that also means UA detection should do what we hope [19:19:41] we just need to... have a way to figure out what that is [19:19:57] maybe if AndyRussG's test html includes js that outputs the UA [19:24:15] dstrine / AndyRussG I may skip the CPS checkin today 1if that's ok [19:24:26] ok [19:24:33] thanks for the reminder :) [19:26:36] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi: make selecting the Deceased checkbox also unsubscribe donor's email address - https://phabricator.wikimedia.org/T153110#2870061 (MBeat33) [19:30:10] oooh oopse, dstrine there in 1-2 minutes [19:59:18] Fundraising Sprint Testing on Production, Fundraising Sprint Unbreaking Now, Fundraising Sprint Value Subtracting, Fundraising Sprint Waiting for Godot, and 3 others: Civi: restore the 'unsubscribe from spam' option to Main menu - https://phabricator.wikimedia.org/T147571#2870246 (MBeat33) This i... [20:06:43] (PS1) Eileen: CiviCRM submodule update [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/327034 [20:06:59] (CR) Eileen: [C: 2] CiviCRM submodule update [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/327034 (owner: Eileen) [20:07:49] bike chain busted! wasn't too far from the community bike shop, fortunately. [20:09:23] I'm not getting dash - are other people? [20:13:27] (PS2) Eileen: CiviCRM submodule update [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/327034 [20:28:48] (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/327037 [20:29:04] (CR) Eileen: [C: 2] "merge commit" [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/327037 (owner: Eileen) [20:29:44] (Merged) jenkins-bot: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/327037 (owner: Eileen) [20:38:19] sorry for the extended absence fr-tech [20:38:40] what's the latest on the blight? [20:39:08] ooh, broke your chains off to run! [20:39:28] I think AndyRussG and bblack have almost sorted it out [20:39:38] @#wikimedia-operations [20:40:05] world domination, that is [20:41:19] yasss [20:42:14] ver nass [20:42:38] That dedupe email was just one job catching up to another job [20:42:54] I reset one to be on a diff part of the DB [20:43:12] we are about 1 million behind on deduping but deduping faster than receiving now [20:44:45] !log update CiviCRM from 7c8536c799c6eee774027a949178d44400cff3bc to 4bf38dae0ed99e8584190aafbc224b44fcce8b47 [20:44:57] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [20:45:43] Wish I knew why my new rectifier falls over with no error message [21:06:54] fr-tech any reason to keep that weblight task wmf-fr only? [21:07:16] ejegg: yeah I was gonna say... would have been nice to have others be able to see it... [21:07:17] +1 no, but not +2ing [21:07:34] I see nothing secret [21:08:18] Krinkle: feel like weighing in with the voice of RL-ish authority? https://gerrit.wikimedia.org/r/#/c/327043 :) [21:11:17] RoanKattouw: ^ ? [21:11:34] ejegg: I don't have mw installed on my vps, do u? [21:11:55] yeah, just gotta update it to anything like recent... [21:12:06] doing so... [21:12:09] Ah K thx!!! [21:12:45] (PS1) Eileen: CRM-19752 Fix slow query on contribution dash. [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/327054 (https://phabricator.wikimedia.org/T152936) [21:13:31] ejegg: I found a second place where those financial ACL joins were being added to the query in order to hurt our site ^^ [21:13:33] heh, it was at 1.23 [21:13:41] k, looking [21:14:02] (I just deployed the other one & looked in the show processlist & found that one) [21:16:11] eileen1: weird, what's that else clause for: $where[] = "c.financial_type_id IN (0)" [21:16:42] ejegg: IF financial ACLS are enabled and you do not have permission to any financial types [21:16:42] what does id 0 mean? [21:16:53] then it basically returns nothing [21:16:59] it could equally be 1 = 0 [21:17:00] ah, so it might as well be 1=0 [21:17:05] bang [21:17:06] hehe [21:17:47] as an aside I have a guy asking me for stuff to prepare to try to get into gsoc & I suggested he upstream that fix & write a unit test for it [21:17:59] wait, I thought the last one just didn't filter when getAvailableTypes returned nothing [21:19:05] nah - the other one that 0 shit going on too [21:19:15] ah, sorry, missed it [21:19:26] ok, well, that looks straightforward [21:19:30] this is a bad fn name isACLFinancialTypeStatus [21:19:49] but if I grep I find many instances [21:24:46] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query: dedupe script - https://phabricator.wikimedia.org/T153127#2870604 (Eileenmcnaughton) [21:25:52] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query: dedupe script - https://phabricator.wikimedia.org/T153127#2870622 (Eileenmcnaughton) [21:26:05] (CR) Ejegg: [C: 2] CRM-19752 Fix slow query on contribution dash. [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/327054 (https://phabricator.wikimedia.org/T152936) (owner: Eileen) [21:28:22] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query: core civicrm affecting one of the scheduled jobs - https://phabricator.wikimedia.org/T153128#2870636 (Eileenmcnaughton) [21:30:06] (Merged) jenkins-bot: CRM-19752 Fix slow query on contribution dash. [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/327054 (https://phabricator.wikimedia.org/T152936) (owner: Eileen) [21:33:46] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query - contribution search - https://phabricator.wikimedia.org/T153129#2870670 (Eileenmcnaughton) [21:34:59] (PS1) Eileen: CiviCRM submodule update [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/327058 [21:36:45] (CR) Eileen: [C: 2] CiviCRM submodule update [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/327058 (owner: Eileen) [21:44:17] (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/327093 [21:44:33] (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/327093 (owner: Eileen) [22:01:08] (Merged) jenkins-bot: Merge branch 'master' of https://gerrit.wikimedia.org/r/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/327093 (owner: Eileen) [22:01:36] fr-tech: Hangouts wigging out for anyone else, or is that just me? [22:08:23] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work: Spike: investigate slow queries - https://phabricator.wikimedia.org/T153134#2870826 (Eileenmcnaughton) [22:09:04] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work: Spike: investigate slow queries - https://phabricator.wikimedia.org/T153134#2870851 (Eileenmcnaughton) This came off digging into the engage slowness. I found a bunch of other slow que... [22:09:46] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi: make selecting the Deceased checkbox also unsubscribe donor's email address - https://phabricator.wikimedia.org/T153110#2870854 (awight) p:Triage>Normal [22:11:29] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query - contribution search - https://phabricator.wikimedia.org/T153129#2870860 (Eileenmcnaughton) [22:11:32] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query: core civicrm affecting one of the scheduled jobs - https://phabricator.wikimedia.org/T153128#2870861 (Eileenmcnaughton) [22:11:33] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query: dedupe script - https://phabricator.wikimedia.org/T153127#2870862 (Eileenmcnaughton) [22:11:36] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review, Unplanned-Sprint-Work: CRM-19752 Fix impact of financial acl code on query speed - https://phabricator.wikimedia.org/T152936#2870863 (Eileenmcnaughton) [22:16:35] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Spike: where to host WMF CiviCRM extensions - https://phabricator.wikimedia.org/T153014#2866495 (awight) Random notes: * Does CiviCRM have a command-line tool to update extensions from their home repo, a la Composer? * @Eileenmcnaughton is pointing out... [22:18:39] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Unplanned-Sprint-Work: New thank you email for big english - https://phabricator.wikimedia.org/T151784#2870899 (Ejegg) Open>Resolved [22:18:57] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Can't access thank_you module configuration form - https://phabricator.wikimedia.org/T151941#2870900 (Ejegg) Open>Resolved [22:19:15] Fundraising Dash, Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Patch-For-Review, Unplanned-Sprint-Work: Allow Big English widget to show last two days of November - https://phabricator.wikimedia.org/T151820#2870903 (Ejegg) Open>Resolved [22:19:28] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Unplanned-Sprint-Work: New thank you email for big english - https://phabricator.wikimedia.org/T151784#2828076 (Ejegg) [22:19:31] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Patch-For-Review, Unplanned-Sprint-Work: Create new CiviCRM backoffice letter version for sending through CiviCRM - https://phabricator.wikimedia.org/T151814#2870906 (Ejegg) Open>Resolved [22:22:04] fundraising-tech-ops, Operations: Port fundraising stats off Ganglia - https://phabricator.wikimedia.org/T152562#2870916 (Jgreen) By way of scoping: My understanding is that we're using prometheus-node-exporter to on each host to collect local metrics and listen on a TCP port for the HTTP request from t... [22:22:45] Fundraising Sprint Testing on Production, Fundraising Sprint Unbreaking Now, Fundraising Sprint Value Subtracting, Fundraising Sprint Waiting for Godot, and 3 others: Civi: restore the 'unsubscribe from spam' option to Main menu - https://phabricator.wikimedia.org/T147571#2696936 (Eileenmcnaughton... [22:32:39] (PS2) Eileen: Fix unsubscribe screen to hide results when data changes. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/326883 (https://phabricator.wikimedia.org/T147571) [22:32:41] (PS1) Eileen: Update unsubscribe extension to differentiate between opted out & already opted out [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/327115 (https://phabricator.wikimedia.org/T147571) [22:32:43] (PS1) Eileen: Update unsubscribe so that email is required [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/327116 (https://phabricator.wikimedia.org/T147571) [22:35:58] (CR) jenkins-bot: [V: ] Fix unsubscribe screen to hide results when data changes. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/326883 (https://phabricator.wikimedia.org/T147571) (owner: Eileen) [22:37:10] (CR) jenkins-bot: [V: ] Update unsubscribe extension to differentiate between opted out & already opted out [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/327115 (https://phabricator.wikimedia.org/T147571) (owner: Eileen) [22:37:11] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Patch-For-Review, Unplanned-Sprint-Work: Fail mail on 'city is too long' - https://phabricator.wikimedia.org/T152022#2835693 (Eileenmcnaughton) @Ejegg should we return this to review since there is still your mustache patch against it? [22:37:39] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Unplanned-Sprint-Work: Spurious Amazon clicks / Banners on googleweblight.com - https://phabricator.wikimedia.org/T152602#2870980 (Pcoombe) [22:38:02] (CR) jenkins-bot: [V: ] Update unsubscribe so that email is required [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/327116 (https://phabricator.wikimedia.org/T147571) (owner: Eileen) [22:57:48] * awight announces loudly that I'm using Visio cos it's the best tool for making diagrams [22:57:51] Just to screw with cwd [22:58:09] Either that or Illustrator ;-) [22:58:11] * cwd quietly sobs [22:58:37] * awight immediately changes tact and tries to recruit cwd to the Other Side [22:58:47] https://www.osalt.com/visio [22:59:15] * cwd gets a computer virus just thinking about it [22:59:40] I've pulled the unsubscribe page back into review because I made some updates based on feedback by Michael & ejegg [23:03:36] !log CiviCRM updated from 4bf38dae0ed99e8584190aafbc224b44fcce8b47 to 76bc6ba8f005c15410b8785c1d5543154187a17f [23:03:46] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [23:05:48] O_o [23:05:54] cwd: oh argouml is pretty nice actually [23:06:00] but only does a handful of diagram types [23:06:07] and is lacking Undo [23:06:11] which gets me right through the heart [23:08:28] ouch [23:08:55] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work: Spike: investigate slow queries - https://phabricator.wikimedia.org/T153134#2871044 (Eileenmcnaughton) [23:08:58] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi unresponsive for Engage in evenings - https://phabricator.wikimedia.org/T152786#2871045 (Eileenmcnaughton) [23:09:00] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review, Unplanned-Sprint-Work: CRM-19752 Fix impact of financial acl code on query speed - https://phabricator.wikimedia.org/T152936#2863990 (Eileenmcnaughton) Open>Resolved [23:09:41] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work: Slow query on contribution dashboard - https://phabricator.wikimedia.org/T153141#2871050 (Eileenmcnaughton) [23:09:58] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work: Slow query on contribution dashboard - https://phabricator.wikimedia.org/T153141#2871050 (Eileenmcnaughton) [23:23:41] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query rendering statistics for contribution search - https://phabricator.wikimedia.org/T153144#2871125 (Eileenmcnaughton) [23:24:03] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query rendering statistics for contribution search - https://phabricator.wikimedia.org/T153144#2871125 (Eileenmcnaughton) [23:24:49] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query on contribution dashboard - https://phabricator.wikimedia.org/T153141#2871156 (Eileenmcnaughton) [23:26:00] I've now put $80 into this free bike, but it's still a decent price for three months of transportation [23:26:12] i'll say [23:26:21] :-) [23:28:12] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Spike: Spike: Investigate huge spike in StaleCampaignException messages since Dec 8 - https://phabricator.wikimedia.org/T152741#2858756 (Ejegg) Open>Resolved Sounds like they must have been repl... [23:29:58] ejegg: i have had this print on my wall forever, you might like it: https://sadbastard.org/bicycle.jpg [23:30:35] i love it! [23:36:11] cool! [23:36:15] lmao [23:36:41] any time people idolize the bicycle however, I feel obliged to bring in exhibit B: the sailboat [23:36:58] everything should be a sailboat. [23:37:33] https://www.youtube.com/watch?v=J36Sr9lXS_w [23:39:07] until we end up canniballizing so much wind power the seasons stop changing [23:41:11] * XenoRyet wants a sailbike [23:41:27] fr-tech another symptom of blight is that images below the fold never load for long articles: https://googleweblight.com/?lite_url=https://es.wikipedia.org/wiki/Barack_Obama [23:42:02] Oh god that's so hobbled [23:42:07] t'is a blighted internet with no pictures alright [23:59:15] AndyRussG: you determined that the userAgent seen by JS is the same as the one in the request header? [23:59:35] I'm trying a test page with document.write(navigator.userAgent); [23:59:45] but it keeps saying 'This page could not be transcoded due to technical issues.'