[jira] [Created] (CLOUDSTACK-3612) 3.0.6 to ASF 4.2 Upgrade: Database Schema Inconsistencies on the Upgraded Setup

["Chandan Purushothama (JIRA)" <ji...@apache.org>]

Chandan Purushothama created CLOUDSTACK-3612:
------------------------------------------------

             Summary: 3.0.6 to ASF 4.2 Upgrade: Database Schema Inconsistencies on the Upgraded Setup
                 Key: CLOUDSTACK-3612
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3612
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Upgrade
    Affects Versions: 4.2.0
            Reporter: Chandan Purushothama
            Priority: Critical
             Fix For: 4.2.0



Table 1: baremetal_dhcp_devices

On ASF 4.2 Setup:
 `nsp_id` bigint(20) UNSIGNED DEFAULT NULL,
 `pod_id` bigint(20) UNSIGNED DEFAULT NULL,
 `device_type` varchar(255) DEFAULT NULL,
 `physical_network_id` bigint(20) UNSIGNED DEFAULT NULL,
 `host_id` bigint(20) UNSIGNED DEFAULT NULL,

On the 4.2 Upgraded Setup: 
 `nsp_id` bigint(20) UNSIGNED NOT NULL,
 `pod_id` bigint(20) UNSIGNED NOT NULL,
 `device_type` varchar(255) NOT NULL,
 `physical_network_id` bigint(20) UNSIGNED NOT NULL,
 `host_id` bigint(20) UNSIGNED NOT NULL,

Table 2: baremetal_pxe_devices

On ASF 4.2 Setup:
 `nsp_id` bigint(20) UNSIGNED DEFAULT NULL,
 `device_type` varchar(255) DEFAULT NULL,
 `physical_network_id` bigint(20) UNSIGNED DEFAULT NULL,
 `host_id` bigint(20) UNSIGNED DEFAULT NULL,

On the 4.2 Upgraded Setup:
 `nsp_id` bigint(20) UNSIGNED NOT NULL,
 `device_type` varchar(255) NOT NULL,
 `physical_network_id` bigint(20) UNSIGNED NOT NULL,
 `host_id` bigint(20) UNSIGNED NOT NULL,

Table 3: netscaler_pod_ref

On ASF 4.2 Setup:
Present on the Setup

Missing on the Upgraded Setup.

Table 4: nicira_nvp_nic_map

On ASF 4.2 Setup:
Constraint:
ALTER TABLE `cloud`.`nicira_nvp_nic_map` ADD CONSTRAINT `fk_nicira_nvp_nic_map__nic`
 FOREIGN KEY ( `nic` ) REFERENCES `nics` ( `uuid` ) ON DELETE CASCADE;

On the 4.2 Upgraded Setup:
No such constraint

Table 5: router_network_ref

On ASF 4.2 Setup:
Constraint:
ALTER TABLE `cloud`.`router_network_ref` ADD CONSTRAINT `fk_router_network_ref__router_id`
 FOREIGN KEY ( `router_id` ) REFERENCES `domain_router` ( `id` ) ON DELETE CASCADE;

On the 4.2 Upgraded Setup:
No such constraint

Table 6: sync_queue

On ASF 4.2 Setup:
  `queue_size` smallint(6) NOT NULL DEFAULT '0',
 `queue_size_limit` smallint(6) NOT NULL DEFAULT '1',

On the 4.2 Upgraded Setup: 
 `queue_size` smallint(6) DEFAULT '0',
 `queue_size_limit` smallint(6) DEFAULT '1',

Table 7: usage_event

On ASF 4.2 Setup:
no virtual_size column

On the 4.2 Upgraded Setup: 
 `virtual_size` bigint(20) UNSIGNED DEFAULT NULL,

Table 8: volumes

On ASF 4.2 Setup:
no iso_id column

On the 4.2 Upgraded Setup: 
 `iso_id` bigint(20) UNSIGNED DEFAULT NULL,

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira