duplicate index on block_device_mapping ('instance_uuid', 'device_name')
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
Medium
|
Johannes Erdfelt |
Bug Description
Due to an upgrade issue in Havana DB migration 186 there is now a duplicate index on the block_device_
DROP TABLE IF EXISTS `block_
/*!40101 SET @saved_cs_client = @@character_
/*!40101 SET character_
CREATE TABLE `block_
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`device_name` varchar(255) DEFAULT NULL,
`delete_
`snapshot_id` varchar(36) DEFAULT NULL,
`volume_id` varchar(36) DEFAULT NULL,
`volume_size` int(11) DEFAULT NULL,
`no_device` tinyint(1) DEFAULT NULL,
`connection_info` mediumtext,
`instance_uuid` varchar(36) DEFAULT NULL,
`deleted` int(11) DEFAULT NULL,
`source_type` varchar(255) DEFAULT NULL,
`destination_
`guest_format` varchar(255) DEFAULT NULL,
`device_type` varchar(255) DEFAULT NULL,
`disk_bus` varchar(255) DEFAULT NULL,
`boot_index` int(11) DEFAULT NULL,
`image_id` varchar(36) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `snapshot_id` (`snapshot_id`),
KEY `volume_id` (`volume_id`),
KEY `block_
KEY `block_
KEY `block_
KEY `block_
CONSTRAINT `block_
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_
*** We should drop the block_device_
Changed in nova: | |
assignee: | nobody → Dan Prince (dan-prince) |
importance: | Undecided → Medium |
status: | New → In Progress |
Changed in nova: | |
milestone: | none → juno-3 |
status: | Fix Committed → Fix Released |
Changed in nova: | |
milestone: | juno-3 → 2014.2 |
Fix proposed to branch: master /review. openstack. org/109104
Review: https:/