Continuous query does not produce values

Telegraf
1

Hi,

can anybody here help me or give me an advice why my continous query isnt producing any values?

This is what the query looks like:

cq_strom_tagesverbrauch
CREATE CONTINUOUS QUERY cq_strom_tagesverbrauch
ON vzlogger RESAMPLE EVERY 1h
BEGIN SELECT difference(max(value)) / 1000 INTO vzlogger."1Jahr".strom_tagesverbrauch
FROM vzlogger."1Jahr".vz_measurement
WHERE (source = 'sml' AND type = 'Strom' AND uuid = '9edde7d0-49c5-11e6-9303-6dc38e68c2e8' AND time >= now() - 1d)
GROUP BY time(1d) END

It should run every hour an write a actual value for power consumption.

But nothing works at all. If I a enter the query by hand everything works fine (here is some example output):

> SELECT difference(max(value)) / 1000 INTO vzlogger."1Jahr".strom_tagesverbrauch FROM vzlogger."1Jahr".vz_measurement WHERE (source = 'sml' AND type = 'Strom' AND uuid = '9edde7d0-49c5-11e6-9303-6dc38e68c2e8' AND time >= now() - 5d) GROUP BY time(1d)
name: result
time    written
----    -------
0       4

>

I am using influx db 1.6.0.

regards

Sascha

2

I could solve my issue with updating to Influxdb 1.7.3
The query seems to work now!

1 Like