alexott opened a new pull request, #25579:
URL: https://github.com/apache/airflow/pull/25579
When running migrations on MySQL, the migration code for
`dag_owner_attributes` fails with error:
```
1215 (HY000): Cannot add foreign key constraint
```
This is caused by the type incompatibility between table definition of the
`dag_id` column
that was declared as `sa.Column('dag_id', sa.String(length=250),
nullable=False)`, but the
`dag_id` in `dag` table is declared as `StringID()` that is mapped into UTF-8
string (`dag_id VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL`).
MySQL is sensitive in difference of the charset declarations and fails
because of it.
related: #25280
--
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]
