https://prefect.io logo
Title
e

Edmund Tian

12/20/2022, 5:29 PM
Hi, I’m getting the following error during my Flow Run.
OperationalError:
(sqlite3.OperationalError) no such table: flow_run_alert_policy
[SQL: ALTER TABLE flow_run_alert_policy RENAME TO flow_run_notification_policy]
(Background on this error at: <https://sqlalche.me/e/14/e3q8>)
I’m using the
@flow
and
@task
decorators for my Python functions. I’m not using Prefect Cloud. I’m on the following prefect version
prefect==2.3.2
. It’s hard for me to repo because this occurs during my chron job, and it only occurs for a small subset of the Flow Runs. I haven’t been able to repo locally. Anyone know what’s going on? A quick Google brought me to this, but this doesn’t seem related as I am not deploying anything and I’m not using
orion
.
k

Khuyen Tran

12/20/2022, 5:35 PM
This seems to be the same issue as this one. Did you try to delete the
~/.prefect/orion.db
file, or run
prefect orion database reset
?
e

Edmund Tian

12/21/2022, 2:52 PM
These errors are happening on my app deployed to GCP, not my local machine. How can I do that for a deployed app?
k

Khuyen Tran

12/21/2022, 5:04 PM
I don’t know about GCP well. Do you know how to handle this, @Ryan Peden?