grafana-sqlite-datasource: Cached Query Results - SQLite database not updating in Grafana
Describe the bug Queries executed via Grafana with a SQLite data source appear cached / incorrect.
To Reproduce Steps to reproduce the behavior:
- Run query in Grafana (yields incorrect results, see below).
- Run same query on a local copy of the DB, or on the remote instance (where Grafana is running) using
sqlite3which gives correct result.
Screenshots
Local:

Remote:

Versions (please complete the following information):
- OS: Ubuntu
- Run via docker? No
- Browser: Safari
- Grafana Version: v8.4.3 (b7d2911cac)
- Plugin Version 3.0.0
- Plugin installed via grafana-cli or manually? grafana-cli
Additional context
grafana.ini updated to allow reading of database from within the home folder. Additionally, permissions set via chmod -R a+rwX ./sqlite.db. 100% sure running the same DB locally and remotely as SHA1 hash identical.
Really appreciate your help, thanks!
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 20 (8 by maintainers)
I would also be interested to know if this problems occurs for others users as well. This might help to isolate the issue to something plugin or setup related.