You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Olivier GUIN <ol...@ariasnet.com> on 2018/03/27 14:06:16 UTC
CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
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.guin@ariasnet.com <ma...@ariasnet.com>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Posted by Daznis <da...@gmail.com>.
Hello,
I was using a KVM host for my hypervisor. My mariadb version was 10.2.13.
On Wed, Mar 28, 2018 at 10:09 PM, Dag Sonstebo <Da...@shapeblue.com>
wrote:
> Hi Olivier,
>
>
>
> I’ve just spun the same environment as you have up in the lab, using
> CentOS7 management, XS6.5SP1 hypervisors, advanced zone and installing from
> http://cloudstack.apt-get.eu/centos/7/4.11/ , and I can’t reproduce the
> issues you are seeing.
>
> The only difference in my environment is the MariaDB version – and I
> suspect this may be your problem.
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat
> /etc/yum.repos.d/cloudstack.repo | grep http
>
> baseurl=http://cloudstack.apt-get.eu/centos/7/4.11/
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/redhat-release
>
> CentOS Linux release 7.4.1708 (Core)
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# mysql --version
>
> *mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline
> 5.1 <<<< My lab version*
>
> *mysql Ver 15.1 Distrib 10.0.34-MariaDB, for Linux (x86_64) using
> readline 5.1 <<<<<< Your version *
>
>
>
> > SELECT * FROM cloud.version
>
>
>
> + ------- + ------------ + ------------ + --------- +
>
> | id | version | updated | step |
>
> + ------- + ------------ + ------------ + --------- +
>
> | 1 | 4.0.0 | 2018-03-28 18:44:26 | Complete |
>
> | 2 | 4.1.0 | 2018-03-28 18:44:49 | Complete |
>
> …..
>
> | 21 | 4.9.3.0 | 2018-03-28 18:45:02 | Complete |
>
> | 22 | 4.10.0.0 | 2018-03-28 18:45:03 | Complete |
>
> | 23 | 4.11.0.0 | 2018-03-28 18:45:03 | Complete |
>
>
>
> > SELECT * FROM cloud.host_view
>
>
>
> ******************** 1. row *********************
>
> id: 1
>
> uuid: df4cbefc-3dc1-4f41-ac7e-723920808114
>
> name: ref-trl-418-x-cs411-dsonstebo-xs1
>
> status: Up
>
> disconnected:
>
> type: Routing
>
> private_ip_address: removed
>
> version: 4.11.0.0
>
> hypervisor_type: XenServer
>
> hypervisor_version: 6.5.0
>
> capabilities: xen-3.0-x86_64 , xen-3.0-x86_32p ,
> hvm-3.0-x86_32 , hvm-3.0-x86_32p , hvm-3.0-x86_64
>
> last_ping: 1486584835
>
> created: 2018-03-28 18:52:06
>
> removed:
>
> resource_state: Enabled
>
> mgmt_server_id: 7393350059856
>
> cpu_sockets: 3
>
> cpus: 3
>
> speed: 1994
>
> ram: 7427139712
>
> cluster_id: 1
>
> cluster_uuid: 30cb6537-8d6e-4a42-965c-b50c30262a55
>
> cluster_name: p1-c1
>
> cluster_type: CloudManaged
>
> data_center_id: 1
>
> data_center_uuid: 407346a2-4ee3-4fa2-b17f-37f1fa1150df
>
> data_center_name: ref-trl-418-x-cs411-dsonstebo
>
> data_center_type: Advanced
>
> pod_id: 1
>
> pod_uuid: 68481e39-9427-486f-a983-71b36737fae4
>
> pod_name: Pod1
>
> tag: GPU
>
> guest_os_category_id:
>
> guest_os_category_uuid:
>
> guest_os_category_name:
>
> memory_used_capacity: 536870912
>
> memory_reserved_capacity: 0
>
> cpu_used_capacity: 500
>
> cpu_reserved_capacity: 0
>
> job_id:
>
> job_uuid:
>
> job_status:
>
> job_account_id:
>
> oobm_enabled:
>
> oobm_power_state:
>
> ha_enabled:
>
> ha_state:
>
> ha_provider:
>
> annotation:
>
> last_annotated:
>
> username:
>
> ******************** 2. row *********************
>
>
>
>
>
> Regards,
>
> Dag Sonstebo
>
> Cloud Architect
>
> ShapeBlue
>
>
>
> Dag.Sonstebo@shapeblue.com
> www.shapeblue.com
> @shapeblue
>
>
>
>
> *From: *Olivier GUIN <ol...@ariasnet.com>
> *Reply-To: *"users@cloudstack.apache.org" <us...@cloudstack.apache.org>, "
> olivier.guin@ariasnet.com" <ol...@ariasnet.com>
> *Date: *Wednesday, 28 March 2018 at 15:35
>
> *To: *"users@cloudstack.apache.org" <us...@cloudstack.apache.org>
> *Subject: *Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate
> instance !
>
>
>
> 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.Sonstebo@shapeblue.com
> www.shapeblue.com
> @shapeblue
>
>
>
>
> *From: *Olivier GUIN <ol...@ariasnet.com>
> <ol...@ariasnet.com>
> *Reply-To: *"users@cloudstack.apache.org" <us...@cloudstack.apache.org>
> <us...@cloudstack.apache.org> <us...@cloudstack.apache.org>,
> "olivier.guin@ariasnet.com" <ol...@ariasnet.com>
> <ol...@ariasnet.com> <ol...@ariasnet.com>
> *Date: *Wednesday, 28 March 2018 at 14:44
> *To: *"users@cloudstack.apache.org" <us...@cloudstack.apache.org>
> <us...@cloudstack.apache.org> <us...@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
>
> 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 <da...@gmail.com> <da...@gmail.com>
>
> Sent: quarta-feira, 28 de março de 2018 06:50
>
> To: users@cloudstack.apache.org; olivier.guin@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.guin@ariasnet.com <ma...@ariasnet.com> <ol...@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" <ma...@ariasnet.com> <ol...@ariasnet.com> <ol...@ariasnet.com> <ol...@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.guin@ariasnet.com <ma...@ariasnet.com> <ol...@ariasnet.com> <ma...@ariasnet.com> <ol...@ariasnet.com> <ma...@ariasnet.com> <ol...@ariasnet.com>
>
>
>
>
>
>
>
>
>
> Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com> <Da...@shapeblue.com>
>
> www.shapeblue.com <http://www.shapeblue.com> <http://www.shapeblue.com>
>
> 53 Chandos Place, Covent Garden, London <https://maps.google.com/?q=53+Chandos+Place,+Covent+Garden,+London+WC2N&entry=gmail&source=g> 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> <https://maps.google.com/?q=53+Chandos+Place,+Covent+Garden,+London++WC2N&entry=gmail&source=g> 4HSUK
>
> @shapeblue
>
>
>
>
>
>
>
> --
>
> *[image: cid:image001.png@01D3C6BB.2013D130]*
> * ARIAS Informatique*
> Olivier GUIN
> Direction
>
> Tel. : 05 94 31 02 44
> Fax : 09 76 41 08 39
> Mail : olivier.guin@ariasnet.com
> Site : www.ariasnet.com
>
>
>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Posted by ilya musayev <il...@gmail.com>.
I was going to mention same thing.
Try MariaDB 5.5 - which is equivalent to MySQL 5.6
I know we did work to support MySQL 5.7 - but I personally haven’t tested
it and have no experience. I’m not certain what MariaDB equivalent would be.
Also check the output of Catalina.out for SQL related errors.
On Wed, Mar 28, 2018 at 12:10 PM Dag Sonstebo <Da...@shapeblue.com>
wrote:
> Hi Olivier,
>
>
>
> I’ve just spun the same environment as you have up in the lab, using
> CentOS7 management, XS6.5SP1 hypervisors, advanced zone and installing from
> http://cloudstack.apt-get.eu/centos/7/4.11/ , and I can’t reproduce the
> issues you are seeing.
>
> The only difference in my environment is the MariaDB version – and I
> suspect this may be your problem.
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat
> /etc/yum.repos.d/cloudstack.repo | grep http
>
> baseurl=http://cloudstack.apt-get.eu/centos/7/4.11/
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/redhat-release
>
> CentOS Linux release 7.4.1708 (Core)
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# mysql --version
>
> *mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline
> 5.1 <<<< My lab version*
>
> *mysql Ver 15.1 Distrib 10.0.34-MariaDB, for Linux (x86_64) using
> readline 5.1 <<<<<< Your version *
>
>
>
> > SELECT * FROM cloud.version
>
>
>
> + ------- + ------------ + ------------ + --------- +
>
> | id | version | updated | step |
>
> + ------- + ------------ + ------------ + --------- +
>
> | 1 | 4.0.0 | 2018-03-28 18:44:26 | Complete |
>
> | 2 | 4.1.0 | 2018-03-28 18:44:49 | Complete |
>
> …..
>
> | 21 | 4.9.3.0 | 2018-03-28 18:45:02 | Complete |
>
> | 22 | 4.10.0.0 | 2018-03-28 18:45:03 | Complete |
>
> | 23 | 4.11.0.0 | 2018-03-28 18:45:03 | Complete |
>
>
>
> > SELECT * FROM cloud.host_view
>
>
>
> ******************** 1. row *********************
>
> id: 1
>
> uuid: df4cbefc-3dc1-4f41-ac7e-723920808114
>
> name: ref-trl-418-x-cs411-dsonstebo-xs1
>
> status: Up
>
> disconnected:
>
> type: Routing
>
> private_ip_address: removed
>
> version: 4.11.0.0
>
> hypervisor_type: XenServer
>
> hypervisor_version: 6.5.0
>
> capabilities: xen-3.0-x86_64 , xen-3.0-x86_32p ,
> hvm-3.0-x86_32 , hvm-3.0-x86_32p , hvm-3.0-x86_64
>
> last_ping: 1486584835
>
> created: 2018-03-28 18:52:06
>
> removed:
>
> resource_state: Enabled
>
> mgmt_server_id: 7393350059856
>
> cpu_sockets: 3
>
> cpus: 3
>
> speed: 1994
>
> ram: 7427139712
>
> cluster_id: 1
>
> cluster_uuid: 30cb6537-8d6e-4a42-965c-b50c30262a55
>
> cluster_name: p1-c1
>
> cluster_type: CloudManaged
>
> data_center_id: 1
>
> data_center_uuid: 407346a2-4ee3-4fa2-b17f-37f1fa1150df
>
> data_center_name: ref-trl-418-x-cs411-dsonstebo
>
> data_center_type: Advanced
>
> pod_id: 1
>
> pod_uuid: 68481e39-9427-486f-a983-71b36737fae4
>
> pod_name: Pod1
>
> tag: GPU
>
> guest_os_category_id:
>
> guest_os_category_uuid:
>
> guest_os_category_name:
>
> memory_used_capacity: 536870912
>
> memory_reserved_capacity: 0
>
> cpu_used_capacity: 500
>
> cpu_reserved_capacity: 0
>
> job_id:
>
> job_uuid:
>
> job_status:
>
> job_account_id:
>
> oobm_enabled:
>
> oobm_power_state:
>
> ha_enabled:
>
> ha_state:
>
> ha_provider:
>
> annotation:
>
> last_annotated:
>
> username:
>
> ******************** 2. row *********************
>
>
>
>
>
> Regards,
>
> Dag Sonstebo
>
> Cloud Architect
>
> ShapeBlue
>
>
>
> Dag.Sonstebo@shapeblue.com
> www.shapeblue.com
> @shapeblue
>
>
>
>
> *From: *Olivier GUIN <ol...@ariasnet.com>
>
>
> *Reply-To: *"users@cloudstack.apache.org" <us...@cloudstack.apache.org>, "
> olivier.guin@ariasnet.com" <ol...@ariasnet.com>
>
> *Date: *Wednesday, 28 March 2018 at 15:35
>
>
> *To: *"users@cloudstack.apache.org" <us...@cloudstack.apache.org>
> *Subject: *Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate
> instance !
>
>
>
> 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.Sonstebo@shapeblue.com
> www.shapeblue.com
> @shapeblue
>
>
>
>
> *From: *Olivier GUIN <ol...@ariasnet.com>
> <ol...@ariasnet.com>
> *Reply-To: *"users@cloudstack.apache.org" <us...@cloudstack.apache.org>
> <us...@cloudstack.apache.org> <us...@cloudstack.apache.org>,
> "olivier.guin@ariasnet.com" <ol...@ariasnet.com>
> <ol...@ariasnet.com> <ol...@ariasnet.com>
> *Date: *Wednesday, 28 March 2018 at 14:44
> *To: *"users@cloudstack.apache.org" <us...@cloudstack.apache.org>
> <us...@cloudstack.apache.org> <us...@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
>
> 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 <da...@gmail.com> <da...@gmail.com>
>
> Sent: quarta-feira, 28 de março de 2018 06:50
>
> To: users@cloudstack.apache.org; olivier.guin@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.guin@ariasnet.com <ma...@ariasnet.com> <ol...@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" <ma...@ariasnet.com> <ol...@ariasnet.com> <ol...@ariasnet.com> <ol...@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.guin@ariasnet.com <ma...@ariasnet.com> <ol...@ariasnet.com> <ma...@ariasnet.com> <ol...@ariasnet.com> <ma...@ariasnet.com> <ol...@ariasnet.com>
>
>
>
>
>
>
>
>
>
> Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com> <Da...@shapeblue.com>
>
> www.shapeblue.com <http://www.shapeblue.com> <http://www.shapeblue.com>
>
> 53 Chandos Place, Covent Garden, London <https://maps.google.com/?q=53+Chandos+Place,+Covent+Garden,+London+WC2N&entry=gmail&source=g> 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> <https://maps.google.com/?q=53+Chandos+Place,+Covent+Garden,+London++WC2N&entry=gmail&source=g> 4HSUK
>
> @shapeblue
>
>
>
>
>
>
>
> --
>
> *[image: cid:image001.png@01D3C6BB.2013D130]*
>
>
> * ARIAS Informatique*
> Olivier GUIN
> Direction
>
> Tel. : 05 94 31 02 44
> Fax : 09 76 41 08 39
> Mail : olivier.guin@ariasnet.com
> Site : www.ariasnet.com
>
>
>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When
Migrate instance !
Posted by Dag Sonstebo <Da...@shapeblue.com>.
Excellent, glad you both got it sorted.
Regards,
Dag Sonstebo
Cloud Architect
ShapeBlue
On 02/04/2018, 00:00, "Olivier GUIN" <ol...@ariasnet.com> wrote:
Hi Dag,
Ok it's ok with 5.5.56. and new fresh install CentOS 7
I install CS 4.10 to work fine with hostbill not 4.11 .. another problem !
I ok now
Thank's for all
Olivier
Le 31/03/2018 à 16:15, Lotic Lists a écrit :
> Hi Dag.
>
>
>
> You are right, the problem is the mysql version, with 5.5.56 works fine
>
>
>
> Thanks
>
> Marcelo.
>
>
>
> From: Dag Sonstebo <Da...@shapeblue.com>
> Sent: quarta-feira, 28 de março de 2018 16:10
> To: users@cloudstack.apache.org
> Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
>
>
>
> Hi Olivier,
>
>
>
> I’ve just spun the same environment as you have up in the lab, using CentOS7 management, XS6.5SP1 hypervisors, advanced zone and installing from http://cloudstack.apt-get.eu/centos/7/4.11/ , and I can’t reproduce the issues you are seeing.
>
> The only difference in my environment is the MariaDB version – and I suspect this may be your problem.
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/yum.repos.d/cloudstack.repo | grep http
>
> baseurl=http://cloudstack.apt-get.eu/centos/7/4.11/
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/redhat-release
>
> CentOS Linux release 7.4.1708 (Core)
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# mysql --version
>
> mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1 <<<< My lab version
>
> mysql Ver 15.1 Distrib 10.0.34-MariaDB, for Linux (x86_64) using readline 5.1 <<<<<< Your version
>
>
>
>> SELECT * FROM cloud.version
>
>
> + ------- + ------------ + ------------ + --------- +
>
> | id | version | updated | step |
>
> + ------- + ------------ + ------------ + --------- +
>
> | 1 | 4.0.0 | 2018-03-28 18:44:26 | Complete |
>
> | 2 | 4.1.0 | 2018-03-28 18:44:49 | Complete |
>
> …..
>
> | 21 | 4.9.3.0 | 2018-03-28 18:45:02 | Complete |
>
> | 22 | 4.10.0.0 | 2018-03-28 18:45:03 | Complete |
>
> | 23 | 4.11.0.0 | 2018-03-28 18:45:03 | Complete |
>
>
>
>> SELECT * FROM cloud.host_view
>
>
> ******************** 1. row *********************
>
> id: 1
>
> uuid: df4cbefc-3dc1-4f41-ac7e-723920808114
>
> name: ref-trl-418-x-cs411-dsonstebo-xs1
>
> status: Up
>
> disconnected:
>
> type: Routing
>
> private_ip_address: removed
>
> version: 4.11.0.0
>
> hypervisor_type: XenServer
>
> hypervisor_version: 6.5.0
>
> capabilities: xen-3.0-x86_64 , xen-3.0-x86_32p , hvm-3.0-x86_32 , hvm-3.0-x86_32p , hvm-3.0-x86_64
>
> last_ping: 1486584835
>
> created: 2018-03-28 18:52:06
>
> removed:
>
> resource_state: Enabled
>
> mgmt_server_id: 7393350059856
>
> cpu_sockets: 3
>
> cpus: 3
>
> speed: 1994
>
> ram: 7427139712
>
> cluster_id: 1
>
> cluster_uuid: 30cb6537-8d6e-4a42-965c-b50c30262a55
>
> cluster_name: p1-c1
>
> cluster_type: CloudManaged
>
> data_center_id: 1
>
> data_center_uuid: 407346a2-4ee3-4fa2-b17f-37f1fa1150df
>
> data_center_name: ref-trl-418-x-cs411-dsonstebo
>
> data_center_type: Advanced
>
> pod_id: 1
>
> pod_uuid: 68481e39-9427-486f-a983-71b36737fae4
>
> pod_name: Pod1
>
> tag: GPU
>
> guest_os_category_id:
>
> guest_os_category_uuid:
>
> guest_os_category_name:
>
> memory_used_capacity: 536870912
>
> memory_reserved_capacity: 0
>
> cpu_used_capacity: 500
>
> cpu_reserved_capacity: 0
>
> job_id:
>
> job_uuid:
>
> job_status:
>
> job_account_id:
>
> oobm_enabled:
>
> oobm_power_state:
>
> ha_enabled:
>
> ha_state:
>
> ha_provider:
>
> annotation:
>
> last_annotated:
>
> username:
>
> ******************** 2. row *********************
>
>
>
>
>
> Regards,
>
> Dag Sonstebo
>
> Cloud Architect
>
> ShapeBlue
>
>
>
> Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com>
> www.shapeblue.com <http://www.shapeblue.com>
> @shapeblue
>
>
>
>
> From: Olivier GUIN <olivier.guin@ariasnet.com <ma...@ariasnet.com> >
> Reply-To: "users@cloudstack.apache.org <ma...@cloudstack.apache.org> " <users@cloudstack.apache.org <ma...@cloudstack.apache.org> >, "olivier.guin@ariasnet.com <ma...@ariasnet.com> " <olivier.guin@ariasnet.com <ma...@ariasnet.com> >
> Date: Wednesday, 28 March 2018 at 15:35
> To: "users@cloudstack.apache.org <ma...@cloudstack.apache.org> " <users@cloudstack.apache.org <ma...@cloudstack.apache.org> >
> Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
>
>
>
> 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
>
>
>
> <ma...@shapeblue.com> Dag.Sonstebo@shapeblue.com
> <http://www.shapeblue.com> www.shapeblue.com
> @shapeblue
>
>
>
>
> From: Olivier GUIN <ma...@ariasnet.com> <ol...@ariasnet.com>
> Reply-To: <ma...@cloudstack.apache.org> "users@cloudstack.apache.org" <ma...@cloudstack.apache.org> <us...@cloudstack.apache.org>, <ma...@ariasnet.com> "olivier.guin@ariasnet.com" <ma...@ariasnet.com> <ol...@ariasnet.com>
> Date: Wednesday, 28 March 2018 at 14:44
> To: <ma...@cloudstack.apache.org> "users@cloudstack.apache.org" <ma...@cloudstack.apache.org> <us...@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
>
> 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 <ma...@gmail.com> <da...@gmail.com>
> Sent: quarta-feira, 28 de março de 2018 06:50
> To: users@cloudstack.apache.org <ma...@cloudstack.apache.org> ; olivier.guin@ariasnet.com <ma...@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.
>
>
>
>
>
>
>
Dag.Sonstebo@shapeblue.com
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue
> On Tue, Mar 27, 2018 at 6:45 PM, Olivier GUIN <olivier.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@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" <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ol...@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.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com>
>
>
>
>
> Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com> <ma...@shapeblue.com> <ma...@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
>
>
>
>
>
>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance
!
Posted by Olivier GUIN <ol...@ariasnet.com>.
Hi Dag,
Ok it's ok with 5.5.56. and new fresh install CentOS 7
I install CS 4.10 to work fine with hostbill not 4.11 .. another problem !
I ok now
Thank's for all
Olivier
Le 31/03/2018 à 16:15, Lotic Lists a écrit :
> Hi Dag.
>
>
>
> You are right, the problem is the mysql version, with 5.5.56 works fine
>
>
>
> Thanks
>
> Marcelo.
>
>
>
> From: Dag Sonstebo <Da...@shapeblue.com>
> Sent: quarta-feira, 28 de março de 2018 16:10
> To: users@cloudstack.apache.org
> Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
>
>
>
> Hi Olivier,
>
>
>
> I’ve just spun the same environment as you have up in the lab, using CentOS7 management, XS6.5SP1 hypervisors, advanced zone and installing from http://cloudstack.apt-get.eu/centos/7/4.11/ , and I can’t reproduce the issues you are seeing.
>
> The only difference in my environment is the MariaDB version – and I suspect this may be your problem.
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/yum.repos.d/cloudstack.repo | grep http
>
> baseurl=http://cloudstack.apt-get.eu/centos/7/4.11/
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/redhat-release
>
> CentOS Linux release 7.4.1708 (Core)
>
>
>
> [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# mysql --version
>
> mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1 <<<< My lab version
>
> mysql Ver 15.1 Distrib 10.0.34-MariaDB, for Linux (x86_64) using readline 5.1 <<<<<< Your version
>
>
>
>> SELECT * FROM cloud.version
>
>
> + ------- + ------------ + ------------ + --------- +
>
> | id | version | updated | step |
>
> + ------- + ------------ + ------------ + --------- +
>
> | 1 | 4.0.0 | 2018-03-28 18:44:26 | Complete |
>
> | 2 | 4.1.0 | 2018-03-28 18:44:49 | Complete |
>
> …..
>
> | 21 | 4.9.3.0 | 2018-03-28 18:45:02 | Complete |
>
> | 22 | 4.10.0.0 | 2018-03-28 18:45:03 | Complete |
>
> | 23 | 4.11.0.0 | 2018-03-28 18:45:03 | Complete |
>
>
>
>> SELECT * FROM cloud.host_view
>
>
> ******************** 1. row *********************
>
> id: 1
>
> uuid: df4cbefc-3dc1-4f41-ac7e-723920808114
>
> name: ref-trl-418-x-cs411-dsonstebo-xs1
>
> status: Up
>
> disconnected:
>
> type: Routing
>
> private_ip_address: removed
>
> version: 4.11.0.0
>
> hypervisor_type: XenServer
>
> hypervisor_version: 6.5.0
>
> capabilities: xen-3.0-x86_64 , xen-3.0-x86_32p , hvm-3.0-x86_32 , hvm-3.0-x86_32p , hvm-3.0-x86_64
>
> last_ping: 1486584835
>
> created: 2018-03-28 18:52:06
>
> removed:
>
> resource_state: Enabled
>
> mgmt_server_id: 7393350059856
>
> cpu_sockets: 3
>
> cpus: 3
>
> speed: 1994
>
> ram: 7427139712
>
> cluster_id: 1
>
> cluster_uuid: 30cb6537-8d6e-4a42-965c-b50c30262a55
>
> cluster_name: p1-c1
>
> cluster_type: CloudManaged
>
> data_center_id: 1
>
> data_center_uuid: 407346a2-4ee3-4fa2-b17f-37f1fa1150df
>
> data_center_name: ref-trl-418-x-cs411-dsonstebo
>
> data_center_type: Advanced
>
> pod_id: 1
>
> pod_uuid: 68481e39-9427-486f-a983-71b36737fae4
>
> pod_name: Pod1
>
> tag: GPU
>
> guest_os_category_id:
>
> guest_os_category_uuid:
>
> guest_os_category_name:
>
> memory_used_capacity: 536870912
>
> memory_reserved_capacity: 0
>
> cpu_used_capacity: 500
>
> cpu_reserved_capacity: 0
>
> job_id:
>
> job_uuid:
>
> job_status:
>
> job_account_id:
>
> oobm_enabled:
>
> oobm_power_state:
>
> ha_enabled:
>
> ha_state:
>
> ha_provider:
>
> annotation:
>
> last_annotated:
>
> username:
>
> ******************** 2. row *********************
>
>
>
>
>
> Regards,
>
> Dag Sonstebo
>
> Cloud Architect
>
> ShapeBlue
>
>
>
> Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com>
> www.shapeblue.com <http://www.shapeblue.com>
> @shapeblue
>
>
>
>
> From: Olivier GUIN <olivier.guin@ariasnet.com <ma...@ariasnet.com> >
> Reply-To: "users@cloudstack.apache.org <ma...@cloudstack.apache.org> " <users@cloudstack.apache.org <ma...@cloudstack.apache.org> >, "olivier.guin@ariasnet.com <ma...@ariasnet.com> " <olivier.guin@ariasnet.com <ma...@ariasnet.com> >
> Date: Wednesday, 28 March 2018 at 15:35
> To: "users@cloudstack.apache.org <ma...@cloudstack.apache.org> " <users@cloudstack.apache.org <ma...@cloudstack.apache.org> >
> Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
>
>
>
> 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
>
>
>
> <ma...@shapeblue.com> Dag.Sonstebo@shapeblue.com
> <http://www.shapeblue.com> www.shapeblue.com
> @shapeblue
>
>
>
>
> From: Olivier GUIN <ma...@ariasnet.com> <ol...@ariasnet.com>
> Reply-To: <ma...@cloudstack.apache.org> "users@cloudstack.apache.org" <ma...@cloudstack.apache.org> <us...@cloudstack.apache.org>, <ma...@ariasnet.com> "olivier.guin@ariasnet.com" <ma...@ariasnet.com> <ol...@ariasnet.com>
> Date: Wednesday, 28 March 2018 at 14:44
> To: <ma...@cloudstack.apache.org> "users@cloudstack.apache.org" <ma...@cloudstack.apache.org> <us...@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
>
> 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 <ma...@gmail.com> <da...@gmail.com>
> Sent: quarta-feira, 28 de março de 2018 06:50
> To: users@cloudstack.apache.org <ma...@cloudstack.apache.org> ; olivier.guin@ariasnet.com <ma...@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.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@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" <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ol...@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.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com>
>
>
>
>
> Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com> <ma...@shapeblue.com> <ma...@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
>
>
>
>
>
>
RE: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Posted by Lotic Lists <li...@lotic.com.br>.
Hi Dag.
You are right, the problem is the mysql version, with 5.5.56 works fine
Thanks
Marcelo.
From: Dag Sonstebo <Da...@shapeblue.com>
Sent: quarta-feira, 28 de março de 2018 16:10
To: users@cloudstack.apache.org
Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Hi Olivier,
I’ve just spun the same environment as you have up in the lab, using CentOS7 management, XS6.5SP1 hypervisors, advanced zone and installing from http://cloudstack.apt-get.eu/centos/7/4.11/ , and I can’t reproduce the issues you are seeing.
The only difference in my environment is the MariaDB version – and I suspect this may be your problem.
[root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/yum.repos.d/cloudstack.repo | grep http
baseurl=http://cloudstack.apt-get.eu/centos/7/4.11/
[root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/redhat-release
CentOS Linux release 7.4.1708 (Core)
[root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# mysql --version
mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1 <<<< My lab version
mysql Ver 15.1 Distrib 10.0.34-MariaDB, for Linux (x86_64) using readline 5.1 <<<<<< Your version
> SELECT * FROM cloud.version
+ ------- + ------------ + ------------ + --------- +
| id | version | updated | step |
+ ------- + ------------ + ------------ + --------- +
| 1 | 4.0.0 | 2018-03-28 18:44:26 | Complete |
| 2 | 4.1.0 | 2018-03-28 18:44:49 | Complete |
…..
| 21 | 4.9.3.0 | 2018-03-28 18:45:02 | Complete |
| 22 | 4.10.0.0 | 2018-03-28 18:45:03 | Complete |
| 23 | 4.11.0.0 | 2018-03-28 18:45:03 | Complete |
> SELECT * FROM cloud.host_view
******************** 1. row *********************
id: 1
uuid: df4cbefc-3dc1-4f41-ac7e-723920808114
name: ref-trl-418-x-cs411-dsonstebo-xs1
status: Up
disconnected:
type: Routing
private_ip_address: removed
version: 4.11.0.0
hypervisor_type: XenServer
hypervisor_version: 6.5.0
capabilities: xen-3.0-x86_64 , xen-3.0-x86_32p , hvm-3.0-x86_32 , hvm-3.0-x86_32p , hvm-3.0-x86_64
last_ping: 1486584835
created: 2018-03-28 18:52:06
removed:
resource_state: Enabled
mgmt_server_id: 7393350059856
cpu_sockets: 3
cpus: 3
speed: 1994
ram: 7427139712
cluster_id: 1
cluster_uuid: 30cb6537-8d6e-4a42-965c-b50c30262a55
cluster_name: p1-c1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: 407346a2-4ee3-4fa2-b17f-37f1fa1150df
data_center_name: ref-trl-418-x-cs411-dsonstebo
data_center_type: Advanced
pod_id: 1
pod_uuid: 68481e39-9427-486f-a983-71b36737fae4
pod_name: Pod1
tag: GPU
guest_os_category_id:
guest_os_category_uuid:
guest_os_category_name:
memory_used_capacity: 536870912
memory_reserved_capacity: 0
cpu_used_capacity: 500
cpu_reserved_capacity: 0
job_id:
job_uuid:
job_status:
job_account_id:
oobm_enabled:
oobm_power_state:
ha_enabled:
ha_state:
ha_provider:
annotation:
last_annotated:
username:
******************** 2. row *********************
Regards,
Dag Sonstebo
Cloud Architect
ShapeBlue
Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com>
www.shapeblue.com <http://www.shapeblue.com>
@shapeblue
From: Olivier GUIN <olivier.guin@ariasnet.com <ma...@ariasnet.com> >
Reply-To: "users@cloudstack.apache.org <ma...@cloudstack.apache.org> " <users@cloudstack.apache.org <ma...@cloudstack.apache.org> >, "olivier.guin@ariasnet.com <ma...@ariasnet.com> " <olivier.guin@ariasnet.com <ma...@ariasnet.com> >
Date: Wednesday, 28 March 2018 at 15:35
To: "users@cloudstack.apache.org <ma...@cloudstack.apache.org> " <users@cloudstack.apache.org <ma...@cloudstack.apache.org> >
Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
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
<ma...@shapeblue.com> Dag.Sonstebo@shapeblue.com
<http://www.shapeblue.com> www.shapeblue.com
@shapeblue
From: Olivier GUIN <ma...@ariasnet.com> <ol...@ariasnet.com>
Reply-To: <ma...@cloudstack.apache.org> "users@cloudstack.apache.org" <ma...@cloudstack.apache.org> <us...@cloudstack.apache.org>, <ma...@ariasnet.com> "olivier.guin@ariasnet.com" <ma...@ariasnet.com> <ol...@ariasnet.com>
Date: Wednesday, 28 March 2018 at 14:44
To: <ma...@cloudstack.apache.org> "users@cloudstack.apache.org" <ma...@cloudstack.apache.org> <us...@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
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 <ma...@gmail.com> <da...@gmail.com>
Sent: quarta-feira, 28 de março de 2018 06:50
To: users@cloudstack.apache.org <ma...@cloudstack.apache.org> ; olivier.guin@ariasnet.com <ma...@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.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@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" <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ol...@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.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com>
Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com> <ma...@shapeblue.com> <ma...@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
--
ARIAS Informatique
Olivier GUIN
Direction
Tel. : 05 94 31 02 44
Fax : 09 76 41 08 39
Mail : <ma...@ariasnet.com> olivier.guin@ariasnet.com
Site : <http://www.ariasnet.com> www.ariasnet.com
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When
Migrate instance !
Posted by Dag Sonstebo <Da...@shapeblue.com>.
Hi Olivier,
I’ve just spun the same environment as you have up in the lab, using CentOS7 management, XS6.5SP1 hypervisors, advanced zone and installing from http://cloudstack.apt-get.eu/centos/7/4.11/ , and I can’t reproduce the issues you are seeing.
The only difference in my environment is the MariaDB version – and I suspect this may be your problem.
[root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/yum.repos.d/cloudstack.repo | grep http
baseurl=http://cloudstack.apt-get.eu/centos/7/4.11/
[root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/redhat-release
CentOS Linux release 7.4.1708 (Core)
[root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# mysql --version
mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1 <<<< My lab version
mysql Ver 15.1 Distrib 10.0.34-MariaDB, for Linux (x86_64) using readline 5.1 <<<<<< Your version
> SELECT * FROM cloud.version
+ ------- + ------------ + ------------ + --------- +
| id | version | updated | step |
+ ------- + ------------ + ------------ + --------- +
| 1 | 4.0.0 | 2018-03-28 18:44:26 | Complete |
| 2 | 4.1.0 | 2018-03-28 18:44:49 | Complete |
…..
| 21 | 4.9.3.0 | 2018-03-28 18:45:02 | Complete |
| 22 | 4.10.0.0 | 2018-03-28 18:45:03 | Complete |
| 23 | 4.11.0.0 | 2018-03-28 18:45:03 | Complete |
> SELECT * FROM cloud.host_view
******************** 1. row *********************
id: 1
uuid: df4cbefc-3dc1-4f41-ac7e-723920808114
name: ref-trl-418-x-cs411-dsonstebo-xs1
status: Up
disconnected:
type: Routing
private_ip_address: removed
version: 4.11.0.0
hypervisor_type: XenServer
hypervisor_version: 6.5.0
capabilities: xen-3.0-x86_64 , xen-3.0-x86_32p , hvm-3.0-x86_32 , hvm-3.0-x86_32p , hvm-3.0-x86_64
last_ping: 1486584835
created: 2018-03-28 18:52:06
removed:
resource_state: Enabled
mgmt_server_id: 7393350059856
cpu_sockets: 3
cpus: 3
speed: 1994
ram: 7427139712
cluster_id: 1
cluster_uuid: 30cb6537-8d6e-4a42-965c-b50c30262a55
cluster_name: p1-c1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: 407346a2-4ee3-4fa2-b17f-37f1fa1150df
data_center_name: ref-trl-418-x-cs411-dsonstebo
data_center_type: Advanced
pod_id: 1
pod_uuid: 68481e39-9427-486f-a983-71b36737fae4
pod_name: Pod1
tag: GPU
guest_os_category_id:
guest_os_category_uuid:
guest_os_category_name:
memory_used_capacity: 536870912
memory_reserved_capacity: 0
cpu_used_capacity: 500
cpu_reserved_capacity: 0
job_id:
job_uuid:
job_status:
job_account_id:
oobm_enabled:
oobm_power_state:
ha_enabled:
ha_state:
ha_provider:
annotation:
last_annotated:
username:
******************** 2. row *********************
Regards,
Dag Sonstebo
Cloud Architect
ShapeBlue
From: Olivier GUIN <ol...@ariasnet.com>
Reply-To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>, "olivier.guin@ariasnet.com" <ol...@ariasnet.com>
Date: Wednesday, 28 March 2018 at 15:35
To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>
Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
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.Sonstebo@shapeblue.com<ma...@shapeblue.com>
www.shapeblue.com<http://www.shapeblue.com>
@shapeblue
From: Olivier GUIN <ol...@ariasnet.com>
Reply-To: "users@cloudstack.apache.org"<ma...@cloudstack.apache.org> <us...@cloudstack.apache.org>, "olivier.guin@ariasnet.com"<ma...@ariasnet.com> <ol...@ariasnet.com>
Date: Wednesday, 28 March 2018 at 14:44
To: "users@cloudstack.apache.org"<ma...@cloudstack.apache.org> <us...@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
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 <da...@gmail.com>
Sent: quarta-feira, 28 de março de 2018 06:50
To: users@cloudstack.apache.org<ma...@cloudstack.apache.org>; olivier.guin@ariasnet.com<ma...@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.
Dag.Sonstebo@shapeblue.com
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue
On Tue, Mar 27, 2018 at 6:45 PM, Olivier GUIN <ol...@ariasnet.com> <ma...@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" <ma...@ariasnet.com> <ol...@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.guin@ariasnet.com<ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com>
Dag.Sonstebo@shapeblue.com<ma...@shapeblue.com> <ma...@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
--
[cid:image001.png@01D3C6BB.2013D130]
ARIAS Informatique
Olivier GUIN
Direction
Tel. : 05 94 31 02 44
Fax : 09 76 41 08 39
Mail : olivier.guin@ariasnet.com<ma...@ariasnet.com>
Site : www.ariasnet.com<http://www.ariasnet.com>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance
!
Posted by Olivier GUIN <ol...@ariasnet.com>.
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.Sonstebo@shapeblue.com
> www.shapeblue.com
> @shapeblue
>
> *From: *Olivier GUIN <ol...@ariasnet.com>
> *Reply-To: *"users@cloudstack.apache.org"
> <us...@cloudstack.apache.org>, "olivier.guin@ariasnet.com"
> <ol...@ariasnet.com>
> *Date: *Wednesday, 28 March 2018 at 14:44
> *To: *"users@cloudstack.apache.org" <us...@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<da...@gmail.com> <ma...@gmail.com>
>
> Sent: quarta-feira, 28 de março de 2018 06:50
>
> To:users@cloudstack.apache.org <ma...@cloudstack.apache.org>;olivier.guin@ariasnet.com <ma...@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.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@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"<ma...@ariasnet.com> <ma...@ariasnet.com> <ol...@ariasnet.com> <ma...@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.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com>
>
>
>
>
>
>
>
>
>
> Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com> <ma...@shapeblue.com>
> <ma...@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.guin@ariasnet.com <ma...@ariasnet.com>
Site : www.ariasnet.com <http://www.ariasnet.com>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When
Migrate instance !
Posted by Dag Sonstebo <Da...@shapeblue.com>.
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 <ol...@ariasnet.com>
Reply-To: "users@cloudstack.apache.org" <us...@cloudstack.apache.org>, "olivier.guin@ariasnet.com" <ol...@ariasnet.com>
Date: Wednesday, 28 March 2018 at 14:44
To: "users@cloudstack.apache.org" <us...@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
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 <da...@gmail.com>
Sent: quarta-feira, 28 de março de 2018 06:50
To: users@cloudstack.apache.org<ma...@cloudstack.apache.org>; olivier.guin@ariasnet.com<ma...@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.
Dag.Sonstebo@shapeblue.com
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue
On Tue, Mar 27, 2018 at 6:45 PM, Olivier GUIN <ol...@ariasnet.com> <ma...@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" <ma...@ariasnet.com> <ol...@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.guin@ariasnet.com<ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com>
Dag.Sonstebo@shapeblue.com<ma...@shapeblue.com> <ma...@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
--
--
[cid:image001.png@01D3C6A6.93A9B5C0]
ARIAS Informatique
Olivier GUIN
Direction
Tel. : 05 94 31 02 44
Fax : 09 76 41 08 39
Mail : olivier.guin@ariasnet.com<ma...@ariasnet.com>
Site : www.ariasnet.com<http://www.ariasnet.com>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance
!
Posted by Olivier GUIN <ol...@ariasnet.com>.
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 <da...@gmail.com>
> Sent: quarta-feira, 28 de março de 2018 06:50
> To: users@cloudstack.apache.org; olivier.guin@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.guin@ariasnet.com <ma...@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> ') 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" <ma...@ariasnet.com> <ol...@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.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com>
>
>
>
>
> Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com>
> 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> 4HSUK
> @shapeblue
>
>
>
>
>
>
--
--
*****
ARI**AS Informatique*
Olivier GUIN
Direction
Tel. : 05 94 31 02 44
Fax : 09 76 41 08 39
Mail : olivier.guin@ariasnet.com <ma...@ariasnet.com>
Site : www.ariasnet.com <http://www.ariasnet.com>
RE: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Posted by Lotic Lists <li...@lotic.com.br>.
Same error when creating new advanced zone on fresh install, stage “Adding Hosts”
Regards
Lotic
From: Daznis <da...@gmail.com>
Sent: quarta-feira, 28 de março de 2018 06:50
To: users@cloudstack.apache.org; olivier.guin@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.guin@ariasnet.com <ma...@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> ') 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" <ma...@ariasnet.com> <ol...@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.guin@ariasnet.com <ma...@ariasnet.com> <ma...@ariasnet.com> <ma...@ariasnet.com>
Dag.Sonstebo@shapeblue.com <ma...@shapeblue.com>
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> 4HSUK
@shapeblue
--
--
ARIAS Informatique
Olivier GUIN
Direction
Tel. : 05 94 31 02 44
Fax : 09 76 41 08 39
Mail : olivier.guin@ariasnet.com <ma...@ariasnet.com>
Site : www.ariasnet.com <http://www.ariasnet.com>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Posted by Daznis <da...@gmail.com>.
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 <ol...@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>') **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" <ol...@ariasnet.com> <ol...@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.guin@ariasnet.com <ma...@ariasnet.com> <ol...@ariasnet.com>
>
>
>
> Dag.Sonstebo@shapeblue.com 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 : olivier.guin@ariasnet.com
> Site : www.ariasnet.com
>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance
!
Posted by Olivier GUIN <ol...@ariasnet.com>.
Hi,
Only this table host_view is empty :
I saw :
/(`host_details`.`name` = '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')*))) 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" <ol...@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.guin@ariasnet.com <ma...@ariasnet.com>
>
>
>
>
> Dag.Sonstebo@shapeblue.com
> www.shapeblue.com
> 53 Chandos Place, Covent Garden, London WC2N 4HSUK
> @shapeblue
>
>
>
--
--
*****
ARI**AS Informatique*
Olivier GUIN
Direction
Tel. : 05 94 31 02 44
Fax : 09 76 41 08 39
Mail : olivier.guin@ariasnet.com <ma...@ariasnet.com>
Site : www.ariasnet.com <http://www.ariasnet.com>
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When
Migrate instance !
Posted by Dag Sonstebo <Da...@shapeblue.com>.
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" <ol...@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.guin@ariasnet.com <ma...@ariasnet.com>
Dag.Sonstebo@shapeblue.com
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue