[influxdb] [Kapacitor] Capture n consecutive values and raise Alert

2016-10-13 Thread prashanthc
I am listening to an event and want to raise a critical alert whenever a value in an event is 0 consecutively for 3 times, how this can be done? The value i am looking out can either be 0 or 1. -- Remember to include the version number! --- You received this message because you are subscribed

[influxdb] Re: Reg usage of telegraf for Docker Stats within Container

2016-10-13 Thread kostas
On Wednesday, October 12, 2016 at 6:33:18 PM UTC+3, pck...@gmail.com wrote: > Hi, > > I am using Telegraf in my current production environment to read the jolokia > for JVM Stats and saves it in Influxdb. In the same way I would like to use > the same telegraf plugin to post the Docker Stats to

[influxdb] Re: Kapacitor and external InfluxDB.

2016-10-13 Thread codeprojtwo
ID: cpu_alert Error: Template: Type: stream Status: disabled Executing: false Created: 12 Oct 16 15:37 MSK Modified: 12 Oct 16 18:37 MSK LastEnabled: 01 Jan 01 00:00 UTC Databases Retention Policies: ["cp"."default"] TICKscript: stream // Select just the cpu measurement from our example datab

[influxdb] InfluxDB Raspberry Pi installation?

2016-10-13 Thread EBRAddict
Hi, I'd like to try InfluxDB on a Raspberry Pi 3 for a mobile sensor project. Currently it's logging ~50 data points every 200ms to a USB flash drive text file but I want to ramp that up to 200 every 10ms, or however fast I can push data from the microcontrollers to the Pi. I downloaded and un

Re: [influxdb] Not able to view new measurement after creating continuous query

2016-10-13 Thread tracyann . monteiro
On typing that query, I get the following syntax error: > SELECT sum("value") as Sumin FROM "ardata" where metric = 'In_bits' GROUP BY > time(15m) ERR: error parsing query: aggregate functions with GROUP BY time require a WHERE time clause -- Remember to include the version number! --- You re

Re: [influxdb] Not able to view new measurement after creating continuous query

2016-10-13 Thread tracyann . monteiro
If I change the query like this however: select sum("value") as "SumIn" from ardata where metric = 'InBps' and time > now() - 2h group by time(15m), device It does return results. Should I change the where clause with respect to time in the continuous query too? -- Remember to include the v

[influxdb] InfluxDB restarts every 24 hours and some data is missing

2016-10-13 Thread Pavel
Hi guys, I have really strange problem with our Influxdb server. First of all we are running the latest version 1.0.2. We use Infuxdb to store some performance statistics from around 40k devices. We do this regularly every 5 minutes. The server in question has 40GB RAM and 16 CPU's. We keep dat

Re: [influxdb] Not able to view new measurement after creating continuous query

2016-10-13 Thread tracyann . monteiro
I am able to view the measurement now. I did the same thing that I did yesterday. But it works now. -- 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 em

[influxdb] Re: Kapacitor and external InfluxDB.

2016-10-13 Thread codeprojtwo
вторник, 11 октября 2016 г., 20:29:26 UTC+3 пользователь codep...@gmail.com написал: > I'm having a hard time setting up a record. Currently kapacitor.conf contains: > > [[influxdb]] > enabled = true > name = "cp" > default = true > urls = ["http://influx-cp.internal:8086";] > username

[influxdb] /Var directory gets full after a week of posting data to InfluxDB

2016-10-13 Thread tracyann . monteiro
I have influxDB 1.0.0 running on one of my VM's. I have created a DB with a retention policy of one hour and a Python script that posts data to InfluxDB every 5 minutes. After running InfuxDB for a week, the /var directory gets full. Is there any way of avoiding this? -- Remember to include th

[influxdb] Re: InfluxDB Raspberry Pi installation?

2016-10-13 Thread Robert
I'm on a raspi 2, but adding "deb https://repos.influxdata.com/ubuntu jessie stable" to /etc/apt/sources.list let me install influx/telegraf via apt. On Thursday, October 13, 2016 at 8:39:27 AM UTC-4, EBRAddict wrote: > > Hi, > > I'd like to try InfluxDB on a Raspberry Pi 3 for a mobile sensor p

Re: [influxdb] InfluxDB restarts every 24 hours and some data is missing

2016-10-13 Thread Sean Beckett
> Now, we have two issues, one is that server restart every 24h due to OOM, look at this: Does the RAM use spike every 24 hours, or does it slowly grow? One of your tags is a MAC address. That has very high cardinality. How many series are there in your system? http://docs.influxdata.com/influxdb

Re: [influxdb] /Var directory gets full after a week of posting data to InfluxDB

2016-10-13 Thread Sean Beckett
What specifically in /var is filling up? (du -h -d 2 /var/lib/influxdb/) Are you sure that your writes are going to the RP you created? Did you set it as DEFAULT? On Thu, Oct 13, 2016 at 1:40 PM, wrote: > I have influxDB 1.0.0 running on one of my VM's. I have created a DB with > a retention po

Re: [influxdb] Re: question about last performance

2016-10-13 Thread Sean Beckett
See this comment on a LIMIT issue for context on why the LAST() point in a series can be tough to define. With no tags included, the system has to look for the LAST() point in every possible series for that measurement. The

[influxdb] Re: InfluxDB Raspberry Pi installation?

2016-10-13 Thread EBRAddict
That worked! Thank you. -- 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

[influxdb] Re: InfluxDB Raspberry Pi installation?

2016-10-13 Thread Frank Inselbuch
After you tar you will install it with dpkg. It will probably get started automatically at that point. But if you want to start it/restart/stop just sudo service influxd start (or restart or stop) by default I believe the server will be available for http: requests on port 8086 i would encourag

Re: [influxdb] Internal server error, timeout and unusable server after large imports

2016-10-13 Thread Tanya Unterberger
Thanks, Sean. It is good to know what the limitations are. And good that I made a mistake at the start and we kind of have a work around... On 13 October 2016 at 16:24, Sean Beckett wrote: > Tonya, when you write the data in ms but don't specify the precision, the > database interprets those mi