Can't write Metric Server to brand new VM influxdb Server

[robmit68]

Hello,
I am getting the following error on a proxmox influxdb database, which is unable to write to database - of course i can't see measurements. Please assist me in resolving this issue
Thank you

influxDb version: InfluxDB shell version: 1.6.7~rc0
Ubuntu Server: Ubuntu 22.04.2 LTS

InfluxDB udp configuration on
[[udp]]
enabled = true
bind-address = "0.0.0.0:8089"
database = "proxmox"
retention-policy = "one_year"
precision = "s"
batch-size = 5000
batch-pending = 10
batch-timeout = "1s"
read-buffer = 0

Error from syslog
May 5 04:44:50 fnc-influxdb-server-01 influxd[6484]: ts=2023-05-05T04:44:50.428961Z lvl=info msg="Failed to parse points" log_id=0hbZTCoG000 service=udp error="unable to parse 'system,object=storages,nodename=fnc-proxmox-dellr630-prod-01,host=local-lvm,type=lvmthin active=1,avail=2534827622400,content=\"rootdir,images\",enabled=1,shared=0,total=2534827622400,type=\"lvmthin\",used=0 1683261890000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=storages,nodename=fnc-proxmox-dellr630-prod-01,host=SynologyNFS-Backup,type=nfs active=1,avail=8123543060480,content=\"snippets,backup,iso,vztmpl,images,rootdir\",enabled=1,shared=1,total=23029958311936,type=\"nfs\",used=14906415251456 1683261890000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=storages,nodename=fnc-proxmox-dellr630-prod-01,host=local,type=dir active=1,avail=85378039808,content=\"backup,vztmpl,iso\",enabled=1,shared=0,total=100861726720,type=\"dir\",used=10312949760 1683261890000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=storages,nodename=fnc-proxmox-dellr630-prod-01,host=fnc-container-storage,type=nfs active=1,avail=8123543060480,content=\"snippets,rootdir,images,backup,vztmpl,iso\",enabled=1,shared=1,total=23029958311936,type=\"nfs\",used=14906415251456 1683261890000000000': time outside range -9223372036854775806 - 9223372036854775806"

 

[Lukas Wagner]

Hi,

I could reproduce your error, it seems like the precision = "s" setting is at fault here. You are telling InfluxDB to expect timestamps formatted as seconds, while Proxmox VE submits them in nanoseconds.
Just commit it out, the default should work.

Hope this helps!

 

[robmit68]

Hello Lukas i have set up the precision = "s" but still receiving the error, i have tried also to comment out the line but still getting the same result, i was wondering if something change on proxmox updates that could cause this issue?
before the updates it was working and now it is not

i had tried another influxdb server and still the same issue with or without precision = "s" i get the same response from the syslog on the influxdb server

May 5 19:34:41 titi-raspi-master01 influxd[265070]: ts=2023-05-05T19:34:41.194697Z lvl=info msg="Failed to parse points" log_id=0hcMGjkW000 service=udp error="unable to parse 'system,object=storages,nodename=fnc-proxmox-dellr630-prod-01,host=local-lvm,type=lvmthin active=1,avail=2534827622400,content=\"rootdir,images\",enabled=1,shared=0,total=2534827622400,type=\"lvmthin\",used=0 1683315280000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=storages,nodename=fnc-proxmox-dellr630-prod-01,host=SynologyNFS-Backup,type=nfs active=1,avail=8061685465088,content=\"rootdir,images,backup,iso,vztmpl,snippets\",enabled=1,shared=1,total=23029958311936,type=\"nfs\",used=14968272846848 1683315280000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=storages,nodename=fnc-proxmox-dellr630-prod-01,host=local,type=dir active=1,avail=85377269760,content=\"iso,vztmpl,backup\",enabled=1,shared=0,total=100861726720,type=\"dir\",used=10313719808 1683315280000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=storages,nodename=fnc-proxmox-dellr630-prod-01,host=fnc-container-storage,type=nfs active=1,avail=8061685465088,content=\"snippets,backup,vztmpl,iso,rootdir,images\",enabled=1,shared=1,total=23029958311936,type=\"nfs\",used=14968272846848 1683315280000000000': time outside range -9223372036854775806 - 9223372036854775806


Regards

 

[Lukas Wagner]

I run the latest Proxmox VE packages, so at least the most current updates should work fine. Although I do not remember that anybody changed the metric integration in the recent past.
Have you tried setting it explicitly to nanoseconds, so `precision = "ns"`? Maybe your InfluxDB version has other defaults, and thus the default, commented out value is somehow different...