nova-api throws a database integrity error during a "nova boot"
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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
