Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLAlchemy >= 2.0.0, Depedency for IBM-DB2 #206

Open
DelongChenQC opened this issue Jul 6, 2024 · 0 comments
Open

SQLAlchemy >= 2.0.0, Depedency for IBM-DB2 #206

DelongChenQC opened this issue Jul 6, 2024 · 0 comments

Comments

@DelongChenQC
Copy link

When using pipedag_config.get('instance') function with an IBM-DB2 that needs to be connected to. There is the following error, when SQLAlchemy is below version 2.0.0:

I only logged the actuall error outputs.

TypeError: Invalid argument(s) 'isolation_level' sent to create_engine(), using configuration DB2Dialect_ibm_db/QueuePool/Engine.  Please check that the keyword arguments are appropriate for this combination of components.
RuntimeError: Failed loading table_store
RuntimeError: Error while creating backend objects from pipedag config (instance=mini, flow=None): /home/ubuntu/hf4-claims-exploration/src/hf4_claims_exploration/pipeline/pipedag.yaml

To my understanding, when trying to call the create_engine() function of sqlalchemy, with an specific isolation_level for versions below 2.0.0 it can lead to incompatibility issues. This is fixed in versions > 2.0.0 as noted here. I simply upgraded the sqlalchemy version and then it worked. Does this incompatibility maybe warrant setting the SQLAlchemy dependency to > 2.0.0 in the pyproject.toml?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant