yahoo-eng-team team mailing list archive

[Dan Prince <dprince@xxxxxxxxxx>]

** Changed in: nova
       Status: In Progress => Invalid

** Changed in: nova
     Assignee: Dan Prince (dan-prince) => (unassigned)

-- 
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/1265838

Title:
  duplicate unique index on virtual_interfaces.address

Status in OpenStack Compute (Nova):
  Invalid

Bug description:
  Due to an upgrade issue in Havana migration 185 the virtual_interfaces
  table now has a duplicate unique index on the 'address' column.

  CREATE TABLE `virtual_interfaces` (
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    `deleted_at` datetime DEFAULT NULL,
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `address` varchar(255) DEFAULT NULL,
    `network_id` int(11) DEFAULT NULL,
    `uuid` varchar(36) DEFAULT NULL,
    `instance_uuid` varchar(36) DEFAULT NULL,
    `deleted` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `address` (`address`),
    UNIQUE KEY `uniq_virtual_interfaces0address` (`address`),
    KEY `network_id` (`network_id`),
    KEY `virtual_interfaces_instance_uuid_fkey` (`instance_uuid`),
    CONSTRAINT `virtual_interfaces_instance_uuid_fkey` FOREIGN KEY (`instance_uuid`) REFERENCES `instances` (`uuid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;

  ----

  We should drop this in Icehouse...

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1265838/+subscriptions