Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error on Sync job after moving ESXi Host(s) from Internal to DMZ #99

Closed
ChristianMoritz opened this issue Apr 1, 2019 · 0 comments
Closed
Assignees
Labels
Milestone

Comments

@ChristianMoritz
Copy link

Expected Behavior

ive got 6 esxi hosts on my vcenter... (the 2 oldest for dmz, 4 newer nodes for internal)
after deleting the old 2 dmz nodes and switching the 2 next oldest nodes from internal to the dmz ive now got a warnung message every 60seconds on the CLI that the there is a duplicate entry...

Current Behavior

service@icinga:/# icingacli vspheredb daemon run
#{m5\F] failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4c4c4544-005a-4310-8058-c6c04f473632' for key 'sysinfo_uuid', query was: INSERT INTO host_system (uuid, vcenter_uuid, host_name, product_api_version, pro duct_full_name, bios_version, bios_release_date, sysinfo_vendor, sysinfo_model, sysinfo_uuid, service_tag, hardware_cpu_model, hardware_cpu_mhz, hardware_cpu_pa ckages, hardware_cpu_cores, hardware_cpu_threads, hardware_memory_size_mb, hardw are_num_hba, hardware_num_nic, runtime_power_state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) {array (
#{m5\F',=> '(1p,4~p
'vcenter_uuid' => 'oXXXXXX',
'host_name' => 'XXXXXX',
'product_api_version' => '6.5',
'product_full_name' => 'VMware ESXi 6.5.0 Build-10390116',
'bios_version' => '2.8.0',
'bios_release_date' => NULL,
'sysinfo_vendor' => 'Dell Inc.',
'sysinfo_model' => 'PowerEdge R730',
'sysinfo_uuid' => 'XXXXXX',
'service_tag' => 'XXXXXX',
'hardware_cpu_model' => 'Intel(R) Xeon(R) CPU E5-2670 v3 @ 2.30GHz',
'hardware_cpu_mhz' => 2299,
'hardware_cpu_packages' => 2,
'hardware_cpu_cores' => 24,
'hardware_cpu_threads' => 48,
'hardware_memory_size_mb' => 1048482.0,
'hardware_num_hba' => 5,
'hardware_num_nic' => 6,
'runtime_power_state' => 'poweredOn',
)}

Your Environment

  • Iicnga2 r2.10.3-1
  • VMware vCenter®/ESXi™-Version: 6.5
  • Version/GIT-Hash of this module: vspheredb(1.0.3)& vsphere (1.1.0)
  • Icinga Web 2 version: 2.6.2
  • Operating System and version: debian 9.6 x64
  • Webserver, PHP versions: apache2 / php7
@Thomas-Gelf Thomas-Gelf self-assigned this Apr 29, 2020
@Thomas-Gelf Thomas-Gelf added this to the v1.2.0 milestone Apr 29, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants