Grafana does not return any data by mysql query

Grafana
1

I’am using Grafana 8.0.3 (docker-image)
I want to read selective data from a large table (3.6 GB).
The table has following structure:
Versuch-ID int(11)
timestamp timestamp
Lebensbit_Sp_PLS bit(1)
EI257039 float
EI257040 float
… (45 float rows follows)

The following query does not return any data:

SELECT
  timestamp AS "time",
  `TI308062-T2.1`
FROM DataManagement__20200430_223015
WHERE
  timestamp BETWEEN FROM_UNIXTIME(1631507478) AND FROM_UNIXTIME(1631529078) AND
  `Versuch-ID` = 98
ORDER BY timestamp

The same statement with MySQL Workbench delivers the following return values:
time TI308062-T2.1
2021-09-13 06:31:18 48.0612
2021-09-13 06:31:19 48.0612
2021-09-13 06:31:20 48.0612
2021-09-13 06:31:21 48.0612
…

No errors receive in the Grafana UI or in related logs

*Did you follow any online instructions? If so, what is the URL?
Yes, as best I could.

2

Hi @dummyuser

So, two initial questions: what visualization are you using? Can you try the table panel?

If you click the dropdown for the panel, and then choose the inspect drawer, you can inspect the raw query and response. What do you see there?

Lastly, when you added the MySQL datasource, did it save and configure successfully?

3

Hello @mattabrams
Thanks for the fast respond

  1. visualisation: Docker Image on QNAP-NAS
  2. Yes, I’ve tryed with inspect drawer
  3. The configuration was successfully

The data was in the table view but was not displayed on the plot because the timestamp read is in the future (+ 2h CEST).
I think my problem is the same like described in #15777.
Dealing with the timestamp from MySQL (MariaDB) is probably not easy.

4

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