AndyRussG (Andrew Green)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Oct 28 2014, 2:36 PM (215 w, 6 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
AGreen (WMF) [ Global Accounts ]

Recent Activity

Tue, Dec 11

AndyRussG added a comment to T209763: Right 'banner-protect' is missing i18n descriptions.

@Ejegg Thanks for your reply. Would then:

"banner-protect": "Protect translatable banner messages handled by the translate extension"

be an appropriate i18n summary to display on Special:ListGroupRights?

Tue, Dec 11, 8:22 PM · Patch-For-Review, Fundraising Sprint XML ate my homework, User-MarcoAurelio, Fundraising Sprint Window dressing is mostly olive oil, Fundraising-Backlog, I18n, MediaWiki-extensions-CentralNotice

Tue, Dec 4

AndyRussG added a comment to T210986: Missing centralnotice admin protection level messages causing broken edit summaries and strings in Special Pages.

@MarcoAurelio @Jdforrester-WMF Thanks!!!!!!

Tue, Dec 4, 3:35 PM · MW-1.33-notes (1.33.0-wmf.8; 2018-12-11), Fundraising-Backlog, User-MarcoAurelio, MediaWiki-extensions-CentralNotice, I18n, WikimediaMessages

Mon, Nov 26

AndyRussG moved T209741: Database error when editting banner with translations from Doing to Backlog on the Fundraising Sprint Window dressing is mostly olive oil board.
Mon, Nov 26, 8:26 PM · Wikimedia-production-error, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG updated subscribers of T209741: Database error when editting banner with translations.

The specific error is related about database replication: "Replication wait failed: MySQL server has gone away". There are other errors on this banner that seem linked to rebuilding the Translate extension MessageGroupStats index. See these Logstash entries.

Mon, Nov 26, 8:26 PM · Wikimedia-production-error, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG added a comment to T209763: Right 'banner-protect' is missing i18n descriptions.

Thanks, @MarcoAurelio! Indeed, this should be documented properly. The banner-protect right is used to protect translatable banner messages handled by the translate extension. The goal is to ensure that translation managers can approve and publish translations for those messages without permission to modify other banner content.

Mon, Nov 26, 7:37 PM · Patch-For-Review, Fundraising Sprint XML ate my homework, User-MarcoAurelio, Fundraising Sprint Window dressing is mostly olive oil, Fundraising-Backlog, I18n, MediaWiki-extensions-CentralNotice
AndyRussG updated subscribers of T210102: Make protection reason localizable, display on wiki content language.

Thanks @MarcoAurelio and @Seddon! It seems that this is the right way to go. If I understand correctly, the i18n aspect would be mostly of use outside the WMF, on wikis that use CentralNotice and are in languages other than English... Is that correct?

Mon, Nov 26, 7:01 PM · Fundraising Sprint XML ate my homework, Patch-For-Review, Fundraising Sprint Window dressing is mostly olive oil, I18n, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Wed, Nov 21

AndyRussG added a project to T210101: Consider not displaying protection log entries in RecentChanges caused by CentralNotice actions: Fundraising-Backlog.
Wed, Nov 21, 6:12 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Tue, Nov 20

AndyRussG moved T209741: Database error when editting banner with translations from Backlog to Doing on the Fundraising Sprint Window dressing is mostly olive oil board.
Tue, Nov 20, 8:36 PM · Wikimedia-production-error, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T208570: test ext.centralNotice.kvStore fails sometimes from Doing to Backlog on the Fundraising Sprint Window dressing is mostly olive oil board.
Tue, Nov 20, 8:36 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG moved T208570: test ext.centralNotice.kvStore fails sometimes from Backlog to Doing on the Fundraising Sprint Window dressing is mostly olive oil board.
Tue, Nov 20, 8:36 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG moved T178930: CentralNotice: Consolidate typical analytics queries (for example, for impression rates) into a library from Backlog to Review on the Fundraising Sprint Window dressing is mostly olive oil board.
Tue, Nov 20, 8:35 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint Junebugs prefer July, Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Gravity wasn't always this pushy, Fundraising Sprint Fhabricator is spelled with an "F", Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Bermuda Rhombus (where things disappear then reappear), Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Uptight Piano, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T195594: New scripts to ingress data from Kafkatee into MySQL from Backlog to Review on the Fundraising Sprint Window dressing is mostly olive oil board.
Tue, Nov 20, 8:35 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Patch-For-Review, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising-Backlog
AndyRussG added a comment to T203669: Return to real time banner impressions in Druid.

@AndyRussG @Jseddon Hi! So I have something to show to you in: https://turnilo.wikimedia.org/#event_centralnoticeimpression

We have a tool called Eventlogging2Druid now that automagically imports data from Eventlogging/Hive and index it to Druid. We indexed only a couple of days (Oct 27th/28th) in Druid as example, but you can play with the data and see if it fits your needs

Tue, Nov 20, 6:17 PM · Analytics-Kanban, User-Elukey, Analytics

Mon, Nov 19

AndyRussG renamed T208570: test ext.centralNotice.kvStore fails sometimes from test ext.centralNotice.kvStore fails sometimes on gate-and-submit to test ext.centralNotice.kvStore fails sometimes.
Mon, Nov 19, 8:48 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG added a project to T208570: test ext.centralNotice.kvStore fails sometimes: Fundraising-Backlog.
Mon, Nov 19, 6:16 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Oct 31 2018

AndyRussG moved T178930: CentralNotice: Consolidate typical analytics queries (for example, for impression rates) into a library from Backlog to Review on the Fundraising Sprint Vestigial tails shoot from the hip board.
Oct 31 2018, 4:19 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint Junebugs prefer July, Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Gravity wasn't always this pushy, Fundraising Sprint Fhabricator is spelled with an "F", Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Bermuda Rhombus (where things disappear then reappear), Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Uptight Piano, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T195594: New scripts to ingress data from Kafkatee into MySQL from Backlog to Review on the Fundraising Sprint Vestigial tails shoot from the hip board.
Oct 31 2018, 4:18 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Patch-For-Review, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising-Backlog
AndyRussG moved T196564: DB schemas (production changes and test DB) and SQL commands to run for new banner and LP impression data from EL from Backlog to Review on the Fundraising Sprint Vestigial tails shoot from the hip board.
Oct 31 2018, 4:18 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog
AndyRussG moved T196563: Write a specification for mapping banner/landing page impression event properties -> database schema from Backlog to Review on the Fundraising Sprint Vestigial tails shoot from the hip board.
Oct 31 2018, 4:18 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog

Oct 26 2018

AndyRussG added a comment to T208004: Call to undefined method LanguageEn::truncate().

@Jdforrester-WMF Thanks!! :)

Oct 26 2018, 12:07 AM · MediaWiki-extensions-CentralNotice, Fr-CentralNotice-translations, Wikimedia-production-error

Oct 25 2018

AndyRussG added a project to T208004: Call to undefined method LanguageEn::truncate(): MediaWiki-extensions-CentralNotice.
Oct 25 2018, 11:06 PM · MediaWiki-extensions-CentralNotice, Fr-CentralNotice-translations, Wikimedia-production-error

Oct 23 2018

AndyRussG committed rWMFRb6b51f00ee4b: Remove unused import in controller.py (authored by AndyRussG).
Remove unused import in controller.py
Oct 23 2018, 7:25 PM
AndyRussG committed rWMFR1ce2a93e79cd: Remove testing field (for banner previews) from CNEvents (authored by AndyRussG).
Remove testing field (for banner previews) from CNEvents
Oct 23 2018, 7:25 PM

Oct 22 2018

AndyRussG added a comment to T206562: Delay in French mobile banners showing up in Banner Allocation.

Here's the Jupyter notebook with the queries used:

Oct 22 2018, 4:50 AM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG added a comment to T206562: Delay in French mobile banners showing up in Banner Allocation.

Hi! I've found a pretty convincing indication that the problem was with old ChoiceData being sent to browsers.

Oct 22 2018, 4:37 AM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog

Oct 19 2018

AndyRussG added a comment to T207501: Compare data between new and old pipelines.

Some notes:

