Page MenuHomePhabricator

Deal with non-timeboxed queries recomputing too much data for the mobile report-card
Closed, DuplicatePublic

Description

mobile report-card runs on all of the data available (since the beginning) and it has been failing. Sean had to kill hundreds of blocked processes.

Get from the mobile team which queries we need to run

For each report:
    - rewrite query to fit into timeboxed format
    - add parameters to config (quick)
    - test (does timebox filter gets pushed in each of the union subqueries?)

Details

Related Gerrit Patches:
analytics/limn-mobile-data : masterDisable 19 queries from the scheduler

Event Timeline

Milimetric claimed this task.
Milimetric raised the priority of this task from to Needs Triage.
Milimetric updated the task description. (Show Details)
Milimetric added a project: Analytics-Kanban.
Milimetric added a subscriber: Milimetric.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 13 2015, 4:50 PM

Change 210364 had a related patch set uploaded (by Milimetric):
Disable 19 queries from the scheduler

https://gerrit.wikimedia.org/r/210364

kevinator renamed this task from Deal with non-timeboxed queries recomputing too much data to Deal with non-timeboxed queries recomputing too much data for the mobile report-card.Jun 1 2015, 4:47 PM
kevinator triaged this task as Normal priority.
kevinator updated the task description. (Show Details)
kevinator set Security to None.
kevinator updated the task description. (Show Details)Jun 1 2015, 5:05 PM

Change 210364 abandoned by Milimetric:
Disable 19 queries from the scheduler

Reason:
no longer relevant after the mobile reportcard cleanup

https://gerrit.wikimedia.org/r/210364