[00:04:12] K4-713: quick question about travel dates: Doreen sent me two flight options, one involves arriving on Sunday evening as I requested, and the other involves arriving on Monday afternoon. Departure times are about the same, and they're both cost the same, but the arriving Monday option would be much quicker in both directions because it's direct... [00:06:59] K4-713: OK, trying the export with read uncommitted. will also attempt to add an email to my civi contact while the heavy queries are running [00:08:33] hmm. [00:08:37] worked fine during the insert into...select from [00:08:39] I don't know if that's going to work. [00:09:07] you mean you don't think it's a good indicator? [00:09:20] or the whole read uncommitted thing is a bad idea? [00:09:25] AndyRussG: Yeah, I think it's fine if you take the Monday flight. [00:09:35] Either way you want to go, will work. [00:09:38] K4-713: fantastic thanks :) [00:09:47] ejegg: Er. [00:10:10] Hang on a minute while I look something up. [00:10:13] Yeah less travel time = generally better, it's only waking up 1 hour earlier than usual on Monday [00:10:29] also direct flight = less carbon emissions [00:11:47] * AndyRussG things the solar-powered airline doesn't do SF-Montreal yet [00:15:23] ejegg: I think you may have to worry more about the transaction isolation levels being used by the queue consumer, and civi. [00:15:35] K4-713: ahh, phooey [00:16:02] Or, at least, the same amount of worry. Heh. [00:16:20] Possibly just qc, come to think of it. [00:17:02] I wouldn't want to get in the habit of sprinkling everything with read uncommitted [00:21:05] Well, as soon as it gets to the update with joins brouping by email, I'll try editing in civi just for kicks, then kill the job [00:21:27] and then check out how ugly the intermediate file solution would be [00:22:56] actually, the select into a temp table seemed not to lock, just the nasty update with join. So we could probably just make a temp copy of the source tables with select into. [00:36:16] K4-713: actually, this seems to be working! [00:37:39] orly [00:38:26] donations queue consumer ran fine during the worst query, and I was able to add and remove email addys to my contact with no lag [00:46:15] (PS2) Ejegg: Database voodoo so sp export doesn't lock up db [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/174313 [00:56:27] atgo: see my note on card 1957? Who should be responsible for editing that CSS if it can be done on the foundation wiki? [00:56:36] i assume our team? [00:56:48] i'm not sure... K4-713 do you know? [00:58:07] OK, cool, makes sense 'cause it interacts with stuff we deploy moreso than most wiki-editable elements [01:02:01] Whoa, were we supposed to apply that to our gateway stylesheet too? Cause those fields look way different from the ones on our site [01:02:05] reverting [01:03:14] think that needs to be coordinated with a gateway.css deploy [01:06:22] hur? [01:06:26] Ah. [01:07:05] atgo: Rule of thumb is that if it's on-wiki, it's the-wub. [01:07:10] But. [01:07:57] If it involves poking something inside our account, we'll need to coordinate. [01:08:30] yeah, this needs no account poking, just matching the deployed css change with the wiki-editable css change [01:09:03] only the RTL bit needs account poking [01:09:45] should I throw it back to the-wub? [01:10:19] We should at least involve him, I think. [01:10:29] ah i see. so we can't do our deployment before changing the css on foundationwiki? [01:10:44] Well, we can. It'll just look funny for a minute. [01:10:51] Well. [01:10:55] Funnier than now. [01:11:31] haha [01:11:46] ok... we have bigger fish to fry unfortunately [01:12:22] We do? [01:12:33] well... nearly everything else in the sprint [01:12:44] Oh. Right. [01:12:47] That. [01:12:49] :P [01:14:28] And on that note, I'm going to peace out for today. [01:14:36] see ya later [01:15:34] yo tambíen [01:15:47] ah shit. también [01:15:51] * atgo hangs head [01:17:06] WMF LYBUNT works! [01:17:22] as long as you don't choose year = 2004-6 [01:17:43] ejegg that's awesome!!!!!! [01:17:44] ...and we're not updating daily, just yet [01:17:52] what do you mean? [01:18:10] I ran it on barium to test, out of a private hacked up copy [01:18:24] generated all the data that the report needs [01:19:00] but we haven't deployed to the real exporter and updated the scheduled job [01:19:34] So if people donate tomorrow, they won't show up as 2014 donors yet [01:19:49] I'll coordinate the job switch with Jeff tomorrow [01:20:08] oh awesome [01:20:22] so once that's done it should work as expected? [01:20:28] Yep. [01:35:05] (PS1) Ejegg: Update input and select styling for GlobalCollect [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/174617 [17:30:56] Jeff_Green: I tried the silverpop export again yesterday, but setting the session transaction isolation level to 'read uncommitted', and it let the qc run with no errors [17:31:30] I was adding and removing email addresses from my civi contact during the heaviest queries, and there was no lag [17:46:51] ejegg: ok, great [17:47:22] sounds like we can leave it on fundraisingdb's to me [17:48:07] ejegg: should I add it to lutetium's replication, so you have a read-only instance there that can be abused? [17:55:03] Jeff_Green: Yeah, that would be great [17:55:19] alright. it's not updating now right? [17:55:38] Also, after I get the code +2ed and deployed we'll need to change the host in the config file. [17:55:49] ok [17:55:53] nope, it's not running now [17:56:10] why don't we deal with that part first, and then I'll do replication [17:56:29] otherwise it's going to explode next time it runs [17:57:57] good call [17:58:20] hey Jeff_Green - did you get a chance to set heather o'malley up with her cert for civi? [17:58:26] also good morning everyone! [17:58:34] hi atgo! [17:58:39] hiiii! [17:58:44] atgo: nobody responded re. cell [17:58:54] ohh ok [17:59:00] ccogdill: did you get heather's cell number confirmed? [17:59:21] no I didn’t, I thought she was following up with Jeff [17:59:24] I can email her. [18:20:56] ccogdill: i think we left things that you were going to confirm that the number you had for her was her cell [18:21:46] I think I said in the thread that I would wait for her to confirm [18:21:53] but I’ll follow up with her directly [18:30:38] ahh ok! thanks ccogdill :) [18:43:05] hey the-wub_... any idea why i might be getting country=XX from donate.wikimedia.org? [18:43:18] (PS3) Ejegg: Database voodoo so sp export doesn't lock up db [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/174313 [19:06:50] does payments serve anything through the varnishes? [19:36:42] Hi K4-713 ! [19:36:53] ejegg: Hey! I'm in the hangout. [19:37:02] OK, be right there [19:57:45] (PS1) Ejegg: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/174785 [19:58:46] (CR) Katie Horn: [C: 2] Database voodoo so sp export doesn't lock up db [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/174313 (owner: Ejegg) [19:59:46] (CR) Katie Horn: [C: 2] Allow periods in message correlation ids [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/174595 (owner: Ejegg) [20:05:14] (PS1) Ejegg: Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - https://gerrit.wikimedia.org/r/174792 [20:05:48] (CR) Ejegg: [C: 2] "+2 for deploy" [wikimedia/fundraising/tools] (deploy) - https://gerrit.wikimedia.org/r/174792 (owner: Ejegg) [20:10:57] !log updated tools from fe9b463379fac35ad5e71a57fbbb95ae39e2356e to b537e2ec80d16b84f8e0539d4e3d78c8afef1b63 [20:10:59] Logged the message, Master [20:12:12] Jeff_Green: The silverpop export code is updated. You can swap the host in the config file whenever you want [20:21:10] ok [20:21:51] ejegg: which config file are we talking about? [20:51:21] (PS2) AndyRussG: WIP Use per-campaign buckets, with smooth transition [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/174581 [20:51:54] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/174799 [20:52:08] (CR) Ejegg: [C: 2] "+2 for deploy" [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/174799 (owner: Ejegg) [20:52:35] (CR) jenkins-bot: [V: -1] WIP Use per-campaign buckets, with smooth transition [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/174581 (owner: AndyRussG) [20:54:25] !log updated crm from ff89895638a0dd0600b2e4c0b6adfd1b8e402df5 to ed3f3f8e31119eb7d52d5730ece4e22ac1dd055a [20:54:31] Logged the message, Master [21:04:44] (PS1) Ejegg: Allow submitting / downloading messages with '.' [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/174801 [21:16:35] (CR) Ejegg: [C: 2] "+2 for deploy" [extensions/DonationInterface] (deployment) - https://gerrit.wikimedia.org/r/174785 (owner: Ejegg) [21:21:12] K4-713: this was the other fix for the damaged queue: https://gerrit.wikimedia.org/r/174801 [21:22:27] ejegg: Looking [21:22:43] hey ejegg [21:22:48] looking at this one: https://wikimedia.mingle.thoughtworks.com/projects/online_fundraiser/cards/2144 [21:23:02] you said you added it to the sprint so it doesn't get forgotten - does it need to happen before DEcember? [21:23:14] (CR) Katie Horn: [C: 2] "Get 'em all this time? Heh." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/174801 (owner: Ejegg) [21:23:30] atgo, I'm not totally sure about that. I know it was making WP refunds easier for somebody [21:24:02] ok... WP is really low volume so i'm going to take it out of the sprint and add it to the "Worldpay Followup" supertask [21:24:05] sound ok? [21:24:10] ahh, ok [21:24:20] so long as it doesn't get lost! [21:24:22] ok :) [21:26:24] deploying the logspam / WP test forms DonationInterface update [21:33:57] !log updated payments-wiki e3d235f881282120409e1a6ed1a3908ce9a63c26 to 1e533d6dfc200e6a84f0a8418a8a1ecddb2b3aed [21:33:59] Logged the message, Master [21:37:05] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/174817 [21:37:18] (CR) Ejegg: [C: 2] "+2 for deploy" [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/174817 (owner: Ejegg) [21:38:13] !log updated crm from ed3f3f8e31119eb7d52d5730ece4e22ac1dd055a to e13cae8c418d29ef444899e0a70bbe03f4b7079d [21:38:15] Logged the message, Master [21:53:35] yay ejegg! lybunt! [21:53:51] major gifts is going to be sooo happy [21:54:13] yep, the full update seems to have run without problems! [22:01:19] (PS4) Ssmith: Fix range values [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/173064 [22:07:56] ejegg: hey... deploy windows are wide open tomorrow... any preference re: times? [22:08:40] somewhat early would be nice, but no so early that we're rushing the review. The patch still needs more coding, right? [22:08:59] Basically just fixing the tests to make 'em run [22:09:05] ah, cool [22:09:27] i'll look over the rest of it then [22:09:31] We could even take 2 slots, one quite early to deploy to test sites, and another later to deploy everywhere around midday [22:09:33] Thanks! [22:09:41] :) [22:13:36] ejegg: the only other thing it could use is a bit more comments... [22:13:40] I'll add those... [22:17:14] ok [22:19:12] ejegg: thanks... ah oops also gotta change RecordImpression... [22:31:59] (PS1) Katie Horn: Changing legal text in en [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/174837 [22:35:36] atgo: Is there a card for the legal text changes? [22:35:43] not yet [22:35:49] want me to make one or you got it? [22:35:54] I have submitted the initial patch. [22:36:21] Heh, I can make one. Just didn't want to have that parallel effort thing going on. :) [22:36:29] ...and, she's gone. [22:37:11] atgo: You missed it. I said "I can make one. Just didn't want to have that parallel effort thing going on. :)" [22:40:36] (PS3) AndyRussG: WIP Use per-campaign buckets, with smooth transition [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/174581 [22:40:48] ejegg: there it is w/ more comments and impressionData... [22:41:49] (CR) jenkins-bot: [V: -1] WIP Use per-campaign buckets, with smooth transition [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/174581 (owner: AndyRussG) [22:42:03] AndyRussG: thanks! [22:42:22] np, likewise! [22:42:57] (PS3) Ssmith: Make navbar px-perfect [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/173224 [22:46:57] (PS4) AndyRussG: WIP Use per-campaign buckets, with smooth transition [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/174581 [22:47:42] (PS1) Cmcmahon: QA: this is how beta works right now [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/174839 [22:47:43] ejegg: I have to run for a little while... That last patch should take care of jslint---can we decide on the deploy times by e-mail or if not a bit later? Thanks a lot!! :) [22:48:06] OK, email works [22:48:10] (CR) jenkins-bot: [V: -1] WIP Use per-campaign buckets, with smooth transition [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/174581 (owner: AndyRussG) [22:48:45] thanks! I'll also fix the qunit in a bit :) [22:49:34] !log rolled back payments-wiki from 1e533d6dfc200e6a84f0a8418a8a1ecddb2b3aed to e3d235f881282120409e1a6ed1a3908ce9a63c26 [22:49:39] Logged the message, Master [23:25:54] (PS4) Ssmith: Make navbar px-perfect [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/173224 [23:35:34] (CR) Ejegg: [C: 2] Fix range values [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/173064 (owner: Ssmith) [23:35:53] (PS6) Ejegg: Extend ChartJS and make selection chart dynamic [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/173190 (owner: Ssmith) [23:45:29] (CR) Ejegg: [C: 2] "As discussed, will replace mouseout with KO's subscribe in a future patch" [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/173190 (owner: Ssmith) [23:47:04] (PS5) Ejegg: Make navbar px-perfect [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/173224 (owner: Ssmith) [23:53:24] (CR) Ejegg: [C: 2] Make navbar px-perfect [wikimedia/fundraising/dash] - https://gerrit.wikimedia.org/r/173224 (owner: Ssmith) [23:57:13] hey meganhernandez if there's anything else for today, i need to run in about 30 [23:58:01] hi atgo haven;t seen email in a while [23:58:11] are we good to put US back up and send emails tomorrow? [23:58:18] the patch is pending review [23:58:37] ok, do you know when that will go out? [23:59:57] talking to k4-713 right now, it looks like maybe tomorrow?