liuning89757 commented on issue #24247: URL: https://github.com/apache/airflow/issues/24247#issuecomment-1185105663
> > Can anyone test if `return Sequence(sequence_name)` actually works with MariaDB? > > > > * Airflow 2.3.1 (SQLAlchemy== 1.4.9) > > * MariaDB 10.3 > > > > https://github.com/apache/airflow/blob/2.3.1/airflow/www/fab_security/sqla/models.py#L56-L83 https://github.com/apache/airflow/blob/2.3.1/airflow/migrations/versions/0073_2_0_0_prefix_dag_permissions.py > > Sequence, was used in model but can't find where it was used in migrations. I might be missing something. Any Idea? How did you create your db in the first place? @ephraimbuddy I think the migration file might be https://github.com/apache/airflow/blob/2.3.1/airflow/migrations/versions/0057_1_10_13_add_fab_tables.py . In this migration alembic create table with out explicit create sequence. And according to https://stackoverflow.com/questions/17196234/how-to-create-postgresqls-sequences-in-alembic#comment115841207_17196812 , the sequence in MariaDB need to be create manually -- 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]
