Public bug reported: Kilo latest code
Reproduce steps: 1. In nova.conf, compute_driver=libvirt.LibvirtDriver. Start nova- compute. 2. Modify nova.conf, compute_driver=vmwareapi.VMwareVCDriver. Restart nova-compute. 3. Modify nova.conf, compute_driver=libvirt.LibvirtDriver. Restart nova-compute. Restart fails. Error in nova-compute log: 2015-02-04 04:00:53.240 4993 TRACE nova.openstack.common.threadgroup RemoteError: Remote error: DBDuplicateEntry (IntegrityError) ibm_db_dbi::IntegrityError: Sending data failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "3" constrains table "NOVA.COMPUTE_NODES" from having duplicate values for the index key. SQLSTATE=23505 SQLCODE=-803 'INSERT INTO compute_nodes (created_at, updated_at, deleted_at, deleted, service_id, host, vcpus, memory_mb, local_gb, vcpus_used, memory_mb_used, local_gb_used, hypervisor_type, hypervisor_version, hypervisor_hostname, free_ram_mb, free_disk_gb, current_workload, running_vms, cpu_info, disk_available_least, host_ip, supported_instances, metrics, pci_stats, extra_resources, stats, numa_topology) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (datetime.datetime(2015, 2, 3, 20, 0, 53, 40880), None, None, 0, 7, 'icm', 4, 5808, 25, 0, 512, 0, 'QEMU', 1005003, 'icm.dtc.ibm.com', 5296, 25, 0, 0, '{"vendor": "Intel", "model": "Westmere", "arch": "x86_64", "features": ["ss", "hypervisor", "vme", "pcid", "pclmuldq", "x2apic"], "topology": {"cores": 1, "threads": 1, "sockets": 4}}', 17, '10.104.0.190', '[["i686", "qemu", "hvm"], ["x86_64", "qemu", "hvm"]]', '[]', '[]', None, '{}', '{"nova_object.version": "1.2", "nova_object.changes": ["cells"], "nova_object.name": "NUMATopology", "nova_object.data": {"cells": [{"nova_object.version": "1.2", "nova_object.changes": ["cpu_usage", "memory_usage", "cpuset", "pinned_cpus", "siblings", "memory", "mempages", "id"], "nova_object.name": "NUMACell", "nova_object.data": {"cpu_usage": 0, "memory_usage": 0, "cpuset": [0, 1, 2, 3], "pinned_cpus": [], "siblings": [], "memory": 6143, "mempages": [], "id": 0}, "nova_object.namespace": "nova"}]}, "nova_object.namespace": "nova"}') ** Affects: nova Importance: Undecided Status: New -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova). https://bugs.launchpad.net/bugs/1417744 Title: nova-compute fail to start after change driver Status in OpenStack Compute (Nova): New Bug description: Kilo latest code Reproduce steps: 1. In nova.conf, compute_driver=libvirt.LibvirtDriver. Start nova- compute. 2. Modify nova.conf, compute_driver=vmwareapi.VMwareVCDriver. Restart nova-compute. 3. Modify nova.conf, compute_driver=libvirt.LibvirtDriver. Restart nova-compute. Restart fails. Error in nova-compute log: 2015-02-04 04:00:53.240 4993 TRACE nova.openstack.common.threadgroup RemoteError: Remote error: DBDuplicateEntry (IntegrityError) ibm_db_dbi::IntegrityError: Sending data failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "3" constrains table "NOVA.COMPUTE_NODES" from having duplicate values for the index key. SQLSTATE=23505 SQLCODE=-803 'INSERT INTO compute_nodes (created_at, updated_at, deleted_at, deleted, service_id, host, vcpus, memory_mb, local_gb, vcpus_used, memory_mb_used, local_gb_used, hypervisor_type, hypervisor_version, hypervisor_hostname, free_ram_mb, free_disk_gb, current_workload, running_vms, cpu_info, disk_available_least, host_ip, supported_instances, metrics, pci_stats, extra_resources, stats, numa_topology) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (datetime.datetime(2015, 2, 3, 20, 0, 53, 40880), None, None, 0, 7, 'icm', 4, 5808, 25, 0, 512, 0, 'QEMU', 1005003, 'icm.dtc.ibm.com', 5296, 25, 0, 0, '{"vendor": "Intel", "model": "Westmere", "arch": "x86_64", "features": ["ss", "hypervisor", "vme", "pcid", "pclmuldq", "x2apic"], "topology": {"cores": 1, "threads": 1, "sockets": 4}}', 17, '10.104.0.190', '[["i686", "qemu", "hvm"], ["x86_64", "qemu", "hvm"]]', '[]', '[]', None, '{}', '{"nova_object.version": "1.2", "nova_object.changes": ["cells"], "nova_object.name": "NUMATopology", "nova_object.data": {"cells": [{"nova_object.version": "1.2", "nova_object.changes": ["cpu_usage", "memory_usage", "cpuset", "pinned_cpus", "siblings", "memory", "mempages", "id"], "nova_object.name": "NUMACell", "nova_object.data": {"cpu_usage": 0, "memory_usage": 0, "cpuset": [0, 1, 2, 3], "pinned_cpus": [], "siblings": [], "memory": 6143, "mempages": [], "id": 0}, "nova_object.namespace": "nova"}]}, "nova_object.namespace": "nova"}') To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1417744/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp