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

2016-10-14 Thread dragande
Hi, I have increased shard durations to two weeks for 'three_months'. We will see how this reflect to memory usage. Thank you very much for your help! -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group.

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

2016-10-14 Thread paveldimow
Hi, I have increased shard duration to two weeks for 'three_months', and I will monitor RAM usage for the next few days. Thank you very much for your help. -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData"

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

2016-10-14 Thread paveldimow
Hi, I will try to future investigate this problem in more details. I am pretty sure that there should be not timestamp collision but I need little more time to get all the relevant data. Again, thank you very much for your help! -- Remember to include the version number! --- You received

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

2016-10-14 Thread paveldimow
Hi Sean, here is the graph from out NMS about memory usage https://s18.postimg.org/a6buyzna1/memory.png and I would say we have spikes, but they are not every 24h but rather every 30 minutes and I guess it's because of our CQ we use for downsampling. I can post that CQ if that can help. We

[influxdb] Re: Telegraf Cloudwatch metrics

2016-10-14 Thread kmg
Any idea on this ?. I'm not sure whether its a bug on the plugin On Wednesday, 12 October 2016 11:39:50 UTC+5:30, kmg wrote: > > I tried to pull AWS metrics through cloudwatch using telegraf and write > the output data into influxdb. > > When I run the test with sample config, it shows only EC2

[influxdb] InfluxDB import

2016-10-14 Thread manish216
How can i see the data imported in the database. I reached till this step - [root@integration@DEV influxdb]influx -import -path=first.txt 2016/10/14 09:22:45 Processed 3 commands 2016/10/14 09:22:45 Processed 6 inserts 2016/10/14 09:22:45 Failed 0 inserts Please help how i can see the

Re: [influxdb] Time-weighted mean?

2016-10-14 Thread Sean Beckett
Can you adapt MOVING_AVERAGE() to meet your needs? If not, https://github.com/influxdata/influxdb/pull/6113 where that function is implemented provides a good template if you wanted to submit a time-weighted mean

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

2016-10-14 Thread tracyann . monteiro
I get the following when I do du -h 2 /var/lib/influxdb/ 4.0K/var/lib/influxdb/data/juniper/one_hr 8.0K/var/lib/influxdb/data/juniper 8.0K/var/lib/influxdb/data/links/autogen/16 8.0K/var/lib/influxdb/data/links/autogen/12 8.0K/var/lib/influxdb/data/links/autogen/15 28K

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

2016-10-14 Thread Sean Beckett
It looks like your CQ does lead to RAM spikes close to the capacity of the box. Your shard durations are what's tipping the issue, I believe. With 1 day shards in a 90 day retention policy, there are a lot of housecleaning tasks to do each night at midnight UTC. When each shard expires, the series

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

2016-10-14 Thread Sean Beckett
> By missing the whole measurement I mean that for example we have one measurement at10:00 pm in InfluxDB and in our file (we do write data in file for debugging), then we have next measurement in 10:05 pm in both InfluxDB and file, the next measurement in 10:10 we are missing in InfluxDB but we

Re: [influxdb] InfluxDB import

2016-10-14 Thread Sean Beckett
Please share the DDL from the top of the import file. Dod you look in the logs? Are you sure you are querying the right database? On Fri, Oct 14, 2016 at 3:45 AM, wrote: > How can i see the data imported in the database. > I reached till this step - > >

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

2016-10-14 Thread Sean Beckett
The majority of the data usage is from the `_internal` monitoring database. ALTER the default retention policy on _internal to lower the duration of that RP to reduce the data retention. On Fri, Oct 14, 2016 at 7:29 AM, wrote: > I get the following when I do du -h 2

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

2016-10-14 Thread tracyann . monteiro
Thanks a lot! :) -- 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

[influxdb] Problems understanding new Telegraf's SNMP Plugin

2016-10-14 Thread sacha . yunusic
Hi, In the old SNMP Plugin I had this: ... [[inputs.snmp.host]] address = "server.domain.local:161" community = "community" # default public version = 2 # default 2 collect = ["CargaCPU"] [[inputs.snmp.bulk]] name = "CargaCPU" oid = "hrProcessorLoad" And