[influxdb] [Influxdb] post processing analysis

[Michael Huang]

Hello everyone,

I've just been getting into learning about Influxdb and a bit of Kapacitor 
so I'm still rather green to some of the concepts but I had some questions 
pertaining a post processing analysis context.

The use case I'm working with is I have some sets of test results that have 
been ingested into Influx and want to do a comparison of those results 
against each other at certain time ranges (startTime A, endTime B in test1 
vs startTimeC/endTime B in test 2 for some attribute). If some threshold 
has been exceed for some comparison I'd like for something to happen 
(perhaps trigger an alert). However Influxdb itself doesn't seem to have 
some of the necessary functions I'd need such as traditional joins (or at 
the least I'd imagine I need). Which led me to Kapacitor which has 
alerting, joins and other pieces of interest. However it seems like on a 
preliminary looking at, Kapacitor might not be the tool I'd want to use. 
I'm not really looking to process the data as a stream of points currently 
(which is what both stream and batch nodes look to do to my understanding 
albeit slightly differently); I'm looking more towards just being able to 
compare the two sets of data as a whole (time ranges) against each other. 

Is there perhaps a more recommended work flow, set of tools or simply 
better use of Kapacitor/Influx that would allow for this kind of use case?

Michael

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/928f330a-bd38-4679-9575-cd8040136f2d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [CAS Spam] Re: [influxdb] telegraf on Windows - [[inputs.exe]]

[Sanford Whiteman]

>  The  script  only contains "echo mytest value=1". As with Linux, It
>  is  strictly  impossible  it  can  emit  anything else than "mytest
>  value=1".

Actually, when you run a batch file it emits the content of the script
as well as the echoed content.

Use @echo instead of echo and you suppress the "self-echo" behavior.

-- Sandy

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/875068110.20170215221833%40figureone.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] telegraf on Windows - [[inputs.exe]]

[digivaluefr]

> I am doing the same thing . so you need to define it in line protocol, 
> e.g 
> test1,tag1=value1 value=1
>

The script provided in the original question clearly emit data in line 
protocol: "mytest value=1"
I suspect we overlooked a detail, because a so simple thing shouldn't break.

Can you please copy/paste your [[inputs.exec]] and related script?

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/b3d4efe6-1365-4396-8084-682d7bb3f706%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] telegraf on Windows - [[inputs.exe]]

[digivaluefr]

> It looks like the entire line emitted is:
>
> C:\Windows\system32>echo mytest value=1 
>

The script only contains "echo mytest value=1".
As with Linux, It is strictly impossible it can emit anything else than 
"mytest value=1".

The line "C:\Windows\system32>echo mytest value=1" is the command prompt + 
the script's content.
Maybe telegraf execute scripts in an unexpected way?

A working example for Windows could be of great value  :-)

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/2a82d89b-8553-42b9-ba3e-eb596e834b81%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] telegraf on Windows - [[inputs.exe]]

[Rishma Gupta]

I am doing the same thing . so you need to define it in line protocol,
e.g
test1,tag1=value1 value=1

On Wed, Feb 15, 2017 at 4:39 PM, Mark Rushakoff  wrote:

