Max values per tag limit exceeded InfluxDB

influxdb
Ammad picture Ammad · May 3, 2017 · Viewed 14.8k times · Source

I am using java and writing into InfluxDb using batch points. My code is mention below,

 BatchPoints batchPoints = BatchPoints
.database(dbName).retentionPolicy("autogen") .consistency(InfluxDB.ConsistencyLevel.ALL).build();


    point = Point.measurement("cpu")...

    batchPoints.point(point);

I am writing 20 to 30 Million points, and after a while getting exception:

.java.lang.RuntimeException: {"error":"partial write: max-values-per-tag limit exceeded (100708/100000): measurement=\"cpu\" tag=\"jkey\" value=\ .....

Wondering how to increase the limit? Or do i need to change my schema design?

Answer

Ammad picture Ammad · May 4, 2017

I found the solution so pasting here, open influxdb.conf file usually located at /etc/influxdb/influxdb.conf and search for:

# max-values-per-tag = 100000

uncomment and replace the value to zero as shown below, 

max-values-per-tag = 0

And bounce the influxDb instance for changes to take effect.

Related questions

Can you delete data from influxdb?

How do you delete data from influxdb? The documentation shows it should be as simple as: delete from foo where time < now() -1h For some reason, influxdb rejects my delete statements saying "Delete queries can't have where clause …

Read More
How to format time in influxdb select query

I am new to InfluxDB. I am querying data in admin ui. I see time as timestamp. Is it possible to see it formatted as date and time?

Read More
InfluxDB - Getting only last value in query

Is possible to query only for the last value (or n-th value) of the results of a query? For example, in the query: SELECT value FROM response_times WHERE time > now() - 1h limit 1000; Is possible to get only …

Read More