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:

  1. Run query in Grafana (yields incorrect results, see below).
  2. Run same query on a local copy of the DB, or on the remote instance (where Grafana is running) using sqlite3 which gives correct result.

Screenshots Local: Screenshot 2022-03-10 at 22 25 47

Remote: Screenshot 2022-03-10 at 22 25 13

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)

Most upvoted comments

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.