NetXMS Support Forum

Helle together,

it is even more than two month I got many of these logentries:

2025.11.01 00:02:22.882 *E* [db.drv             ] SQL query failed (Query = "INSERT INTO nodes (primary_ip,primary_name,snmp_port,capabilities,snmp_version,community,agent_port,secret,snmp_oid,uname,agent_version,platform_name,poller_node_id,zone_guid,proxy_node,snmp_proxy,icmp_proxy,required_polls,use_ifxtable,usm_auth_password,usm_priv_password,usm_methods,snmp_sys_name,bridge_base_addr,down_since,driver_name,rack_image_front,rack_position,rack_height,physical_container_id,boot_time,agent_cache_mode,snmp_sys_contact,snmp_sys_location,last_agent_comm_time,syslog_msg_count,snmp_trap_count,node_type,node_subtype,ssh_login,ssh_password,ssh_key_id,ssh_port,ssh_proxy,port_rows,port_numbering_scheme,agent_comp_mode,tunnel_id,lldp_id,fail_time_snmp,fail_time_agent,fail_time_ssh,rack_orientation,rack_image_rear,agent_id,agent_cert_subject,hypervisor_type,hypervisor_info,icmp_poll_mode,chassis_placement_config,vendor,product_code,product_name,product_version,serial_number,cip_device_type,cip_status,cip_state,eip_proxy,eip_port,hardware_id,cip_vendor_code,agent_cert_mapping_method,agent_cert_mapping_data,snmp_engine_id,snmp_context_engine_id,syslog_codepage,snmp_codepage,ospf_router_id,mqtt_proxy,modbus_proxy,modbus_tcp_port,modbus_unit_id,vnc_password,vnc_port,vnc_proxy,path_check_reason,path_check_node_id,path_check_iface_id,expected_capabilities,id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE primary_ip=VALUES(primary_ip),primary_name=VALUES(primary_name),snmp_port=VALUES(snmp_port),capabilities=VALUES(capabilities),snmp_version=VALUES(snmp_version),community=VALUES(community),agent_port=VALUES(agent_port),secret=VALUES(secret),snmp_oid=VALUES(snmp_oid),uname=VALUES(uname),agent_version=VALUES(agent_version),platform_name=VALUES(platform_name),poller_node_id=VALUES(poller_node_id),zone_guid=VALUES(zone_guid),proxy_node=VALUES(proxy_node),snmp_proxy=VALUES(snmp_proxy),icmp_proxy=VALUES(icmp_proxy),required_polls=VALUES(required_polls),use_ifxtable=VALUES(use_ifxtable),usm_auth_password=VALUES(usm_auth_password),usm_priv_password=VALUES(usm_priv_password),usm_methods=VALUES(usm_methods),snmp_sys_name=VALUES(snmp_sys_name),bridge_base_addr=VALUES(bridge_base_addr),down_since=VALUES(down_since),driver_name=VALUES(driver_name),rack_image_front=VALUES(rack_image_front),rack_position=VALUES(rack_position),rack_height=VALUES(rack_height),physical_container_id=VALUES(physical_container_id),boot_time=VALUES(boot_time),agent_cache_mode=VALUES(
agent_cache_mode),snmp_sys_contact=VALUES(snmp_sys_contact),snmp_sys_location=VALUES(snmp_sys_location),last_agent_comm_time=VALUES(last_agent_comm_time),syslog_msg_count=VALUES(syslog_msg_count),snmp_trap_count=VALUES(snmp_trap_count),node_type=VALUES(node_type),node_subtype=VALUES(node_subtype),ssh_login=VALUES(ssh_login),ssh_password=VALUES(ssh_password),ssh_key_id=VALUES(ssh_key_id),ssh_port=VALUES(ssh_port),ssh_proxy=VALUES(ssh_proxy),port_rows=VALUES(port_rows),port_numbering_scheme=VALUES(port_numbering_scheme),agent_comp_mode=VALUES(agent_comp_mode),tunnel_id=VALUES(tunnel_id),lldp_id=VALUES(lldp_id),fail_time_snmp=VALUES(fail_time_snmp),fail_time_agent=VALUES(fail_time_agent),fail_time_ssh=VALUES(fail_time_ssh),rack_orientation=VALUES(rack_orientation),rack_image_rear=VALUES(rack_image_rear),agent_id=VALUES(agent_id),agent_cert_subject=VALUES(agent_cert_subject),hypervisor_type=VALUES(hypervisor_type),hypervisor_info=VALUES(hypervisor_info),icmp_poll_mode=VALUES(icmp_poll_mode),chassis_placement_config=VALUES(chassis_placement_config),vendor=VALUES(vendor),product_code=VALUES(product_code),product_name=VALUES(product_name),product_version=VALUES(product_version),serial_number=VALUES(serial_number),cip_device_type=VALUES(cip_device_type),cip_status=VALUES(cip_status),cip_state=VALUES(cip_state),eip_proxy=VALUES(eip_proxy),eip_port=VALUES(eip_port),hardware_id=
VALUES(hardware_id),cip_vendor_code=VALUES(cip_vendor_code),agent_cert_mapping_method=VALUES(agent_cert_mapping_method),agent_cert_mapping_data=VALUES(agent_cert_mapping_data),snmp_engine_id=VALUES(snmp_engine_id),snmp_context_engine_id=VALUES(snmp_context_engine_id),syslog_codepage=VALUES(syslog_codepage),snmp_codepage=VALUES(snmp_codepage),ospf_router_id=VALUES(ospf_router_id),mqtt_proxy=VALUES(mqtt_proxy),modbus_proxy=VALUES(modbus_proxy),modbus_tcp_port=VALUES(modbus_tcp_port),modbus_unit_id=VALUES(modbus_unit_id),vnc_password=VALUES(vnc_password),vnc_port=VALUES(vnc_port),vnc_proxy=VALUES(vnc_proxy),path_check_reason=VALUES(path_check_reason),path_check_node_id=VALUES(path_check_node_id),path_check_iface_id=VALUES(path_check_iface_id),expected_capabilities=VALUES(expected_capabilities),id=VALUES(id)"): Data too long for column 'lldp_id' at row 1

Checking the database with nxdbmgr does not report any errors.

Using version 5.2.8 with mariadb on debian

Best regards

Georg