Oct 19 2018, 5:44 PM · Fundraising-Backlog
AndyRussG triaged T207501: Compare data between new and old pipelines as Normal priority.
Oct 19 2018, 5:40 PM · Fundraising-Backlog
AndyRussG added a comment to T204396: Identify source of discrepancy between HUE query in Count of event.impression and druid queries via turnilo/superset.

Can you answer these questions

Hey... of course, apologies for the delays!!!

Oct 19 2018, 3:38 PM · Analytics, Fundraising-Backlog
AndyRussG added a comment to T204396: Identify source of discrepancy between HUE query in Count of event.impression and druid queries via turnilo/superset.

@Nuria, @JAllemandou, @mforns thanks so much taking the time to check this out, much appreciated!!! We can dig into it further (as priorities allow). :)

Oct 19 2018, 2:45 PM · Analytics, Fundraising-Backlog

Oct 18 2018

AndyRussG claimed T206562: Delay in French mobile banners showing up in Banner Allocation.
Oct 18 2018, 4:05 PM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog

Oct 17 2018

AndyRussG added a comment to T206562: Delay in French mobile banners showing up in Banner Allocation.

What this isn't:

  • Not a more general Mediawiki or database issue, outage, or any known problem on the cluster.
  • Not a campaign or banner configuration issue.
  • Not a general CentralNotice outage.
  • Not a data pipeline issue.
Oct 17 2018, 3:37 PM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG added a comment to T206562: Delay in French mobile banners showing up in Banner Allocation.

Checked a couple more things:

Oct 17 2018, 3:14 PM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T178930: CentralNotice: Consolidate typical analytics queries (for example, for impression rates) into a library from Backlog to Review on the Fundraising Sprint USB stands for underhanded socket bureaucracy board.
Oct 17 2018, 2:53 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint Junebugs prefer July, Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Gravity wasn't always this pushy, Fundraising Sprint Fhabricator is spelled with an "F", Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Bermuda Rhombus (where things disappear then reappear), Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Uptight Piano, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T195594: New scripts to ingress data from Kafkatee into MySQL from Backlog to Review on the Fundraising Sprint USB stands for underhanded socket bureaucracy board.
Oct 17 2018, 2:53 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Patch-For-Review, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising-Backlog
AndyRussG moved T196563: Write a specification for mapping banner/landing page impression event properties -> database schema from Backlog to Review on the Fundraising Sprint USB stands for underhanded socket bureaucracy board.
Oct 17 2018, 2:53 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog
AndyRussG moved T196564: DB schemas (production changes and test DB) and SQL commands to run for new banner and LP impression data from EL from Backlog to Review on the Fundraising Sprint USB stands for underhanded socket bureaucracy board.
Oct 17 2018, 2:52 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog
AndyRussG moved T203925: Save times for changes to translation variable text in centralnotice paralysingly slow from Backlog to Pending Deployment on the Fundraising Sprint USB stands for underhanded socket bureaucracy board.
Oct 17 2018, 2:52 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG moved T206562: Delay in French mobile banners showing up in Banner Allocation from Backlog to Doing on the Fundraising Sprint USB stands for underhanded socket bureaucracy board.
Oct 17 2018, 2:52 PM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog

Oct 16 2018

AndyRussG added a comment to T203669: Return to real time banner impressions in Druid.

the size of every month varies a lot, so we were wondering about the consistency of the data over the past months.

Oct 16 2018, 1:56 PM · Analytics-Kanban, User-Elukey, Analytics
AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

What is the status of this with the recent changes merged? Is it still a high priority?

Oct 16 2018, 1:02 AM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Oct 15 2018

AndyRussG added a comment to T206562: Delay in French mobile banners showing up in Banner Allocation.

Also just re-checked CentralNotice logs... I don't see any changes in any of them around 18:40 on 2018-10-09, which is when the mobil frFR banner finally went out (according to Druid/Turnilo, see above).

Oct 15 2018, 6:11 PM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T206562: Delay in French mobile banners showing up in Banner Allocation from Backlog to Doing on the Fundraising Sprint They Live board.
Oct 15 2018, 5:54 PM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T203925: Save times for changes to translation variable text in centralnotice paralysingly slow from Doing to Pending Deployment on the Fundraising Sprint They Live board.
Oct 15 2018, 5:54 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG added a comment to T206562: Delay in French mobile banners showing up in Banner Allocation.

