hertzbeat icon indicating copy to clipboard operation
hertzbeat copied to clipboard

[BUG] <using tdengine 3.1.1.12 error>

Open thinwonton opened this issue 5 months ago • 0 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

Current Behavior

when insert something into tdengine, HertzBeat server happened and print logs !

ERROR org.dromara.hertzbeat.warehouse.store.HistoryTdEngineDataStorage - TDengine ERROR (216): sql: INSERT INTO windows_interfaces_337759650085376USINGwindows_interfaces_super TAGS (337759650085376) VALUES (1704938734407, '{"descr":"Software Loopback Interface 1\\u0000"}', 1.0, 'Software Loopback Interface 1', 1500.0, 1048576.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734408, '{"descr":"Microsoft 6to4 Adapter\\u0000"}', 2.0, 'Microsoft 6to4 Adapter', 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '2', '6') (1704938734409, '{"descr":"Microsoft Kernel Debug Network Adapter\\u0000"}', 3.0, 'Microsoft Kernel Debug Network Adapter', 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '2', '6') (1704938734410, '{"descr":"Bluetooth Device (Personal Area Network)\\u0000"}', 4.0, 'Bluetooth Device (Personal Area Network)', 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '2', '6') (1704938734411, '{"descr":"WAN Miniport (Network Monitor)\\u0000"}', 5.0, 'WAN Miniport (Network Monitor)', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734412, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter #2\\u0000"}', 6.0, 'Microsoft Wi-Fi Direct Virtual Adapter #2', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734413, '{"descr":"Microsoft IP-HTTPS Platform Adapter\\u0000"}', 7.0, 'Microsoft IP-HTTPS Platform Adapter', 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '2', '6') (1704938734414, '{"descr":"WAN Miniport (IPv6)\\u0000"}', 8.0, 'WAN Miniport (IPv6)', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734415, '{"descr":"Realtek USB GbE Family Controller\\u0000"}', 9.0, 'Realtek USB GbE Family Controller', 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '2', '6') (1704938734416, '{"descr":"WAN Miniport (SSTP)\\u0000"}', 10.0, 'WAN Miniport (SSTP)', 4091.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734417, '{"descr":"Intel(R) Wi-Fi 6 AX200 160MHz\\u0000"}', 11.0, 'Intel(R) Wi-Fi 6 AX200 160MHz', 1500.0, 589355.4688, 9.52156262E8, 0.0, 0.0, 5.2435712E7, 0.0, 0.0, '1', '1') (1704938734418, '{"descr":"Remote NDIS based Internet Sharing Device\\u0000"}', 12.0, 'Remote NDIS based Internet Sharing Device', 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '2', '6') (1704938734419, '{"descr":"WAN Miniport (L2TP)\\u0000"}', 13.0, 'WAN Miniport (L2TP)', 1460.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734420, '{"descr":"VMware Virtual Ethernet Adapter for VMnet1\\u0000"}', 14.0, 'VMware Virtual Ethernet Adapter for VMnet1', 1500.0, 97656.25, 16.0, 0.0, 0.0, 1288.0, 0.0, 0.0, '1', '1') (1704938734421, '{"descr":"Sangfor SSL VPN CS Support System VNIC\\u0000"}', 15.0, 'Sangfor SSL VPN CS Support System VNIC', 1400.0, 9765.625, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734422, '{"descr":"WAN Miniport (PPPOE)\\u0000"}', 16.0, 'WAN Miniport (PPPOE)', 1494.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734423, '{"descr":"Microsoft Teredo Tunneling Adapter\\u0000"}', 17.0, 'Microsoft Teredo Tunneling Adapter', 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '2', '6') (1704938734424, '{"descr":"WAN Miniport (IKEv2)\\u0000"}', 18.0, 'WAN Miniport (IKEv2)', 1480.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734425, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter\\u0000"}', 19.0, 'Microsoft Wi-Fi Direct Virtual Adapter', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734426, '{"descr":"WAN Miniport (PPTP)\\u0000"}', 20.0, 'WAN Miniport (PPTP)', 1464.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734427, '{"descr":"VMware Virtual Ethernet Adapter for VMnet8\\u0000"}', 21.0, 'VMware Virtual Ethernet Adapter for VMnet8', 1500.0, 97656.25, 27090.0, 0.0, 0.0, 27272.0, 0.0, 0.0, '1', '1') (1704938734428, '{"descr":"WAN Miniport (IP)\\u0000"}', 22.0, 'WAN Miniport (IP)', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734429, '{"descr":"Sangfor aTrust VNIC\\u0000"}', 23.0, 'Sangfor aTrust VNIC', 1500.0, 976562.5, 0.0, 0.0, 0.0, 177105.0, 0.0, 0.0, '1', '1') (1704938734430, '{"descr":"Gateway NC Adapter\\u0000"}', 24.0, 'Gateway NC Adapter', 1400.0, 976562.5, 1340126.0, 0.0, 0.0, 547932.0, 0.0, 0.0, '1', '1') (1704938734431, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter #2-WFP Native MAC Layer LightWeight Filter-0000\\u0000"}', 25.0, 'Microsoft Wi-Fi Direct Virtual Adapter #2-WFP Native MAC Layer LightWeight Filter-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734432, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter-WFP Native MAC Layer LightWeight Filter-0000\\u0000"}', 26.0, 'Microsoft Wi-Fi Direct Virtual Adapter-WFP Native MAC Layer LightWeight Filter-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734433, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter-Native WiFi Filter Driver-0000\\u0000"}', 27.0, 'Microsoft Wi-Fi Direct Virtual Adapter-Native WiFi Filter Driver-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734434, '{"descr":"Sangfor SSL VPN CS Support System VNIC-WFP Native MAC Layer LightWeight Filter-0000\\u0000"}', 28.0, 'Sangfor SSL VPN CS Support System VNIC-WFP Native MAC Layer LightWeight Filter-0000', 1400.0, 9765.625, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734435, '{"descr":"Sangfor SSL VPN CS Support System VNIC-QoS Packet Scheduler-0000\\u0000"}', 29.0, 'Sangfor SSL VPN CS Support System VNIC-QoS Packet Scheduler-0000', 1400.0, 9765.625, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734436, '{"descr":"Sangfor SSL VPN CS Support System VNIC-WFP 802.3 MAC Layer LightWeight Filter-0000\\u0000"}', 30.0, 'Sangfor SSL VPN CS Support System VNIC-WFP 802.3 MAC Layer LightWeight Filter-0000', 1400.0, 9765.625, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734437, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter-QoS Packet Scheduler-0000\\u0000"}', 31.0, 'Microsoft Wi-Fi Direct Virtual Adapter-QoS Packet Scheduler-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734438, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter-WFP 802.3 MAC Layer LightWeight Filter-0000\\u0000"}', 32.0, 'Microsoft Wi-Fi Direct Virtual Adapter-WFP 802.3 MAC Layer LightWeight Filter-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734439, '{"descr":"Gateway NC Adapter-WFP Native MAC Layer LightWeight Filter-0000\\u0000"}', 33.0, 'Gateway NC Adapter-WFP Native MAC Layer LightWeight Filter-0000', 1400.0, 976562.5, 1340126.0, 0.0, 0.0, 547932.0, 0.0, 0.0, '1', '1') (1704938734440, '{"descr":"Intel(R) Wi-Fi 6 AX200 160MHz-WFP Native MAC Layer LightWeight Filter-0000\\u0000"}', 34.0, 'Intel(R) Wi-Fi 6 AX200 160MHz-WFP Native MAC Layer LightWeight Filter-0000', 1500.0, 589355.4688, 9.52156262E8, 0.0, 0.0, 5.2435712E7, 0.0, 0.0, '1', '1') (1704938734441, '{"descr":"Intel(R) Wi-Fi 6 AX200 160MHz-Virtual WiFi Filter Driver-0000\\u0000"}', 35.0, 'Intel(R) Wi-Fi 6 AX200 160MHz-Virtual WiFi Filter Driver-0000', 1500.0, 589355.4688, 9.52156262E8, 0.0, 0.0, 5.2435712E7, 0.0, 0.0, '1', '1') (1704938734442, '{"descr":"Intel(R) Wi-Fi 6 AX200 160MHz-Native WiFi Filter Driver-0000\\u0000"}', 36.0, 'Intel(R) Wi-Fi 6 AX200 160MHz-Native WiFi Filter Driver-0000', 1500.0, 589355.4688, 9.52156262E8, 0.0, 0.0, 5.2435712E7, 0.0, 0.0, '1', '1') (1704938734443, '{"descr":"Intel(R) Wi-Fi 6 AX200 160MHz-QoS Packet Scheduler-0000\\u0000"}', 37.0, 'Intel(R) Wi-Fi 6 AX200 160MHz-QoS Packet Scheduler-0000', 1500.0, 589355.4688, 9.52156262E8, 0.0, 0.0, 5.2435712E7, 0.0, 0.0, '1', '1') (1704938734444, '{"descr":"Intel(R) Wi-Fi 6 AX200 160MHz-WFP 802.3 MAC Layer LightWeight Filter-0000\\u0000"}', 38.0, 'Intel(R) Wi-Fi 6 AX200 160MHz-WFP 802.3 MAC Layer LightWeight Filter-0000', 1500.0, 589355.4688, 9.52156262E8, 0.0, 0.0, 5.2435712E7, 0.0, 0.0, '1', '1') (1704938734445, '{"descr":"WAN Miniport (IP)-WFP Native MAC Layer LightWeight Filter-0000\\u0000"}', 39.0, 'WAN Miniport (IP)-WFP Native MAC Layer LightWeight Filter-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734446, '{"descr":"WAN Miniport (IP)-QoS Packet Scheduler-0000\\u0000"}', 40.0, 'WAN Miniport (IP)-QoS Packet Scheduler-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734447, '{"descr":"WAN Miniport (IPv6)-WFP Native MAC Layer LightWeight Filter-0000\\u0000"}', 41.0, 'WAN Miniport (IPv6)-WFP Native MAC Layer LightWeight Filter-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734448, '{"descr":"WAN Miniport (IPv6)-QoS Packet Scheduler-0000\\u0000"}', 42.0, 'WAN Miniport (IPv6)-QoS Packet Scheduler-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734449, '{"descr":"WAN Miniport (Network Monitor)-WFP Native MAC Layer LightWeight Filter-0000\\u0000"}', 43.0, 'WAN Miniport (Network Monitor)-WFP Native MAC Layer LightWeight Filter-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734450, '{"descr":"WAN Miniport (Network Monitor)-QoS Packet Scheduler-0000\\u0000"}', 44.0, 'WAN Miniport (Network Monitor)-QoS Packet Scheduler-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '1') (1704938734451, '{"descr":"Gateway NC Adapter-QoS Packet Scheduler-0000\\u0000"}', 45.0, 'Gateway NC Adapter-QoS Packet Scheduler-0000', 1400.0, 976562.5, 1340126.0, 0.0, 0.0, 547932.0, 0.0, 0.0, '1', '1') (1704938734452, '{"descr":"Gateway NC Adapter-WFP 802.3 MAC Layer LightWeight Filter-0000\\u0000"}', 46.0, 'Gateway NC Adapter-WFP 802.3 MAC Layer LightWeight Filter-0000', 1400.0, 976562.5, 1340126.0, 0.0, 0.0, 547932.0, 0.0, 0.0, '1', '1') (1704938734453, '{"descr":"Sangfor aTrust VNIC-WFP Native MAC Layer LightWeight Filter-0000\\u0000"}', 47.0, 'Sangfor aTrust VNIC-WFP Native MAC Layer LightWeight Filter-0000', 1500.0, 976562.5, 0.0, 0.0, 0.0, 177105.0, 0.0, 0.0, '1', '1') (1704938734454, '{"descr":"Sangfor aTrust VNIC-QoS Packet Scheduler-0000\\u0000"}', 48.0, 'Sangfor aTrust VNIC-QoS Packet Scheduler-0000', 1500.0, 976562.5, 0.0, 0.0, 0.0, 177105.0, 0.0, 0.0, '1', '1') (1704938734455, '{"descr":"Sangfor aTrust VNIC-WFP 802.3 MAC Layer LightWeight Filter-0000\\u0000"}', 49.0, 'Sangfor aTrust VNIC-WFP 802.3 MAC Layer LightWeight Filter-0000', 1500.0, 976562.5, 0.0, 0.0, 0.0, 177105.0, 0.0, 0.0, '1', '1') (1704938734456, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter #2-Native WiFi Filter Driver-0000\\u0000"}', 50.0, 'Microsoft Wi-Fi Direct Virtual Adapter #2-Native WiFi Filter Driver-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734457, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter #2-QoS Packet Scheduler-0000\\u0000"}', 51.0, 'Microsoft Wi-Fi Direct Virtual Adapter #2-QoS Packet Scheduler-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2') (1704938734458, '{"descr":"Microsoft Wi-Fi Direct Virtual Adapter #2-WFP 802.3 MAC Layer LightWeight Filter-0000\\u0000"}', 52.0, 'Microsoft Wi-Fi Direct Virtual Adapter #2-WFP 802.3 MAC Layer LightWeight Filter-0000', 1500.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, '1', '2'), desc: syntax error near ''Software Loopback Interface 1' (invalid data or symbol)

Expected Behavior

No response

Steps To Reproduce

No response

Environment

HertzBeat version(v1.4.3):

Debug logs

No response

Anything else?

No response

thinwonton avatar Jan 11 '24 02:01 thinwonton