I had the same problem, but after executing the satements it did work.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts MenuNetworkDiscovery.MergeDuplicateNodes = 0
root@netxms:~# netxmsd -v
NetXMS Server Version 3.7.116 Build 3.7-116-g133064d484 (UNICODE)
NXCP: 5.53.1.29 (AES-256, Blowfish-256, 3DES, AES-128, Blowfish-128)
Built with: g++ (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0
root@netxms:~# netxmsd -v
NetXMS Server Version 3.7.95 Build 3.7-95-ga7a4f1d5c7 (UNICODE)
NXCP: 5.53.1.29 (AES-256, Blowfish-256, 3DES, AES-128, Blowfish-128)
Built with: g++ (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0
2020.06.06 10:49:47.781 *I* [ ] NetXMS Server started
2020.06.06 10:51:48.635 *W* [ ] Failed to execute transformation script for object Haas HP DL380 Gen9 (iLO) [118319] DCI Dummy [290984] (Error 17 in line 8: Argument is not of string type and cannot be converted to string)
2020.06.06 10:51:49.923 *E* [db.drv ] SQL query failed (Query = "INSERT INTO interface_address_list (iface_id,ip_addr,ip_netmask) VALUES (?,?,?)"): Deadlock found when trying to get lock; try restarting transaction
2020.06.06 10:52:51.877 *E* [db.drv ] SQL query failed (Query = "INSERT INTO items (node_id,template_id,name,source,datatype,polling_interval,retention_time,status,delta_calculation,transformation,description,instance,template_item_id,flags,resource_id,proxy_node,base_units,unit_multiplier,custom_units_name,perftab_settings,system_tag,snmp_port,snmp_raw_value_type,instd_method,instd_data,instd_filter,samples,comments,guid,npe_name,instance_retention_time,grace_period_start,related_object,polling_interval_src,retention_time_src,polling_schedule_type,retention_type,snmp_version,item_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE node_id=VALUES(node_id),template_id=VALUES(template_id),name=VALUES(name),source=VALUES(source),datatype=VALUES(datatype),polling_interval=VALUES(polling_interval),retention_time=VALUES(retention_time),status=VALUES(status),delta_calculation=VALUES(delta_calculation),transformation=VALUES(transformation),description=VALUES(description),instance=VALUES(instance),template_item_id=VALUES(template_item_id),flags=VALUES(flags),resource_id=VALUES(resource_id),proxy_node=VALUES(proxy_node),base_units=VALUES(base_units),unit_multiplier=VALUES(unit_multiplier),custom_units_name=VALUES(custom_units_name),perftab_settings=VALUES(perftab_settings),system_tag=VALUES(system_tag),snmp_port=VALUES(snmp_port),snmp_raw_value_type=VALUES(snmp_raw_value_type),instd_method=VALUES(instd_method),instd_data=VALUES(instd_data),instd_filter=VALUES(instd_filter),samples=VALUES(samples),comments=VALUES(comments),guid=VALUES(guid),npe_name=VALUES(npe_name),instance_retention_time=VALUES(instance_retention_time),grace_period_start=VALUES(grace_period_start),related_object=VALUES(related_object),polling_interval_src=VALUES(polling_interval_src),retention_time_src=VALUES(retention_time_src),polling_schedule_type=VALUES(polling_schedule_type),retention_type=VALUES(retention_type),snmp_version=VALUES(snmp_version),item_id=VALUES(item_id)"): Deadlock found when trying to get lock; try restarting transaction
2020.06.06 10:52:52.335 *E* [db.drv ] SQL query failed (Query = "INSERT INTO items (node_id,template_id,name,source,datatype,polling_interval,retention_time,status,delta_calculation,transformation,description,instance,template_item_id,flags,resource_id,proxy_node,base_units,unit_multiplier,custom_units_name,perftab_settings,system_tag,snmp_port,snmp_raw_value_type,instd_method,instd_data,instd_filter,samples,comments,guid,npe_name,instance_retention_time,grace_period_start,related_object,polling_interval_src,retention_time_src,polling_schedule_type,retention_type,snmp_version,item_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE node_id=VALUES(node_id),template_id=VALUES(template_id),name=VALUES(name),source=VALUES(source),datatype=VALUES(datatype),polling_interval=VALUES(polling_interval),retention_time=VALUES(retention_time),status=VALUES(status),delta_calculation=VALUES(delta_calculation),transformation=VALUES(transformation),description=VALUES(description),instance=VALUES(instance),template_item_id=VALUES(template_item_id),flags=VALUES(flags),resource_id=VALUES(resource_id),proxy_node=VALUES(proxy_node),base_units=VALUES(base_units),unit_multiplier=VALUES(unit_multiplier),custom_units_name=VALUES(custom_units_name),perftab_settings=VALUES(perftab_settings),system_tag=VALUES(system_tag),snmp_port=VALUES(snmp_port),snmp_raw_value_type=VALUES(snmp_raw_value_type),instd_method=VALUES(instd_method),instd_data=VALUES(instd_data),instd_filter=VALUES(instd_filter),samples=VALUES(samples),comments=VALUES(comments),guid=VALUES(guid),npe_name=VALUES(npe_name),instance_retention_time=VALUES(instance_retention_time),grace_period_start=VALUES(grace_period_start),related_object=VALUES(related_object),polling_interval_src=VALUES(polling_interval_src),retention_time_src=VALUES(retention_time_src),polling_schedule_type=VALUES(polling_schedule_type),retention_type=VALUES(retention_type),snmp_version=VALUES(snmp_version),item_id=VALUES(item_id)"): Deadlock found when trying to get lock; try restarting transaction
2020.06.06 10:52:52.657 *E* [db.drv ] SQL query failed (Query = "INSERT INTO items (node_id,template_id,name,source,datatype,polling_interval,retention_time,status,delta_calculation,transformation,description,instance,template_item_id,flags,resource_id,proxy_node,base_units,unit_multiplier,custom_units_name,perftab_settings,system_tag,snmp_port,snmp_raw_value_type,instd_method,instd_data,instd_filter,samples,comments,guid,npe_name,instance_retention_time,grace_period_start,related_object,polling_interval_src,retention_time_src,polling_schedule_type,retention_type,snmp_version,item_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE node_id=VALUES(node_id),template_id=VALUES(template_id),name=VALUES(name),source=VALUES(source),datatype=VALUES(datatype),polling_interval=VALUES(polling_interval),retention_time=VALUES(retention_time),status=VALUES(status),delta_calculation=VALUES(delta_calculation),transformation=VALUES(transformation),description=VALUES(description),instance=VALUES(instance),template_item_id=VALUES(template_item_id),flags=VALUES(flags),resource_id=VALUES(resource_id),proxy_node=VALUES(proxy_node),base_units=VALUES(base_units),unit_multiplier=VALUES(unit_multiplier),custom_units_name=VALUES(custom_units_name),perftab_settings=VALUES(perftab_settings),system_tag=VALUES(system_tag),snmp_port=VALUES(snmp_port),snmp_raw_value_type=VALUES(snmp_raw_value_type),instd_method=VALUES(instd_method),instd_data=VALUES(instd_data),instd_filter=VALUES(instd_filter),samples=VALUES(samples),comments=VALUES(comments),guid=VALUES(guid),npe_name=VALUES(npe_name),instance_retention_time=VALUES(instance_retention_time),grace_period_start=VALUES(grace_period_start),related_object=VALUES(related_object),polling_interval_src=VALUES(polling_interval_src),retention_time_src=VALUES(retention_time_src),polling_schedule_type=VALUES(polling_schedule_type),retention_type=VALUES(retention_type),snmp_version=VALUES(snmp_version),item_id=VALUES(item_id)"): Deadlock found when trying to get lock; try restarting transaction
2020.06.06 10:52:52.667 *E* [db.drv ] SQL query failed (Query = "INSERT INTO items (node_id,template_id,name,source,datatype,polling_interval,retention_time,status,delta_calculation,transformation,description,instance,template_item_id,flags,resource_id,proxy_node,base_units,unit_multiplier,custom_units_name,perftab_settings,system_tag,snmp_port,snmp_raw_value_type,instd_method,instd_data,instd_filter,samples,comments,guid,npe_name,instance_retention_time,grace_period_start,related_object,polling_interval_src,retention_time_src,polling_schedule_type,retention_type,snmp_version,item_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE node_id=VALUES(node_id),template_id=VALUES(template_id),name=VALUES(name),source=VALUES(source),datatype=VALUES(datatype),polling_interval=VALUES(polling_interval),retention_time=VALUES(retention_time),status=VALUES(status),delta_calculation=VALUES(delta_calculation),transformation=VALUES(transformation),description=VALUES(description),instance=VALUES(instance),template_item_id=VALUES(template_item_id),flags=VALUES(flags),resource_id=VALUES(resource_id),proxy_node=VALUES(proxy_node),base_units=VALUES(base_units),unit_multiplier=VALUES(unit_multiplier),custom_units_name=VALUES(custom_units_name),perftab_settings=VALUES(perftab_settings),system_tag=VALUES(system_tag),snmp_port=VALUES(snmp_port),snmp_raw_value_type=VALUES(snmp_raw_value_type),instd_method=VALUES(instd_method),instd_data=VALUES(instd_data),instd_filter=VALUES(instd_filter),samples=VALUES(samples),comments=VALUES(comments),guid=VALUES(guid),npe_name=VALUES(npe_name),instance_retention_time=VALUES(instance_retention_time),grace_period_start=VALUES(grace_period_start),related_object=VALUES(related_object),polling_interval_src=VALUES(polling_interval_src),retention_time_src=VALUES(retention_time_src),polling_schedule_type=VALUES(polling_schedule_type),retention_type=VALUES(retention_type),snmp_version=VALUES(snmp_version),item_id=VALUES(item_id)"): Deadlock found when trying to get lock; try restarting transaction
2020.06.06 10:52:52.682 *E* [db.drv ] SQL query failed (Query = "INSERT INTO items (node_id,template_id,name,source,datatype,polling_interval,retention_time,status,delta_calculation,transformation,description,instance,template_item_id,flags,resource_id,proxy_node,base_units,unit_multiplier,custom_units_name,perftab_settings,system_tag,snmp_port,snmp_raw_value_type,instd_method,instd_data,instd_filter,samples,comments,guid,npe_name,instance_retention_time,grace_period_start,related_object,polling_interval_src,retention_time_src,polling_schedule_type,retention_type,snmp_version,item_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE node_id=VALUES(node_id),template_id=VALUES(template_id),name=VALUES(name),source=VALUES(source),datatype=VALUES(datatype),polling_interval=VALUES(polling_interval),retention_time=VALUES(retention_time),status=VALUES(status),delta_calculation=VALUES(delta_calculation),transformation=VALUES(transformation),description=VALUES(description),instance=VALUES(instance),template_item_id=VALUES(template_item_id),flags=VALUES(flags),resource_id=VALUES(resource_id),proxy_node=VALUES(proxy_node),base_units=VALUES(base_units),unit_multiplier=VALUES(unit_multiplier),custom_units_name=VALUES(custom_units_name),perftab_settings=VALUES(perftab_settings),system_tag=VALUES(system_tag),snmp_port=VALUES(snmp_port),snmp_raw_value_type=VALUES(snmp_raw_value_type),instd_method=VALUES(instd_method),instd_data=VALUES(instd_data),instd_filter=VALUES(instd_filter),samples=VALUES(samples),comments=VALUES(comments),guid=VALUES(guid),npe_name=VALUES(npe_name),instance_retention_time=VALUES(instance_retention_time),grace_period_start=VALUES(grace_period_start),related_object=VALUES(related_object),polling_interval_src=VALUES(polling_interval_src),retention_time_src=VALUES(retention_time_src),polling_schedule_type=VALUES(polling_schedule_type),retention_type=VALUES(retention_type),snmp_version=VALUES(snmp_version),item_id=VALUES(item_id)"): Deadlock found when trying to get lock; try restarting transaction
2020.06.06 10:53:02.238 *E* [db.drv ] SQL query failed (Query = "INSERT INTO interface_address_list (iface_id,ip_addr,ip_netmask) VALUES (?,?,?)"): Deadlock found when trying to get lock; try restarting transaction
2020.06.06 10:55:41.384 *W* [ ] Failed to execute transformation script for object @HR-Soft QNAP TS-259 [198] DCI .1.3.6.1.4.1.24681.1.3.17.1.1.1 [24748] (Error 5 in line 4: Invalid operation with NULL value)
2020.06.06 11:16:56.005 *W* [ ] Failed to execute transformation script for object Haas HP DL380 Gen9 (iLO) [118345] DCI Dummy [291118] (Error 17 in line 8: Argument is not of string type and cannot be converted to string)
2020.06.06 11:17:52.642 *E* [db.drv ] SQL query failed (Query = "INSERT INTO interface_address_list (iface_id,ip_addr,ip_netmask) VALUES (?,?,?)"): Deadlock found when trying to get lock; try restarting transaction
2020.06.06 11:18:13.515 *I* [ ] NetXMS Server stopped by signal