codersaur / SmartThings

Samsung SmartThings SmartApps and Device Handlers
Apache License 2.0
300 stars 541 forks source link

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

Open Bboy486 opened 4 years ago

Bboy486 commented 4 years ago

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