astro-cli
astro-cli copied to clipboard
sqlalchemy.exc.ArgumentError: Invalid value for 'executemany_mode': 'values'
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