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
Jake Kaplan
06/12/2023, 1:49 PM
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
Marco Barbero Mota
06/12/2023, 2:03 PM
Ephemeral and anything that uses perfect gives this error now.
n
Nate
06/12/2023, 2:35 PM
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
Marco Barbero Mota
06/13/2023, 5:07 PM
I tried uninstalling and installing again prefect. Will do it again then!
Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.