Also nothing stands out in logstash for that time: search 1, search 2.

Oct 15 2018, 4:04 AM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG added a comment to T206562: Delay in French mobile banners showing up in Banner Allocation.

Just checking stuff to eliminate possible causes: there's nothing odd in the server logs for that time, nor were any actions related to the datacenter switchover set for that day (see T199073).

Oct 15 2018, 1:52 AM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T178930: CentralNotice: Consolidate typical analytics queries (for example, for impression rates) into a library from Backlog to Review on the Fundraising Sprint They Live board.
Oct 15 2018, 1:12 AM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint Junebugs prefer July, Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Gravity wasn't always this pushy, Fundraising Sprint Fhabricator is spelled with an "F", Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Bermuda Rhombus (where things disappear then reappear), Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Uptight Piano, MediaWiki-extensions-CentralNotice, Fundraising-Backlog

Oct 11 2018

AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

Thanks much for this!!!! I debugged through the merged patch locally. Unfortunately... it looks like it might not fix the problem, since, at least locally, the mergeable updates are never merged. This is because each is added to DeferredUpdates within the execution of a different AtomicSectionUpdate. (See the Gerrit change for more details.)

Oct 11 2018, 7:39 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Oct 10 2018

AndyRussG added a comment to T206562: Delay in French mobile banners showing up in Banner Allocation.

Thanks!! Checked the data in Turnilo (formerly Pivot), and it shows the problem happened as described: https://bit.ly/2NzT6OW

Oct 10 2018, 7:29 PM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG added a comment to T203669: Return to real time banner impressions in Druid.

@elukey so just to confirm, it's fine to go ahead and use the eventlogging_CentralNoticeImpression stream for this. Thanks so much again and apologies again for the delays in replying!!!

Oct 10 2018, 4:02 PM · Analytics-Kanban, User-Elukey, Analytics

Oct 9 2018

AndyRussG added a comment to T203669: Return to real time banner impressions in Druid.

Hi!!! Many apologies for the delay here...

Oct 9 2018, 4:26 PM · Analytics-Kanban, User-Elukey, Analytics
AndyRussG added a comment to T206478: Frdev1001 server and mysql access.

pgehres hasn't worked here for years

Oct 9 2018, 3:24 PM · fundraising-tech-ops, Fundraising-Backlog, Wikimedia-Fundraising, Operations

Oct 3 2018

AndyRussG moved T196563: Write a specification for mapping banner/landing page impression event properties -> database schema from Backlog to Review on the Fundraising Sprint They Live board.
Oct 3 2018, 2:40 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog
AndyRussG moved T195594: New scripts to ingress data from Kafkatee into MySQL from Backlog to Review on the Fundraising Sprint They Live board.
Oct 3 2018, 2:40 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Patch-For-Review, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising-Backlog
AndyRussG moved T196564: DB schemas (production changes and test DB) and SQL commands to run for new banner and LP impression data from EL from Backlog to Review on the Fundraising Sprint They Live board.
Oct 3 2018, 2:40 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog
AndyRussG moved T198752: Queries and maybe scripts to verify equivalence of data in new-Kafka-pipeline-testing and pgehres production databases from Backlog to Review on the Fundraising Sprint They Live board.
Oct 3 2018, 2:39 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Patch-For-Review, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising-Backlog
AndyRussG moved T203925: Save times for changes to translation variable text in centralnotice paralysingly slow from Backlog to Doing on the Fundraising Sprint They Live board.
Oct 3 2018, 2:39 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Oct 2 2018

AndyRussG added a comment to T200853: Banner previews occasionally fail to load.

Thanks @Pcoombe... That looks like a significant clue!! In the logs, the related server errors seem to come in clusters... That might be related to when campaigns and tests are running, though. There are other MessageCache issues now (see T203925), so we might want to look at them all together.

Oct 2 2018, 7:51 PM · Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, MediaWiki-extensions-CentralNotice, Fundraising-Backlog

