<@ULVA73B9P> I get hte following error a lot. sql...
# ask-marvin
n
@Marvin I get hte following error a lot. 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)]
m
It appears you're encountering
sqlite3.OperationalError: database is locked
errors, which can occur for several reasons, such as concurrent writes to a SQLite database, which isn't intended for high concurrency workloads. To address the problem, you could consider some solutions like: 1. Ensuring you are not exceeding SQLite's limitations regarding concurrency. 2. Exploring alternative databases like PostgreSQL if you require high concurrency. 3. Investigating your application's database connection management to prevent long-lived transactions. I found some relevant GitHub issues that you might find useful: 1. An issue where Prefect server deployed with SQLite logs errors related to a locked database. (#10188) 2. A report where the use of the map function causes a database lock, but everything seems to work correctly. (#10956) 3. A user experiencing a
QueuePool
issue with 1500+ task flows. (#6492) Checking these discussions may provide more insights or potential workarounds suitable for your use case.