[00:01:19] (PS3) Eileen: Dedupe Engage imports when email+name matchable, or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [00:05:52] (CR) jerkins-bot: [V: -1] Dedupe Engage imports when email+name matchable, or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) (owner: Eileen) [00:45:48] (PS4) Eileen: Dedupe Engage imports when email+name matchable, or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [00:49:55] (PS2) Ejegg: Merge branch 'master' into wmf_deploy [extensions/CentralNotice] (wmf_deploy) - https://gerrit.wikimedia.org/r/419313 [00:50:46] (CR) jerkins-bot: [V: -1] Dedupe Engage imports when email+name matchable, or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) (owner: Eileen) [00:53:57] (CR) Ejegg: [C: 2] Merge branch 'master' into wmf_deploy [extensions/CentralNotice] (wmf_deploy) - https://gerrit.wikimedia.org/r/419313 (owner: Ejegg) [00:56:21] AndyRussG: I diffed against master, and the merge looks good. I'mma request deploy during the 'Morning SWAT' slot tomorrow [00:56:23] (Merged) jenkins-bot: Merge branch 'master' into wmf_deploy [extensions/CentralNotice] (wmf_deploy) - https://gerrit.wikimedia.org/r/419313 (owner: Ejegg) [01:23:29] (PS5) Eileen: Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [01:28:38] (CR) jerkins-bot: [V: -1] Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) (owner: Eileen) [01:28:39] ejegg: okok [02:19:35] (PS6) Eileen: Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [02:37:17] (PS7) Eileen: Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [03:42:39] (PS8) Eileen: Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [03:49:16] (CR) jerkins-bot: [V: -1] Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) (owner: Eileen) [07:40:50] (PS9) Eileen: Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [07:46:02] (CR) jerkins-bot: [V: -1] Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) (owner: Eileen) [07:46:12] (PS10) Eileen: Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [07:47:01] (PS11) Eileen: Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [11:30:40] Fundraising-Backlog, Wikimedia-Fundraising: Move fundraising thank you pages to donate.wikimedia.org - https://phabricator.wikimedia.org/T189664#4049347 (Pcoombe) [12:10:34] Fundraising-Backlog, Wikimedia-Fundraising: Move fundraising support pages to donate.wikimedia.org - https://phabricator.wikimedia.org/T189668#4049417 (Pcoombe) [15:03:42] Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Fhabricator is spelled with an "F", an... - https://phabricator.wikimedia.org/T186883#4050028 [15:25:44] Fundraising Sprint Fhabricator is spelled with an "F", Fundraising-Backlog, Fr-Ingenico-integration_2017-18, Patch-For-Review: Ingenico adapter: parse response errors - https://phabricator.wikimedia.org/T176502#4050137 (jgleeson) [15:38:31] ejegg: what was the question you wanted to ask Hawking? [15:39:35] mepps: was saying you'll never get an answer? [15:41:18] dstrine: it was when I was taking time off college [15:41:27] i had gotten disillusion with physics [15:41:44] oh cool [15:42:06] cause the experiments had gotten so expensive you had post-docs working for years on trivial tiny bits of them [15:42:19] and i didn't feel like i had the math chops for theoretical physics [15:43:17] so when i randomly saw him at a restaurant in harvard square, i waited outside till his helpers went to get the van, and asked him if it was still possible for a single person to make a meaninful contribution in expermental physics [15:44:12] but as he was composing an answer, some dumb kid came up and started pointing at him saying stuff like oh damn, you're that guy from the discovery channel [15:44:20] and that's when his helpers came back [15:44:37] so they whisked him out to the van before i heard his answer [15:47:06] good question [15:48:42] ejegg: Oh man. Yeah, I had the same disillusionment with "Big Science". One reason I switched from studying physics (which had always been my dream) to materials science, it just seemed so much more practical to have a real impact. [15:49:20] ejegg: oh man that's a crazy story [15:49:34] That dream partly inspired by Hawking of course. I saw him around Cambridge a couple of times, but never had a chance to speak to him. [15:50:04] crap now I'm jealous of both of you ejegg and pcoombe [15:50:14] ^^ [15:50:16] ejegg: good question [15:50:38] pcoombe: ejegg; one can always switch back to such a career around mid-life-crisis time [15:53:59] heh, man, i think that's almost as tough as deciding to go into medical school later in life [15:54:05] dstrine: It was only ever brief glances. Surprising how fast he would drive that wheelchair around! [15:54:10] especially the math-heavy bits [15:54:45] they say mathematicians mostly publish all their good papers in their 20s [15:54:53] AndyRussG: I'm very happy where I've ended up though, even if it was a bit of a strange route getting here :) [15:54:58] heh, same! [15:56:41] the proper version of a bachelors is supposed to make you a well rounded person, able to do many things. Few of us actually do what we studied (looks at film degree gathering dust). [15:57:40] pcoombe: ejegg cool! [15:57:53] dstrine: film! neat! [16:18:24] Fundraising-Backlog: CPS report of high donation volume in IT - https://phabricator.wikimedia.org/T189697#4050362 (DStrine) [16:19:07] 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: Stat1005 BH data i... - https://phabricator.wikimedia.org/T181811#3803125 [16:20:50] Fundraising-Backlog: CPS report of high donation volume in IT - https://phabricator.wikimedia.org/T189697#4050362 (DStrine) @Pcoombe or @CCogdill_WMF does this spike match any tests or emails? [16:30:14] PROBLEM - check_procs on frdb1001 is CRITICAL: PROCS CRITICAL: 1146 processes [16:40:14] RECOVERY - check_procs on frdb1001 is OK: PROCS OK: 217 processes [17:05:05] PROBLEM - check_procs on frdb1002 is CRITICAL: PROCS CRITICAL: 1082 processes [17:07:31] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: MG search killed Civi - https://phabricator.wikimedia.org/T189705#4050620 (DStrine) [17:10:05] PROBLEM - check_mysql on frdb1002 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1211 [17:10:05] RECOVERY - check_procs on frdb1002 is OK: PROCS OK: 483 processes [17:10:06] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1211 [17:15:05] RECOVERY - check_mysql on frdb1002 is OK: Uptime: 3009384 Threads: 1 Questions: 201614572 Slow queries: 2024874 Opens: 17107 Flush tables: 1 Open tables: 877 Queries per second avg: 66.995 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [17:15:05] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 2900732 Threads: 5 Questions: 191833580 Slow queries: 392517 Opens: 17108 Flush tables: 1 Open tables: 1204 Queries per second avg: 66.132 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [17:21:50] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: MG search killed Civi - https://phabricator.wikimedia.org/T189705#4050620 (LeanneS) All searches have been going slow this morning, but the ones that kept loading without yielding any results were using Advanced Search with the following criteria: Cont... [17:26:21] fr-tech any news for scrum of scrums? [17:26:41] None here [17:27:31] none from me! [17:27:46] ejegg: nothing special here... I guess security stuff deploy and announce deserve a mention, as you see fit :) [17:28:03] yep, got the CN stuff in! [17:34:55] ejegg nope! [17:50:11] PROBLEM - check_procs on frdev1001 is CRITICAL: PROCS CRITICAL: 1471 processes [17:51:02] Fundraising-Backlog: CPS report of high donation volume in IT - https://phabricator.wikimedia.org/T189697#4050790 (Pcoombe) That's strange, we were just running our normal desktop campaign then. I don't see any donation spike in Civi at that time, and the [banner activity in Pivot](https://pivot.wikimedia.or... [17:52:16] Fundraising-Backlog: CPS report of high donation volume in IT - https://phabricator.wikimedia.org/T189697#4050802 (CCogdill_WMF) The last IT email was 2018-02-21, so that shouldn't be a factor here either. [17:55:11] RECOVERY - check_procs on frdev1001 is OK: PROCS OK: 454 processes [18:02:00] hey fr-tech, running an errand, back later [19:04:35] fundraising-tech-ops, Operations, ops-eqiad: rack frpig1001 - https://phabricator.wikimedia.org/T187365#4051190 (Cmjohnson) a:ayounsi @ayounsi can you help setup network ports please and assign to Jeff Green once finished. Thanks! [19:05:02] fundraising-tech-ops, Operations, ops-eqiad: rack frdata1001 - https://phabricator.wikimedia.org/T187364#4051193 (Cmjohnson) a:ayounsi @ayounsi can you help setup network ports please and assign to Jeff Green once finished. Thanks! [19:05:30] fundraising-tech-ops, Operations, ops-eqiad, Patch-For-Review: Rack/setup frmon1001 - https://phabricator.wikimedia.org/T186073#4051197 (Cmjohnson) a:ayounsi @ayounsi can you help setup network ports please and assign to Jeff Green once finished. Thanks! [19:06:03] fundraising-tech-ops, Operations, ops-eqiad: rack frbast1001 - https://phabricator.wikimedia.org/T187363#4051201 (Cmjohnson) a:ayounsi @ayounsi can you help setup network ports please and assign to Jeff Green once finished. Thanks! [19:18:29] Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Fhabricator is spelled with an "F", an... - https://phabricator.wikimedia.org/T186883#4051282 [20:53:30] (PS1) Hashar: Let install.php detect and inject extensions [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/419526 (https://phabricator.wikimedia.org/T189567) [20:54:34] (CR) Hashar: "Same as the REL1_27 patch ( https://gerrit.wikimedia.org/r/419393 )." [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/419526 (https://phabricator.wikimedia.org/T189567) (owner: Hashar) [20:59:08] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Unplanned-Sprint-Work: Spike: investigate slow queries - https://phabricator.wikimedia.org/T153134#4051662 (Eileenmcnaughton) [20:59:11] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Slow query - contribution search - https://phabricator.wikimedia.org/T153129#4051661 (Eileenmcnaughton) Open>Resolved [21:01:37] Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Fhabricator is spelled with an "F", and... - https://phabricator.wikimedia.org/T171987#4051691 [21:01:40] Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Fhabricator is spelled with an "F", and... - https://phabricator.wikimedia.org/T175900#4051690 [21:02:11] Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Fhabricator is spelled with an "F", and... - https://phabricator.wikimedia.org/T171987#3482312 [21:13:46] (PS2) Ejegg: Update CommentStore usage [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/418147 (owner: Anomie) [21:14:02] (CR) Ejegg: [C: 2] "Looks good!" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/418147 (owner: Anomie) [21:17:19] (Merged) jenkins-bot: Update CommentStore usage [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/418147 (owner: Anomie) [21:29:47] ejegg: Ok, I've finally got a list of GC transactions in the format mepps said the script wanted. [21:30:05] it's on frdev in the temp folder [21:30:13] XenoRyet: OK, and the plan is to run the refunds today, right? [21:30:28] Yea, I think so. [21:30:36] ccogdill: Can you confirm that? [21:30:48] I can get you a list of GC emails, that's already on frdev as well. [21:30:51] XenoRyet: OK, I'll start with the first 5 [21:35:12] yeah, works for me! [21:36:24] XenoRyet: cool, I think we just need to do the reverse mapping of the submethods [21:36:38] Yea, just noticed I forgot to do that part. [21:36:50] we really should have that mapping in a db table someplace :( [21:37:03] Yea, would be nice [21:37:10] XenoRyet let me know where that list is when you can [21:37:54] ccogdill: Can you log on to frdev1001? If so, it's in the tmp directory there. [21:38:13] if not, maybe ejegg can put it on the file server while I do one last tweek to the refund list. [21:38:23] for some reason I can't get into the file server myself [21:38:29] I don't know how to search within directories [21:38:36] I'm good at mysql but not that :D [21:39:25] if you know the filename I can get it [21:39:47] or the query and I can dump it into a txt file from there [21:39:52] unintendedRecurGCEmails.csv in the /tmp directory [21:40:03] thanks! [21:40:16] no worries [21:40:47] ooh and a csv, so nice [21:41:06] I try to be polite with my file formats ;-) [21:46:33] ejegg: submethods are in that file now. [21:46:44] cool, will try the first 5 [21:54:57] XenoRyet: oh shoot, we need one more thing for that file, and it might not be in the db... [21:55:04] the merchant reference [21:55:18] orrrr maybe we're putting that in invoice_id now, lemme see [21:56:52] let's hope it's in the db somewhere [21:57:07] argh, it's not in invoice_id [21:57:35] Am I remembering right that it's their name for our contribution tracking id? [21:58:06] the recurs don't have rows in contribution tracking [21:58:25] right, they'll have the same merchant ref as the original txn [21:58:36] i'm just worried it's that darn random number [22:00:06] well crap, it is [22:00:24] that's not good [22:00:25] I think I can stick the stuff together based on the logs [22:00:38] yea? [22:01:17] yeah, want to do this via screenshare? [22:01:58] I have the email ready to go--should I wait a bit longer? take Beast for a walk and come back? [22:02:15] I'll jump in the normal hangout [22:02:18] ccogdill: it'll be at least a half hour here [22:02:26] k thanks! [22:09:02] ejegg, XenoRyet: probably going to make my way home before long, anything you need from me at this point? [22:09:21] Na, we should be good [22:09:54] right on, good luck! i'll check in later [22:32:29] ejegg XenoRyet - how's she looking? [22:33:12] still messing with the logs getting a missing number, but we're making progress [22:34:29] okay cool [22:34:53] I'm going to slightly adjust our email language to say we "are refunding" and schedule it to go out in 10 [22:35:01] MBeat is that okay with you? [22:35:14] this is a weird time for GB but it's fine for other time zones [22:35:22] sure thing, ccogdill [22:39:49] sending you a test email, FYI [22:40:10] main send has been schedule for 10:45pm GMT (3:45pm PST) [22:41:35] thanks! [22:57:37] (PS12) Eileen: Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [23:01:54] ejegg: mepps early response from a donor we just notified about the unintended recurring: [23:01:57] You’re good people. Thank you. Happy to be a supporter of your great resource reference. [23:02:30] :) [23:02:45] et al, XenoRyet [23:02:58] thank you fr-tech [23:03:09] (CR) jerkins-bot: [V: -1] Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) (owner: Eileen) [23:09:02] (PS13) Eileen: Dedupe Engage imports when email+name matchable, name+address matchable or when anonymous. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/419331 (https://phabricator.wikimedia.org/T189617) [23:16:46] MBeat: argh, the batch script is failing on missing country, this'll take a little longer [23:17:13] totally fine, ejegg [23:21:00] (PS1) Ejegg: Stuff country with default for refunds [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/419622 (https://phabricator.wikimedia.org/T186883) [23:21:26] (CR) XenoRyet: [C: 2] Stuff country with default for refunds [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/419622 (https://phabricator.wikimedia.org/T186883) (owner: Ejegg) [23:23:14] (PS1) Ejegg: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/419624 [23:25:40] (CR) jerkins-bot: [V: -1] Stuff country with default for refunds [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/419622 (https://phabricator.wikimedia.org/T186883) (owner: Ejegg) [23:25:56] (PS1) Ejegg: Update DonationInterface submodule [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/419625 [23:27:08] (PS2) Ejegg: Stuff country with default for refunds [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/419622 (https://phabricator.wikimedia.org/T186883) [23:27:33] (CR) XenoRyet: [C: 2] Stuff country with default for refunds [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/419622 (https://phabricator.wikimedia.org/T186883) (owner: Ejegg) [23:28:18] (PS1) Ejegg: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/419626 [23:28:29] (Abandoned) Ejegg: Update DonationInterface submodule [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/419625 (owner: Ejegg) [23:28:42] (Abandoned) Ejegg: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/419624 (owner: Ejegg) [23:28:55] fundraising-tech-ops, Operations, ops-eqiad: rack frpig1001 - https://phabricator.wikimedia.org/T187365#4052029 (ayounsi) a:ayounsi>Jgreen Switch port configured. [23:30:17] (Merged) jenkins-bot: Stuff country with default for refunds [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/419622 (https://phabricator.wikimedia.org/T186883) (owner: Ejegg) [23:30:28] (CR) Ejegg: [C: 2] Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/419626 (owner: Ejegg) [23:30:41] Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Fhabricator is spelled with an "F", Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Fr-CiviCRM-dedupe-FY2017/18: Step 1 , 2 and 3 of engage import - https://phabricator.wikimedia.org/T189617#4052036 (Eileenmcna... [23:30:42] (PS1) Ejegg: Update DonationInterface [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/419627 [23:31:18] (Merged) jenkins-bot: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/419626 (owner: Ejegg) [23:31:22] (CR) Ejegg: [C: 2] Update DonationInterface [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/419627 (owner: Ejegg) [23:32:20] fundraising-tech-ops, Operations, ops-eqiad: rack frdata1001 - https://phabricator.wikimedia.org/T187364#4052040 (ayounsi) a:ayounsi>Jgreen Switch port configured. [23:34:36] fundraising-tech-ops, Operations, ops-eqiad, Patch-For-Review: Rack/setup frmon1001 - https://phabricator.wikimedia.org/T186073#4052047 (ayounsi) a:ayounsi>Jgreen Switch port configured. [23:36:29] fundraising-tech-ops, Operations, ops-eqiad: rack frbast1001 - https://phabricator.wikimedia.org/T187363#4052049 (ayounsi) a:ayounsi>Jgreen Switch ports configured. [23:41:45] (Merged) jenkins-bot: Update DonationInterface [core] (fundraising/REL1_27) - https://gerrit.wikimedia.org/r/419627 (owner: Ejegg) [23:45:41] !log updated payments-wiki from 86715f6e9e to 9068692c32 [23:45:45] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [23:55:45] hi XenoRyet|afk , looks like you got it up? [23:58:23] argh, now it's failing with NULL VALUE IS NOT ALLOWED FOR EFFORTID [23:58:32] how are we not sending an effortid?