cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Tutkowski <mike.tutkow...@solidfire.com>
Subject Re: [DB-CHANGE] Infrastructure tab fails to load with db exception
Date Wed, 06 Aug 2014 15:25:47 GMT
Thanks for sending this out! These can be really helpful.


On Wed, Aug 6, 2014 at 4:06 AM, Saksham Srivastava <
saksham.srivastava@citrix.com> wrote:

> 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 <nitin.mehta@citrix.com>
> 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
>         vm_instance.id id,
>         vm_instance.name name,
>         account.id account_id,
>         account.uuid account_uuid,
>         account.account_name account_name,
>         account.type account_type,
>         domain.id domain_id,
>         domain.uuid domain_uuid,
>         domain.name domain_name,
>         domain.path domain_path,
>         projects.id project_id,
>         projects.uuid project_uuid,
>         projects.name 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_id,
>         data_center.uuid data_center_uuid,
>         data_center.name 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_id,
>         host.uuid host_uuid,
>         host.name host_name,
>        host.hypervisor_type,
>         host.cluster_id cluster_id,
>         vm_template.id template_id,
>         vm_template.uuid template_uuid,
>         service_offering.id service_offering_id,
>         disk_offering.uuid service_offering_uuid,
>         disk_offering.name service_offering_name,
>         nics.id 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_id,
>         vpc.uuid vpc_uuid,
>         networks.uuid network_uuid,
>         networks.name network_name,
>         networks.network_domain network_domain,
>         networks.traffic_type traffic_type,
>         networks.guest_type guest_type,
>         async_job.id 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
>     from
>         `cloud`.`domain_router`
>            inner join
>         `cloud`.`vm_instance` ON vm_instance.id = domain_router.id
>             inner join
>         `cloud`.`account` ON vm_instance.account_id = account.id
>             inner join
>         `cloud`.`domain` ON vm_instance.domain_id = domain.id
>             left join
>         `cloud`.`host_pod_ref` ON vm_instance.pod_id = host_pod_ref.id
>             left join
>         `cloud`.`projects` ON projects.project_account_id = account.id
>             left join
>         `cloud`.`data_center` ON vm_instance.data_center_id =
> data_center.id
>             left join
>         `cloud`.`host` ON vm_instance.host_id = host.id
>             left join
>         `cloud`.`vm_template` ON vm_instance.vm_template_id =
> vm_template.id
>             left join
>        `cloud`.`service_offering` ON vm_instance.service_offering_id =
> service_offering.id
>             left join
>         `cloud`.`disk_offering` ON vm_instance.service_offering_id =
> disk_offering.id
>             left join
>         `cloud`.`nics` ON vm_instance.id = nics.instance_id and
> nics.removed is null
>             left join
>         `cloud`.`networks` ON nics.network_id = networks.id
>             left join
>         `cloud`.`vpc` ON domain_router.vpc_id = vpc.id and vpc.removed is
> null
>             left join
>         `cloud`.`async_job` ON async_job.instance_id = vm_instance.id
>             and async_job.instance_type = 'DomainRouter'
>         and async_job.job_status = 0;
>
>
>
> Thanks,
> Saksham
>



-- 
*Mike Tutkowski*
*Senior CloudStack Developer, SolidFire Inc.*
e: mike.tutkowski@solidfire.com
o: 303.746.7302
Advancing the way the world uses the cloud
<http://solidfire.com/solution/overview/?video=play>*™*

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