[PR] [v3-3-test] Limit deadline alerts endpoint to the latest serialized Dag row (#70804) [airflow]

["github-actions[bot] (via GitHub)" <gi...@apache.org>]

github-actions[bot] opened a new pull request, #70965:
URL: https://github.com/apache/airflow/pull/70965

   * The deadline alerts endpoint fetches the latest serialized Dag by
   ordering all rows for a dag_id descending and reading the first one.
   Without a LIMIT, the database materializes every serialized version of
   the Dag when only the newest is needed. Cap the lookup at a single row.
   
   * Sort imports in deadline alerts UI route tests
   
   * UI: Allow reading deadline alerts of a specific Dag version
   
   A backfill run executes the Dag version that was current when it was
   queued, whose deadline alerts may differ from the ones deployed today.
   The endpoint could only ever resolve the newest serialized Dag, so the
   UI reported present-day alerts for historical runs and misrepresented
   what those runs were actually held to.
   
   Resolving the version through DagVersion.version_number also removes a
   reliance on the serialized_dag primary key sorting chronologically,
   which only held because uuid7 happens to be time-ordered and would give
   the wrong row if an older version were serialized after a newer one.
   Only the primary key is read, so the serialized Dag blob no longer
   crosses the wire for a lookup that discards it.
   (cherry picked from commit 1b3121d03b6967796cbaf370f7ecf9c66664cae5)
   
   Co-authored-by: Richard <ri...@ualberta.ca>


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [PR] [v3-3-test] Limit deadline alerts endpoint to the latest serialized Dag row (#70804) [airflow]

["bbovenzi (via GitHub)" <gi...@apache.org>]

bbovenzi merged PR #70965:
URL: https://github.com/apache/airflow/pull/70965


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org