cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Saksham Srivastava <>
Subject [DB-CHANGE] Infrastructure tab fails to load with db exception
Date Wed, 06 Aug 2014 10:06:54 GMT
I remember we used to follow the practice of informing others in case db changes are committed,
but we do not do it anymore.
In case you are on dev setup on master branch post the following commit :
commit b9d834e83854009483f6d061f9996e5ffaa9b883
Author: Nitin Mehta <>
Date:   Tue Aug 5 17:29:34 2014 -0700
CLOUDSTACK-4200: listSystemVMs API and listRouters API should return hypervisor property since
dynamic scaling is not enabled for all the hypervisors and that action can be showed only
for the hypervisors t

Update your database with :

DROP VIEW IF EXISTS `cloud`.`domain_router_view`;
CREATE VIEW `cloud`.`domain_router_view` AS
    select id, name, account_id,
        account.uuid account_uuid,
        account.account_name account_name,
        account.type account_type, domain_id,
        domain.uuid domain_uuid, domain_name,
        domain.path domain_path, project_id,
        projects.uuid project_uuid, project_name,
        vm_instance.uuid uuid,
        vm_instance.created created,
        vm_instance.state state,
        vm_instance.removed removed,
        vm_instance.pod_id pod_id,
        vm_instance.instance_name instance_name,
        host_pod_ref.uuid pod_uuid, data_center_id,
        data_center.uuid data_center_uuid, data_center_name,
        data_center.networktype data_center_type,
        data_center.dns1 dns1,
        data_center.dns2 dns2,
        data_center.ip6_dns1 ip6_dns1,
        data_center.ip6_dns2 ip6_dns2, host_id,
        host.uuid host_uuid, host_name,
        host.cluster_id cluster_id, template_id,
        vm_template.uuid template_uuid, service_offering_id,
        disk_offering.uuid service_offering_uuid, service_offering_name, nic_id,
        nics.uuid nic_uuid,
        nics.network_id network_id,
        nics.ip4_address ip_address,
        nics.ip6_address ip6_address,
        nics.ip6_gateway ip6_gateway,
        nics.ip6_cidr ip6_cidr,
        nics.default_nic is_default_nic,
        nics.gateway gateway,
        nics.netmask netmask,
        nics.mac_address mac_address,
        nics.broadcast_uri broadcast_uri,
        nics.isolation_uri isolation_uri, vpc_id,
        vpc.uuid vpc_uuid,
        networks.uuid network_uuid, network_name,
        networks.network_domain network_domain,
        networks.traffic_type traffic_type,
        networks.guest_type guest_type, job_id,
        async_job.uuid job_uuid,
        async_job.job_status job_status,
        async_job.account_id job_account_id,
        domain_router.template_version template_version,
        domain_router.scripts_version scripts_version,
        domain_router.is_redundant_router is_redundant_router,
        domain_router.redundant_state redundant_state,
        domain_router.stop_pending stop_pending,
        domain_router.role role
           inner join
        `cloud`.`vm_instance` ON =
            inner join
        `cloud`.`account` ON vm_instance.account_id =
            inner join
        `cloud`.`domain` ON vm_instance.domain_id =
            left join
        `cloud`.`host_pod_ref` ON vm_instance.pod_id =
            left join
        `cloud`.`projects` ON projects.project_account_id =
            left join
        `cloud`.`data_center` ON vm_instance.data_center_id =
            left join
        `cloud`.`host` ON vm_instance.host_id =
            left join
        `cloud`.`vm_template` ON vm_instance.vm_template_id =
            left join
       `cloud`.`service_offering` ON vm_instance.service_offering_id =
            left join
        `cloud`.`disk_offering` ON vm_instance.service_offering_id =
            left join
        `cloud`.`nics` ON = nics.instance_id and nics.removed is null
            left join
        `cloud`.`networks` ON nics.network_id =
            left join
        `cloud`.`vpc` ON domain_router.vpc_id = and vpc.removed is null
            left join
        `cloud`.`async_job` ON async_job.instance_id =
            and async_job.instance_type = 'DomainRouter'
        and async_job.job_status = 0;


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message