Expected Behavior

Running vspheredb deamon with seperate tasks for each VCenter

Current Behavior

Only 1 task is running 2nd is crushing. Error msg is: "Task virtualMachines failed: Storing virtual_machine"

some errors from log:

10:42:34: Task virtualMachines failed: Storing virtual_machine[��Nc${���] failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'guest_tools_running_status' cannot be null, query was: INSERT INTO virtual_machine (uuid, vcenter_uuid, annotation, custom_values, hardware_memorymb, hardware_numcpu, hardware_numcorespersocket, template, bios_uuid, instance_uuid, version, connection_state, online_standby, paused, guest_id, guest_full_name, guest_state, guest_host_name, guest_ip_address, guest_tools_status, guest_tools_running_status, guest_tools_version, resource_pool_uuid, runtime_host_uuid, runtime_last_boot_time, runtime_last_suspend_time, runtime_power_state, boot_network_protocol, boot_order, cpu_hot_add_enabled, memory_hot_add_enabled) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) {array (
'uuid' => '��Nc${���',
'vcenter_uuid' => 'oֆIwC!A�',
'annotation' => NULL,
'custom_values' => NULL,
'hardware_memorymb' => NULL,
'hardware_numcpu' => NULL,
'hardware_numcorespersocket' => NULL,
'template' => NULL,
'bios_uuid' => NULL,
'instance_uuid' => NULL,
'version' => NULL,
'connection_state' => 'connected',
'online_standby' => 'n',
'paused' => 'n',
'guest_id' => NULL,
'guest_full_name' => NULL,
'guest_state' => 'unknown',
'guest_host_name' => NULL,
'guest_ip_address' => NULL,
'guest_tools_status' => NULL,
'guest_tools_running_status' => NULL,
'guest_tools_version' => NULL,
'resource_pool_uuid' => 'r%)�U
�˨3w',
'runtime_host_uuid' => NULL,
'runtime_last_boot_time' => NULL,
'runtime_last_suspend_time' => NULL,
'runtime_power_state' => 'poweredOff',
'boot_network_protocol' => NULL,
'boot_order' => NULL,
'cpu_hot_add_enabled' => NULL,
'memory_hot_add_enabled' => NULL,
)}
10:42:35:
10:43:16: Task virtualMachines failed: Storing virtual_machine[��Nc${���] failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'guest_tools_running_status' cannot be null, query was: INSERT INTO virtual_machine (uuid, vcenter_uuid, annotation, custom_values, hardware_memorymb, hardware_numcpu, hardware_numcorespersocket, template, bios_uuid, instance_uuid, version, connection_state, online_standby, paused, guest_id, guest_full_name, guest_state, guest_host_name, guest_ip_address, guest_tools_status, guest_tools_running_status, guest_tools_version, resource_pool_uuid, runtime_host_uuid, runtime_last_boot_time, runtime_last_suspend_time, runtime_power_state, boot_network_protocol, boot_order, cpu_hot_add_enabled, memory_hot_add_enabled) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) {array (
'uuid' => '��Nc${���',
'vcenter_uuid' => 'oֆIwC!A�',
'annotation' => NULL,
'custom_values' => NULL,
'hardware_memorymb' => NULL,
'hardware_numcpu' => NULL,
'hardware_numcorespersocket' => NULL,
'template' => NULL,
'bios_uuid' => NULL,
'instance_uuid' => NULL,
'version' => NULL,
'connection_state' => 'connected',
'online_standby' => 'n',
'paused' => 'n',
'guest_id' => NULL,
'guest_full_name' => NULL,
'guest_state' => 'unknown',
'guest_host_name' => NULL,
'guest_ip_address' => NULL,
'guest_tools_status' => NULL,
'guest_tools_running_status' => NULL,
'guest_tools_version' => NULL,
'resource_pool_uuid' => 'r%)�U
�˨3w',
'runtime_host_uuid' => NULL,
'runtime_last_boot_time' => NULL,
'runtime_last_suspend_time' => NULL,
'runtime_power_state' => 'poweredOff',
'boot_network_protocol' => NULL,
'boot_order' => NULL,
'cpu_hot_add_enabled' => NULL,
'memory_hot_add_enabled' => NULL,
)}
10:43:17:

Possible Solution

Unknown.

Steps to Reproduce (for bugs)

Unknown. Just happend.

Your Environment

2 x VMware vCenter®/ESXi™-Version: 6.5

• Version/GIT-Hash of this module: last, today pulled from master branch
• Icinga Web 2 version: 2.7.3
• Operating System and version: Debian 8

Hi, today we found new bug. When it appears one of our tasks stop to work. Then suddenly error disappear and everything looks ok. It looks like that maybe error handling didnt setup properly. On this 2nd vcenter I belive in that particular time someone was adding new machine over vcenter.