cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Olivier GUIN <olivier.g...@ariasnet.com>
Subject Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Date Sun, 01 Apr 2018 23:00:30 GMT
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 <Dag.Sonstebo@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 <mailto:Dag.Sonstebo@shapeblue.com>
> www.shapeblue.com <http://www.shapeblue.com>
> @shapeblue
>    
>
>    
>
> From: Olivier GUIN <olivier.guin@ariasnet.com <mailto:olivier.guin@ariasnet.com>
>
> Reply-To: "users@cloudstack.apache.org <mailto:users@cloudstack.apache.org> " <users@cloudstack.apache.org
<mailto:users@cloudstack.apache.org> >, "olivier.guin@ariasnet.com <mailto:olivier.guin@ariasnet.com>
" <olivier.guin@ariasnet.com <mailto:olivier.guin@ariasnet.com> >
> Date: Wednesday, 28 March 2018 at 15:35
> To: "users@cloudstack.apache.org <mailto:users@cloudstack.apache.org> " <users@cloudstack.apache.org
<mailto:users@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
>
>   
>
>   <mailto:Dag.Sonstebo@shapeblue.com> Dag.Sonstebo@shapeblue.com
>   <http://www.shapeblue.com> www.shapeblue.com
> @shapeblue
>    
>
>    
>
> From: Olivier GUIN  <mailto:olivier.guin@ariasnet.com> <olivier.guin@ariasnet.com>
> Reply-To:  <mailto:users@cloudstack.apache.org> "users@cloudstack.apache.org" 
<mailto:users@cloudstack.apache.org> <users@cloudstack.apache.org>,  <mailto:olivier.guin@ariasnet.com>
"olivier.guin@ariasnet.com"  <mailto:olivier.guin@ariasnet.com> <olivier.guin@ariasnet.com>
> Date: Wednesday, 28 March 2018 at 14:44
> To:  <mailto:users@cloudstack.apache.org> "users@cloudstack.apache.org"  <mailto:users@cloudstack.apache.org>
<users@cloudstack.apache.org>
> Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
>
>   
>
> Hi,
> CS 411 (Centos7) fresh install advanced zone, xen65
>
> No solution ?
> Look this link : https://cloudbox.wayscom.com/index.php/s/B6dET2yUxYYf8ac
>
> 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  <mailto:daznis@gmail.com> <daznis@gmail.com>
> Sent: quarta-feira, 28 de março de 2018 06:50
> To: users@cloudstack.apache.org <mailto:users@cloudstack.apache.org> ; olivier.guin@ariasnet.com
<mailto: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 <mailto:olivier.guin@ariasnet.com>
  <mailto:olivier.guin@ariasnet.com> <mailto:olivier.guin@ariasnet.com> > wrote:
>   
> Hi,
>   
> Only this table host_view is empty :
>   
> I saw :
> (`host_details`.`name` = 'guest.os.category.id  <http://guest.os.category.id> <http://guest.os.category.id>
')   It's strange no correspondance !
>   
> //-------------------
> select `host`.`id` AS `id`,`host`.`uuid` AS `uuid`,`host`.`name` AS `name`,`host`.`status`
AS `status`,`host`.`disconnected` AS `disconnected`,`host`.`type` AS `type`,`host`.`private_ip_address`
AS `private_ip_address`,`host`.`version` AS `version`,`host`.`hypervisor_type` AS `hypervisor_type`,`host`.`hypervisor_version`
AS `hypervisor_version`,`host`.`capabilities` AS `capabilities`,`host`.`last_ping` AS `last_ping`,`host`.`created`
AS `created`,`host`.`removed` AS `removed`,`host`.`resource_state` AS `resource_state`,`host`.`mgmt_server_id`
AS `mgmt_server_id`,`host`.`cpu_sockets` AS `cpu_sockets`,`host`.`cpus` AS `cpus`,`host`.`speed`
AS `speed`,`host`.`ram` AS `ram`,`cluster`.`id` AS `cluster_id`,`cluster`.`uuid` AS `cluster_uuid`,`cluster`.`name`
AS `cluster_name`,`cluster`.`cluster_type` AS `cluster_type`,`data_center`.`id` AS `data_center_id`,`data_center`.`uuid`
AS `data_center_uuid`,`data_center`.`name` AS `data_center_name`,`data_center`.`networktype`
AS `data_center_type`,`host_pod_ref`.`id` AS `pod_id`,`host_pod_ref`.`uuid` AS `pod_uuid`,`host_pod_ref`.`name`
AS `pod_name`,`host_tags`.`tag` AS `tag`,`guest_os_category`.`id` AS `guest_os_category_id`,`guest_os_category`.`uuid`
AS `guest_os_category_uuid`,`guest_os_category`.`name` AS `guest_os_category_name`,`mem_caps`.`used_capacity`
AS `memory_used_capacity`,`mem_caps`.`reserved_capacity` AS `memory_reserved_capacity`,`cpu_caps`.`used_capacity`
AS `cpu_used_capacity`,`cpu_caps`.`reserved_capacity` AS `cpu_reserved_capacity`,`async_job`.`id`
AS `job_id`,`async_job`.`uuid` AS `job_uuid`,`async_job`.`job_status` AS `job_status`,`async_job`.`account_id`
AS `job_account_id`,`oobm`.`enabled` AS `oobm_enabled`,`oobm`.`power_state` AS `oobm_power_state`,`ha_config`.`enabled`
AS `ha_enabled`,`ha_config`.`ha_state` AS `ha_state`,`ha_config`.`provider` AS `ha_provider`,`last_annotation_view`.`annotation`
AS `annotation`,`last_annotation_view`.`created` AS `last_annotated`,`user`.`username` AS
`username` from (((((((((((((`host` left join `cluster` on((`host`.`cluster_id` = `cluster`.`id`)))
left join `data_center` on((`host`.`data_center_id` = `data_center`.`id`))) left join `host_pod_ref`
on((`host`.`pod_id` = `host_pod_ref`.`id`))) left join `host_details` on(((`host`.`id` = `host_details`.`host_id`)
and (`host_details`.`name` = 'guest.os.category.id  <http://guest.os.category.id> <http://guest.os.category.id>
')))) left join `guest_os_category` on((`guest_os_category`.`id` = cast(`host_details`.`value`
as unsigned)))) left join `host_tags` on((`host_tags`.`host_id` = `host`.`id`))) left join
`op_host_capacity` `mem_caps` on(((`host`.`id` = `mem_caps`.`host_id`) and (`mem_caps`.`capacity_type`
= 0)))) left join `op_host_capacity` `cpu_caps` on(((`host`.`id` = `cpu_caps`.`host_id`) and
(`cpu_caps`.`capacity_type` = 1)))) left join `async_job` on(((`async_job`.`instance_id` =
`host`.`id`) and (`async_job`.`instance_type` = 'Host') and (`async_job`.`job_status` = 0))))
left join `oobm` on((`oobm`.`host_id` = `host`.`id`))) left join `ha_config` on(((`ha_config`.`resource_id`
= `host`.`id`) and (`ha_config`.`resource_type` = 'Host')))) left join `last_annotation_view`
on((`last_annotation_view`.`entity_uuid` = `host`.`uuid`))) left join `user` on((`user`.`uuid`
= `last_annotation_view`.`user_uuid`)))
> //-----------------------
>   
> Regards,
> Olivier
>   
>   
>   
> Le 27/03/2018 à 11:32, Dag Sonstebo a écrit :
>   
> Hi Olivier,
>   
> Have your views populated at all? Can you give us the output of the following mysql query:
>   
> show full tables in cloud where table_type like 'VIEW';
>   
>   
> Regards,
> Dag Sonstebo
> Cloud Architect
> ShapeBlue
>   
> On 27/03/2018, 15:06, "Olivier GUIN"   <mailto:olivier.guin@ariasnet.com> <mailto:olivier.guin@ariasnet.com>
 <mailto:olivier.guin@ariasnet.com> <olivier.guin@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 <mailto:olivier.guin@ariasnet.com>   <mailto:olivier.guin@ariasnet.com>
<mailto:olivier.guin@ariasnet.com>    <mailto:olivier.guin@ariasnet.com> <mailto:olivier.guin@ariasnet.com>
 <mailto:olivier.guin@ariasnet.com> <mailto:olivier.guin@ariasnet.com>
>      
>      
>   
>   
> Dag.Sonstebo@shapeblue.com <mailto:Dag.Sonstebo@shapeblue.com>   <mailto:Dag.Sonstebo@shapeblue.com>
<mailto:Dag.Sonstebo@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
>    
>
>   
>
>   
>



Mime
View raw message