[jira] [Created] (CLOUDSTACK-6195) an ACS db upgraded from Pre-4.0 version is missing unique key constraint on host_details

["Joris van Lieshout (JIRA)" <ji...@apache.org>]

Joris van Lieshout created CLOUDSTACK-6195:
----------------------------------------------

             Summary: an ACS db upgraded from Pre-4.0 version is missing unique key constraint on host_details
                 Key: CLOUDSTACK-6195
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6195
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Upgrade
    Affects Versions: 4.2.0, 4.1.0, 4.0.2, 4.0.1, 4.0.0, 4.1.1, 4.2.1, 4.1.2
         Environment: Pre-4.0 db upgraded to 4.x. We have confirmed this bug in a db that started out as 2.2.14. 
            Reporter: Joris van Lieshout


This is the table in our 4.2.1 env that has been upgraded from 2.2.14.

CREATE TABLE `host_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` bigint(20) unsigned NOT NULL COMMENT 'host id',
  `name` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_host_details__host_id` (`host_id`),
  CONSTRAINT `fk_host_details__host_id` FOREIGN KEY (`host_id`) REFERENCES `host` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=752966 DEFAULT CHARSET=utf8;

And this is the table of a fresh 4.x install:

CREATE TABLE `host_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` bigint(20) unsigned NOT NULL COMMENT 'host id',
  `name` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_host_id_name` (`host_id`,`name`),
  KEY `fk_host_details__host_id` (`host_id`),
  CONSTRAINT `fk_host_details__host_id` FOREIGN KEY (`host_id`) REFERENCES `host` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=242083 DEFAULT CHARSET=utf8;



--
This message was sent by Atlassian JIRA
(v6.2#6252)