Hello everyone, I'm using Prefect 2.6.8 on GCP, an...
# prefect-community
Hello everyone, I'm using Prefect 2.6.8 on GCP, and I'm seeing sqlite errors like this pretty frequently:
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table flow_run has no column named state_timestamp"
prefect.exceptions.MissingResult: State data is missing. Typically, this occurs when result persistence is disabled and the state has been retrieved from the API.
File "/usr/local/lib/python3.8/dist-packages/prefect/utilities/asyncutils.py", line 267, in on_shutdown
EVENT_LOOP_GC_REFS.pop(key) KeyError: 140157491380864
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: flow
Has anyone see this kind of things before?
Hello Sean, admittedly I have also not seen this error before. I'll pass this along to the team to see what this could be. Were you by chance able to try out the troubleshooting steps in this article?
Thanks for the response! Yes - so this approach works - for a while. But oddly enough it seems that the errors reappear after a while. Once I restart everything, the job runs error-free at first, but then the errors keep coming back.
it looks like some issue with your database - if you don't want to deal with DB administration, we have a generous free tier on Prefect Cloud https://app.prefect.cloud/ also, given you already asked on Discourse, can we keep the convo on Discourse? makes it easier for us. Thanks a lot