Hi,
I have reported the same error a while back. I just stopped at host view having no hosts displayed. On Tue, Mar 27, 2018 at 6:45 PM, Olivier GUIN <[email protected]> wrote: > Hi, > > Only this table host_view is empty : > > I saw : > *(`host_details`.`name` = 'guest.os.category.id > <http://guest.os.category.id>') **It's strange no correspondance ! * > > //------------------- > select `host`.`id` AS `id`,`host`.`uuid` AS `uuid`,`host`.`name` AS > `name`,`host`.`status` AS `status`,`host`.`disconnected` AS > `disconnected`,`host`.`type` AS `type`,`host`.`private_ip_address` AS > `private_ip_address`,`host`.`version` AS `version`,`host`.`hypervisor_type` > AS `hypervisor_type`,`host`.`hypervisor_version` AS > `hypervisor_version`,`host`.`capabilities` AS > `capabilities`,`host`.`last_ping` > AS `last_ping`,`host`.`created` AS `created`,`host`.`removed` AS > `removed`,`host`.`resource_state` AS `resource_state`,`host`.`mgmt_server_id` > AS `mgmt_server_id`,`host`.`cpu_sockets` AS `cpu_sockets`,`host`.`cpus` > AS `cpus`,`host`.`speed` AS `speed`,`host`.`ram` AS `ram`,`cluster`.`id` AS > `cluster_id`,`cluster`.`uuid` AS `cluster_uuid`,`cluster`.`name` AS > `cluster_name`,`cluster`.`cluster_type` AS `cluster_type`,`data_center`.`id` > AS `data_center_id`,`data_center`.`uuid` AS > `data_center_uuid`,`data_center`.`name` > AS `data_center_name`,`data_center`.`networktype` AS > `data_center_type`,`host_pod_ref`.`id` AS `pod_id`,`host_pod_ref`.`uuid` > AS `pod_uuid`,`host_pod_ref`.`name` AS `pod_name`,`host_tags`.`tag` AS > `tag`,`guest_os_category`.`id` AS > `guest_os_category_id`,`guest_os_category`.`uuid` > AS `guest_os_category_uuid`,`guest_os_category`.`name` AS > `guest_os_category_name`,`mem_caps`.`used_capacity` AS > `memory_used_capacity`,`mem_caps`.`reserved_capacity` AS > `memory_reserved_capacity`,`cpu_caps`.`used_capacity` AS > `cpu_used_capacity`,`cpu_caps`.`reserved_capacity` AS > `cpu_reserved_capacity`,`async_job`.`id` AS `job_id`,`async_job`.`uuid` > AS `job_uuid`,`async_job`.`job_status` AS > `job_status`,`async_job`.`account_id` > AS `job_account_id`,`oobm`.`enabled` AS `oobm_enabled`,`oobm`.`power_state` > AS `oobm_power_state`,`ha_config`.`enabled` AS > `ha_enabled`,`ha_config`.`ha_state` AS `ha_state`,`ha_config`.`provider` > AS `ha_provider`,`last_annotation_view`.`annotation` AS > `annotation`,`last_annotation_view`.`created` AS > `last_annotated`,`user`.`username` > AS `username` from (((((((((((((`host` left join `cluster` > on((`host`.`cluster_id` = `cluster`.`id`))) left join `data_center` > on((`host`.`data_center_id` = `data_center`.`id`))) left join > `host_pod_ref` on((`host`.`pod_id` = `host_pod_ref`.`id`))) left join > `host_details` on(((`host`.`id` = `host_details`.`host_id`) and* > (`host_details`.`name` = 'guest.os.category.id > <http://guest.os.category.id>')*))) left join `guest_os_category` > on((`guest_os_category`.`id` = cast(`host_details`.`value` as unsigned)))) > left join `host_tags` on((`host_tags`.`host_id` = `host`.`id`))) left join > `op_host_capacity` `mem_caps` on(((`host`.`id` = `mem_caps`.`host_id`) and > (`mem_caps`.`capacity_type` = 0)))) left join `op_host_capacity` `cpu_caps` > on(((`host`.`id` = `cpu_caps`.`host_id`) and (`cpu_caps`.`capacity_type` = > 1)))) left join `async_job` on(((`async_job`.`instance_id` = `host`.`id`) > and (`async_job`.`instance_type` = 'Host') and (`async_job`.`job_status` = > 0)))) left join `oobm` on((`oobm`.`host_id` = `host`.`id`))) left join > `ha_config` on(((`ha_config`.`resource_id` = `host`.`id`) and > (`ha_config`.`resource_type` = 'Host')))) left join `last_annotation_view` > on((`last_annotation_view`.`entity_uuid` = `host`.`uuid`))) left join > `user` on((`user`.`uuid` = `last_annotation_view`.`user_uuid`))) > //----------------------- > > Regards, > Olivier > > > Le 27/03/2018 à 11:32, Dag Sonstebo a écrit : > > Hi Olivier, > > Have your views populated at all? Can you give us the output of the following > mysql query: > > show full tables in cloud where table_type like 'VIEW'; > > > Regards, > Dag Sonstebo > Cloud Architect > ShapeBlue > > On 27/03/2018, 15:06, "Olivier GUIN" <[email protected]> > <[email protected]> wrote: > > Hello, > I have multiple display issues with my new installation of Cloudstack > 4.11. > I can not display the list of hosts! nor their processors! > I can not display the list of systemvms (the cursor searches in a loop!) > > And when I want to migrate an instance on a new hosts I have the error > below: > Index 0, Size 0 > Probably because I have no record in the table. (host_view) > And I have this error message: > / WARN: Received unknown parameters for command listHosts. Unknown > parameters: listall / > And display systemvm: > / WARN: Received unknown parameters for command listSystemVms. Unknown > parameters: listall / > > http://ibb.co/kPWWN7 > > http://ibb.co/mrC2vS > > Can you help me ! > > Regards, > > Olivier GUIN > > > -- > Olivier GUIN > > Mail : [email protected] <mailto:[email protected]> > <[email protected]> > > > > [email protected] www.shapeblue.com53 Chandos Place, Covent Garden, > London WC2N > <https://maps.google.com/?q=53+Chandos+Place,+Covent+Garden,+London++WC2N&entry=gmail&source=g> > 4HSUK > @shapeblue > > > > > > -- > > -- > > * ARI**AS Informatique* > Olivier GUIN > Direction > Tel. : 05 94 31 02 44 > Fax : 09 76 41 08 39 > Mail : [email protected] > Site : www.ariasnet.com >