> It looks like the entire line emitted is:
>
> C:\Windows\system32>echo mytest value=1
>
> That isn't valid line protocol, so that's why you're seeing the parse
> error. You want it to be only
>
> mytest value=1
>
> But I don't know enough about Windows to say what you can change to omit
> the path piece.
>
> On Wed, Feb 15, 2017 at 4:07 PM,  wrote:
>
>> Hi,
>>
>> We try to use a custom made script for telegraf on a Windows 10 host.
>>
>> The executable is C:\Program Files\telegraf\telegraf.exe
>>
>>
>>
>> The configuration file is C:\Program Files\telegraf\telegraf.conf
>>
>> (...begining of file not displayed...)
>>
>> [[inputs.exec]]
>> commands = ["C:/test.bat"]
>> timeout = "5s"
>> name_suffix = "_mycollector"
>> data_format = "influx"
>> We just removed every other [[inputs.xxx]], and specified the server
>> address and database name.
>>
>>
>> C:\test.bat
>> echo  mytest   value=1
>>
>>
>> But this only lead to an error in C:\Program Files\telegraf\telegraf.log
>> 2017-02-15T23:49:40Z E! ERROR in input [inputs.exec]: Errors encountered:
>> [ metric parsing error, reason: [invalid field format], buffer: [C:\
>> Windows\system32>echo mytest value=1 ], index: [29]]
>>
>>
>> A very similar setup works fine on Linux.
>> What do we do wrongly?
>>
>>
>>
>> --
>> Remember to include the version number!
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "InfluxData" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to influxdb+unsubscr...@googlegroups.com.
>> To post to this group, send email to influxdb@googlegroups.com.
>> Visit this group at https://groups.google.com/group/influxdb.
>> To view this discussion on the web visit https://groups.google.com/d/ms
>> gid/influxdb/ec431971-5dbf-4078-b7d9-3c358ea5ff5c%40googlegroups.com
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/CALxJwdPiLu6Hwury1pjJy5g7kK4tvfNPvwu7BTrfZ3v%2B18Z50w%
> 40mail.gmail.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CA%2BB14t2H8d2Ze63GogtsDx_A2Wmks3HxcQJMmfAjKo44huYsDQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] telegraf on Windows - [[inputs.exe]]

[Mark Rushakoff]

It looks like the entire line emitted is:

C:\Windows\system32>echo mytest value=1

That isn't valid line protocol, so that's why you're seeing the parse
error. You want it to be only

mytest value=1

But I don't know enough about Windows to say what you can change to omit
the path piece.

On Wed, Feb 15, 2017 at 4:07 PM,  wrote:

> Hi,
>
> We try to use a custom made script for telegraf on a Windows 10 host.
>
> The executable is C:\Program Files\telegraf\telegraf.exe
>
>
>
> The configuration file is C:\Program Files\telegraf\telegraf.conf
>
> (...begining of file not displayed...)
>
> [[inputs.exec]]
> commands = ["C:/test.bat"]
> timeout = "5s"
> name_suffix = "_mycollector"
> data_format = "influx"
> We just removed every other [[inputs.xxx]], and specified the server
> address and database name.
>
>
> C:\test.bat
> echo  mytest   value=1
>
>
> But this only lead to an error in C:\Program Files\telegraf\telegraf.log
> 2017-02-15T23:49:40Z E! ERROR in input [inputs.exec]: Errors encountered:
> [ metric parsing error, reason: [invalid field format], buffer: [C:\
> Windows\system32>echo mytest value=1 ], index: [29]]
>
>
> A very similar setup works fine on Linux.
> What do we do wrongly?
>
>
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/ec431971-5dbf-4078-b7d9-3c358ea5ff5c%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CALxJwdPiLu6Hwury1pjJy5g7kK4tvfNPvwu7BTrfZ3v%2B18Z50w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] telegraf on Windows - [[inputs.exe]]

[digivaluefr]

Hi,

We try to use a custom made script for telegraf on a Windows 10 host.

The executable is C:\Program Files\telegraf\telegraf.exe



The configuration file is C:\Program Files\telegraf\telegraf.conf

(...begining of file not displayed...)

[[inputs.exec]]
commands = ["C:/test.bat"]
timeout = "5s"
name_suffix = "_mycollector"
data_format = "influx"
We just removed every other [[inputs.xxx]], and specified the server 
address and database name.


C:\test.bat
echo  mytest   value=1


But this only lead to an error in C:\Program Files\telegraf\telegraf.log
2017-02-15T23:49:40Z E! ERROR in input [inputs.exec]: Errors encountered: [ 
metric parsing error, reason: [invalid field format], buffer: [C:\Windows\
system32>echo mytest value=1 ], index: [29]]


A very similar setup works fine on Linux.
What do we do wrongly?



-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/ec431971-5dbf-4078-b7d9-3c358ea5ff5c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] InfluxDB keeps on logging for httpd

[arnout . verbeken]

Hello,

My /var/log/syslog gets spammed with http POST messages. I have disabled all 
possible logging settings in /etc/influxdb/influxdb.conf but they just keep on 
coming.

Anybody knows how to disable this kind of logging?

Here is what is getting logged:

Feb 15 22:04:11 Condor1 influxd[736]: [httpd] ::1 - root [15/Feb/2017:22:04:11 
+0100] "POST /write?db=home_assistant HTTP/1.1" 204 0 "-" 
"python-requests/2.13.0" 4c9a6dcd-f3c2-11e6-8904- 319301
Feb 15 22:04:12 Condor1 influxd[736]: [httpd] ::1 - root [15/Feb/2017:22:04:11 
+0100] "POST /write?db=home_assistant HTTP/1.1" 204 0 "-" 
"python-requests/2.13.0" 4cbb6ce8-f3c2-11e6-8905- 341562
Feb 15 22:04:12 Condor1 influxd[736]: [httpd] ::1 - root [15/Feb/2017:22:04:11 
+0100] "POST /write?db=home_assistant HTTP/1.1" 204 0 "-" 
"python-requests/2.13.0" 4cbb8739-f3c2-11e6-8906- 364649
Feb 15 22:04:12 Condor1 influxd[736]: [httpd] ::1 - root [15/Feb/2017:22:04:11 
+0100] "POST /write?db=home_assistant HTTP/1.1" 204 0 "-" 
"python-requests/2.13.0" 4cbd5d2d-f3c2-11e6-8907- 376806
Feb 15 22:04:12 Condor1 influxd[736]: [httpd] ::1 - root [15/Feb/2017:22:04:11 
+0100] "POST /write?db=home_assistant HTTP/1.1" 204 0 "-" 
"python-requests/2.13.0" 4cbec95a-f3c2-11e6-8908- 413035
Feb 15 22:04:23 Condor1 influxd[736]: [httpd] ::1 - root [15/Feb/2017:22:04:23 
+0100] "POST /write?db=home_assistant HTTP/1.1" 204 0 "-" 
"python-requests/2.13.0" 53c1d896-f3c2-11e6-8909- 19403
Feb 15 22:04:24 Condor1 influxd[736]: [httpd] ::1 - root [15/Feb/2017:22:04:24 
+0100] "POST /write?db=home_assistant HTTP/1.1" 204 0 "-" 
"python-requests/2.13.0" 54125939-f3c2-11e6-890a- 24924
Feb 15 22:04:29 Condor1 influxd[736]: [httpd] ::1 - root [15/Feb/2017:22:04:29 
+0100] "POST /write?db=home_assistant HTTP/1.1" 204 0 "-" 
"python-requests/2.13.0" 574e2c68-f3c2-11e6-890b- 37141
Feb 15 22:04:30 Condor1 influxd[736]: [httpd] ::1 - root [15/Feb/2017:22:04:30 
+0100] "POST /write?db=home_assistant HTTP/1.1" 204 0 "-" 
"python-requests/2.13.0" 57f2d6ae-f3c2-11e6-890c- 28901


Thanks in advance

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/d605b307-43cc-4d8d-8bb8-bcdb914e623b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] Re: InfluxDB Raspberry Pi installation?

[Ross McDonald]

You can find the v1.2.0 Debian package compatible with ARM-based
distributions here:

https://dl.influxdata.com/influxdb/releases/influxdb_1.2.0_armhf.deb

On Wed, Feb 15, 2017 at 2:45 PM,  wrote:

>
> I want to install version 1.2. How can i do it?
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/0aa56979-6d6e-4956-997c-56ed3c35208f%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CAD8sRLAKxbuzu9yEc-85nmJyRJWjq6NNWD6RvrmQjJ3pRY0_VA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: InfluxDB Raspberry Pi installation?

[michaeljuergens1985]

I want to install version 1.2. How can i do it?

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/0aa56979-6d6e-4956-997c-56ed3c35208f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] difference() output is not in order (v1.2)

[ahmet . kizilay]

Sure, Issue link: https://github.com/influxdata/influxdb/issues/8009

