openstack heat resource create failed

[Robert Eby]

OpenStack Newton running under Docker/K8S (installed with openstack helm charts).

Ran an "openstack stack create" command to create a new stack.
Most resources created correctly. One (VM) failed with:

ClientException: resources.dcae_c_vm: Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible. <class 'oslo_db.exception.DBReferenceError'> (HTTP 500) (Request-ID: req-7b6aef97-a4eb-457c-bc86-732c5adb952f)

nova api log attached as requested. The time of the creation failure corresponds with the "Unexpected exception in API method" in this log.

[jichenjc (jichenjc)]

might need more info here, seems db is reporting foreign key issue, any previous operations or DB direct operations made?

2017-12-18 16:30:04.136 1 ERROR nova.api.openstack.extensions raise errorclass(errno, errorvalue)
2017-12-18 16:30:04.136 1 ERROR nova.api.openstack.extensions DBReferenceError: (pymysql.err.IntegrityError) (1452, u'Cannot add or update a child row: a foreign key constraint fails (`nova`.`block_device_mapping`, CONSTRAINT `block_device_mapping_instance_uuid_fkey` FOREIGN KEY (`instance_uuid`) REFERENCES `instances` (`uuid`))') [SQL: u'INSERT INTO block_device_mapping (created_at, updated_at, deleted_at, deleted, instance_uuid, source_type, destination_type, guest_format, device_type, disk_bus, boot_index, device_name, delete_on_termination, snapshot_id, volume_id, volume_size, image_id, no_device, connection_info, tag) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(instance_uuid)s, %(source_type)s, %(destination_type)s, %(guest_format)s, %(device_type)s, %(disk_bus)s, %(boot_index)s, %(device_name)s, %(delete_on_termination)s, %(snapshot_id)s, %(volume_id)s, %(volume_size)s, %(image_id)s, %(no_device)s, %(connection_info)s, %(tag)s)'] [parameters: {'instance_uuid': '225981a8-fa04-4fcf-8e6d-8f504625da8b', 'guest_format': None, 'boot_index': 0, 'image_id': u'd162bde0-7b60-4cfa-8af3-c2d42a510466', 'source_type': u'image', 'connection_info': None, 'created_at': datetime.datetime(2017, 12, 18, 16, 30, 3, 945929), 'no_device': 0, 'deleted': 0, 'updated_at': None, 'device_name': None, 'disk_bus': None, 'volume_size': None, 'tag': None, 'snapshot_id': None, 'device_type': u'disk', 'volume_id': None, 'destination_type': u'local', 'deleted_at': None, 'delete_on_termination': 1}]
2017-12-18 16:30:04.136 1 ERROR nova.api.openstack.extensions

[Launchpad Janitor (janitor)]

[Expired for OpenStack Compute (nova) because there has been no activity for 60 days.]