SQLAlchemy - AttributeError: 'Engine' object has no attribute 'execute'

[MartinBernstorff]

Hi guys! Trying the dagster tutorial. Steps:

1. Create and activate virtualenv
2. Install using pip install dagster dagit requests
3. Copy the example from the tutorial, https://docs.dagster.io/0.12.0/tutorial/intro-tutorial/single-solid-pipeline#hello-solid
4. Run dagit -f test_dagster.py

Gets me the following error:

Looks like it's something with sqlite, which I assume dagster uses as its own storage backend. Sqlalchemy is installed with its latest version:

Any ideas?

[geoHeil]

Sqlalchemy release 2.0.0 seems to be breaking something. Facing the same problem.

[sryza]

We're going to pin sqlalchemy in our next release. In the mean time, you can do

pip install --force-reinstall 'sqlalchemy<2.0.0'

[geoHeil]

exactly - this is also what I have done.
There seems to be some quite weird behavior with sqlalchemy for 2.x not only for SQLite - but also for Postgres.

[rsurendra48]

sudo /usr/local/bin/pip3.7 install -U
psycopg2
py4j

sudo /usr/local/bin/python3.7 -m pip install --upgrade pip
sudo /usr/local/bin/python3.7 -m pip install pymysql==1.0.2
sudo /usr/local/bin/python3.7 -m pip install numpy==1.24.0
sudo /usr/local/bin/python3.7 -m pip install pandas==1.5.2
sudo /usr/local/bin/python3.7 -m pip install --force-reinstall 'sqlalchemy<2.0.0'

I'm still getting the following error :

result = session.get_bind().execute(
AttributeError: 'Engine' object has no attribute 'execute'

[pdroooooooo]

For me I had to downgrade to pymysql==1.0.2 and sqlalchemy==1.4.40

[rsurendra48]

sudo /usr/local/bin/pip3.7 install -U
psycopg2
py4j

sudo /usr/local/bin/python3.7 -m pip install --upgrade pip
sudo /usr/local/bin/python3.7 -m pip install pymysql==1.0.2
sudo /usr/local/bin/python3.7 -m pip install numpy==1.24.0
sudo /usr/local/bin/python3.7 -m pip install pandas==1.5.2
sudo /usr/local/bin/python3.7 -m pip install --force-reinstall 'sqlalchemy<2.0.0'

I'm still getting the following error :

result = session.get_bind().execute(
AttributeError: 'Engine' object has no attribute 'execute'

[charanhu]

aiohttp==3.8.4
aiosignal==1.3.1
async-timeout==4.0.2
attrs==23.1.0
certifi==2023.5.7
charset-normalizer==3.1.0
colorama==0.4.6
dataclasses-json==0.5.7
frozenlist==1.3.3
gpt-index==0.6.0
greenlet==2.0.2
idna==3.4
langchain==0.0.165
llama-index==0.6.5
marshmallow==3.19.0
marshmallow-enum==1.5.1
multidict==6.0.4
mypy-extensions==1.0.0
numexpr==2.8.4
numpy==1.24.3
openai==0.27.6
openapi-schema-pydantic==1.2.4
packaging==23.1
pandas==2.0.1
pydantic==1.10.7
python-dateutil==2.8.2
python-dotenv==1.0.0
pytz==2023.3
PyYAML==6.0
regex==2023.5.5
requests==2.29.0
six==1.16.0
SQLAlchemy==2.0.13
tenacity==8.2.2
tiktoken==0.4.0
tqdm==4.65.0
typing-inspect==0.8.0
typing_extensions==4.5.0
tzdata==2023.3
urllib3==1.26.15
yarl==1.9.2

[apoorvpandey0]

Downgrading to sqlalchemy version 1.4 solved the issue for me