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/04/01 23:00:30 UTC
Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance
!
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 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
>
>
>
>
>
>