Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !

[Olivier GUIN]

Hi,

It's new install, CS 4.11 on CentOS7, I've mariadb cluster
I use my script https://cloudbox.wayscom.com/index.php/s/FHCwWt35fGZk0gD

[root@crtl-1 opt]# mysql --version
mysql  Ver 15.1 Distrib 10.0.34-MariaDB, for Linux (x86_64) using 
readline 5.1
[root@crtl-1 opt]# cat /etc/redhat-release
CentOS Linux release 7.4.1708 (Core)

My cloudstack.repo :
[cloudstack]
name=cloudstack
baseurl=http://cloudstack.apt-get.eu/centos/$releasever/4.11/
enabled=1
gpgcheck=0

For the query, returns nothing  ! also with cloudstack-management 
restart  ...
I deleted the view and restart the request the view is well created but 
still nothing in it!

Regards,
Olivier

Le 28/03/2018 à 11:08, Dag Sonstebo a écrit :

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

dag.sonst...@shapeblue.com
www.shapeblue.com
@shapeblue

*From: *Olivier GUIN <olivier.g...@ariasnet.com>
*Reply-To: *"users@cloudstack.apache.org" 
<users@cloudstack.apache.org>, "olivier.g...@ariasnet.com" 
<olivier.g...@ariasnet.com>
*Date: *Wednesday, 28 March 2018 at 14:44
*To: *"users@cloudstack.apache.org" <users@cloudstack.apache.org>
*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 
<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<daz...@gmail.com> <mailto:daz...@gmail.com>  

    Sent: quarta-feira, 28 de março de 2018 06:50

    To:users@cloudstack.apache.org 
<mailto:users@cloudstack.apache.org>;olivier.g...@ariasnet.com 
<mailto:olivier.g...@ariasnet.com>

    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.

      

      

      

    On Tue, Mar 27, 2018 at 6:45 PM, Olivier GUIN <olivier.g...@ariasnet.com 
<mailto:olivier.g...@ariasnet.com>  <mailto:olivier.g...@ariasnet.com> 
<mailto:olivier.g...@ariasnet.com>  > 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:olivier.g...@ariasnet.com> 
<mailto:olivier.g...@ariasnet.com>  <olivier.g...@ariasnet.com> 
<mailto:olivier.g...@ariasnet.com>  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 :olivier.g...@ariasnet.com <mailto:olivier.g...@ariasnet.com>  
<mailto:olivier.g...@ariasnet.com> <mailto:olivier.g...@ariasnet.com>    
<mailto:olivier.g...@ariasnet.com> <mailto:olivier.g...@ariasnet.com>  
<mailto:olivier.g...@ariasnet.com> <mailto:olivier.g...@ariasnet.com>

         

         

      

      

    dag.sonst...@shapeblue.com <mailto:dag.sonst...@shapeblue.com>  
<mailto:dag.sonst...@shapeblue.com>
    <mailto:dag.sonst...@shapeblue.com>   

    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

       



--
*****
ARI**AS Informatique*
Olivier GUIN
Direction

Tel. :   05 94 31 02 44
Fax :   09 76 41 08 39
Mail : olivier.g...@ariasnet.com <mailto:olivier.g...@ariasnet.com>
Site : www.ariasnet.com <http://www.ariasnet.com>