rted 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 ->
ected...
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 recom
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 schema
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 I
> - 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'@'%' IDENTIF
Sean,
As Rohit hints at this we see this often after upgrades if the following has
occurred:
- 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 g
Sean,
Can you try to drop and recreate host_view, as in your DB:
https://github.com/apache/cloudstack/blob/master/engine/schema/src/main/resources/META-INF/db/schema-41000to41100.sql#L159
Regards,
Rohit Yadav
Software Architect, ShapeBlue
https://www.shapeblue.com
_
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 Lair,
