mrdavidlaing
02/22/2022, 8:06 PMinstance/overview
page)
Is this a know issue; or something to do with our specific set of dependencies?
AttributeError: 'Select' object has no attribute 'subquery'
Traceback (most recent call last):
...snip...
File "/Users/dlaing/workspace/tanzu-dm/.venv/lib/python3.7/site-packages/dagster/core/storage/runs/sql_run_storage.py", line 312, in _runs_query
subquery = base_query.subquery()
graphql.error.located_error.GraphQLLocatedError: 'Select' object has no attribute 'subquery'
prha
02/22/2022, 8:07 PMmrdavidlaing
02/22/2022, 8:09 PMrun_storage:
module: dagster.core.storage.runs
class: SqliteRunStorage
config:
base_dir: /Users/dlaing/workspace/tanzu-dm/tmp/dagster_home/history/
/Users/dlaing/workspace/tanzu-dm/tmp/dagster_home
and then restarted (to ensure no left over state version issues) - still getting the same errorprha
02/22/2022, 8:52 PMalex
02/22/2022, 8:54 PMSQLAlchemy
mrdavidlaing
02/22/2022, 8:57 PM$ pip freeze | egrep 'SQL'
SQLAlchemy==1.4.31
$ sqlite3 -version
3.36.0 2021-06-18 18:58:49 d24547a13b6b119c43ca2ede05fecaa707068f18c7430d47fc95fb5a2232aapl
prha
02/23/2022, 12:23 AMmrdavidlaing
02/23/2022, 7:38 AMalex
02/23/2022, 4:30 PMsqlite3
(in shell) might not resolve to the same as what python
is using, so could double check in python
quick:
>>> import sqlite3
>>> sqlite3.version
'2.6.0'
>>> sqlite3.sqlite_version
'3.32.3'
prha
02/23/2022, 4:33 PM3.7.12
) and maybe a requirements.txt
file (minus the private packages)mrdavidlaing
02/26/2022, 9:36 AM$ pipenv run python
Python 3.7.9 (default, Sep 22 2021, 10:42:20)
[Clang 12.0.5 (clang-1205.0.22.9)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.version
'2.6.0'
>>> sqlite3.sqlite_version
'3.37.2'
>>>
SQLAlchemy==1.3.15
installedSQLAlchemy==1.4.0
the problem goes away...SQLAlchemy
comes through dagster
-> alembic
(source); although alembic
only seems to specify SQLAlchemy>=1.3.0
(source)
dagit==0.14.1
- dagster [required: ==0.14.1, installed: 0.14.1]
- alembic [required: >=1.2.1,<1.7.0,!=1.6.3, installed: 1.6.5]
- SQLAlchemy [required: >=1.3.0, installed: 1.3.15]
SQLAlchemy>=1.4.0
dagster
or alembic
WDYT?alex
02/28/2022, 5:37 PMdagster
that is only available in > 1.4 we should probably improve our pinsubquery
on Select
?mrdavidlaing
03/01/2022, 10:11 PMprha
03/01/2022, 10:19 PMmrdavidlaing
03/02/2022, 10:47 PM