On Wednesday, February 15, 2017 at 12:42:43 PM UTC-5, Mark Rushakoff wrote:
> That looks like a bug to me. Do you think you would be able to write a short 
> script to reproduce the problem and open an issue on Github? I'm guessing the 
> problem here has something to do with the difference function when querying 
> data across multiple shards. Thanks.
> 
> 
> On Wed, Feb 15, 2017 at 8:57 AM,   wrote:
> I have an increasing time-series data and I would like to get the difference 
> between two consecutive measurements. I am using the difference() function, 
> but I get erroneous negative output and irregular time order in the output.
> 
> 
> 
> Check the following two queries:
> 
> 
> 
> > SELECT "view_count" FROM daily_graph_stats WHERE time >= '2016-09-01'
> 
> name: daily_graph_stats
> 
> time                 view_count
> 
>                  --
> 
> 2016-09-01T04:00:00Z 462
> 
> 2016-09-02T04:00:00Z 464
> 
> 2016-09-03T04:00:00Z 464
> 
> 2016-09-04T04:00:00Z 466
> 
> 2016-09-05T04:00:00Z 467
> 
> 2016-09-06T04:00:00Z 468
> 
> 2016-09-07T04:00:00Z 468
> 
> 2016-09-08T04:00:00Z 468
> 
> 2016-09-09T04:00:00Z 470
> 
> 2016-09-10T04:00:00Z 472
> 
> 2016-09-11T04:00:00Z 474
> 
> 2016-09-12T04:00:00Z 474
> 
> 2016-09-13T04:00:00Z 475
> 
> 2016-09-14T04:00:00Z 480
> 
> 2016-09-15T04:00:00Z 483
> 
> 2016-09-16T04:00:00Z 485
> 
> 2016-09-19T04:00:00Z 491
> 
> 2016-09-20T04:00:00Z 493
> 
> 2016-09-21T04:00:00Z 496
> 
> 2016-09-22T04:00:00Z 498
> 
> 2016-09-23T04:00:00Z 498
> 
> 
> 
> 
> 
> > SELECT difference("view_count") FROM daily_graph_stats WHERE time >= 
> > '2016-09-01'
> 
> name: daily_graph_stats
> 
> time                 difference
> 
>                  --
> 
> 2016-09-02T04:00:00Z 2
> 
> 2016-09-03T04:00:00Z 0
> 
> 2016-09-04T04:00:00Z 2
> 
> 2017-02-06T05:00:00Z 918
> 
> 2017-02-07T05:00:00Z 22
> 
> 2017-02-08T05:00:00Z 15
> 
> 2017-02-09T05:00:00Z 38
> 
> 2017-02-10T05:00:00Z 13
> 
> 2017-02-11T05:00:00Z 8
> 
> 2017-01-30T05:00:00Z -225
> 
> 2017-01-31T05:00:00Z 22
> 
> 2017-02-01T05:00:00Z 26
> 
> 2017-02-02T05:00:00Z 27
> 
> 2017-02-03T05:00:00Z 35
> 
> 2017-02-04T05:00:00Z 8
> 
> 2017-02-05T05:00:00Z 7
> 
> 2017-01-23T05:00:00Z -214
> 
> 2017-01-24T05:00:00Z 15
> 
> 2017-01-25T05:00:00Z 15
> 
> 2017-01-26T05:00:00Z 10
> 
> 2017-01-27T05:00:00Z 10
> 
> 2017-01-28T05:00:00Z 15
> 
> 2017-01-29T05:00:00Z 7
> 
> 2017-01-16T05:00:00Z -195
> 
> 2017-01-17T05:00:00Z 4
> 
> 2017-01-18T05:00:00Z 30
> 
> 2017-01-19T05:00:00Z 31
> 
> 
> 
> 
> 
> The first query returns as expected, but the second (difference) query output 
> is not what I expect to see.
> 
> 
> 
> Is there something I am missing? Your help is appreciated.
> 
> 
> 
> Ubuntu 14.04 InfluxDB v1.2
> 
> 
> 
> Regards,
> 
> Ahmet Kizilay
> 
> 
> 
> --
> 
> Remember to include the version number!
> 
> ---
> 
> You received this message because you are subscribed to the Google Groups 
> "InfluxData" group.
> 
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to influxdb+u...@googlegroups.com.
> 
> To post to this group, send email to infl...@googlegroups.com.
> 
> Visit this group at https://groups.google.com/group/influxdb.
> 
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/influxdb/0fffedf4-0687-4862-84a9-3a88260ea8de%40googlegroups.com.
> 
> For more options, visit https://groups.google.com/d/optout.

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/c9dedacb-9fd6-4af9-b73c-b249567ad792%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] difference() output is not in order (v1.2)

[Mark Rushakoff]

That looks like a bug to me. Do you think you would be able to write a
short script to reproduce the problem and open an issue on Github? I'm
guessing the problem here has something to do with the difference function
when querying data across multiple shards. Thanks.

On Wed, Feb 15, 2017 at 8:57 AM,  wrote:

> I have an increasing time-series data and I would like to get the
> difference between two consecutive measurements. I am using the
> difference() function, but I get erroneous negative output and irregular
> time order in the output.
>
> Check the following two queries:
>
> > SELECT "view_count" FROM daily_graph_stats WHERE time >= '2016-09-01'
> name: daily_graph_stats
> time view_count
>  --
> 2016-09-01T04:00:00Z 462
> 2016-09-02T04:00:00Z 464
> 2016-09-03T04:00:00Z 464
> 2016-09-04T04:00:00Z 466
> 2016-09-05T04:00:00Z 467
> 2016-09-06T04:00:00Z 468
> 2016-09-07T04:00:00Z 468
> 2016-09-08T04:00:00Z 468
> 2016-09-09T04:00:00Z 470
> 2016-09-10T04:00:00Z 472
> 2016-09-11T04:00:00Z 474
> 2016-09-12T04:00:00Z 474
> 2016-09-13T04:00:00Z 475
> 2016-09-14T04:00:00Z 480
> 2016-09-15T04:00:00Z 483
> 2016-09-16T04:00:00Z 485
> 2016-09-19T04:00:00Z 491
> 2016-09-20T04:00:00Z 493
> 2016-09-21T04:00:00Z 496
> 2016-09-22T04:00:00Z 498
> 2016-09-23T04:00:00Z 498
>
>
> > SELECT difference("view_count") FROM daily_graph_stats WHERE time >=
> '2016-09-01'
> name: daily_graph_stats
> time difference
>  --
> 2016-09-02T04:00:00Z 2
> 2016-09-03T04:00:00Z 0
> 2016-09-04T04:00:00Z 2
> 2017-02-06T05:00:00Z 918
> 2017-02-07T05:00:00Z 22
> 2017-02-08T05:00:00Z 15
> 2017-02-09T05:00:00Z 38
> 2017-02-10T05:00:00Z 13
> 2017-02-11T05:00:00Z 8
> 2017-01-30T05:00:00Z -225
> 2017-01-31T05:00:00Z 22
> 2017-02-01T05:00:00Z 26
> 2017-02-02T05:00:00Z 27
> 2017-02-03T05:00:00Z 35
> 2017-02-04T05:00:00Z 8
> 2017-02-05T05:00:00Z 7
> 2017-01-23T05:00:00Z -214
> 2017-01-24T05:00:00Z 15
> 2017-01-25T05:00:00Z 15
> 2017-01-26T05:00:00Z 10
> 2017-01-27T05:00:00Z 10
> 2017-01-28T05:00:00Z 15
> 2017-01-29T05:00:00Z 7
> 2017-01-16T05:00:00Z -195
> 2017-01-17T05:00:00Z 4
> 2017-01-18T05:00:00Z 30
> 2017-01-19T05:00:00Z 31
>
>
> The first query returns as expected, but the second (difference) query
> output is not what I expect to see.
>
> Is there something I am missing? Your help is appreciated.
>
> Ubuntu 14.04 InfluxDB v1.2
>
> Regards,
> Ahmet Kizilay
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/0fffedf4-0687-4862-84a9-3a88260ea8de%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CALxJwdP3xoN50K1BbGnp7DxT%3D2gT1givRRx%3D1c8_OcBD-FKTRw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] difference() output is not in order (v1.2)

[ahmet . kizilay]

I have an increasing time-series data and I would like to get the difference 
between two consecutive measurements. I am using the difference() function, but 
I get erroneous negative output and irregular time order in the output.

Check the following two queries:

> SELECT "view_count" FROM daily_graph_stats WHERE time >= '2016-09-01'
name: daily_graph_stats
time view_count
 --
2016-09-01T04:00:00Z 462
2016-09-02T04:00:00Z 464
2016-09-03T04:00:00Z 464
2016-09-04T04:00:00Z 466
2016-09-05T04:00:00Z 467
2016-09-06T04:00:00Z 468
2016-09-07T04:00:00Z 468
2016-09-08T04:00:00Z 468
2016-09-09T04:00:00Z 470
2016-09-10T04:00:00Z 472
2016-09-11T04:00:00Z 474
2016-09-12T04:00:00Z 474
2016-09-13T04:00:00Z 475
2016-09-14T04:00:00Z 480
2016-09-15T04:00:00Z 483
2016-09-16T04:00:00Z 485
2016-09-19T04:00:00Z 491
2016-09-20T04:00:00Z 493
2016-09-21T04:00:00Z 496
2016-09-22T04:00:00Z 498
2016-09-23T04:00:00Z 498


> SELECT difference("view_count") FROM daily_graph_stats WHERE time >= 
> '2016-09-01'
name: daily_graph_stats
time difference
 --
2016-09-02T04:00:00Z 2
2016-09-03T04:00:00Z 0
2016-09-04T04:00:00Z 2
2017-02-06T05:00:00Z 918
2017-02-07T05:00:00Z 22
2017-02-08T05:00:00Z 15
2017-02-09T05:00:00Z 38
2017-02-10T05:00:00Z 13
2017-02-11T05:00:00Z 8
2017-01-30T05:00:00Z -225
2017-01-31T05:00:00Z 22
2017-02-01T05:00:00Z 26
2017-02-02T05:00:00Z 27
2017-02-03T05:00:00Z 35
2017-02-04T05:00:00Z 8
2017-02-05T05:00:00Z 7
2017-01-23T05:00:00Z -214
2017-01-24T05:00:00Z 15
2017-01-25T05:00:00Z 15
2017-01-26T05:00:00Z 10
2017-01-27T05:00:00Z 10
2017-01-28T05:00:00Z 15
2017-01-29T05:00:00Z 7
2017-01-16T05:00:00Z -195
2017-01-17T05:00:00Z 4
2017-01-18T05:00:00Z 30
2017-01-19T05:00:00Z 31


The first query returns as expected, but the second (difference) query output 
is not what I expect to see.

Is there something I am missing? Your help is appreciated.

Ubuntu 14.04 InfluxDB v1.2

Regards,
Ahmet Kizilay

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/0fffedf4-0687-4862-84a9-3a88260ea8de%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: How are multiple instances of the same processs handled

[Willem D'Haese]

Thanks a lot for this. This issue has been open long enough imho. Not being 
able to monitor processes which have the 'same name' is really a problem.


I'll have to wait untill the PR is accepted and in a Telegraf release 
before I can test though.

Grtz

Willem

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/9ddd02d1-5b80-4d47-8d0e-581b27fd1fbc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] how to solution multi agent from multi datasource

[Mark Rushakoff]

One option would be to use the statsd plugin for telegraf [1] so you can
use gauges.

Another option would be to add a tag to the agent, and then use a
continuous query [2] to perform the sum.

[1]
https://www.influxdata.com/getting-started-with-sending-statsd-metrics-to-telegraf-influxdb/
[2]
https://docs.influxdata.com/influxdb/v1.2/query_language/continuous_queries/

On Wed, Feb 15, 2017 at 2:58 AM,  wrote:

>
> in my case,i having multi agent to insert from multi node.
>
> agent-1:
> insert mechine_id = a value=98 1
>
> agent-2
> insert mechine_id = a value=102 1
>
> in influxdb,apply last insert value,
> but,in my case,the real value is 98 + 102
>
> how to solution this?
>
>
>
>
>
>
>
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/7ac9215d-10ac-4943-8d9e-71b011f21680%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CALxJwdOex1UXZCHOJdeAgxo0gGnuwJnCjEH0ZmyzAUsKo9kDHQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] about optimizing too many series

[Mark Rushakoff]

I don't think I understand the question, but if you're finding that your
InfluxDB clients are regularly issuing queries that select too many series,
the coordinator.max-select-series config option [1] will likely be helpful.

[1]
https://docs.influxdata.com/influxdb/v1.2/administration/config/#max-select-series-0

On Tue, Feb 14, 2017 at 11:44 PM,  wrote:

