[00:03:43] Yea, that is the question. If we had an actual example I'd want to see if it made it into any other tables we could left join against to look for more. [00:05:48] XenoRyet ah, I think I see what's up with one of those [00:06:21] So, there are TWO payments in the logs with the one ct_id. It's like another one of those reload things [00:06:28] and we should refund the later one [00:07:01] Ah, ok. [00:07:21] but because of the silly way we link the table (contribution_tracking has a column with contribution_id in it), the contribution_tracking row ends up associated with whichever came in later [00:08:08] ooh, and we just need to check for gaps in the sequence [00:09:16] Is there any way a gap in the sequence might show up under normal opperation? [00:09:22] select count(*) from contribution_tracking c1 inner join contribution_tracking c2 on c1.id = c2.id + 1 where c1.id between 45000000 and 45700000 and c2.id between 45000000 and 45700000; [00:09:26] 700000 [00:09:32] so, no failures lately [00:10:29] k, I think this really is a false alarm, and we just need to redouble our efforts to prevent duplicate charges [00:10:43] Yep, I agree. [00:11:00] That querry tells the tale well enough. [00:15:30] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-ContributionTracking, MediaWiki-extensions-DonationInterface, Spike: ContributionTracking sometimes fails to insert rows - https://phabricator.wikimedia.org/T153730#2897630 (Ejegg) Yep, false alarm. There was ano... [00:15:54] Fundraising Sprint Value Subtracting, Fundraising Sprint Waiting for Godot, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-2016-17-Q2-Bugs: [Spike] investigate contribution tracking data (was Engage import failing to import certain signi... - https://phabricator.wikimedia.org/T146295#2897635 [00:15:56] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-ContributionTracking, MediaWiki-extensions-DonationInterface, Spike: ContributionTracking sometimes fails to insert rows - https://phabricator.wikimedia.org/T153730#2888867 (Ejegg) Open>Resolved a:Ejegg [00:18:06] XenoRyet: want to talk through that new ticket ^^^ [00:18:08] ? [00:19:23] XenoRyet: err, this one: https://phabricator.wikimedia.org/T153992 [00:19:53] Sure [00:20:54] OK, let's figure out where we read from contribution_tracking in DonationInterface [00:21:02] guess it's got cwd's face on it, but I don't know if he's actually licked the cookie yet. [00:21:17] Doesn't stop us talking about it anyway. [00:21:20] oh, oops, just 'cause I made it a subtask of his other one [00:21:26] Ah. [00:21:28] he's working on plugging the hole from the front end [00:21:35] cool [00:21:44] not to mention saving a page load per donation! [00:22:29] XenoRyet: fr-tech-talk? [00:22:44] Sure, brt [00:51:53] (PS1) Ejegg: WIP fetch contribution_id for orphans [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/328855 [01:08:37] (PS2) Ejegg: Check contribution_id before rectifying orphans [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/328855 (https://phabricator.wikimedia.org/T153992) [01:10:08] (PS2) Cdentinger: WIP: Process payment before popping out of iframe [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/328725 (https://phabricator.wikimedia.org/T153972) [01:11:06] well i'm outta here, have a great holiday everyone [01:13:46] (PS1) Ejegg: Batch look up order status for Ingenico [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/328858 [01:13:57] later cwd|afk [01:14:06] and to all a good night [01:22:56] (CR) Ejegg: "Yes! Totally on the right track" (2 comments) [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/328725 (https://phabricator.wikimedia.org/T153972) (owner: Cdentinger) [01:29:50] (CR) Ejegg: "Even better: this is an opportunity to DRY up globalcollect_resultswitcher, as it duplicates code from GatewayPage::handleResultRequest." [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/328725 (https://phabricator.wikimedia.org/T153972) (owner: Cdentinger) [01:34:59] Fundraising Tech Backlog, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, I18n, RTL: Time selector on SpecialCentralNotice should use a standardized module - https://phabricator.wikimedia.org/T38793#2897814 (Krinkle) [01:35:14] Fundraising Tech Backlog, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, I18n, RTL: Time selector on SpecialCentralNotice should use a standardized module - https://phabricator.wikimedia.org/T38793#406919 (Krinkle) [01:36:06] Fundraising Tech Backlog, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, I18n, RTL: Time selector on SpecialCentralNotice should use a standardized module - https://phabricator.wikimedia.org/T38793#406919 (Krinkle) >>! In T38794#2897812, @Krinkle wrote: > If CentralNotice's page is... [04:19:08] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Spike: Impressions abnormally low for Ireland - https://phabricator.wikimedia.org/T152650#2898074 (AndyRussG) Here's the [[ https://gist.github.com/AndrewGreen/3a512d0cfe01c5cf8db6ae217d7b66c7 | ipython not... [04:43:12] Fundraising Tech Backlog, Fundraising-Backlog, MediaWiki-extensions-CentralNotice, I18n, RTL: Time selector on SpecialCentralNotice should use a standardized module - https://phabricator.wikimedia.org/T38793#2898087 (kaldari) @Krinkle: I'm confused. If [[ https://www.mediawiki.org/wiki/Manual... [18:00:09] fr-tech: If swimming is so good for your figure, how come whales look the [18:00:09] way they do? [18:00:09] -- discuss. [18:52:35] fundraising-tech-ops, Operations, ops-eqiad: Degraded raid on barium - https://phabricator.wikimedia.org/T154039#2899402 (fgiunchedi) [19:26:07] fundraising-tech-ops, Operations, ops-eqiad: Degraded raid on barium - https://phabricator.wikimedia.org/T154039#2899402 (Cmjohnson) This will required downtime to replace the disk. There are 4 internal 3.5" disks. I can do this next week if it works for @jeff_green [19:45:40] fundraising-tech-ops, Operations, ops-eqiad: Degraded raid on barium - https://phabricator.wikimedia.org/T154039#2899521 (Jgreen) Barium has two RAID1 partitions, the disk that failed belongs to the OS /archive partition which is used to buffer logs and jenkins output for sync offhost for long-term a... [22:42:46] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Spike: Impressions abnormally low for Ireland - https://phabricator.wikimedia.org/T152650#2899891 (AndyRussG) Just checked the data for December 18th. Unknown region in Ireland still had the lowest impressi... [22:49:36] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Spike: Impressions abnormally low for Ireland - https://phabricator.wikimedia.org/T152650#2856086 (Dzahn) @AndyRussG Maybe filling out this form with a "GeoIP data correction request" and your contact data... [22:58:26] Fundraising Sprint Waiting for Godot, Fundraising-Backlog, MediaWiki-extensions-CentralNotice: Spike: Impressions abnormally low for Ireland - https://phabricator.wikimedia.org/T152650#2856086 (bd808) My guess is that these IP blocks don't have any valid [[https://en.wikipedia.org/wiki/Shared_Whois_P...