iagochoa opened a new issue, #32266:
URL: https://github.com/apache/airflow/issues/32266

   ### Body
   
   **Apache Airflow version**
   2.5.1
   
   **Operating System**
   AWS EKS
   
   **Deployment**
   HELM Chart 1.9.0
   
   **Deployment details**
   Deployed using ArgoCD.
   
   **What happened**
   When I try to get data via grafana query it is listed that some columns do 
not exist.
   
   **Example error:**
   `db query error: pq: column task_fail.execution_date does not exist`
   
   **Used query**
   ```
   WITH task_fails_to_remove AS (
     SELECT 
       task_fail.dag_id,
       task_fail.task_id,
       task_fail.execution_date
     FROM
       task_fail
     LEFT JOIN 
       dag_run ON 
       dag_run.dag_id = task_fail.dag_id 
       AND dag_run.execution_date = task_fail.execution_date
     WHERE
       dag_run.run_id IS NULL
   )
   DELETE FROM
       task_fail
   USING 
       task_fails_to_remove
   WHERE (
       task_fail.dag_id = task_fails_to_remove.dag_id
       AND task_fail.task_id = task_fails_to_remove.task_id
       AND task_fail.execution_date = task_fails_to_remove.execution_date
   );
   
   ```
   **What I've tried so far**
   1) Run ` airflow db upgrade`
   2) Run `airflow db clean`
   3) Run `airflow db check-migrations`
   4) Tried to apply this [GitHub 
issue](https://github.com/apache/airflow/issues/18894) solution
   
   **Additional details:** 
   - I didn't change anytime the airflow version on my deployment.
   - I used the [official helm 
](https://airflow.apache.org/docs/helm-chart/stable/index.html)deployment guide 
(mentions some changes to run migrations on argo deployment)
   - In my first time deploying I lost the fernetKey and deployed again, so I 
used `airflow db reset` to rebuild the database.
   
   Any tips on how to solve this?
   
   ### Committer
   
   - [X] I acknowledge that I am a maintainer/committer of the Apache Airflow 
project.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to