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
name    duration        shardGroupDuration      replicaN        default
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      840h0m0s        12h0m0s                 1               false
2w      336h0m0s        6h0m0s                  1               false
1w      168h0m0s        3h0m0s                  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  NI    VIRT    RES    SHR 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/4b86d6c9-a772-4eca-a386-92ce16784d8b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to