Bug 1902284 Comment 0 Edit History

Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.

Airflow task <Airflow DAG>.<task name> failed for exec_date <date>

Task link:
<failed_task_link>

Log extract:
```
<extract of error log>
```
Airflow task bqetl_mobile_feature_usage.fenix_derived__feature_usage_events__v1 and fenix_derived__feature_usage_metrics__v1 failed for exec_date 2024-06-13

Task link:
https://workflow.telemetry.mozilla.org/dags/bqetl_mobile_feature_usage/grid?dag_run_id=scheduled__2024-06-12T06%3A00%3A00%2B00%3A00&task_id=fenix_derived__feature_usage_events__v1

Log extract:
```
 STRING, va...; failed to parse view 'fenix.metrics' at [23:1]
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base] Traceback (most recent call last):
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "<string>", line 1, in <module>
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/app/bigquery_etl/cli/__init__.py", line 76, in cli
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     group(prog_name=prog_name)
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1157, in __call__
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     return self.main(*args, **kwargs)
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]            ^^^^^^^^^^^^^^^^^^^^^^^^^^
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/usr/local/lib/python3.11/site-packages/rich_click/rich_command.py", line 126, in main
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     rv = self.invoke(ctx)
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]          ^^^^^^^^^^^^^^^^
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     return _process_result(sub_ctx.command.invoke(sub_ctx))
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     return _process_result(sub_ctx.command.invoke(sub_ctx))
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1434, in invoke
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     return ctx.invoke(self.callback, **ctx.params)
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/usr/local/lib/python3.11/site-packages/click/core.py", line 783, in invoke
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     return __callback(*args, **kwargs)
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/usr/local/lib/python3.11/site-packages/click/decorators.py", line 33, in new_func
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     return f(get_current_context(), *args, **kwargs)
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/app/bigquery_etl/cli/query.py", line 868, in run
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     _run_query(
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/app/bigquery_etl/cli/query.py", line 1013, in _run_query
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     subprocess.check_call(["bq"] + query_arguments, stdin=query_stream)
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]   File "/usr/local/lib/python3.11/subprocess.py", line 413, in check_call
[2024-06-13, 07:03:11 UTC] {pod_manager.py:466} INFO - [base]     raise CalledProcessError(retcode, cmd)
[2024-06-13, 07:03:12 UTC] {pod_manager.py:483} INFO - [base] subprocess.CalledProcessError: Command '['bq', 'query', '--parameter=submission_date:DATE:2024-06-12', '--project_id=moz-fx-data-shared-prod', '--destination_table=feature_usage_events_v1$20240612', '--use_legacy_sql=False', '--dataset_id=fenix_derived']' returned non-zero exit status 1.
[2024-06-13, 07:03:12 UTC] {pod_manager.py:616} INFO - Pod fenix-derived--feature-usage-events--v1-rbkuy2s0 has phase Running
[2024-06-13, 07:03:15 UTC] {pod.py:912} INFO - Skipping deleting pod: fenix-derived--feature-usage-events--v1-rbkuy2s0
[2024-06-13, 07:03:15 UTC] {taskinstance.py:2728} ERROR - Task failed with exception
```

Back to Bug 1902284 Comment 0