"No data in response" error with SQLite

  • What Grafana version and what operating system are you using?
    Grafana version 8.1.5
    SQLite plugin version 2.1.0 (frser-sqlite-datasource)
    MacOS Big Sur 11.5.1

  • What are you trying to achieve?
    Creating a simple line chart by fetching time and value from a SQLite DB

  • How are you trying to achieve it?
    I created a new panel and use this query to fetch data

WITH converted AS (
SELECT future_oi_abs, date || ‘T00:00:00Z’ AS datetime FROM fao_mkt_summary where symbol = “$symbol”
)
SELECT datetime, future_oi_abs FROM converted ORDER BY datetime ASC

The DB exists and Grafana connects to it fine. The variable $symbol that currently has value ACC has been extracted from the very same DB.

Can someone please point me to what am I missing? Why would query run fine directly on DB but fail via Grafana.

This weird issue got fixed automatically by restarting Grafana server.