SmartThings icon indicating copy to clipboard operation
SmartThings copied to clipboard

InfluxDB Error: unsupported mean iterator type: *query.stringInterruptIterator + Refresh issue

Open Bboy486 opened this issue 3 years ago • 0 comments

I followed the directions here - http://codersaur.com/2016/04/smartthings-data-visualisation-using-influxdb-and-grafana/

All good except for two issues

  1. When I add a device I have to switch between attributes (temperature and contact for example) for grafana to pull in any data.

  2. I am getting an error on a lot of devices - InfluxDB Error: unsupported mean iterator type: *query.stringInterruptIterator

Object message:"InfluxDB Error: unsupported mean iterator type: *query.stringInterruptIterator" data:Object results:Array[1] executedQueryString:"SELECT mean("value") FROM "thermostatOperatingState" WHERE ("deviceName" = 'Ecobee - Thermostat') AND time >= now() - 15m GROUP BY time(1s) fill(null)"

https://prnt.sc/u83qwv

request:Object method:"GET" url:"api/datasources/proxy/5/query" params:Object db:"SmartThings" q:"SELECT mean("value") FROM "thermostatOperatingState" WHERE ("deviceName" = 'Ecobee - Thermostat') AND time >= now() - 15m GROUP BY time(2s) fill(null)" epoch:"ms" data:null precision:"ms" response:Object results:Array[1] 0:Object

Bboy486 avatar Aug 29 '20 18:08 Bboy486