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

This topic was automatically closed after 365 days. New replies are no longer allowed.