Page MenuHomePhabricator

[M] No data from ptwikinews in event.mediawiki_mediasearch_interaction table
Closed, ResolvedPublic

Description

Media search extension was enabled in Portuguese Wikinews (T299872), and have officially made MediaSearch the default search on their wiki (https://pt.wikinews.org/w/index.php?search=tree&title=Especial:MediaSearch&type=page).

We did some test searches on PT Wiki News and also on Commons with console event logging turned on, and I only see the events show up properly on Commons. We also checked the event.eventgate_analytics_external_error_validation table in the Data Lake, and the corresponding Kibana dashboard, and didn’t see MediaSearch show up there either.

Event Timeline

CBogen renamed this task from No data from ptwikinews in event.mediawiki_mediasearch_interaction table to [M] No data from ptwikinews in event.mediawiki_mediasearch_interaction table .Jun 1 2022, 4:40 PM

Estimated as a M assuming this is a config we need to find and turn on somewhere. If this turns out to involve re-doing the schema itself, we will re-evaluate.

mfossati changed the task status from Open to In Progress.Jun 29 2022, 9:34 AM

@cchen, this query should count the ptwikinews events available in event.mediawiki_mediasearch_interaction, starting from May 16, i.e., when MediaSearch was enabled on ptwikinews:

SELECT COUNT(*) FROM event.mediawiki_mediasearch_interaction
WHERE datacenter='eqiad' AND year=2022 AND month=5 AND day>16
AND normalized_host.project_class='wikinews' AND normalized_host.project='pt'

Output: 603
I've also tried to compare a random ptwikinews event with a Commons one, but I don't see any difference.

Am I missing something or is the data actually available and we can close this ticket as invalid?

@mfossati I see the data is available now! thanks for checking. it wasn't there when we checked on May 16. I will close this ticket.