InfluxDB VM name number/string

[FlorianM]

Hello !

I have an error, I have a VM with the name "test" and another "123"

Only the "test" VM is monitor and I have this error in syslog

srv01 influxd[14520]: ts=2021-06-11T17:28:02.485659Z lvl=info msg="Failed to write point batch to database" log_id=0UdKidnl000 service=udp db_instance=X error="partial write: field type conflict: input field \"name\" on measurement \"system\" is type string, already exists as type float dropped=7"

Do you have an idea to force string in influxdb? Which file should be modified?

Thank's

 

[dcsapak]

can you post your version: pveversion -v ?

 

[FlorianM]

can you post your version: pveversion -v ?

Hello;
Yes

proxmox-ve: 6.4-1 (running kernel: 5.4.114-1-pve)
pve-manager: 6.4-8 (running version: 6.4-8/185e14db)
pve-kernel-5.4: 6.4-2
pve-kernel-helper: 6.4-2
pve-kernel-5.4.114-1-pve: 5.4.114-1
ceph-fuse: 12.2.11+dfsg1-2.1+b1
corosync: 3.1.2-pve1
criu: 3.11-3
glusterfs-client: 5.5-3
ifupdown: residual config
ifupdown2: 3.0.0-1+pve3
libjs-extjs: 6.0.1-10
libknet1: 1.20-pve1
libproxmox-acme-perl: 1.1.0
libproxmox-backup-qemu0: 1.0.3-1
libpve-access-control: 6.4-1
libpve-apiclient-perl: 3.1-3
libpve-common-perl: 6.4-3
libpve-guest-common-perl: 3.1-5
libpve-http-server-perl: 3.2-3
libpve-storage-perl: 6.4-1
libqb0: 1.0.5-1
libspice-server1: 0.14.2-4~pve6+1
lvm2: 2.03.02-pve4
lxc-pve: 4.0.6-2
lxcfs: 4.0.6-pve1
novnc-pve: 1.1.0-1
proxmox-backup-client: 1.1.8-1
proxmox-mini-journalreader: 1.1-1
proxmox-widget-toolkit: 2.5-6
pve-cluster: 6.4-1
pve-container: 3.3-5
pve-docs: 6.4-2
pve-edk2-firmware: 2.20200531-1
pve-firewall: 4.1-4
pve-firmware: 3.2-4
pve-ha-manager: 3.1-1
pve-i18n: 2.3-1
pve-qemu-kvm: 5.2.0-6
pve-xtermjs: 4.7.0-3
qemu-server: 6.4-2
smartmontools: 7.2-pve2
spiceterm: 3.1-1
vncterm: 1.6-2
zfsutils-linux: 2.0.4-pve1

 

[httpways]

Hello I have an error too:

Details of my PVE server:

pveversion -v
proxmox-ve: 6.4-1 (running kernel: 5.4.128-1-pve)
pve-manager: 6.4-13 (running version: 6.4-13/9f411e79)
pve-kernel-5.4: 6.4-5
pve-kernel-helper: 6.4-5
pve-kernel-5.4.128-1-pve: 5.4.128-1
ceph-fuse: 12.2.11+dfsg1-2.1+b1
corosync: 3.1.2-pve1
criu: 3.11-3
glusterfs-client: 5.5-3
ifupdown: 0.8.35+pve1
libjs-extjs: 6.0.1-10
libknet1: 1.20-pve1
libproxmox-acme-perl: 1.1.0
libproxmox-backup-qemu0: 1.1.0-1
libpve-access-control: 6.4-3
libpve-apiclient-perl: 3.1-3
libpve-common-perl: 6.4-3
libpve-guest-common-perl: 3.1-5
libpve-http-server-perl: 3.2-3
libpve-storage-perl: 6.4-1
libqb0: 1.0.5-1
libspice-server1: 0.14.2-4~pve6+1
lvm2: 2.03.02-pve4
lxc-pve: 4.0.6-2
lxcfs: 4.0.6-pve1
novnc-pve: 1.1.0-1
proxmox-backup-client: 1.1.12-1
proxmox-mini-journalreader: 1.1-1
proxmox-widget-toolkit: 2.6-1
pve-cluster: 6.4-1
pve-container: 3.3-6
pve-docs: 6.4-2
pve-edk2-firmware: 2.20200531-1
pve-firewall: 4.1-4
pve-firmware: 3.2-4
pve-ha-manager: 3.1-1
pve-i18n: 2.3-1
pve-qemu-kvm: 5.2.0-6
pve-xtermjs: 4.7.0-3
pve-zsync: 2.2
qemu-server: 6.4-2
smartmontools: 7.2-pve2
spiceterm: 3.1-1
vncterm: 1.6-2
zfsutils-linux: 2.0.5-pve1~bpo10+1

cat /etc/pve/status.cfg
influxdb: proxmox
    port 8089
    server XX.XX.XX.XX

Details of my infludb server:

Test that the UDP stream is working:

tcpdump -n udp port 8089
tcpdump: verbose output suppressed, use -v[v]... for full protocol decode
listening on ens18, link-type EN10MB (Ethernet), snapshot length 262144 bytes
15:34:29.199025 IP XX.XX.XX.XX.35981 > 192.168.7.5.8089: UDP, length 1340
15:34:29.199131 IP XX.XX.XX.XX.35981 > 192.168.7.5.8089: UDP, length 1046
15:34:29.199132 IP XX.XX.XX.XX.35981 > 192.168.7.5.8089: UDP, length 1378
15:34:29.199391 IP XX.XX.XX.XX.35981 > 192.168.7.5.8089: UDP, length 1440
15:34:29.199588 IP XX.XX.XX.XX.35981 > 192.168.7.5.8089: UDP, length 1381
15:34:29.199589 IP XX.XX.XX.XX.35981 > 192.168.7.5.8089: UDP, length 855
15:34:29.199824 IP XX.XX.XX.XX.35981 > 192.168.7.5.8089: UDP, length 1342
15:34:29.199825 IP XX.XX.XX.XX.35981 > 192.168.7.5.8089: UDP, length 869
15:34:29.199923 IP XX.XX.XX.XX.35981 > 192.168.7.5.8089: UDP, length 1370
15:34:29.213814 IP XX.XX.XX.XX.38984 > 192.168.7.5.8089: UDP, length 579
...