Sep 29 2018

AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

Here's a limited, temporary workaround for banners using translatable messages: use only two or three messages. Though save times will be long (1 minute or more), I think it'll work. You can include HTML fragments in the messages, so it should be doable, though cumbersome.

Sep 29 2018, 1:36 AM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Sep 28 2018

AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

My intention with T193271 is to change MessageCache to only pre-cache MW-pages that represent interface message overrides for message keys recognised by the software. See that task for more details.

Sep 28 2018, 6:31 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

Currently, CentralNotice uses Revision::getContent() in the administration UI to show the content of a banner's translatable messages. So, as far as that UI is concerned, it's not essential to update MessageCache before the form returns. (Note: that part of the UI has been broken-ish for a while--see T72939.)

Sep 28 2018, 3:21 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Sep 27 2018

AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

Hi! Thanks so much, everyone!!

Sep 27 2018, 5:46 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Sep 26 2018

AndyRussG committed rWMFR66c87389c6c4: Remove testing field (for banner previews) from CNEvents (authored by AndyRussG).
Remove testing field (for banner previews) from CNEvents
Sep 26 2018, 5:27 PM
AndyRussG moved T196563: Write a specification for mapping banner/landing page impression event properties -> database schema from Doing to Review on the Fundraising Sprint Sasquatches can't find us either board.
Sep 26 2018, 4:38 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog

Sep 25 2018

AndyRussG merged T170591: WMDE banners failing to save - Timing out on save into T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.
Sep 25 2018, 8:12 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG merged task T170591: WMDE banners failing to save - Timing out on save into T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.
Sep 25 2018, 8:12 PM · Fr-CentralNotice-Translation-Bugs, Fundraising Sprint Synchronized Screaming, Fundraising Sprint RadioActivewear, Fundraising Sprint Quill Pencil, Performance-Team (Radar), MediaWiki-extensions-Translate, WMDE-Fundraising-CN, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG created T205483: Fix CentralNotice rebuilding of Translate message cache.
Sep 25 2018, 7:44 PM · MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T196563: Write a specification for mapping banner/landing page impression event properties -> database schema from Backlog to Doing on the Fundraising Sprint Sasquatches can't find us either board.
Sep 25 2018, 7:30 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog
AndyRussG created T205478: Validate CentralNotice translatable message names/fix errors on messages with spaces.
Sep 25 2018, 7:29 PM · Patch-For-Review, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG added a comment to T180223: Port CentralNotice Selenium tests from Ruby to Node.js.

Hi @zeljkofilipin... Many apologies for not responding here, and thanks for the sample test!!!!! Can you say how urgent this is? Also, is the lack of update maybe related to recent failures on OSX for the legacy system? Thanks so much and apologies again!

Sep 25 2018, 7:25 PM · Patch-For-Review, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG created T205477: Document CentralNotice-Translate integration.
Sep 25 2018, 7:19 PM · Fr-CentralNotice-Translation-Bugs, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG added a comment to T158084: Mediawiki namespace pages, including CentralNotice banners, are slow to save.

This may well be a less severe symptom as the same problem that's causing T203925: Save times for changes to translation variable text in centralnotice paralysingly slow. (More details here: T203925#4609441.)

Sep 25 2018, 4:15 PM · Performance-Team (Radar), MediaWiki-Cache, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG added a comment to T195840: Track when a CentralNotice banner was displayed to the user in NavTiming.

@Peter, @Gilles, looks great!!! :)

Sep 25 2018, 4:04 PM · MW-1.32-notes (WMF-deploy-2018-10-02 (1.32.0-wmf.24)), Patch-For-Review, Wikimedia-Fundraising, MediaWiki-extensions-NavigationTiming, Performance-Team
AndyRussG moved T203499: Update EventLogging schema for CentralNotice from Doing to Done on the Fundraising Sprint Sasquatches can't find us either board.
Sep 25 2018, 4:27 AM · Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Epic, Fundraising-Backlog
AndyRussG closed T203499: Update EventLogging schema for CentralNotice as Invalid.
Sep 25 2018, 4:27 AM · Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Epic, Fundraising-Backlog
AndyRussG closed T203499: Update EventLogging schema for CentralNotice, a subtask of T183978: [Epic] Fundraising kafkatee changes, as Invalid.
Sep 25 2018, 4:27 AM · Epic, Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Bermuda Rhombus (where things disappear then reappear), Fundraising Sprint Asymmetrical Earth Theory, Fundraising-Backlog
AndyRussG added a comment to T203499: Update EventLogging schema for CentralNotice.

