nova-api throws a database integrity error during a "nova boot"

Solution In Progress - Updated -

Issue

  • nova-api throws a database integrity error during a "nova boot"
  • Issuing a "nova boot" request will fail with an error similar to this one:
[root@hostname01 ~(openstack_admin)]# nova boot --flavor 2 --image rhel-7.1-password --nic net-id=a95dabca-145b-4c35-8e27-854deec995f1 ztest
ERROR (ClientException): The server has either erred or is incapable of performing the requested operation. (HTTP 500) (Request-ID: req-38d4201f-de7a-4ce0-a075-154737344f6f)
  • The following error message will be shown in /var/log/nova/nova-api.log
2015-09-15 10:49:37.910 49479 TRACE nova.api.openstack DBDuplicateEntry: (IntegrityError) (1062, "Duplicate entry '1083' for key 'PRIMARY'") 'INSERT INTO instances (deleted_at, deleted, created_at, updated_at, user_id, project_id, image_ref, kernel_id, ramdisk_id, hostname, launch_index, key_name, key_data, power_state, vm_state, task_state, memory_mb, vcpus, root_gb, ephemeral_gb, ephemeral_key_uuid, host, node, instance_type_id, user_data, reservation_id, scheduled_at, launched_at, terminated_at, availability_zone, display_name, display_description, launched_on, locked, locked_by, os_type, architecture, vm_mode, uuid, root_device_name, default_ephemeral_device, default_swap_device, config_drive, access_ip_v4, access_ip_v6, auto_disk_config, progress, shutdown_terminate, disable_terminate, cell_name, internal_id, cleaned) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (None, 0, datetime.datetime(2015, 9, 15, 15, 49, 37, 899635), None, 'b286dc1955f84e37ad372fd33f2c4e15', '9cfdcca495354d738ea9bd6220c413fd', 'ce7614a0-eeb0-4af4-b6fb-37e58cc72d32', '', '', 'ztest', 0, None, None, 0, 'building', 'scheduling', 2048, 1, 20, 0, None, None, None, 15, None, 'r-ymg0opu3', None, None, None, None, 'ztest', 'ztest', None, 0, None, None, None, None, 'a836974d-70d2-4296-900e-bda26ac24b76', None, None, None, '', None, None, 0, 0, 0, 0, None, None, 0)

Environment

  • Red Hat OpenStack 6.0 (RHOS)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.