>
> we know series number is very important of performance。
>
> but some case must include a very dynamic key(like user id)。
>
> so,if  application can be  promise  the select must include a condition
> with that key,its right way ?
>
> eg:
>
> select sum(value) from `case` where `key` = USERID 
>
>
>
>
>
>
>
>
>
>
>
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/de40a183-3cc3-4ffa-9b61-e7c108aa6a68%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CALxJwdOwFdvoDzMXk9r2fTiRXfxrxOzdgCm0z-zw%2BvVALnNMrg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] shift listen's Deadman

[ambrozio963]

Hello,

i have a problem with Deadman tool of  kapacitor.

To import data into influxdb i use "influx -import -path=filename 
-precision=ns" every minute. But the duration of the import is 5 minutes (big 
file). So i have 5 minutes of a dead zone (in the worst case) for the deadman 
tool and he throws an alert because i have set threshold Deadman tool to alert 
at 0.0 on a period of one minute for each host and name (group by host,name).

It is possible to shift listen's tool Deadman  less than 5 minutes from real 
time ?


Probes,host=host1,name=name1 status=1

-- My tick -

var db = 'telegraf'

var rp = 'autogen'

var measurement = 'probe'

var messageField = 'message'

var message = 'Probe "{{ index .Tags "name" }}" on the server "{{ index .Tags 
"host" }}" is {{.Level}} '

var groupBy = ['host', 'name']

var outputDB = 'kapacitor'

var outputRP = 'autogen'

var stateChangesOnly = 10m

var durationField = 'duration'

var levelTag = 'level'

var outputMeasurement = 'alerts_probe_deadman'

var threshold = 0.0

var period = 1m

var email = 'kapaci...@dns.en'

var to = 'myem...@dns.en'

var log = '/tmp/alerts.log'

var data = stream
|from()
.database(db)
.retentionPolicy(rp)
.measurement(measurement)
.groupBy(groupBy)
|shift(3m)

var trigger = data
|deadman(threshold,period)
.stateChangesOnly(stateChangesOnly)
.durationField(durationField)
.levelTag(levelTag)
.messageField('message')
.message(message)
.log(log)
.email(email)
.to(to)
trigger
|influxDBOut()
.create()
.database(outputDB)
.retentionPolicy(outputRP)
.measurement(outputMeasurement)

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/d44b74da-c276-40d3-85ac-d8c738c1e290%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] Re: Subquery Help !

[kmg]

Any help on this please ?

On Tuesday, 14 February 2017 19:00:38 UTC+5:30, kmg wrote:
>
> I just came to know the newer version of Influxdb supports subquery. I 
> tried to add this feature into my existing architecture, But it shows null 
> value[Emptry output]. Could someone please help me whats wrong here. 
>
> Does subquery only work on select operations ?
>
> SubQuery I tried : SELECT last(*) FROM "database1_vm_data" where 
> "vm_name"='(SHOW TAG VALUES FROM "database1_vm_data" WITH KEY = "vm_name")'
>
>
> Here I'm trying to pass the tag names [ which contains VMs name] to where 
> clause to find last value of each VMs
>
> Full Steps :
>
>
> > use database1
> Using database database1
> > 
> > SHOW TAG VALUES FROM "database1_vm_data" WITH KEY = "vm_name"
> name: database1_vm_data
> key value
> --- -
> vm_name appvm2
> vm_name appvm3
> vm_name appvm1
>
> > 
> > 
> > 
> > SELECT last(*) FROM "database1_vm_data" where "vm_name"='appvm1'
> name: database1_vm_data
> time last_location last_os_name last_os_type last_os_version 
>  -   ---
> 0eastusUbuntuServer Linux16.04.0-LTS
>
> > 
> >
> >SELECT last(*) FROM "database1_vm_data" where "vm_name"='(SHOW TAG VALUES 
> FROM "database1_vm_data" WITH KEY = "vm_name")'
> >
> >
>
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/986e1e56-2ed2-4f21-b3b5-43f72a491c12%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[influxdb] how to solution multi agent from multi datasource

[imiskolee]

in my case,i having multi agent to insert from multi node.

agent-1:
insert mechine_id = a value=98 1

agent-2
insert mechine_id = a value=102 1

in influxdb,apply last insert value,
but,in my case,the real value is 98 + 102

how to solution this?








-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/7ac9215d-10ac-4943-8d9e-71b011f21680%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.