vatsrahul1001 opened a new pull request, #61806: URL: https://github.com/apache/airflow/pull/61806
Fix "Out of sort memory" error on MySQL during deadline alert data migration in upgrade/downgrade operations. The migration queries in `0099_3_2_0_ui_improvements_for_deadlines.py` select large `data` and `data_compressed` columns while performing `ORDER BY`, which causes MySQL to exceed its sort buffer size when processing serialized DAGs with large data payloads. This fix uses a subquery pattern for MySQL to first sort only small columns (`id`, `dag_id`), then joins back to fetch the large columns without requiring them in the sort buffer. Related: https://github.com/apache/airflow/pull/55589 - [x ] Yes claude * Read the **[Pull Request Guidelines](https://github.com/apache/airflow/blob/main/contributing-docs/05_pull_requests.rst#pull-request-guidelines)** for more information. Note: commit author/co-author name and email in commits become permanently public when merged. * For fundamental code changes, an Airflow Improvement Proposal ([AIP](https://cwiki.apache.org/confluence/display/AIRFLOW/Airflow+Improvement+Proposals)) is needed. * When adding dependency, check compliance with the [ASF 3rd Party License Policy](https://www.apache.org/legal/resolved.html#category-x). * For significant user-facing changes create newsfragment: `{pr_number}.significant.rst` or `{issue_number}.significant.rst`, in [airflow-core/newsfragments](https://github.com/apache/airflow/tree/main/airflow-core/newsfragments). -- 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]