Ooops! I was mistaken... This is not necessary, since we currently don't get data (via either pipeline) from banner previews (makes much more sense, really).

Sep 25 2018, 4:27 AM · Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Epic, Fundraising-Backlog

Sep 24 2018

AndyRussG claimed T203499: Update EventLogging schema for CentralNotice.
Sep 24 2018, 9:53 PM · Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Epic, Fundraising-Backlog
AndyRussG moved T203499: Update EventLogging schema for CentralNotice from Backlog to Doing on the Fundraising Sprint Sasquatches can't find us either board.
Sep 24 2018, 9:52 PM · Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Epic, Fundraising-Backlog
AndyRussG updated subscribers of T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.
Sep 24 2018, 9:32 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

For contrast, the same mwrelp test on enwiki took about 2 seconds:

Sep 24 2018, 4:58 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

Looks like I've found the general area of code causing this. :)

Sep 24 2018, 5:04 AM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG updated the task description for T205118: CentralNotice: When fetching banner settings, pull translation metadata only when necessary.
Sep 24 2018, 4:46 AM · Fr-CentralNotice-Translation-Bugs, MediaWiki-extensions-CentralNotice, Fundraising-Backlog

Sep 21 2018

AndyRussG created T205118: CentralNotice: When fetching banner settings, pull translation metadata only when necessary.
Sep 21 2018, 4:28 PM · Fr-CentralNotice-Translation-Bugs, MediaWiki-extensions-CentralNotice, Fundraising-Backlog

Sep 18 2018

AndyRussG moved T178930: CentralNotice: Consolidate typical analytics queries (for example, for impression rates) into a library from Backlog to Review on the Fundraising Sprint Sasquatches can't find us either board.
Sep 18 2018, 9:20 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising Sprint Junebugs prefer July, Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Gravity wasn't always this pushy, Fundraising Sprint Fhabricator is spelled with an "F", Fundraising Sprint Elevators were never intended to go down, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Bermuda Rhombus (where things disappear then reappear), Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Winter Wanderland, Fundraising Sprint Vaporwerewolf, Fundraising Sprint Uptight Piano, MediaWiki-extensions-CentralNotice, Fundraising-Backlog
AndyRussG moved T195594: New scripts to ingress data from Kafkatee into MySQL from Backlog to Review on the Fundraising Sprint Sasquatches can't find us either board.
Sep 18 2018, 9:20 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Patch-For-Review, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising-Backlog
AndyRussG moved T196564: DB schemas (production changes and test DB) and SQL commands to run for new banner and LP impression data from EL from Backlog to Review on the Fundraising Sprint Sasquatches can't find us either board.
Sep 18 2018, 9:20 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog
AndyRussG moved T203925: Save times for changes to translation variable text in centralnotice paralysingly slow from Backlog to Doing on the Fundraising Sprint Sasquatches can't find us either board.
Sep 18 2018, 9:20 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Sep 17 2018

AndyRussG added a comment to T195594: New scripts to ingress data from Kafkatee into MySQL.

@Ejegg I'm seeing a patch merged here. Is this task Pending Deployment?

Sep 17 2018, 6:29 PM · Fundraising Sprint XML ate my homework, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Patch-For-Review, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising Sprint Karma chameleons hide amongst us, Fundraising-Backlog

Sep 13 2018

AndyRussG added a comment to T203669: Return to real time banner impressions in Druid.

@AndyRussG Hi! I'd like to ask you a couple of questions before starting to work on this task.. are eventlogging_CentralNoticeImpression and eventlogging_LandingPageImpression good authoritative sources for banner impression data instead of filtering webrequest logs?

Sep 13 2018, 3:30 PM · Analytics-Kanban, User-Elukey, Analytics
AndyRussG added a comment to T195840: Track when a CentralNotice banner was displayed to the user in NavTiming.

@Gilles Apologies for the delay... Is it ok with you if this goes on next week's deployment train? (Also replied to your e-mail... Apologies again!!!)

Sep 13 2018, 2:53 PM · MW-1.32-notes (WMF-deploy-2018-10-02 (1.32.0-wmf.24)), Patch-For-Review, Wikimedia-Fundraising, MediaWiki-extensions-NavigationTiming, Performance-Team

Sep 12 2018

AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

Hi! Some notes here:

  • As far as I can tell, by requesting that CentralNotice administrators refrain from creating or editing banners with translatable messages, we're preventing any affectation of cluster performance due to the specific problem described in this bug (incredibly slow save times for banners with translatable messages).
  • Nonetheless, we do need a careful review of CentralNotice-Translate interaction, to improve performance and code sanity in general, which includes this specific bug.
  • The option suggested by @Nikerabbit is the immediate action we're pursuing, though that should also not be deployed until we're clear about its impact on all bits and pieces of this complex system.
  • @Krenair, indeed we wouldn't disable CN-Translate integration without looking carefully at the impact, and, also, that doesn't look like the right option at this point :)
Sep 12 2018, 3:01 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Sep 11 2018

AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

While checking callers of TranslateMetadata I found this code: https://gerrit.wikimedia.org/g/mediawiki/extensions/CentralNotice/+/e8f750a205e1ae61d694d6360c050bff724e7d03/includes/Banner.php#1008

It seems to be running MessageIndexRebuildJob during the request! This should happen in the JobQueue. No wonder saving will take a long time if this is indeed the case.

It also calls MessageGroups::clearCache while MessageGroups::recache is preferred to avoid multiple threads hurrying to rebuild the deleted cache.

Sep 11 2018, 6:12 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

@jcrespo @Nikerabbit Thanks!!! I think we could potentially look at disabling CentralNotice-Translate integration as a measure of last resort. (Note that we have asked CentralNotice administrators to not use translatable messages in banners for now, also.)

Sep 11 2018, 12:27 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Sep 10 2018

AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

Just to note, though the general slow-to-save banner issue is important, that problem, as far as I can tell, has a different cause from very-very-slow-to-save problem with banners containing translatable messages...

Sep 10 2018, 7:35 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

Could this be related to T195293 ?

Sep 10 2018, 7:26 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG added a project to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow: MediaWiki-Database.
Sep 10 2018, 2:53 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice
AndyRussG added a comment to T203925: Save times for changes to translation variable text in centralnotice paralysingly slow.

Hi! Looked at this quickly:

  • This does not seem to be affecting banner displays, as far as I can see.
  • There are a lot of Database warnings related to translatable messages.
Sep 10 2018, 2:52 PM · Core Platform Team Kanban (Done with CPT), Performance-Team-notice, Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Core Platform Team (Security, stability, performance and scalability (TEC1)), Performance-Team, Fundraising Sprint Sasquatches can't find us either, Language-Team, Fundraising Sprint Raw data can give you salmonella, MediaWiki-extensions-Translate, Fundraising-Backlog, MediaWiki-extensions-CentralNotice

Sep 6 2018

AndyRussG committed rWMFRa59621927188: Minor improvements in create_tables.sql (authored by AndyRussG).
Minor improvements in create_tables.sql
Sep 6 2018, 7:21 PM
AndyRussG committed rWMFR73c31d9fdacb: Inline doc and comments (authored by AndyRussG).
Inline doc and comments
Sep 6 2018, 7:12 PM
AndyRussG moved T196564: DB schemas (production changes and test DB) and SQL commands to run for new banner and LP impression data from EL from Doing to Review on the Fundraising Sprint Raw data can give you salmonella board.
Sep 6 2018, 3:30 PM · Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint They Live, Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Fundraising Sprint Owls, Fundraising Sprint Naming Sprints Is Not Important, Fundraising Sprint Matt Damon to head up Space Force, Fundraising Sprint Lactose is unusually tolerant, Fundraising-Backlog