The GitHub Actions job "Copilot code review" on 
airflow.git/refs/pull/63797/head has failed.
Run started by GitHub user Copilot (triggered by Copilot).

Head commit for run:
3cbde3ecbf7ddfc2f82b3ba4ebebdf8dbb16a33c / Yoann Abriel <[email protected]>
fix: add temporary index on serialized_dag.dag_id for MySQL in migration 0101

The migration 0101 paginates over serialized_dag rows using ORDER BY dag_id,
but dag_id has no index. On MySQL with large tables (100K+ rows), this causes
a sort buffer overflow ('Out of sort memory' error).

Create a temporary index on dag_id before the pagination loop and drop it
after completion, in both upgrade and downgrade paths.

Closes: #63786

Report URL: https://github.com/apache/airflow/actions/runs/24261434820

With regards,
GitHub Actions via GitBox


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to