Neil Natarajan
08/26/2022, 7:06 PMRuntimeError: Orion requires sqlite >= 3.24.0 but we found version 3.7.17
how do I go about fixing this errorJeff Hale
08/26/2022, 7:11 PMNeil Natarajan
08/26/2022, 7:14 PMJeff Hale
08/26/2022, 7:21 PMRyan Peden
08/26/2022, 7:26 PMNeil Natarajan
08/26/2022, 7:29 PMRyan Peden
08/26/2022, 7:49 PMNeil Natarajan
08/26/2022, 7:53 PMRyan Peden
08/26/2022, 7:54 PMNeil Natarajan
08/26/2022, 7:55 PMRyan Peden
08/26/2022, 7:58 PMNeil Natarajan
08/26/2022, 8:00 PMFile "/opt/sfdc/python39/lib/python3.9/site-packages/prefect/orion/database/configurations.py", line 189, in engine
raise RuntimeError(
RuntimeError: Orion requires sqlite >= 3.24.0 but we found version 3.7.17
Ryan Peden
08/26/2022, 10:08 PMNeil Natarajan
08/29/2022, 2:58 PMRyan Peden
08/29/2022, 3:29 PMPREFECT_ORION_DATABASE_CONNECTION_URL="<postgresql+asyncpg://your_postgres_user:your_postgres_password@your_postgres_host:5432/orion>"
I know you've probably done that already, but I'm not sure what else might be causing what you are seeingNeil Natarajan
08/29/2022, 4:14 PM+asyncpg
is that portion necessaryRyan Peden
08/29/2022, 4:25 PMNeil Natarajan
08/29/2022, 4:44 PMRyan Peden
08/29/2022, 9:14 PMNeil Natarajan
08/31/2022, 5:01 PMFile "/opt/sfdc/python39/lib/python3.9/site-packages/aiosqlite/core.py", line 397, in connector
return sqlite3.connect(loc, **kwargs)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
(Background on this error at: <https://sqlalche.me/e/14/e3q8>)
sh-4.2$ prefect config view --show-sources
PREFECT_PROFILE='default'
PREFECT_HOME='/my/path' (from env)
PREFECT_ORION_DATABASE_CONNECTION_URL='sqlite+aiosqlite:///my/path/orion.db' (from env)
I however cannot start prefect orion successfully due to the above errorRyan Peden
08/31/2022, 5:14 PMNeil Natarajan
08/31/2022, 5:18 PMRyan Peden
08/31/2022, 6:14 PM/
characters after sqlite+aiosqlite
, so PREFECT_ORION_DATABASE_CONNECTION_URL='sqlite+aiosqlite:////my/path/orion.db'