Hello,
I have the problem that a node gets automatically deleted after some time.
Here is some information about my system:
Server: Ubuntu 18.04.5 LTS (GNU/Linux 4.15.0-130-generic x86_64)
NetXMS version:
The name of the node is: Haas HP DL380 Gen9 (iLO)
When I serach for the name in the log file i see the following errors:
I hope somebody can help me here.
Thanks!
Woody
I have the problem that a node gets automatically deleted after some time.
Here is some information about my system:
Server: Ubuntu 18.04.5 LTS (GNU/Linux 4.15.0-130-generic x86_64)
NetXMS version:
Code Select
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
The name of the node is: Haas HP DL380 Gen9 (iLO)
When I serach for the name in the log file i see the following errors:
Code Select
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
I hope somebody can help me here.
Thanks!
Woody