Hello everyone, I work with prefect to set up flo...
# ask-community
m
Hello everyone, I work with prefect to set up flows and tasks. I usually code using VSCode and its remote SSH add-on to log into a server. Everythign was workign perfectly until today. Something happened and an unexpected disconnection just screwed some stuff up. First I could not log into the server via VSCode. I fixed that. Then when runnign python files with prefect flows and task I keep gettign this error:
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
(Background on this error at: <https://sqlalche.me/e/14/e3q8>)
. I removed all orphan processes because I suspected the disconnection left something runnign that was accessing the SQLite database from prefect… and nothing. I also tried removing the database. It is neither a question of flow size because I also tried to run a very simple test flow and it gives the same error. Any help is really appreciated, this is extremely annoying. I basically cant run any of the code I had set up with prefect :(
j
Hey, could you give some more context about your setup? Are you running a prefect server at all or only the ephemeral API? Do you have a reproducible example flow run that gives this behavior?
m
Ephemeral and anything that uses perfect gives this error now.
n
hi Marco, I just encountered this as well and after upgrading with
pip install -U prefect
I didn't encounter it again - can you try upgrading?
m
I tried uninstalling and installing again prefect. Will do it again then!
Why do you think this happened?