заметки об администрировании и python. Траблшутинг в «примерах» и HOWTO.

👋 О себе | 📚 Литература и ресурсы | 🗂 Все посты | 📮 E-mail

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

| 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

Поделиться
Отправить
Запинить
 240   7 мес   InfluxDB   Telegraf