logging entries netxmsd.log

[gkaudewitz]

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

[Filipp Sudanov]

The error is "Data too long for column 'lldp_id' at row 1".

NetXMS found some new snmp device, for some reason the value for lldp_id column is too long and is not fitting into 255 chars.

It would be good to understand which exactly is that device on your network. You can enable debug for poll.discovery tag by issuing

debug poll.discovery 6

in Tools -> Server Debug Console. Then you should see some IP address being polled prior to the SQL error in the log. Once you know the IP address, please do a walk for 1.0.8802.1.1.2.1.3 branch and share the output. You can use nxsnmpwalk for that