Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

What causes these Airflow ingestion errors? #13638

Closed
scastria opened this issue Oct 18, 2023 · 4 comments · Fixed by #14515
Closed

What causes these Airflow ingestion errors? #13638

scastria opened this issue Oct 18, 2023 · 4 comments · Fixed by #14515
Assignees
Labels
bug Something isn't working Ingestion

Comments

@scastria
Copy link

The particular task it is complaining about was removed just this morning. If I check the AirflowMetadata DB that powers the MWAA environment, I do see that task in the task_instance table, but it has a state of "removed" as it should. So I am wondering if the Airflow metadata ingestion process is not ignoring "removed" tasks like it should or perhaps the error message needs to be more clear??

[[34m2023-10-17T19:57:43.604+0000[0m] {[34mmetadata_rest.py:[0m356} ERROR[0m - Unexpected error writing pipeline status [pipeline_fqn='airflow.third_party-mountain-seed-ingest' pipeline_status=PipelineStatus(timestamp=Timestamp(__root__=1697553453), executionStatus=<StatusType.Successful: 'Successful'>, taskStatus=[TaskStatus(name='task_notify_qa_validate', executionStatus=<StatusType.Successful: 'Successful'>, startTime=Timestamp(__root__=1697554057935), endTime=Timestamp(__root__=1697554142340), logLink=None), TaskStatus(name='task_mountain_seed_post_validation', executionStatus=<StatusType.Successful: 'Successful'>, startTime=Timestamp(__root__=1697553971398), endTime=Timestamp(__root__=1697554054861), logLink=None), TaskStatus(name='task_mountain_seed_data_ingest', executionStatus=<StatusType.Successful: 'Successful'>, startTime=Timestamp(__root__=1697553886154), endTime=Timestamp(__root__=1697553965523), logLink=None), TaskStatus(name='task_mountain_seed_id_resolution', executionStatus=<StatusType.Successful: 'Successful'>, startTime=Timestamp(__root__=1697553787741), endTime=Timestamp(__root__=1697553882382), logLink=None), TaskStatus(name='task_mountain_seed_raw_ingest', executionStatus=<StatusType.Successful: 'Successful'>, startTime=Timestamp(__root__=1697553703752), endTime=Timestamp(__root__=1697553784035), logLink=None), TaskStatus(name='task_mountain_seed_data_qa_validate', executionStatus=<StatusType.Successful: 'Successful'>, startTime=Timestamp(__root__=1697553597671), endTime=Timestamp(__root__=1697553697428), logLink=None), TaskStatus(name='task_mountain_seed_add_unique_key', executionStatus=<StatusType.Pending: 'Pending'>, startTime=Timestamp(__root__=1697553555525), endTime=Timestamp(__root__=1697553601349), logLink=None), TaskStatus(name='task_mountain_seed_remove_unique_key', executionStatus=<StatusType.Pending: 'Pending'>, startTime=None, endTime=None, logLink=None), TaskStatus(name='task_mountain_seed_copy_raw', executionStatus=<StatusType.Successful: 'Successful'>, startTime=Timestamp(__root__=1697553465252), endTime=Timestamp(__root__=1697553548777), logLink=None)])]: Invalid task name task_mountain_seed_add_unique_key[0m

@harshach harshach moved this to Ingestion - Bugs & Minor Features in Release 1.3.0 Oct 22, 2023
@pmbrull
Copy link
Collaborator

pmbrull commented Oct 25, 2023

@scastria can you please give us some version info?

OM version & MWAA versions to replicate this. thanks

@pmbrull pmbrull added bug Something isn't working Need more info Waiting for more info or feedback Ingestion labels Oct 27, 2023
@pmbrull
Copy link
Collaborator

pmbrull commented Oct 31, 2023

hi @scastria need a bit of more info here to know how to reproduce

@scastria
Copy link
Author

scastria commented Nov 1, 2023

Sorry for the delay.

OM Version = 1.1.7
MWAA version = 2.6.3

@pmbrull pmbrull removed the Need more info Waiting for more info or feedback label Dec 12, 2023
@pmbrull
Copy link
Collaborator

pmbrull commented Dec 12, 2023

looks like task deletion reconciliation in the process. to review

pmbrull added a commit that referenced this issue Dec 29, 2023
* Clean name logging and filter out removed tasks

* Update client logging

* Update client logging
@pmbrull pmbrull closed this as completed Dec 29, 2023
@TeddyCr TeddyCr moved this from Ingestion - Bugs & Minor Features to Done in Release 1.3.0 Dec 29, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Ingestion
Projects
No open projects
Status: Done
Development

Successfully merging a pull request may close this issue.

2 participants