Olivier / all,
The view looks odd – can you give us some background – is this a new
installation + what repo did you use?
Checking an installation from our own repo I have the following – can you run
the query and see if this returns anything?
CREATE
ALGORITHM = UNDEFINED
DEFINER = `cloud`@`%`
SQL SECURITY DEFINER
VIEW `cloud`.`host_view` AS
SELECT
`cloud`.`host`.`id` AS `id`,
`cloud`.`host`.`uuid` AS `uuid`,
`cloud`.`host`.`name` AS `name`,
`cloud`.`host`.`status` AS `status`,
`cloud`.`host`.`disconnected` AS `disconnected`,
`cloud`.`host`.`type` AS `type`,
`cloud`.`host`.`private_ip_address` AS `private_ip_address`,
`cloud`.`host`.`version` AS `version`,
`cloud`.`host`.`hypervisor_type` AS `hypervisor_type`,
`cloud`.`host`.`hypervisor_version` AS `hypervisor_version`,
`cloud`.`host`.`capabilities` AS `capabilities`,
`cloud`.`host`.`last_ping` AS `last_ping`,
`cloud`.`host`.`created` AS `created`,
`cloud`.`host`.`removed` AS `removed`,
`cloud`.`host`.`resource_state` AS `resource_state`,
`cloud`.`host`.`mgmt_server_id` AS `mgmt_server_id`,
`cloud`.`host`.`cpu_sockets` AS `cpu_sockets`,
`cloud`.`host`.`cpus` AS `cpus`,
`cloud`.`host`.`speed` AS `speed`,
`cloud`.`host`.`ram` AS `ram`,
`cloud`.`cluster`.`id` AS `cluster_id`,
`cloud`.`cluster`.`uuid` AS `cluster_uuid`,
`cloud`.`cluster`.`name` AS `cluster_name`,
`cloud`.`cluster`.`cluster_type` AS `cluster_type`,
`cloud`.`data_center`.`id` AS `data_center_id`,
`cloud`.`data_center`.`uuid` AS `data_center_uuid`,
`cloud`.`data_center`.`name` AS `data_center_name`,
`cloud`.`data_center`.`networktype` AS `data_center_type`,
`cloud`.`host_pod_ref`.`id` AS `pod_id`,
`cloud`.`host_pod_ref`.`uuid` AS `pod_uuid`,
`cloud`.`host_pod_ref`.`name` AS `pod_name`,
`cloud`.`host_tags`.`tag` AS `tag`,
`cloud`.`guest_os_category`.`id` AS `guest_os_category_id`,
`cloud`.`guest_os_category`.`uuid` AS `guest_os_category_uuid`,
`cloud`.`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`,
`cloud`.`async_job`.`id` AS `job_id`,
`cloud`.`async_job`.`uuid` AS `job_uuid`,
`cloud`.`async_job`.`job_status` AS `job_status`,
`cloud`.`async_job`.`account_id` AS `job_account_id`,
`cloud`.`oobm`.`enabled` AS `oobm_enabled`,
`cloud`.`oobm`.`power_state` AS `oobm_power_state`,
`cloud`.`ha_config`.`enabled` AS `ha_enabled`,
`cloud`.`ha_config`.`ha_state` AS `ha_state`,
`cloud`.`ha_config`.`provider` AS `ha_provider`,
`last_annotation_view`.`annotation` AS `annotation`,
`last_annotation_view`.`created` AS `last_annotated`,
`cloud`.`user`.`username` AS `username`
FROM
(((((((((((((`cloud`.`host`
LEFT JOIN `cloud`.`cluster` ON ((`cloud`.`host`.`cluster_id` =
`cloud`.`cluster`.`id`)))
LEFT JOIN `cloud`.`data_center` ON ((`cloud`.`host`.`data_center_id` =
`cloud`.`data_center`.`id`)))
LEFT JOIN `cloud`.`host_pod_ref` ON ((`cloud`.`host`.`pod_id` =
`cloud`.`host_pod_ref`.`id`)))
LEFT JOIN `cloud`.`host_details` ON (((`cloud`.`host`.`id` =
`cloud`.`host_details`.`host_id`)
AND (`cloud`.`host_details`.`name` = 'guest.os.category.id'))))
LEFT JOIN `cloud`.`guest_os_category` ON
((`cloud`.`guest_os_category`.`id` = CAST(`cloud`.`host_details`.`value` AS
UNSIGNED))))
LEFT JOIN `cloud`.`host_tags` ON ((`cloud`.`host_tags`.`host_id` =
`cloud`.`host`.`id`)))
LEFT JOIN `cloud`.`op_host_capacity` `mem_caps` ON
(((`cloud`.`host`.`id` = `mem_caps`.`host_id`)
AND (`mem_caps`.`capacity_type` = 0))))
LEFT JOIN `cloud`.`op_host_capacity` `cpu_caps` ON
(((`cloud`.`host`.`id` = `cpu_caps`.`host_id`)
AND (`cpu_caps`.`capacity_type` = 1))))
LEFT JOIN `cloud`.`async_job` ON (((`cloud`.`async_job`.`instance_id` =
`cloud`.`host`.`id`)
AND (`cloud`.`async_job`.`instance_type` = 'Host')
AND (`cloud`.`async_job`.`job_status` = 0))))
LEFT JOIN `cloud`.`oobm` ON ((`cloud`.`oobm`.`host_id` =
`cloud`.`host`.`id`)))
LEFT JOIN `cloud`.`ha_config` ON (((`cloud`.`ha_config`.`resource_id` =
`cloud`.`host`.`id`)
AND (`cloud`.`ha_config`.`resource_type` = 'Host'))))
LEFT JOIN `cloud`.`last_annotation_view` ON
((`last_annotation_view`.`entity_uuid` = `cloud`.`host`.`uuid`)))
LEFT JOIN `cloud`.`user` ON ((`cloud`.`user`.`uuid` =
`last_annotation_view`.`user_uuid`)))
Regards,
Dag Sonstebo
Cloud Architect
ShapeBlue
From: Olivier GUIN <[email protected]>
Reply-To: "[email protected]" <[email protected]>,
"[email protected]" <[email protected]>
Date: Wednesday, 28 March 2018 at 14:44
To: "[email protected]" <[email protected]>
Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Hi,
CS 411 (Centos7) fresh install advanced zone, xen65
No solution ?
Look this link : https://cloudbox.wayscom.com/index.php/s/B6dET2yUxYYf8ac
It's a video to show this problem !
Regards,
Olivier
Le 28/03/2018 à 09:06, Lotic Lists a écrit :
Same error when creating new advanced zone on fresh install, stage “Adding
Hosts”
Regards
Lotic
From: Daznis <[email protected]><mailto:[email protected]>
Sent: quarta-feira, 28 de março de 2018 06:50
To: [email protected]<mailto:[email protected]>;
[email protected]<mailto:[email protected]>
Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Hi,
I have reported the same error a while back. I just stopped at host view having
no hosts displayed.
[email protected]
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue
On Tue, Mar 27, 2018 at 6:45 PM, Olivier GUIN
<[email protected]<mailto:[email protected]>
<mailto:[email protected]><mailto:[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><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><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"
<mailto:[email protected]><mailto:[email protected]>
<[email protected]><mailto:[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]>
<mailto:[email protected]><mailto:[email protected]>
<mailto:[email protected]><mailto:[email protected]>
<mailto:[email protected]><mailto:[email protected]>
[email protected]<mailto:[email protected]>
<mailto:[email protected]><mailto:[email protected]>
www.shapeblue.com<http://www.shapeblue.com>
<http://www.shapeblue.com><http://www.shapeblue.com>
53 Chandos Place, Covent Garden, London WC2N
<https://maps.google.com/?q=53+Chandos+Place,+Covent+Garden,+London++WC2N&entry=gmail&source=g><https://maps.google.com/?q=53+Chandos+Place,+Covent+Garden,+London++WC2N&entry=gmail&source=g>
4HSUK
@shapeblue
--
--
[cid:[email protected]]
ARIAS Informatique
Olivier GUIN
Direction
Tel. : 05 94 31 02 44
Fax : 09 76 41 08 39
Mail : [email protected]<mailto:[email protected]>
Site : www.ariasnet.com<http://www.ariasnet.com>
