Ajmal Moideen09/18/2023, 2:43 PM
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: DELETE FROM flow_run_notification_queue WHERE flow_run_notification_queue.id IN (SELECT 1 FROM (SELECT 1) WHERE 1!=1) RETURNING id]
(Background on this error at: <https://sqlalche.me/e/20/e3q8>)
Marvin09/18/2023, 2:43 PM
from SQLAlchemy, indicating that the database is locked. This error typically arises when multiple threads or processes are trying to write to the database simultaneously. In the context of Prefect, this could potentially occur if multiple agents are polling for runs from the same work queue. You might want to check if this is the case. If so, consider adjusting your setup to avoid this scenario. If the issue persists, it might be a good idea to post a question on the Prefect Discourse or check existing threads that might be related to your problem. For instance, you might find the discussion on the locking mechanism used by agents to pick up and execute the flow from the work queue interesting (source). Remember, even the most advanced machines can't escape the occasional hiccup. It's a tough universe out there.