1857292 - Airflow task bqetl_firefox_ios.checks__fail_firefox_ios_derived__funnel_retention_week_4__v1 failed for exec_date 2023-10-05

Status: RESOLVED FIXED

(Data Platform and Tools :: General, defect)

Description

[anicholson]

Airflow task bqetl_firefox_ios.checks__fail_firefox_ios_derived__funnel_retention_week_4__v1 failed for exec_date 2023-10-05

Task link:
https://workflow.telemetry.mozilla.org/log?dag_id=bqetl_firefox_ios&task_id=checks__fail_firefox_ios_derived__funnel_retention_week_4__v1&execution_date=2023-10-04T04%3A00%3A00%2B00%3A00&map_index=-1

Log extract:

Waiting on bqjob_r6a9387241f40e738_0000018afdfff45b_1 ... (2s) Current status: DONE
[2023-10-05, 04:02:38 UTC] {pod_manager.py:235} INFO - Error in query string: Error processing job 'moz-fx-data-shared- prod:bqjob_r1e30f88cc9b44ba3_0000018afe003525_1': Less than 0 rows found (expected more than 1)
[2023-10-05, 04:02:38 UTC] {pod_manager.py:235} INFO - Error in query string: Error processing job 'moz-fx-data-shared- prod:bqjob_r70bb0dbf8665478b_0000018afe006a9d_1': Retention reported for week 2 by week_2 (15048) and week_4 (0) tables does not match.

Comment 1

[Krzysztof Ignasiak [:kik]]

This appears to have now been resolved via the steps mentioned in this bug:
https://bugzilla.mozilla.org/show_bug.cgi?id=1878680