Hello all - just starting my journey with dagster as a converted Airflow'er. Having an issue as soon as I start dagit. Operation name: InstanceSensorsQuery Message: (sqlite3.OperationalError) near "(": syntax error [SQL: SELECT subquery.id, subquery.selector_id, subquery.tick_body FROM (SELECT job_ticks.id AS id, job_ticks.selector_id AS selector_id, job_ticks.tick_body AS tick_body, rank() OVER (PARTITION BY job_ticks.selector_id ORDER BY job_ticks.timestamp DESC) AS rank FROM job_ticks WHERE job_ticks.selector_id IN (?)) AS subquery WHERE subquery.rank <= ? ORDER BY subquery.rank ASC] [parameters: ('03064b2df6239201293d653e3d171fd86ca400fa', 1)] (Background on this error at: https://sqlalche.me/e/14/e3q8) Path: ["repositoriesOrError","nodes",0,"sensors",0,"sensorState","ticks"] Locations: [{"line":152,"column":3}] This results in errors on schedules, sensors, and backfills pages not returning.

What version?

0.14.9

What version of sqllite do you have installed?

3.7.17

I’ll get a fix for this right out… should be able to get this in for the dagster release tomorrow

Do you need to see any more information to assist fix development?

No, I think I got it. I think a workaround in the meantime would be to upgrade your version of sqlite to >

3.25

. If that’s not feasible, I can also walk you through a more involved workaround (would need to manually update a row in your db)

Upgrading isnt a problem - I'll go ahead and pursue that route. If you'd like for me to test the fix with 3.7 once released just let me know! Thanks for the quick turnaround on this!!!

How did you do the upgrade? I think sqlite became builtin to Python, so we’d need to check the version from within the Python executable you’re using to run dagit:

$ python
>>> import sqlite3
>>> sqlite3.sqlite_version
'3.36.0'

Dang - yeah that makes sense - I upgrade usr/bin/sqlite3 and checked version from there