[influxdb] cast in query fails with parsing error

Hello, I have an issue casting from float to int. usual query works: > SELECT "value" FROM "xyz" limit 2 name: xyz -- timevalue 13912128000 19.1 13912128010 18.8 where this fails: > SELECT value::integer FROM "xyz" limit 2 E

Re: [influxdb] Time-weighted mean?

Hi Sean, Thanks for the reply. I did run up a sample database with some time weighted samples and unfortunately the moving average ignores the time that the data is stored so doesn't help. I also had a look at pull 6113 and there is a lot of code in a language & platform I'm unfamiliar with, a

Re: [influxdb] Time-weighted mean?

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] InfluxDB restarts every 24 hours and some data is missing

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 thi

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

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" gr

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

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.

[influxdb] Problems understanding new Telegraf's SNMP Plugin

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 th

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

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 thi

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

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 /var/lib/influxdb/ > > 4.0K

Re: [influxdb] InfluxDB import

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 - > > [root@integration@DEV influxdb]influx -im

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

> 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 do

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

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] /Var directory gets full after a week of posting data to InfluxDB

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 /var

[influxdb] InfluxDB import

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 measurement

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

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 ar

[influxdb] Re: Telegraf Cloudwatch metrics

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 s