Skip to content

InfluxDB: received error partial write: max-series-per-database limit exceeded: (1000000) dropped=542; discarding points

После деплоя возникли проблемы с записью в базу InfluxDB — а именно 400 ошибки. Как на зло даже debug режим ничего нового не показало, в логи так и сыпало ошибки

Apr 21 19:05:22 influx-host-name influxd[4230]: [httpd] 1.1.1.1 - metrics [21/Apr/2021:19:05:22 +0300] "POST /write?db=DATABASE HTTP/1.1" 400 88 "-" "Telegraf/1.14.1" 608a927b-a2bb-11eb-81f7-005056011775 12255
Apr 21 19:05:24 influx-host-name influxd[4230]: [httpd] 1.1.1.1 - metrics [21/Apr/2021:19:05:24 +0300] "POST /write?db=DATABASE HTTP/1.1" 400 88 "-" "Telegraf/1.16.3 Go/1.15.2" 61748180-a2bb-11eb-81f8-005056011775 4667
Apr 21 19:05:25 influx-host-name influxd[4230]: [httpd] 1.1.1.1 - metrics [21/Apr/2021:19:05:25 +0300] "POST /write?db=DATABASE HTTP/1.1" 204 0 "-" "Telegraf/1.16.3 Go/1.15.2" 61e6d6bb-a2bb-11eb-81f9-005056011775 7272
Apr 21 19:05:25 influx-host-name influxd[4230]: [httpd] 1.1.1.1 - metrics [21/Apr/2021:19:05:25 +0300] "POST /write?db=DATABASE HTTP/1.1" 400 88 "-" "Telegraf/1.14.1" 61f15fba-a2bb-11eb-81fa-005056011775 11785

По случаю начал смотреть логи Telegraf где выявил ошибки

Apr 21 19:29:06 host-01 telegraf[16234]: 2021-04-21T16:29:06Z E! [outputs.influxdb] When writing to [http://influx-host:8086]: received error partial write: max-series-per-database limit exceeded: (1000000) dropped=426; discarding points
Apr 21 19:29:16 host-01 telegraf[16234]: 2021-04-21T16:29:16Z E! [outputs.influxdb] When writing to [http://influx-host:8086]: received error partial write: max-series-per-database limit exceeded: (1000000) dropped=568; discarding points
Apr 21 19:29:26 host-01 telegraf[16234]: 2021-04-21T16:29:26Z E! [outputs.influxdb] When writing to [http://influx-host:8086]: received error partial write: max-series-per-database limit exceeded: (1000000) dropped=542; discarding points

Благо на оф сайте Influx было найдено описание проблемы https://docs.influxdata.com/influxdb/v1.8/troubleshooting/errors/#error-max-series-per-database-exceeded–

Таким образом после добавления строки из документации — заработало

[data]
...
max-series-per-database = 0
...

Information about this setting:
The maximum number of series allowed per database before writes are dropped. The default setting is 1000000 (one million). Change the setting to 0 to allow an unlimited number of series per database. If a point causes the number of series in a database to exceed max-series-per-database, InfluxDB will not write the point, and it returns a 500 with the following error

Published inDatabases

Be First to Comment

Залишити відповідь

Ваша e-mail адреса не оприлюднюватиметься. Обов’язкові поля позначені *