Hi everyone, I installed Prefect in a (mini)conda ...
# ask-community
o
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
Hi @Oleg Sheyner if you are running prefect 2.0 and are ok resetting the database, can you try the following commands?
Copy code
rm -rf ~/.prefect/orion.db

prefect orion database reset -y
and then try your flow again
o
@Nate Worked. Awesome thanks.
n
Great to hear 😄