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 <[email protected]> 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 > > > > [email protected] > www.shapeblue.com > @shapeblue > > > > > *From: *Olivier GUIN <[email protected]> > > > *Reply-To: *"[email protected]" <[email protected]>, " > [email protected]" <[email protected]> > > *Date: *Wednesday, 28 March 2018 at 15:35 > > > *To: *"[email protected]" <[email protected]> > *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 > > > > [email protected] > www.shapeblue.com > @shapeblue > > > > > *From: *Olivier GUIN <[email protected]> > <[email protected]> > *Reply-To: *"[email protected]" <[email protected]> > <[email protected]> <[email protected]>, > "[email protected]" <[email protected]> > <[email protected]> <[email protected]> > *Date: *Wednesday, 28 March 2018 at 14:44 > *To: *"[email protected]" <[email protected]> > <[email protected]> <[email protected]> > *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 <[email protected]> <[email protected]> > > Sent: quarta-feira, 28 de março de 2018 06:50 > > To: [email protected]; [email protected] > > 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 <[email protected] > <mailto:[email protected]> <[email protected]> > 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:[email protected]> > <[email protected]> <[email protected]> > <[email protected]> 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 : [email protected] <mailto:[email protected]> > <[email protected]> <mailto:[email protected]> > <[email protected]> <mailto:[email protected]> > <[email protected]> > > > > > > > > > > [email protected] <mailto:[email protected]> > <[email protected]> > > 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:[email protected]]* > > > * ARIAS Informatique* > Olivier GUIN > Direction > > Tel. : 05 94 31 02 44 > Fax : 09 76 41 08 39 > Mail : [email protected] > Site : www.ariasnet.com > > >
