[02:09:13] is our mid-sprint checkin on tomorrow? [02:46:11] eileen: hey.... as far as I know... I mean, it's on the calendar, and I haven't heard otherwise [02:46:39] AndyRussG: Ah I was getting confused about which days are WMF holidays [02:50:03] eileen: ah yeah it's Wednesday through Friday [02:50:11] ah cool [03:53:57] (CR) AndyRussG: Banner Allocation: region dropdown depends on country (1 comment) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/588765 (https://phabricator.wikimedia.org/T102848) (owner: Ejegg) [16:05:10] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Heaven is a page on Wikipedia, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint X-rays, and 6 others: Address final code review comments on geotargeting - https://phabricator.wikimedia.org/T250751 (mepps) So to try to summa... [16:09:51] /ac [16:19:59] Fundraising-Backlog, fundraising-tech-ops: New civi certificate or dstrine - https://phabricator.wikimedia.org/T250827 (DStrine) [16:27:56] huh, logs say Agreed compression: none for this morning's silverpop upload [16:28:03] but it was way faster than the previous [16:28:14] maybe we had some transitory net troubles? Or they did? [16:50:28] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Missing information on the Engage Receipt - https://phabricator.wikimedia.org/T249771 (DStrine) @LeanneS and @MBeat33 can I close this task? [17:07:48] Fundraising-Backlog, fundraising-tech-ops: New civi certificate or dstrine - https://phabricator.wikimedia.org/T250827 (Dwisehaupt) Open→Resolved Was able to use the existing cert and password that is currently valid. No renew or new cert required. [18:05:08] (PS50) Mepps: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [18:26:22] (PS51) Mepps: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [18:32:26] (PS52) Mepps: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [18:34:39] (PS53) Mepps: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [18:35:41] fundraising-tech-ops, Operations, decommission, ops-eqiad: decommission frav1001.frack.eqiad.wmnet - https://phabricator.wikimedia.org/T222109 (Papaul) [18:42:30] (PS54) Mepps: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [19:13:45] (CR) AndyRussG: Geotargeting: Show selected countries and regions under tree selector (1 comment) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/576153 (https://phabricator.wikimedia.org/T226438) (owner: Mepps) [19:51:25] (CR) Eileen: Drush script to tokenize old recurring GC (1 comment) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/582883 (https://phabricator.wikimedia.org/T169357) (owner: Ejegg) [20:05:10] Fundraising Sprint Heaven is a page on Wikipedia, Fundraising-Backlog, MediaWiki-extensions-DonationInterface: Create employer autocomplete for payments-wiki - https://phabricator.wikimedia.org/T249921 (jgleeson) a:jgleeson [20:06:39] fr-tech I just put my face on that ticket. It feels like it might get broken out into smaller tickets across front-end/backend so if anyone wants to pair up that would be cool also! [20:32:45] (PS55) Mepps: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [20:35:05] (CR) jerkins-bot: [V: -1] Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [20:39:46] (PS9) Jgleeson: Schema changes related to BannerTemplates [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/573520 (owner: ItSpiderman) [20:39:48] (PS25) Jgleeson: Banner templates [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/572672 (owner: ItSpiderman) [20:39:50] (PS7) Jgleeson: Rename methods to avoid confusion [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/576648 (owner: ItSpiderman) [20:46:44] fr-tech the banner templates patches are now passing. the fix was pretty small so I added it in. I've just noticed some indentation weirdness which I'll fix also! [20:46:51] https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/CentralNotice/+/576648/ [20:47:12] (PS16) Jgleeson: Cloning Campaign [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/574667 (owner: AlexPinchuk) [20:47:38] jgleeson: noice!! :) [20:51:15] (CR) jerkins-bot: [V: -1] Cloning Campaign [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/574667 (owner: AlexPinchuk) [20:55:21] (PS56) Mepps: Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [21:02:20] (PS8) Jgleeson: Rename methods to avoid confusion [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/576648 (owner: ItSpiderman) [21:09:03] (CR) jerkins-bot: [V: -1] Finer geo targeting [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/518449 (https://phabricator.wikimedia.org/T102848) (owner: Vedmaka Wakalaka) [21:12:50] Fundraising-Backlog: Investigate matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (DStrine) [21:15:51] Fundraising Sprint Heaven is a page on Wikipedia, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Make Civi matching gifts extension store data in custom fields - https://phabricator.wikimedia.org/T249924 (Ejegg) [21:17:17] (CR) Awight: "> Main test build failed." [wikimedia/fundraising/process-control] - https://gerrit.wikimedia.org/r/567991 (https://phabricator.wikimedia.org/T243806) (owner: Ejegg) [21:18:16] (PS9) Jgleeson: Rename methods to avoid confusion [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/576648 (owner: ItSpiderman) [21:18:55] (PS17) Jgleeson: Cloning Campaign [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/574667 (owner: AlexPinchuk) [21:21:12] AndyRussG: mepps I'll hold off +2'ing the banner stuff until yall are happy with the geotargetting stuff. dstrine the banner template stuff is finished and works with the _CURRENT_ version of geotargetting [21:21:30] (CR) Reedy: Schema changes related to BannerTemplates (1 comment) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/573520 (owner: ItSpiderman) [21:24:50] (CR) jerkins-bot: [V: -1] Cloning Campaign [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/574667 (owner: AlexPinchuk) [21:27:50] dwisehaupt: I just discovered some civi breakage which needs civi triggers reload to fix [21:30:05] ooo.. ok. [21:30:13] Any chance I can get you to reload - I can direct you to the file [21:31:10] (PS1) Reedy: Don't use addExtensionUpdate and arrays, use specific functions [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/591484 [21:31:22] yeah. we'll need to stop the queues for that. [21:31:30] (according to my notes) [21:35:01] OK - jist turned them off [21:36:14] cool. [21:39:52] ok. current triggers captured, are they updated ones in place already? [21:40:40] just one mo [21:40:49] sure thing. no rush. [21:42:39] civicrm/ConfigAndLog/CiviCRM.trigger5e9f68bf33b101d42303569d27a548446b737759870c8.sql [21:45:40] dwisehaupt: ^^ [21:46:41] hmmm... normally these live in the scripts dir. is this somewhere else? [21:47:19] ah. i see it. i'll pull that over. [21:49:24] frdb1001 is a little behind master due to a query still executing. waiting for it to catch up and i'll run the update. [21:50:30] yep - it's altering the log tables field types to match the non-log tables on a few tables [21:50:37] that triggered when I regenerated the triggers [21:53:03] ok. there was a major difference in line count from the trigger dump [21:53:15] from 462 down to 49 [21:53:35] usually it's the same or only a minor change, is this expected? [21:54:40] looking at the sql, it looks like it is intended, just want to verify. [21:57:14] PROBLEM - check_mysql on frdb1001 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) [21:59:06] no [21:59:12] let me check again [21:59:28] ACKNOWLEDGEMENT - check_mysql on frdb1001 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) Dwisehaupt Trigger updates [21:59:32] I think that was the drop-script :-( [21:59:33] ACKNOWLEDGEMENT - check_mysql on frdb1001 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) Dwisehaupt Trigger updates [22:07:25] I can't get hangout to open :-( I think it's my internet (with kids home) [22:16:58] (PS1) Awight: Migrate from nose to pytest [wikimedia/fundraising/process-control] - https://gerrit.wikimedia.org/r/591515 [22:17:40] (PS2) Awight: Add kill-job script [wikimedia/fundraising/process-control] - https://gerrit.wikimedia.org/r/567991 (https://phabricator.wikimedia.org/T243806) (owner: Ejegg) [22:18:20] (CR) Awight: "PS 2: experimental rebase onto pytest migration, just to see if it fixes the failures" [wikimedia/fundraising/process-control] - https://gerrit.wikimedia.org/r/567991 (https://phabricator.wikimedia.org/T243806) (owner: Ejegg) [22:37:14] RECOVERY - check_mysql on frdb1001 is OK: Uptime: 6067917 Threads: 2 Questions: 1638661079 Slow queries: 8857 Opens: 167177 Flush tables: 1 Open tables: 935 Queries per second avg: 270.053 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [22:41:54] !log process-control config revision is 6294adfbaa [22:41:58] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [22:46:13] (CR) Awight: Add kill-job script (4 comments) [wikimedia/fundraising/process-control] - https://gerrit.wikimedia.org/r/567991 (https://phabricator.wikimedia.org/T243806) (owner: Ejegg)