Update on the issue. Thanks Richard for the hint about MariaDB needing an
update (and everyone else that responded). It's crazy, I did a manual select,
mimicking the host_view SQL, and also received zero rows. I modifed the select
statement to remove the LEFT JOIN with last_annotation_view, a
Thank you, it's a very handy tool!
On Thu, Apr 25, 2019 at 05:15:15PM -0400, Khosrow Moossavi wrote:
> Hi Vladimir
>
> You need to build the RPMs *on* CentOS 6 machines to be able to have el6 in
> the name.
> Or as an alternative you can use
> https://khos2ow.github.io/cloudstack-rpm-builder/ whi
Thank you, it has helped me very much!
On Thu, Apr 25, 2019 at 01:59:29PM +0200, Andrija Panic wrote:
> Correct - yes.
>
> Best,
>
> On Thu, 25 Apr 2019 at 13:45, Vladimir Melnik wrote:
>
> > Thank you Andrija! I've pulled the image, started /bin/bash in this
> > contaner, is it an environment
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
