https://prefect.io logo
Title
o

Oleg Sheyner

08/01/2022, 4:52 PM
Hi everyone, I installed Prefect in a (mini)conda virtual environment on Windows Server 2019. Attempting to run a local flow gives this error, any thoughts? sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table _alembic_tmp_deployment already exists [SQL: CREATE TABLE _alembic_tmp_deployment ( id CHAR(36) DEFAULT (( lower(hex(randomblob(4)))
1
👍 2
n

Nate

08/01/2022, 5:13 PM
Hi @Oleg Sheyner if you are running prefect 2.0 and are ok resetting the database, can you try the following commands?
rm -rf ~/.prefect/orion.db

prefect orion database reset -y
and then try your flow again
o

Oleg Sheyner

08/01/2022, 5:15 PM
@Nate Worked. Awesome thanks.
n

Nate

08/01/2022, 5:17 PM
Great to hear 😄