yahoo-eng-team team mailing list archive

[Dan Prince <dprince@xxxxxxxxxx>]

Public bug reported:

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...

** Affects: nova
     Importance: Undecided
     Assignee: Dan Prince (dan-prince)
         Status: In Progress

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

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

-- 
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):
  In Progress

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