working as
> expected...
>
> MariaDB bug??
>
>
>
> -Original Message-
> From: Dag Sonstebo [mailto:dag.sonst...@shapeblue.com]
> Sent: Friday, May 31, 2019 4:47 AM
> To: dev@cloudstack.apache.org
> Subject: Re: Do not see KVM Hosts after 4.9.3 -> 4.11.
...
MariaDB bug??
-Original Message-
From: Dag Sonstebo [mailto:dag.sonst...@shapeblue.com]
Sent: Friday, May 31, 2019 4:47 AM
To: dev@cloudstack.apache.org
Subject: Re: Do not see KVM Hosts after 4.9.3 -> 4.11.2
There are known issues with using MariaDB version 10 - I recommend
There are known issues with using MariaDB version 10 - I recommend you stick to
version 5.5 for the foreseeable future, and we have had several cases of people
having to downgrade lately.
The issues you are seeing are most likely down to this Richard - you should not
have to make any DB
I don't believe the issue was related to views as such. When I was
trying to diagnose it earlier in the week I ran the query the view
runs manually, and got the same result. I then started removing
joined tables (even though they were all left joins so should not
matter), and data appeared once
> - You did the upgrade on a newly built MySQL / MariaDB server (keep in mind
> you can not at this point run MariaDB version 10.x)
> - AND you imported database dumps to the new DB servers
> - AND you didn't give 'cloud@%' permissions before the import:
> GRANT ALL ON *.* TO 'cloud'@'%'
Regards,
Rohit Yadav
Software Architect, ShapeBlue
https://www.shapeblue.com
From: Sean Lair
Sent: Friday, May 31, 2019 3:34:18 AM
To: dev@cloudstack.apache.org
Subject: Do not see KVM Hosts after 4.9.3
From: Sean Lair
Sent: Friday, May 31, 2019 3:34:18 AM
To: dev@cloudstack.apache.org
Subject: Do not see KVM Hosts after 4.9.3 -> 4.11.2
After upgrading from 4.9.3 to 4.11.2, we no longer see hosts in the CloudStack
web-interface. Hitting the listHosts API directly also does not ret
Update your database server. We had the same thing this week - updating the
mariadb server fixed it. The problem was the hosts_view which returned no
data, presumably due to a bug. I've also seen someone else mention this
using mysql server instead of mariadb.
On Thu, 30 May 2019, 23:04 Sean
After upgrading from 4.9.3 to 4.11.2, we no longer see hosts in the CloudStack
web-interface. Hitting the listHosts API directly also does not return any
results. It's just an empty list. When looking in the DB we do see the hosts
and there are rows where the version is 4.11.2.0.
The