[influxdb] Re: write failed for shard 35: max series per database exceeded:

2016-09-09 Thread picaudmathieu
I have change the way I write the data. I have reduce the number of fields. 
It's clearly better. Thanks

-- 
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 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/1d04a365-3ca0-472c--517b0a3fdbe0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[influxdb] Re: write failed for shard 35: max series per database exceeded:

2016-09-09 Thread picaudmathieu
Yes, it's more than possible but we also a huge source of information with many 
assets (hundred of switchs with hundred of port, collect each 3 minutes on many 
country/dc/entity.

Thanks for the release not, I have set it in the conf. It's working now.

-- 
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 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/0faeb38b-fe97-4ea4-88e7-b2d397a977c7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[influxdb] Re: write failed for shard 35: max series per database exceeded:

2016-09-09 Thread picaudmathieu
Do you know how to change this option ?

-- 
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 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/a9db97fd-8f08-4510-833f-62621308dae4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[influxdb] Re: write failed for shard 35: max series per database exceeded:

2016-09-09 Thread picaudmathieu
My concern is that I have reached the limit in one week only. 

-- 
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 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/d18b14ff-b353-4754-bb8e-4ef211c06505%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[influxdb] Re: write failed for shard 35: max series per database exceeded:

2016-09-09 Thread picaudmathieu
Hello,

Yes 

-- 
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 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/66adce3e-b329-46db-97df-79276aca1a63%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[influxdb] Re: write failed for shard 35: max series per database exceeded:

2016-09-09 Thread 'Larry Walker' via InfluxDB
Running the 1.0 GA?  There is a config option to increase the max series.



On Friday, September 9, 2016 at 10:02:42 AM UTC-4, picaud...@gmail.com 
wrote:
>
> Hello,
>
> I'am not able any more to write data in my database because it seems that 
> I have reached the number of series
>
> Sep 09 15:54:46  influxd[30433]: [write] 2016/09/09 15:54:46 write 
> failed for shard 35: max series per database exceeded: 
>
> Here are some information :
>
> Data : nagios,tag1=xxx value=XXX,exectime=XX timestamp
>
> show retention policies on nagios
> namedurationshardGroupDuration  replicaNdefault
> default 24h0m0s 1h0m0s  1   true
> 2Y  17472h0m0s  24h0m0s 1   false
> 1Y  8736h0m0s   24h0m0s 1   false
> 6M  5208h0m0s   12h0m0s 1   false
> 3M  2688h0m0s   12h0m0s 1   false
> 1M  840h0m0s12h0m0s 1   false
> 2w  336h0m0s6h0m0s  1   false
> 1w  168h0m0s3h0m0s  1   false
>
>
>  influx -database 'nagios' -format 'csv' -execute 'SHOW SERIES' | wc -l
> 1000100
>
>
> Hardware : 8 CPU / 32GB
>
> Usage : 
>
> %Cpu(s):  1.9 us,  0.1 sy,  0.0 ni, 97.6 id,  0.3 wa,  0.0 hi,  0.0 si, 
>  0.0 st
> KiB Mem : 32782200 total, 25015696 free,  4116368 used,  3650136 buff/cache
> KiB Swap:  8388604 total,  8388604 free,0 used. 26743180 avail Mem
>
>   PID USER  PR  NIVIRTRESSHR S  %CPU %MEM TIME+ COMMAND
> 30433 influxdb  20   0 8474504 4.212g 699284 S   6.2 13.5   6:55.68 influxd
> 1 root  20   0   41756   4192   2368 S   0.0  0.0   0:04.30 systemd
>
> FS have enough space
>
> Is there a way to increase this number ?
>
>

-- 
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 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/a130fd2d-b689-4c64-b675-2c7e939d153b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.