cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lotic Lists" <li...@lotic.com.br>
Subject RE: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance !
Date Sat, 31 Mar 2018 19:15:00 GMT
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
  

 

 

-- 


	
	


ARIAS Informatique
Olivier GUIN
Direction


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

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message