[influxdb] Re: Several doubts about AlertNodes and tickscript in kapacitor

2016-06-15 Thread nathaniel
Carlos, What you have looks good. You are correct that to get different behaviors you need to use two different alert nodes. Here is a example of what I think you want to do: var warn = lambda: "usage_idle" < 40 var crit = lambda: "usage_idle" < 20 var stats = stream |from()

Re: [influxdb] InfluxDBClientError: 400 in InfluxDB v0.13

2016-06-15 Thread Melissa Flores
data = client.query("SELECT * FROM bmspoint WHERE time > now() - 10m AND "name" = 'B10_Area3for2_E_MtrEl17_PwrActv'") Output: File "", line 1 data = client.query("SELECT * FROM bmspoint WHERE time > now() - 10m AND "name" = 'B10_Area3for2_E_MtrEl17_PwrActv'") ^ SyntaxError: invalid syntax On

[influxdb] Re: [1.0.0-beta1] Compaction frequency after 24 hours

2016-06-15 Thread Paul Dix
With 1M unique series you may need to move to SSDs. Can you test that out and let us know how it looks? > > -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe

[influxdb] Re: writing annotations to InfluxDB

2016-06-15 Thread Timothy Appnel
I was rushing and made a couple of mistake in my last message. I'm running v0.13.0 and this is the correct link to my test code: https://gist.github.com/tima/d709da1f88f7e29e0536311f4d9835c2 On Wednesday, June 15, 2016 at 5:08:09 PM UTC-4, Timothy Appnel wrote: > > What is the proper way to

[influxdb] kapacitor: error while evaluating WHERE expression: no field or tag exists for tcp_inerrs

2016-06-15 Thread Moti Levy
I can't seem to get Kapacitor to work with specific fields for some reason. Example tick : > > ID: global-net_tcp_inerrs > Error: > Type: stream > Status: enabled > Executing: true > Created: 15 Jun 16 21:22 UTC > Modified: 15 Jun 16 23:17 UTC > LastEnabled: 15 Jun 16 23:17 UTC > Databases

[influxdb] writing annotations to InfluxDB

2016-06-15 Thread Timothy Appnel
What is the proper way to write an annotation like that start of a new application deploy to InfluxDB? I'm trying to write a python script that writes one, but I'm having difficulties figuring out where I'm going wrong. The docs and sample code I've found isn't working out for me. I'm not

[influxdb] Re: How to query using "SHOW TAG VALUES WITH KEY" instead of SELECT ?

2016-06-15 Thread Quick Query
Please let me know if this is possible using InfluxDB ? Cheers! On Wednesday, June 15, 2016 at 10:27:30 AM UTC-7, Quick Query wrote: > > Hi Everyone, > > I can get the docker container ID list using the following query: > SELECT container_id from docker_container_net where host='' > >

[influxdb] How to query using "SHOW TAG VALUES WITH KEY" instead of SELECT ?

2016-06-15 Thread Quick Query
Hi Everyone, I can get the docker container ID list using the following query: SELECT container_id from docker_container_net where host='' timecontainer_id 2016-06-15T17:14:41Z "" But, can I do this using a "SHOW TAG VALUES WITH KEY ..." query instead? Appreciate any pointers/help. Cheers!

[influxdb] Several doubts about AlertNodes and tickscript in kapacitor

2016-06-15 Thread Carlos PeƱas
We are tiying to define an alert flow based on measurements taken by telegraf and stored in influx. Started with the basic: var stats = stream | from() .database('monitoring') .measurement('cpu') .where (lambda: "cpu" == 'cpu-total')

[influxdb] Re: Deadman problem - ignores new points

2016-06-15 Thread elad . talby
For reference - Here's the *DERIVATIVE* example I've configured, but still sending alerts for existing/new points: - stream |from() .measurement('delaware:last_completed') .where(lambda: "name" == 'exchange_hourly') |stats(1m) |derivative('emitted')

[influxdb] Deadman problem - ignores new points

2016-06-15 Thread elad . talby
Hello, We're trying to setup a *deadman* check for two measurements, but after long hours and QA to this function - I cannot get rid of the false-positives it sends. Could you please take a look at this TICK and let me know what am I doing wrong? Here's the TICK file: stream |from()

Re: [influxdb] Nanoseconds to Human readable Time Format

2016-06-15 Thread Ross McDonald
When you are in the `influx` CLI, you can switch the display to human-readable timestamps by issuing the command: ``` > precision rfc3339 ``` Or you can set it before logging into the instance by adding the parameter `-precision rfc3339` to the CLI option, for example: ``` influx -precision