vsergeyev / loudml-grafana-app

Visualization panel and datasource for Grafana to connect with Loud ML AI solution for ICT and IoT automation
https://vsergeyev.github.io/loudml-grafana-app/
MIT License
48 stars 20 forks source link

failed: invalid field measurement: does not match regular expression #11

Open Nitesh-vaidyanath opened 4 years ago

Nitesh-vaidyanath commented 4 years ago

I am getting this error not sure what exactly error is. Using grafana7.0 and added 7.x plugin.


api_stats_counts_consumer_mongo_count_value__time_10s | Tue Jul 7 04:51:10 2020 | training | failedinvalid field measurement: does not match regular expression
-- | -- | -- | --
Nitesh-vaidyanath commented 4 years ago

I am seeing this error when using measurement name which has dot in it.

vsergeyev commented 4 years ago

Hi @Nitesh-vaidyanath

Thank you for finding and reporting this bug. Addressing it.

V.

vsergeyev commented 4 years ago

@Nitesh-vaidyanath if it is possible - please add a screenshot/query use use in Grafana for this ML model. This will help me a lot in reproducing bug and making app better.

Thank you a lot, V.

Nitesh-vaidyanath commented 4 years ago

@Nitesh-vaidyanath if it is possible - please add a screenshot/query use use in Grafana for this ML model. This will help me a lot in reproducing bug and making app better.

Thank you a lot, V.

@vsergeyev Thanks for looking into this. Bucket config

 - name: apiDOT
   type: influxdb
   addr: 10.3.0.182:8086
   database: api
   retention_policy: autogen
   verify_ssl: false
   use_ssl: true
   dbuser: root
   dbuser_password: x
   measurement: stats.counts.consumer.mongo

query

SELECT count("value") FROM "stats.counts.consumer.mongo" WHERE $timeFilter GROUP BY time(10s) fill(null)

Screenshot 2020-07-09 at 5 03 26 PM

vsergeyev commented 4 years ago

Thank you @Nitesh-vaidyanath for a details! It is in progress.

As a fast workaround you may try to use 0/previous in GROUP BY fill() expression. This should help.

Checked with LoudML schema - measurement with dots is good to go, so actual issue in my panel. It use bad converter for fill() values.

V.

Nitesh-vaidyanath commented 4 years ago

Thank you @Nitesh-vaidyanath for a details! It is in progress.

As a fast workaround you may try to use 0/previous in GROUP BY fill() expression. This should help.

Checked with LoudML schema - measurement with dots is good to go, so actual issue in my panel. It use bad converter for fill() values.

V.

@vsergeyev Thanks for quick response. I tried replacing with 0 but still it is failing with below errors, i don't see this error when there is no dot in measurement name.

10.3.0.172 - - [2020-07-10 12:02:12] "POST /models/api_stats_timers_consumer_mongo_count_value__time_10s/_train?from=now-6h&to=now&output_bucket=loudml&save_output_data=true&flag_abnormal_data=true HTTP/1.1" 202 153 0.002085
INFO:root:job[bbbf9768-3eae-43c1-a424-530e836d215f] starting, nice=5
ERROR:root:job[bbbf9768-3eae-43c1-a424-530e836d215f] failed: invalid field measurement: does not match regular expression
Nitesh-vaidyanath commented 4 years ago

@vsergeyev Seems like issue with docker image https://hub.docker.com/r/loudml/loudml.

https://github.com/regel/loudml/issues/169

Nitesh-vaidyanath commented 4 years ago

@vsergeyev I installed debian package and tried but i am getting 405 error now.

Api. response

{
  "host_id": "9f5e51b32d3080ad750c7286ad1e1e35",
  "tagline": "The Disruptive Machine Learning API",
  "version": "1.5.0"
}

Loudml config

datasources:
 - name: loudml
   type: influxdb
   addr: 10.3.0.172:8086
   database: loudml
   retention_policy: autogen
   measurement: loudml
   annotation_db: loudmlannotations

 - name: apiDOT
   type: influxdb
   addr: 10.3.0.182:8086
   database: api
   retention_policy: autogen
   verify_ssl: false
   use_ssl: true
   dbuser: root
   dbuser_password: x
   measurement: stats.counts.consumer.mongo
Screenshot 2020-07-12 at 6 18 46 PM