1920585 - Airflow tasks `bqetl_glean_usage.checks__warn_net_thunderbird_android*_derived__baseline_clients_last_seen__v1` failed for exec_date 2024-09-20

Status: RESOLVED FIXED

(Data Platform and Tools :: General, defect)

Description

[Sean Rose [:srose]]

The following tasks failed:

• checks__warn_net_thunderbird_android_beta_derived__baseline_clients_last_seen__v1
• checks__warn_net_thunderbird_android_daily_derived__baseline_clients_last_seen__v1
• checks__warn_net_thunderbird_android_derived__baseline_clients_last_seen__v1

Task link:

• https://workflow.telemetry.mozilla.org/dags/bqetl_glean_usage/grid?dag_run_id=scheduled__2024-09-20T02%3A00%3A00%2B00%3A00&task_id=thunderbird_android.checks__warn_net_thunderbird_android_beta_derived__baseline_clients_last_seen__v1&tab=logs
• https://workflow.telemetry.mozilla.org/dags/bqetl_glean_usage/grid?dag_run_id=scheduled__2024-09-20T02%3A00%3A00%2B00%3A00&task_id=thunderbird_android.checks__warn_net_thunderbird_android_daily_derived__baseline_clients_last_seen__v1&tab=logs
• https://workflow.telemetry.mozilla.org/dags/bqetl_glean_usage/grid?dag_run_id=scheduled__2024-09-20T02%3A00%3A00%2B00%3A00&task_id=thunderbird_android.checks__warn_net_thunderbird_android_derived__baseline_clients_last_seen__v1&tab=logs

Log extract:

Error in query string: Error processing job 'moz-fx-data-shared-prod:bqjob_r95dbecea8eca46c_0000019212b404af_1': Min Row Count Error: 0 rows found, expected more than 1 rows
Error in query string: Error processing job 'moz-fx-data-shared-prod:bqjob_r7dea3a46767faa59_0000019212b42d55_1': division by zero: 0 / 0

Comment 1

[Sean Rose [:srose]]

The checks__warn_net_thunderbird_android_derived__baseline_clients_last_seen__v1 task is no longer failing, which gives some confidence that data will eventually appear for the beta and daily apps.

Comment 2

[Sean Rose [:srose]]

The checks__warn_net_thunderbird_android_beta_derived__baseline_clients_last_seen__v1 task is no longer failing.

That just leaves the checks__warn_net_thunderbird_android_daily_derived__baseline_clients_last_seen__v1 task, and I'm seeing some baseline pings from that app in the live tables today, so it should stop failing in tomorrow's DAG run.

Comment 3

[Sean Rose [:srose]]

The checks__warn_net_thunderbird_android_daily_derived__baseline_clients_last_seen__v1 task is no longer failing.