Checking the logs of influxdb server:

journalctl -a | grep influx
...
août 27 15:35:49 influxdb influxd-systemd-start.sh[15804]: ts=2021-08-27T13:35:49.505911Z lvl=info msg="Failed to parse points" log_id=0WDn09y0000 service=udp error="unable to parse 'proxmox-support,object=qemu,vmid=1005,nodename=pve0,host=influxdb pbs-library-version=\"1.1.0 (5eaa3ecffd0d29d4ef5e105e784bafcc605c9d6b)\" 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=qemu,vmid=1005,nodename=pve0,host=influxdb balloon=4294967296,cpu=0.0229179624822834,cpus=2,disk=0,diskread=565571360,diskwrite=6412845056,freemem=1609396224,maxdisk=68719476736,maxmem=4294967296,mem=2512846848,name=\"influxdb\",netin=447766163,netout=51470244,pid=25709,qmpstatus=\"running\",running-machine=\"pc-i440fx-5.2+pve0\",running-qemu=\"5.2.0\",status=\"running\",uptime=88204 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'ballooninfo,object=qemu,vmid=1003,nodename=pve0,host=debian-gnome actual=2147483648,free_mem=99688448,last_update=1630071349,major_page_faults=14584,max_mem=2147483648,mem_swapped_in=50249728,mem_swapped_out=267481088,minor_page_faults=21640664,total_mem=2078978048 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'blockstat,object=qemu,vmid=1003,nodename=pve0,host=debian-gnome,instance=ide2 failed_flush_operations=0,failed_rd_operations=0,failed_unmap_operations=0,failed_wr_operations=0,flush_operations=0,flush_total_time_ns=0,idle_time_ns=759289250204362,invalid_flush_operations=0,invalid_rd_operations=0,invalid_unmap_operations=0,invalid_wr_operations=0,rd_bytes=316,rd_merged=0,rd_operations=10,rd_total_time_ns=127271,unmap_bytes=0,unmap_merged=0,unmap_operations=0,unmap_total_time_ns=0,wr_bytes=0,wr_highest_offset=0,wr_merged=0,wr_operations=0,wr_total_time_ns=0 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806"
août 27 15:35:49 influxdb influxd-systemd-start.sh[15804]: ts=2021-08-27T13:35:49.505948Z lvl=info msg="Failed to parse points" log_id=0WDn09y0000 service=udp error="unable to parse 'blockstat,object=qemu,vmid=1003,nodename=pve0,host=debian-gnome,instance=scsi0 failed_flush_operations=0,failed_rd_operations=0,failed_unmap_operations=0,failed_wr_operations=0,flush_operations=53028,flush_total_time_ns=26839148234,idle_time_ns=11600564952,invalid_flush_operations=0,invalid_rd_operations=0,invalid_unmap_operations=0,invalid_wr_operations=0,rd_bytes=2324499456,rd_merged=0,rd_operations=71988,rd_total_time_ns=14184744599,unmap_bytes=23735697408,unmap_merged=0,unmap_operations=2708,unmap_total_time_ns=6438755,wr_bytes=3811057664,wr_highest_offset=33595592704,wr_merged=0,wr_operations=329667,wr_total_time_ns=403027521422 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'nics,object=qemu,vmid=1003,nodename=pve0,host=debian-gnome,instance=tap1003i0 netin=186538535,netout=6041732 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'proxmox-support,object=qemu,vmid=1003,nodename=pve0,host=debian-gnome pbs-library-version=\"1.1.0 (5eaa3ecffd0d29d4ef5e105e784bafcc605c9d6b)\" 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=qemu,vmid=1003,nodename=pve0,host=debian-gnome balloon=2147483648,cpu=0.000996433151403624,cpus=2,disk=0,diskread=2324499772,diskwrite=3811057664,freemem=99688448,maxdisk=34359738368,maxmem=2147483648,mem=1979289600,name=\"debian-gnome\",netin=186538535,netout=6041732,pid=30266,qmpstatus=\"running\",running-machine=\"pc-i440fx-5.2+pve0\",running-qemu=\"5.2.0\",status=\"running\",uptime=780731 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806"
août 27 15:35:49 influxdb influxd-systemd-start.sh[15804]: ts=2021-08-27T13:35:49.518073Z lvl=info msg="Failed to parse points" log_id=0WDn09y0000 service=udp error="unable to parse 'system,object=storages,nodename=pve0,host=iso,type=dir active=1,avail=7329255424,content=\"iso\",enabled=1,shared=0,total=20986851328,type=\"dir\",used=12567916544 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=storages,nodename=pve0,host=k8s,type=dir active=1,avail=7329255424,content=\"images\",enabled=1,shared=0,total=20986851328,type=\"dir\",used=12567916544 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806\nunable to parse 'system,object=storages,nodename=pve0,host=local,type=dir active=1,avail=405834260480,content=\"iso,snippets,rootdir,images,vztmpl\",enabled=1,shared=0,total=481077682176,type=\"dir\",used=50782453760 1630071349000000000': time outside range -9223372036854775806 - 9223372036854775806"
...

It seems that the data sent to the influxdb server are not formatted well ???

Please help
Thanks