[GitHub] [airflow] liuning89757 commented on issue #24247: DB init and upgrade for MariaDB does not work on Airflow 2.3

[GitBox <gi...@apache.org>]

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

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