astro-cli icon indicating copy to clipboard operation
astro-cli copied to clipboard

sqlalchemy.exc.ArgumentError: Invalid value for 'executemany_mode': 'values'

Open diman82 opened this issue 2 years ago • 0 comments

Describe the bug

The bug results in all astro containers (except postgres:12.6) to constantly restart. It seems it has a conflict with sqlalchemy versions package (I install llama_index package, that requires sqlalchemy>=2.0.15

 Waiting for host: postgres 5432
 Traceback (most recent call last):
   File "/usr/local/bin/airflow", line 5, in <module>
     from airflow.__main__ import main
   File "/usr/local/lib/python3.10/site-packages/airflow/__init__.py", line 66, in <module>
     settings.initialize()
   File "/usr/local/lib/python3.10/site-packages/airflow/settings.py", line 529, in initialize
     configure_orm()
   File "/usr/local/lib/python3.10/site-packages/airflow/settings.py", line 222, in configure_orm
     engine = create_engine(SQL_ALCHEMY_CONN, connect_args=connect_args, **engine_args)
   File "<string>", line 2, in create_engine
   File "/home/astro/.local/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
     return fn(*args, **kwargs)  # type: ignore[no-any-return]
   File "/home/astro/.local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 614, in create_engine
     dialect = dialect_cls(**dialect_args)
   File "/home/astro/.local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 632, in __init__
     self.executemany_mode = parse_user_argument_for_enum(
   File "/home/astro/.local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 1738, in parse_user_argument_for_enum
     raise exc.ArgumentError(f"Invalid value for '{name}': {arg!r}")
 sqlalchemy.exc.ArgumentError: Invalid value for 'executemany_mode': 'values'

CLI version - 1.16.1, ASTRO version - 8.5.0

This CLI bug is related to which Astronomer Platform?

  • [X] Astro
  • [X] Software
  • [ ] None/Unknown

What Operating System is the above CLI installed on? - WSL2

📸 Screenshots

diman82 avatar Jun 20 '23 18:06 diman82