[Airflow] airflow db 초기화 오류

 

airflow db 초기화 오류

----------------------------------------------------------------------------------------------------------------------

Traceback (most recent call last):
  File "/opt/homebrew/bin/airflow", line 5, in <module>
    from airflow.__main__ import main
  File "/opt/homebrew/lib/python3.11/site-packages/airflow/__init__.py", line 68, in <module>
    settings.initialize()
  File "/opt/homebrew/lib/python3.11/site-packages/airflow/settings.py", line 546, in initialize
    configure_orm()
  File "/opt/homebrew/lib/python3.11/site-packages/airflow/settings.py", line 242, in configure_orm
    engine = create_engine(SQL_ALCHEMY_CONN, connect_args=connect_args, **engine_args, future=True)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/opt/homebrew/lib/python3.11/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/lib/python3.11/site-packages/sqlalchemy/engine/create.py", line 680, in create_engine
    raise TypeError(
TypeError: Invalid argument(s) 'encoding' sent to create_engine(), using configuration SQLiteDialect_pysqlite/QueuePool/Engine.  Please check that the keyword arguments are appropriate for this combination of components.

 

----------------------------------------------------------------------------------------------------------------------

 

sqlalchemy 버전을 낮춘다. 

pip install sqlalchemy==1.4.49

 

 

 

Reference ) 

https://stackoverflow.com/questions/76950236/error-while-initializing-airflow-db-in-sqlalchemy-package

Error while initializing airflow DB in sqlalchemy package