NR+influxdb+grafana

[Colin]

Is the field you are trying to chart called field1 or value, and does it exist in the temp measurement? If you use the influx command line, USE the database HUMIDITY and then select * from temp you will see what data you have for each field.

Are you getting an error now or just no data?

[Martin10]

From influx command line i've got this:

Yes, i still got this error:

InfluxDB Error: not executed

[Colin]

Can you show the influx command line output, including the full command sequence to get there please. I want to see the database selection and the headings. If you use select * from temp order by time desc limit 5 then it will output just the most recent samples.
Also in grafana click on the Query Inspector button at the right above the query definition and click Copy to Clipboard and then paste the result here. Use the </> button when pasting it in. Click Query Inspector again to make it go away.

[Martin10]

{
  "request": {
    "method": "GET",
    "url": "api/datasources/proxy/1/query",
    "params": {
      "db": "HUMIDITY",
      "q": "SELECT mean(\"value\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null);SELECT mean(\"value\") FROM \"measurement\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)",
      "epoch": "ms"
    },
    "data": null,
    "precision": "ms"
  },
  "response": {
    "results": [
      {
        "statement_id": 0,
        "error": "not executed"
      }
    ],
    "executedQueryString": "SELECT mean(\"value\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null);SELECT mean(\"value\") FROM \"measurement\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)"
  }
}

[Colin]

Look carefully at the queries shown in the query inspector. What do you see that is unexpected? Check the full text of the query.

[Martin10]

I can't understand what is going on

[Colin]

You have not answered the question. There appear to be two queries in the query inspector, one fetching the field value from the measurement temp and a second one fetching the field value from the measurement named measurement. However there is no such measurement in the database. It suggests to me that you have defined two queries for that chart, but have only been showing us the first one.

[Martin10]

Yes, they was second queries, but i was forget about it (sorry).I delete it, but the problem remains (but a little different).

This is the new query inspector:

{
  "request": {
    "method": "GET",
    "url": "api/datasources/proxy/1/query",
    "params": {
      "db": "HUMIDITY",
      "q": "SELECT mean(\"value\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)",
      "epoch": "ms"
    },
    "data": null,
    "precision": "ms"
  },
  "response": {
    "results": [
      {
        "statement_id": 0,
        "error": "unsupported mean iterator type: *query.stringInterruptIterator"
      }
    ],
    "executedQueryString": "SELECT mean(\"value\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)"
  }
}

[Colin]

Have you written strings to the value field instead of numbers? If you want to chart them then they must be numbers.

[Martin10]

Like This?

[Colin]

No, where you write to the database (in node red presumably). I suspect that you have written strings instead of numbers.

[Martin10]

Actually it did do the trick, now i don't have errors, but still can't collect data.

[Colin]

Make sure you zoom out in case the data is outside the time range.

[Martin10]

I try, but It says no data

[Colin]

What does the data in the dB look like now?

[Martin10]

1598460336473640187        27.00
1598460340183409036        28.00
1598461598993604339        28.00
> 

[Colin]

And the dashboard showing no data?
Also the query inspector output

[Edit] Also please show the commands you used to show the data, as you did before.

[Martin10]

I don't have data anywhere.

Which commands for data you want, from Influxdb or Grafana? From Influxdb are the same.

[Colin]

Show me the query inspector output, a screenshot of the chart showing no data and the terminal commands running influx, USEing the database and SELECTING the data to show what is in the database please.

[Martin10]

Query inspector

{
  "request": {
    "method": "GET",
    "url": "api/datasources/proxy/1/query",
    "params": {
      "db": "HUMIDITY",
      "q": "SELECT mean(\"numbers\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)",
      "epoch": "ms"
    },
    "data": null,
    "precision": "ms"
  },
  "response": {
    "results": [
      {
        "statement_id": 0
      }
    ],
    "executedQueryString": "SELECT mean(\"numbers\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)"
  }
}

Grafana Chart

InfluxDB command