[00:08:32] 06Fundraising-Backlog, 06Wikipedia-Android-App-Backlog, 06Wikipedia-iOS-App-Backlog: Update donation links in apps to use wmf_ parameters - https://phabricator.wikimedia.org/T367360#9942769 (10Cstone) @Tsevener hey sorry this got lost as we were at our offsite last week. @JMando would the change in utm_sou... [00:37:54] (03PS1) 10Eileen: Queue WMFDonor updates to co-worker [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051221 (https://phabricator.wikimedia.org/T368974) [00:38:42] gonna take a break & then try to run ^^ on staging [00:39:45] (03PS2) 10Eileen: Queue WMFDonor updates to co-worker [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051221 (https://phabricator.wikimedia.org/T368974) [02:04:15] (03PS1) 10Cstone: WIP: Switch utm_ to wmf_ [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1051225 (https://phabricator.wikimedia.org/T367360) [02:09:25] (03PS3) 10Eileen: Queue WMFDonor updates to co-worker [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051221 (https://phabricator.wikimedia.org/T368974) [02:13:17] OK - Tried that update a bit on staging & I think it looks good - am ready to try on prod once I can get a +2 [02:14:51] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: LeeroyJenkinsssss(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Civi-Dedupe: Unnecessary deduple conflicts on language - https://phabricator.wikimedia.org/T298169#9942846 (10Eileenmcnaughton) 05Open→03Resolved [02:15:04] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: LeeroyJenkinsssss(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10FR-Civi-Dedupe: Unnecessary deduple conflicts on language - https://phabricator.wikimedia.org/T298169#9942847 (10Eileenmcnaughton) [02:22:06] (03PS1) 10Eileen: Finally remove 2018 paypal legacy handling [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051226 (https://phabricator.wikimedia.org/T365415) [02:34:23] (03PS1) 10Eileen: Move wmf_civicrm_get_wmf_contribution_extra function to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051227 (https://phabricator.wikimedia.org/T365415) [02:34:24] (03PS1) 10Eileen: Move _wmf_civicrm_get_contact_last_donation_data to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051228 (https://phabricator.wikimedia.org/T365415) [02:44:43] (03CR) 10CI reject: [V:04-1] Finally remove 2018 paypal legacy handling [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051226 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [02:46:14] (03PS2) 10Eileen: Finally remove 2018 paypal legacy handling [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051226 (https://phabricator.wikimedia.org/T365415) [02:46:14] (03PS2) 10Eileen: Move wmf_civicrm_get_wmf_contribution_extra function to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051227 (https://phabricator.wikimedia.org/T365415) [02:46:15] (03PS2) 10Eileen: Move _wmf_civicrm_get_contact_last_donation_data to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051228 (https://phabricator.wikimedia.org/T365415) [02:51:57] (03CR) 10Ejegg: [C:03+2] Superficial code clean up [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051209 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [02:52:20] (03CR) 10Ejegg: [C:03+2] Do not run prod upgrade on local dev as it will fail [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051219 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [02:57:04] (03CR) 10CI reject: [V:04-1] Move wmf_civicrm_get_wmf_contribution_extra function to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051227 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [02:58:35] (03CR) 10Ejegg: [C:03+2] Queue WMFDonor updates to co-worker [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051221 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [03:14:38] (03Merged) 10jenkins-bot: Superficial code clean up [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051209 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [03:14:40] (03Merged) 10jenkins-bot: Do not run prod upgrade on local dev as it will fail [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051219 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [03:19:45] (03Merged) 10jenkins-bot: Queue WMFDonor updates to co-worker [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051221 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [03:26:50] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051235 [03:27:11] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051235 (owner: 10Eileen) [03:27:53] (03Merged) 10jenkins-bot: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051235 (owner: 10Eileen) [03:51:13] !log civicrm upgraded from 52dc4f1d to f6af6380 [03:51:14] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [03:55:56] (03PS1) 10Eileen: Remove type hinting that proved to be wrong [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051238 [03:56:55] (03CR) 10Eileen: [C:03+2] "I'm gonna self +2 this as the switch to an array was a last minute attempt in my last patch (after I tested it) to get rid of a notice" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051238 (owner: 10Eileen) [04:18:03] (03Merged) 10jenkins-bot: Remove type hinting that proved to be wrong [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051238 (owner: 10Eileen) [04:18:45] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051239 [04:18:54] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051239 (owner: 10Eileen) [04:19:38] (03Merged) 10jenkins-bot: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051239 (owner: 10Eileen) [04:20:28] (03PS1) 10Eileen: [wip] Dedupe query combiner [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051240 (https://phabricator.wikimedia.org/T353971) [04:22:14] !log civicrm upgraded from f6af6380 to 41c1bd78 [04:22:15] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [04:40:31] (03CR) 10CI reject: [V:04-1] [wip] Dedupe query combiner [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051240 (https://phabricator.wikimedia.org/T353971) (owner: 10Eileen) [05:00:38] (03PS1) 10Eileen: Kick off a more aggressive batch of segment updates [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051241 (https://phabricator.wikimedia.org/T368974) [05:35:29] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Import migration - add support for currency conversion - https://phabricator.wikimedia.org/T368998 (10Eileenmcnaughton) 03NEW [05:36:32] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: CiviCRM point version upgrade (from Wed 3 July) - https://phabricator.wikimedia.org/T368999 (10Eileenmcnaughton) 03NEW [07:02:25] 06Fundraising-Backlog, 10fundraising-tech-ops, 10observability: Shift frack alerting to use alertmanager instead of icinga - https://phabricator.wikimedia.org/T367370#9943195 (10fgiunchedi) Something else I wanted to add: with respect to authoring and deploying alerts we have essentially centralized all aler... [11:17:08] 06Fundraising-Backlog: India Credit Card Donation Erroring out. - https://phabricator.wikimedia.org/T369022 (10RKumar_WMF) 03NEW [11:29:06] 06Fundraising-Backlog: India Credit Card Donation Erroring out. - https://phabricator.wikimedia.org/T369022#9943972 (10RKumar_WMF) This is happening for both Visa and Master credit and debit cards. [12:07:16] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:12:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:17:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:22:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:27:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:32:11] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:37:11] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:42:11] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:47:09] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:52:11] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [12:57:11] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:00:21] (03PS1) 10Damilare Adedoyin: Add log line for cancel autorescue request [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051355 [13:02:09] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:07:11] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:12:09] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:17:09] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:22:09] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:27:09] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:32:08] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:37:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:42:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:47:08] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:52:08] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [13:57:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:02:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:06:28] ejegg: sorry just realised the updates I was sending on the failmail emails were related to the work you were doing on moving cancelRecurAutoRescue to the postcommit hook [14:07:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:10:40] hi damilare ! [14:10:54] Ah, do you think that will help with these? [14:11:26] well at least that was the root cause, I'm just not sure why the request failed. [14:11:52] the request to cancel the autorescue I mean [14:12:01] Maybe if it was making a request to cancel an autorescue which had already been cancelled? [14:12:08] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:12:25] Man, that frdb2003 alert is really annoying [14:12:56] Since it's just the analytics box I think we can ack the warning and just let dwisehaupt know when he signs on [14:14:10] oh hey, it lets me just postpone the next check for a while [14:14:14] i bumped it out 2 hrs [14:15:20] so damilare I think the move to postcommit will help with some failmail [14:15:40] then we can figure out the other cause [14:16:28] which may be related to my cancelling some recurrings on 6/21 without checking whether they had gotten new autorescue references [14:17:08] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:17:26] ohh I see [14:17:35] dang, that icinga alert is still pinging [14:21:50] and... it won't let me ack it [14:22:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:22:53] ok, all the subscr_cancel messages in the damaged table are for recurrings which are already cancelled [14:26:47] (03PS1) 10Ejegg: Script to check on damaged subscr_cancel messages [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051384 [14:27:08] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:27:56] yep [14:30:12] damilare: do you want to check my SQL in that script? I can delete those failed messages in prod and it'll be easier to see if there are others for successful txns that way [14:30:18] https://gerrit.wikimedia.org/r/1051384 [14:30:25] yeah I'm looking at it [14:30:31] thanks! [14:31:29] ok, looks like 43 rows where it's NOT a subscr_cancel [14:32:07] i probably have to restore the rescue reference for those [14:32:08] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:37:08] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:37:52] (03CR) 10Damilare Adedoyin: [C:03+2] Script to check on damaged subscr_cancel messages [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051384 (owner: 10Ejegg) [14:42:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:42:29] thanks damilare [14:42:37] np [14:47:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:52:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:57:12] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [14:57:28] ok, i'm going to write another script to put back the rescue_reference for all the ones I cancelled on the 21st [15:02:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:02:27] (03Merged) 10jenkins-bot: Script to check on damaged subscr_cancel messages [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051384 (owner: 10Ejegg) [15:04:45] 06Fundraising-Backlog, 06Wikipedia-Android-App-Backlog, 06Wikipedia-iOS-App-Backlog, 13Patch-For-Review: Update donation links in apps to use wmf_ parameters - https://phabricator.wikimedia.org/T367360#9945303 (10JMando) @Cstone This should be fine for reporting, so long as - The utm_medium stays 'Wikip... [15:07:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:12:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:17:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:22:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:27:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:32:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:37:12] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:39:17] (03PS1) 10Ejegg: Restore rescue references for 6/21 cancellations [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051400 [15:40:05] so hopefully ^^^ will quiet down all the 'could not find rescue reference' issues [15:40:19] and we can just re-queue the paid ones via the UI [15:42:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:46:31] (03PS2) 10Eileen: Kick off a more aggressive batch of segment updates [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051241 (https://phabricator.wikimedia.org/T368974) [15:46:36] (03CR) 10Ejegg: [C:03+2] Kick off a more aggressive batch of segment updates [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051241 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [15:47:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:50:03] (03PS3) 10Eileen: Finally remove 2018 paypal legacy handling [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051226 (https://phabricator.wikimedia.org/T365415) [15:50:31] (03CR) 10Ejegg: [C:03+2] Finally remove 2018 paypal legacy handling [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051226 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [15:51:06] 06Fundraising-Backlog, 07Mobile, 13Patch-For-Review, 07SEO: Google search results pointing to nonexistent https://donate.m.wikimedia.org/ - https://phabricator.wikimedia.org/T368645#9945495 (10BBlack) ^ While we can maintain the VCL-level hacks for now, it would be best to both dig into how this actual... [15:51:08] (03CR) 10Damilare Adedoyin: [C:03+2] Restore rescue references for 6/21 cancellations [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051400 (owner: 10Ejegg) [15:52:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [15:57:10] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:02:09] PROBLEM - check_mysql on frdb2003 is CRITICAL: Slave IO: Yes Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:02:46] ok, i ran those scripts [16:03:03] will re-queue the subscr_payment ones and see if they work [16:03:39] morning dwisehaupt ! [16:03:53] morning. [16:04:05] just popping in to fix the frdb2003 replication then taking the dog to the sitter. [16:04:27] ah thanks! It's being pretty noisy and icinga wouldn't let me ack it [16:04:56] yeah. i'm going to be checking that dbt job first thing to see why it doesn't replicate cleanly. [16:05:23] it wakes me up at 5am with the phone pings. i ack it in victorops but that doesn't propagate back to icinga. [16:05:31] sorry for the noise. [16:05:52] ok. it should be caught up in just a second. [16:06:01] ah man, 5am pings sound no fun... for us it's just channel/email spam [16:07:06] yeah, even less fun for others in the bedroom when i sleep through the first few. :) [16:07:09] RECOVERY - check_mysql on frdb2003 is OK: Uptime: 406547 Threads: 4 Questions: 113563256 Slow queries: 216 Opens: 6387 Open tables: 1579 Queries per second avg: 279.336 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=frdb2003&service=check_mysql [16:07:38] ok. back in a few after dropping le doge. [16:09:24] (03Merged) 10jenkins-bot: Kick off a more aggressive batch of segment updates [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051241 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [16:13:19] (03Merged) 10jenkins-bot: Finally remove 2018 paypal legacy handling [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051226 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [16:13:25] (03Merged) 10jenkins-bot: Restore rescue references for 6/21 cancellations [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051400 (owner: 10Ejegg) [16:23:13] (03Abandoned) 10Jgleeson: Add guard to check for presence of PaymentError [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051187 (https://phabricator.wikimedia.org/T368947) (owner: 10Jgleeson) [16:49:14] I'll push out that CRM update to start the bigger batches of segment updates [16:50:34] (03PS1) 10Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051418 [16:50:36] (03CR) 10Ejegg: [C:03+2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051418 (owner: 10Ejegg) [16:51:23] (03Merged) 10jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051418 (owner: 10Ejegg) [16:54:07] !log fundraising civicrm upgraded from 41c1bd78 to 64f23ed0 [16:54:08] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [16:54:39] running the upgrader [17:01:46] ok, coworker should be updating those statuses now [17:01:53] let's see if we see the queries [17:03:17] oh huh, that query is in state 'Creating sort index' [17:03:24] seems potentially long... [17:03:39] ah no, finished without too much delay [17:54:28] (03CR) 10Ejegg: "Looks handy! Just thinking about the possibility of going from one gerrit patchset to another without restoring first. We could check to s" [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1046738 (https://phabricator.wikimedia.org/T367798) (owner: 10Jgleeson) [18:03:34] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: India Credit Card Donation Erroring out. - https://phabricator.wikimedia.org/T369022#9946409 (10XenoRyet) p:05Triage→03High [18:06:43] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: DMA default 'spontaneousdonation' - https://phabricator.wikimedia.org/T367477#9946425 (10XenoRyet) [18:08:44] 06Fundraising-Backlog: refund process question - India - https://phabricator.wikimedia.org/T369094 (10RKumar_WMF) 03NEW [18:10:34] thanks for the review ejegg ! [18:12:54] (03PS3) 10Eileen: Minor clean up - move setting on contribution value to contribution import [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1035594 [18:12:55] (03CR) 10Ejegg: [C:03+2] Minor clean up - move setting on contribution value to contribution import [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1035594 (owner: 10Eileen) [18:18:36] I've just been sitting here working in the front window of our bedroom and noticed a guy ride his bike into the front drive of the house two doors down and then start trying the doors on the three cars in the drive and one was open. He didn't steal anything and then calmly got back on his bike and cycled away. I thought it looked odd so I knocked at the house and told them what [18:18:38] happend and they had no idea who he was. Really brazen. It's a nice bright evening here with tons of people on the road and cars but yet he was completely unphased and then didn't steal anything. Odd [18:20:10] casing for later i imagine. [18:25:07] yeah maybe [18:32:24] (03CR) 10Jgleeson: "Thanks @ejegg, I'll add that check to allow switching from patch to patch." [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/1046738 (https://phabricator.wikimedia.org/T367798) (owner: 10Jgleeson) [18:35:39] (03Merged) 10jenkins-bot: Minor clean up - move setting on contribution value to contribution import [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1035594 (owner: 10Eileen) [18:39:18] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: India Credit Card Donation Erroring out. - https://phabricator.wikimedia.org/T369022#9946591 (10Ejegg) Hi @RKumar_WMF , none of these tripped our internal filters. Looks like all of them were rejected at dlocal or the issuer. 207363979.3 was redirected f... [18:46:42] (03PS3) 10Eileen: Move wmf_civicrm_get_wmf_contribution_extra function to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051227 (https://phabricator.wikimedia.org/T365415) [18:46:52] (03PS3) 10Eileen: Move _wmf_civicrm_get_contact_last_donation_data to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051228 (https://phabricator.wikimedia.org/T365415) [18:51:44] oh hmm, failmails [18:52:06] ejegg: I think I see a problem with the queue item that will be causing it [18:52:10] it should have ended [18:52:13] ohh [18:52:30] 3 => [18:52:30] array ( [18:52:30] 1 => [18:52:31] array ( [18:52:31] 'value' => 2000000, [18:52:31] 'type' => 'Integer', [18:52:31] 'increment' => 10000, [18:52:32] 'max' => 2000000, [18:52:32] ), [18:52:33] 2 => [18:52:33] array ( [18:52:34] 'value' => 2620000, [18:52:34] 'type' => 'Integer', [18:52:35] 'increment' => 10000, [18:53:26] huh? [18:54:22] ohhh, if one param doesn't have a max it keeps getting reQueue = TRUE [18:57:12] (03PS1) 10Eileen: Fix requeue to actually end [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051436 (https://phabricator.wikimedia.org/T368974) [18:57:17] ejegg: try ^^ [18:58:20] (03CR) 10Ejegg: [C:03+2] Fix requeue to actually end [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051436 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [18:58:28] yep, that looks right [18:58:54] 06Fundraising-Backlog, 07Epic, 07payments-orchestration: Add Gravy UML Diagrams - https://phabricator.wikimedia.org/T369105 (10jgleeson) 03NEW [18:59:52] (03PS1) 10Eileen: Do IDs 2,000,000 to 20,000,000 in 100k increments [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051437 (https://phabricator.wikimedia.org/T386974) [19:00:17] now we just have to hope we don't see too many fails while we do the jenkins dance [19:03:35] meet taking a while to let me in... [19:07:49] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-Civi-Dedupe: New Segmentation Framework not quite usable yet - https://phabricator.wikimedia.org/T363527#9946704 (10jgleeson) a:05jgleeson→03None [19:08:57] 03Fundraising Sprint: LeeroyJenkinsssss(), 06Fundraising-Backlog: Create links to incorporate ACH into Banners and Emails - https://phabricator.wikimedia.org/T360124#9946719 (10Dwisehaupt) 05Open→03Resolved a:03Dwisehaupt [19:15:39] 06Fundraising-Backlog: refund process question - India - https://phabricator.wikimedia.org/T369094#9946750 (10AKanji-WMF) p:05Triage→03Medium [19:16:26] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: LeeroyJenkinsssss(), 06Fundraising-Backlog: Paypal Giving Fund donations added to Civi under incorrect CID - https://phabricator.wikimedia.org/T363768#9946751 (10XenoRyet) p:05Triage→03High [19:17:01] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: India Credit Card Donation Erroring out. - https://phabricator.wikimedia.org/T369022#9946752 (10AKanji-WMF) p:05High→03Medium [19:17:12] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Import migration - add support for currency conversion - https://phabricator.wikimedia.org/T368998#9946755 (10Ejegg) hmm, any hooks we could subscribe to from within the exchange rates extension? [19:19:15] 06Fundraising-Backlog: Standardize response error text - https://phabricator.wikimedia.org/T368975#9946778 (10Ejegg) Basically we can get a CreatePaymentResponse that returns FALSE from isSuccessful but returns an empty array from getErrors() [19:20:15] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051442 [19:20:25] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051442 (owner: 10Eileen) [19:21:12] (03Merged) 10jenkins-bot: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051442 (owner: 10Eileen) [19:21:52] !log civicrm upgraded from 64f23ed0 to 67bcfd72 [19:21:53] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [19:25:27] (03Abandoned) 10Eileen: Fix import to allow defaults [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1043206 (https://phabricator.wikimedia.org/T342717) (owner: 10Eileen) [19:28:23] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: failmail: Undefined offset: 0 SmashPigRecurringProcessor.php:408 - https://phabricator.wikimedia.org/T368947#9946808 (10AKanji-WMF) p:05Triage→03Medium [19:28:41] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Test out, maybe implement new scheduled communication functionality - https://phabricator.wikimedia.org/T369109 (10Eileenmcnaughton) 03NEW [19:31:30] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Clear out failed updates? - https://phabricator.wikimedia.org/T369110 (10Eileenmcnaughton) 03NEW [19:34:38] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Clear out failed updates? - https://phabricator.wikimedia.org/T369110#9946864 (10AKanji-WMF) p:05Triage→03Medium [19:36:22] 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Clear out failed updates? - https://phabricator.wikimedia.org/T369110#9946874 (10Ejegg) 05Open→03Resolved a:03Ejegg Done [19:46:30] 06Fundraising-Backlog: Remove CVV Placeholder for Japanese donors - https://phabricator.wikimedia.org/T368647#9946939 (10Cstone) Isn't this coming from Adyen's form? Will they let us remove it? [19:47:24] 06Fundraising-Backlog, 10FR-donorservices: Automated merge for RML responses already in Civi - https://phabricator.wikimedia.org/T368670#9946946 (10Ejegg) Hi @SHust. So when a donor puts an existing email address into an RML form and we pull that from Acoustic to Civi, we just discard it rather than creating a... [19:51:23] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-donorservices: Sepa oddity - https://phabricator.wikimedia.org/T368080#9946976 (10AKanji-WMF) [19:53:37] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10FR-donorservices: Sepa oddity - https://phabricator.wikimedia.org/T368080#9946992 (10Cstone) We talked about this at the offsite, the payment actually failed with wrong account number. This did come back as a chargeback with type of "Wrong Account". T... [19:57:03] (03PS1) 10Eileen: Pass clicked_totals all the way through... [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051448 (https://phabricator.wikimedia.org/T344383) [20:14:07] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Test out, maybe implement new scheduled communication functionality - https://phabricator.wikimedia.org/T369109#9947099 (10AKanji-WMF) [20:14:08] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 07Epic, 07payments-orchestration: Add Gravy UML Diagrams - https://phabricator.wikimedia.org/T369105#9947100 (10AKanji-WMF) [20:14:10] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: CiviCRM point version upgrade (from Wed 3 July) - https://phabricator.wikimedia.org/T368999#9947101 (10AKanji-WMF) [20:14:11] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Import migration - add support for currency conversion - https://phabricator.wikimedia.org/T368998#9947102 (10AKanji-WMF) [20:14:12] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Update segments & statuses for 2024-25 - https://phabricator.wikimedia.org/T368974#9947103 (10AKanji-WMF) [20:14:17] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 13Patch-For-Review: Add Zendesk tab to contact summary screen - https://phabricator.wikimedia.org/T368689#9947104 (10AKanji-WMF) [20:14:19] 03Fundraising Sprint: meow(), 06Fundraising-Backlog: Remove CVV Placeholder for Japanese donors - https://phabricator.wikimedia.org/T368647#9947105 (10AKanji-WMF) [20:14:22] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10MW-1.43-notes (1.43.0-wmf.12; 2024-07-02): Donate wiki sending SEPA payment method to gateway chooser with no results - https://phabricator.wikimedia.org/T368570#9947106 (10AKanji-WMF) [20:14:25] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Switch Acoustic mapping to use the API to define the columns - https://phabricator.wikimedia.org/T368470#9947107 (10AKanji-WMF) [20:14:27] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 07Epic, 07payments-orchestration: Gravy - Ensure donations are consumed into CiviCRM with the right parameters - https://phabricator.wikimedia.org/T368039#9947108 (10AKanji-WMF) [20:14:34] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 13Patch-For-Review: alter field name on SEPA form - https://phabricator.wikimedia.org/T367906#9947109 (10AKanji-WMF) [20:14:39] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 07payments-orchestration: Gravy Webhook Processing - https://phabricator.wikimedia.org/T367807#9947110 (10AKanji-WMF) [20:14:42] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 13Patch-For-Review: Fundraising-dev: Add script to safely checkout smashpig patch to payments composer package directory - https://phabricator.wikimedia.org/T367798#9947111 (10AKanji-WMF) [20:14:47] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 13Patch-For-Review, 07payments-orchestration: Gravy - Recurring payment flow from DonationInterface - https://phabricator.wikimedia.org/T367578#9947112 (10AKanji-WMF) [20:14:53] 03Fundraising Sprint: meow(), 06Fundraising-Backlog: Need to not autocancel recurring iDEAL/SEPA chargebacks - https://phabricator.wikimedia.org/T366769#9947114 (10AKanji-WMF) [20:14:56] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10FR-Email: New columns to add to Civi DatabaseUpdate export in July - https://phabricator.wikimedia.org/T366529#9947115 (10AKanji-WMF) [20:15:02] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 13Patch-For-Review, 07payments-orchestration: Gravy backend approve payment - https://phabricator.wikimedia.org/T367112#9947113 (10AKanji-WMF) [20:15:05] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog: Update RML donors to have status of non-donor in CiviCRM - https://phabricator.wikimedia.org/T365534#9947118 (10AKanji-WMF) [20:15:08] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10FR-Smashpig, 13Patch-For-Review: Migrate remaining jobs off JsonSerializableObject - https://phabricator.wikimedia.org/T366367#9947116 (10AKanji-WMF) [20:15:12] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, and 2 others: Make email custom fields editable from contact summary, upstream patch - https://phabricator.wikimedia.org/T366356#9947117 (10AKanji-WMF) [20:15:16] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13Patch-For-Review: Consolidate error handling in queues - https://phabricator.wikimedia.org/T365418#9947119 (10AKanji-WMF) [20:15:22] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog: Re-try data prior to Auto-Rescue was enabled - https://phabricator.wikimedia.org/T365348#9947121 (10AKanji-WMF) [20:15:26] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, and 3 others: Move a bunch of code out of wmf_civicrm.module - https://phabricator.wikimedia.org/T365415#9947120 (10AKanji-WMF) [20:15:30] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13Patch-For-Review: On import, widen the existing contact lookup to include subset & reversed - https://phabricator.wikimedia.org/T365216#9947122 (10AKanji-WMF) [20:15:34] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 07payments-orchestration: Gravy backend createPayment - https://phabricator.wikimedia.org/T364506#9947124 (10AKanji-WMF) [20:15:38] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog: Add Auto Rescue for SEPA Direct Debit - https://phabricator.wikimedia.org/T362575#9947125 (10AKanji-WMF) [20:15:42] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10FR-Civi-Dedupe: Consider phonetic names when deduping - https://phabricator.wikimedia.org/T362196#9947127 (10AKanji-WMF) [20:15:46] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 13Patch-For-Review, 07payments-orchestration: Gravy frontend createPayment - https://phabricator.wikimedia.org/T364508#9947123 (10AKanji-WMF) [20:15:50] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog: ACH on PaymentsWiki - Form Changes - https://phabricator.wikimedia.org/T360825#9947128 (10AKanji-WMF) [20:15:54] 14Fundraising Sprint: didAnyoneTryThis(), 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, and 2 others: Revisit old PayPal bugs, delete code if no longer needed - https://phabricator.wikimedia.org/T355448#9947130 (10AKanji-WMF) [20:15:58] 14Fundraising Sprint: didAnyoneTryThis(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10FR-Civi-Dedupe, 07Unplanned-Sprint-Work: Sandra can't dedupe Name + address matching contacts (no email match) - https://phabricator.wikimedia.org/T353971#9947131 (10AKanji-WMF) [20:16:02] 14Fundraising Sprint: didAnyoneTryThis(), 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Year end update for donor segments & statuses - https://phabricator.wikimedia.org/T344216#9947133 (10AKanji-WMF) [20:16:14] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13Patch-For-Review: Acoustic - request to store click data in mailing stats - https://phabricator.wikimedia.org/T344383#9947132 (10AKanji-WMF) [20:16:18] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Fr-drupal-upgrade-2021, 13Patch-For-Review: Spike - do practice Civi standalone installs locally to get our heads around it - https://phabricator.wikimedia.org/T276395#9947134 (10AKanji-WMF) [20:16:22] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10Fr-drupal-upgrade-2021, 13Patch-For-Review: Move wmf_audit logic into wmf-civicrm Civi extension - https://phabricator.wikimedia.org/T270675#9947135 (10AKanji-WMF) [20:16:26] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog: Paypal Giving Fund donations added to Civi under incorrect CID - https://phabricator.wikimedia.org/T363768#9947138 (10AKanji-WMF) [20:16:33] 14Fundraising Sprint: didAnyoneTryThis(), 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog, and 4 others: Make unsubscribe work in EmailPreferences, delete Unsub extension - https://phabricator.wikimedia.org/T223330#9947137 (10AKanji-WMF) [20:23:07] 06Fundraising-Backlog, 10FR-donorservices: Automated merge for RML responses already in Civi - https://phabricator.wikimedia.org/T368670#9947158 (10RLewis) @Ejegg - looping in @KHaggard as she will know more about the Acoustic side of things. [20:23:44] I think we can kick off some more segment updates now ... https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1051437 [20:42:51] (03CR) 10Ejegg: [C:03+2] Do IDs 2,000,000 to 20,000,000 in 100k increments [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051437 (https://phabricator.wikimedia.org/T386974) (owner: 10Eileen) [20:54:42] (03CR) 10Ejegg: [C:03+2] Pass clicked_totals all the way through... [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051448 (https://phabricator.wikimedia.org/T344383) (owner: 10Eileen) [20:55:21] (03CR) 10Ejegg: "recheck" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051227 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [20:55:42] oops that didn't need a recheck [20:56:21] (03CR) 10Ejegg: [C:03+2] Move wmf_civicrm_get_wmf_contribution_extra function to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051227 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [20:58:43] (03CR) 10Ejegg: [C:03+2] Move _wmf_civicrm_get_contact_last_donation_data to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051228 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [21:04:56] (03Merged) 10jenkins-bot: Do IDs 2,000,000 to 20,000,000 in 100k increments [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051437 (https://phabricator.wikimedia.org/T386974) (owner: 10Eileen) [21:13:45] 14Fundraising Sprint: justWork(), 03Fundraising Sprint: meow(), 06Fundraising-Backlog: Paypal Giving Fund donations added to Civi under incorrect CID - https://phabricator.wikimedia.org/T363768#9947280 (10Ejegg) a:03Ejegg [21:16:54] (03Merged) 10jenkins-bot: Pass clicked_totals all the way through... [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051448 (https://phabricator.wikimedia.org/T344383) (owner: 10Eileen) [21:17:19] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051463 [21:17:32] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051463 (owner: 10Eileen) [21:18:11] (03Merged) 10jenkins-bot: Move wmf_civicrm_get_wmf_contribution_extra function to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051227 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [21:21:04] (03Merged) 10jenkins-bot: Move _wmf_civicrm_get_contact_last_donation_data to only caller [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051228 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [21:21:46] !log civicrm upgraded from 67bcfd72 to 08e568e4 [21:21:47] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [21:24:02] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051465 [21:24:13] (03CR) 10Eileen: [C:03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051465 (owner: 10Eileen) [21:25:07] (03Merged) 10jenkins-bot: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1051465 (owner: 10Eileen) [21:26:25] !log civicrm upgraded from 08e568e4 to 6e03cff2 [21:26:26] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [22:01:19] (03PS1) 10Eileen: Open up Donor segments to do the whole lot [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051468 (https://phabricator.wikimedia.org/T368974) [22:05:29] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 13Patch-For-Review: Update segments & statuses for 2024-25 - https://phabricator.wikimedia.org/T368974#9947443 (10Eileenmcnaughton) @KHaggard we have already updated about 20% of the database & it's going pretty quickly -... [22:11:29] (03CR) 10Ejegg: [C:03+2] Open up Donor segments to do the whole lot [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051468 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [22:18:50] (03PS1) 10Eileen: Split & move update email function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051472 (https://phabricator.wikimedia.org/T365415) [22:25:31] (03PS1) 10Eileen: Remove unused function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051473 (https://phabricator.wikimedia.org/T365415) [22:25:46] (03PS1) 10Ejegg: Delete unused function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051474 (https://phabricator.wikimedia.org/T365415) [22:28:48] (03PS1) 10Ejegg: Move stats hook to new wmf-civicrm extension [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051475 (https://phabricator.wikimedia.org/T365415) [22:29:42] (03PS1) 10Ejegg: Delete reference to deleted file [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051476 (https://phabricator.wikimedia.org/T365415) [22:30:23] (03CR) 10Ejegg: [C:03+2] Remove unused function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051473 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [22:30:35] (03PS2) 10Eileen: Remove unused function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051473 (https://phabricator.wikimedia.org/T365415) [22:30:35] (03PS2) 10Eileen: Split & move update email function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051472 (https://phabricator.wikimedia.org/T365415) [22:31:13] (03CR) 10Eileen: [C:03+2] Move stats hook to new wmf-civicrm extension [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051475 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [22:31:27] (03CR) 10Eileen: [C:03+2] Delete unused function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051474 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [22:31:38] (03CR) 10Eileen: [C:03+2] Delete reference to deleted file [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051476 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [22:33:11] (03CR) 10CI reject: [V:04-1] Move stats hook to new wmf-civicrm extension [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051475 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [22:33:53] (03CR) 10CI reject: [V:04-1] Delete reference to deleted file [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051476 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [22:35:19] (03Merged) 10jenkins-bot: Open up Donor segments to do the whole lot [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051468 (https://phabricator.wikimedia.org/T368974) (owner: 10Eileen) [22:36:49] (03PS1) 10Eileen: Fix function to use apiv4, removes one old function call [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051477 (https://phabricator.wikimedia.org/T365415) [22:37:40] (03PS2) 10Ejegg: Delete reference to deleted file [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051476 (https://phabricator.wikimedia.org/T365415) [22:38:22] (03PS2) 10Ejegg: Delete unused function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051474 (https://phabricator.wikimedia.org/T365415) [22:38:22] (03PS2) 10Ejegg: Move stats hook to new wmf-civicrm extension [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051475 (https://phabricator.wikimedia.org/T365415) [22:38:22] (03PS3) 10Ejegg: Delete reference to deleted file [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051476 (https://phabricator.wikimedia.org/T365415) [22:38:23] (03PS1) 10Ejegg: Delete more unused functions and use statements [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051478 (https://phabricator.wikimedia.org/T365415) [22:38:28] (03CR) 10jenkins-bot: Move stats hook to new wmf-civicrm extension [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051475 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [22:41:26] (03CR) 10CI reject: [V:04-1] Split & move update email function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051472 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [22:42:03] (03PS3) 10Eileen: Split & move update email function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051472 (https://phabricator.wikimedia.org/T365415) [22:42:03] (03PS2) 10Eileen: Fix function to use apiv4, removes one old function call [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051477 (https://phabricator.wikimedia.org/T365415) [22:42:03] (03PS1) 10Eileen: Switch over old refs to CiviCRM_API3_Exception [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051479 [22:44:07] (03PS3) 10Ejegg: Move stats hook to new wmf-civicrm extension [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051475 (https://phabricator.wikimedia.org/T365415) [22:44:10] (03CR) 10Eileen: [C:03+2] Move stats hook to new wmf-civicrm extension [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051475 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [22:45:11] (03CR) 10Ejegg: [C:03+2] Switch over old refs to CiviCRM_API3_Exception [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051479 (owner: 10Eileen) [22:45:28] (03PS4) 10Ejegg: Delete reference to deleted file [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051476 (https://phabricator.wikimedia.org/T365415) [22:46:24] (03PS2) 10Ejegg: Delete more unused functions and use statements [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051478 (https://phabricator.wikimedia.org/T365415) [22:46:27] (03CR) 10Eileen: [C:03+2] Delete more unused functions and use statements [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051478 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [22:51:47] (03PS1) 10Eileen: Remove last caller on wmf_common_locale_civi_to_mediawiki [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051480 (https://phabricator.wikimedia.org/T365415) [22:55:31] (03CR) 10CI reject: [V:04-1] Fix function to use apiv4, removes one old function call [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051477 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [23:05:56] (03Merged) 10jenkins-bot: Move stats hook to new wmf-civicrm extension [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051475 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [23:08:48] (03Merged) 10jenkins-bot: Remove unused function [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051473 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [23:08:52] (03Merged) 10jenkins-bot: Switch over old refs to CiviCRM_API3_Exception [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051479 (owner: 10Eileen) [23:09:13] (03Merged) 10jenkins-bot: Delete more unused functions and use statements [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051478 (https://phabricator.wikimedia.org/T365415) (owner: 10Ejegg) [23:22:42] (03PS1) 10Eileen: Remove some good ideas [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051482 (https://phabricator.wikimedia.org/T365415) [23:22:44] (03PS1) 10Eileen: Load the message object in the parent function & pass around [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051483 (https://phabricator.wikimedia.org/T365415) [23:22:44] (03PS1) 10Eileen: Move retrieval of PaymentToken data to the message class [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051484 (https://phabricator.wikimedia.org/T365415) [23:24:52] (03PS2) 10Eileen: Remove last caller on wmf_common_locale_civi_to_mediawiki [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051480 (https://phabricator.wikimedia.org/T365415) [23:43:06] 03Fundraising Sprint: meow(), 06Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Update segments & statuses for 2024-25 - https://phabricator.wikimedia.org/T368974#9947551 (10KHaggard) Thanks for the update @Eileenmcnaughton - I'll inform the rest of the team so they're aware while I'm out of office. [23:46:14] (03CR) 10CI reject: [V:04-1] Move retrieval of PaymentToken data to the message class [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1051484 (https://phabricator.wikimedia.org/T365415) (owner: 10Eileen) [23:58:52] 06Fundraising-Backlog, 10FR-donorservices: Automated merge for RML responses already in Civi - https://phabricator.wikimedia.org/T368670#9947559 (10KHaggard) Hi both, I can chime in here really quick before my PTO. So our RML emails don't have a %firstname% token (dynamic content) like our regular emails hav...