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.
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.