Grafana SQLite database locked

[schachre1998]

I have hosted grafana on AWS ECS service. and by default it is using sqlite database. When I am doing queries on dashboards, I am facing database lock issue. and then grafana stops working. it gives 502 bad gateway error.

[usman.ahmad]

Hi @schachre1998,

Please check this GitHub issue which shows a possible workaround. Also, SQLite has some limitations (see Notes section) and therefore is not recommended for use in a production environment.

I hope this helps.

[usman.ahmad]

Related to the similar post:

Database is locked

Hi. Every morning at 6 am I get a warning notification due to “no value”. The reason for the error appears as follows. It fixes in a few minutes, but it causes me to receive dozens of notifications. How can I solve this problem? Version: Grafana v9.5.1 (bc353e4b2d) Error: failed to build query ‘A’: [sqlstore.max-retries-reached] retry 1: database is locked