Getting this error while execution of flow sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file Also when i changed backend database to postgres this error comes up: sqlalchemy.exc.ProgrammingError: (sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.Unde finedFunctionError'>: function gen_random_uuid() does not exist HINT: No function matches the given name and argument types. You might need to add explicit type casts.

it looks like a DB migration issue, can you remove the SQLite DB?

rm ~/.prefect/orion.db
prefect orion start

when moving to Postgres you would like need to use:

prefect orion database reset -y

Thanks for this @Anna Geller. But i have reset the database to postgres but there's another issue with this. sqlalchemy.exc.ProgrammingError: (sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.UndefinedFunctionError'>: function gen_random_uuid() does not exist HINT: No function matches the given name and argument types. You might need to add explicit type casts. [SQL: CREATE TABLE flow ( id UUID DEFAULT (GEN_RANDOM_UUID()) NOT NULL, created TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL, updated TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL, name VARCHAR NOT NULL, tags JSONB DEFAULT '[]' NOT NULL, CONSTRAINT pk_flow PRIMARY KEY (id), CONSTRAINT uq_flow__name UNIQUE (name) )

is your Postgres version >= 13?

No, psql (PostgreSQL) 12.12

That's the reason, we only support 13 and higher

Upgraded psql to 15.0 , still getting same error.

Did you run this bit after the upgrade to psql 15?

prefect orion database reset -y

… Have you gotten this to work yet?

The migration should start automatically when you start Orion. Can you try PostgreSQL 14 or 13? 15 is very new

Upgraded psql to 13.8 , also executed this command prefect orion database reset -y, getting different error now asyncio.exceptions.TimeoutError @Anna Geller @Jarvis Stubblefield

Can you post the full error output? You can use the

code

button in the text editor to help display your error more easily. This button:

</>

is for a short code snippet (one liner), and the one to the right is for a block of text. Use the one for the block of text for the error output.

@Shruti Hande I strongly encourage you to Prefect Cloud - there is a free tier, no credit card required, and this will get you started immediately you can always decide to self-host later after the initial exploration

I initially was trying to do it all myself, and I’m happy that I decided to just use Prefect Cloud so I could ramp up faster…

@Anna Geller @Jarvis Stubblefield Thank you for your response it was quite helpful. 🙂🙌 Have deployed the flows on prefect cloud .