Re: Do not see KVM Hosts after 4.9.3 -> 4.11.2

2019-05-30 Thread Rohit Yadav
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


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 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 agent.log on the KVM (CentOS 7) looks good.  We can see a list of running 
VMs in CloudStack and their Running/Stopped statuses look good.  We can see 
Zones/Pods/Clusters, just not Hosts.  The "Infrastructure" page also correctly 
says "2" in the Host Count.  But when we Click Hosts it just says:

No data to show

Any ideas?

Thanks
Sean






rohit.ya...@shapeblue.comĀ 
www.shapeblue.com
Amadeus House, Floral Street, London  WC2E 9DPUK
@shapeblue
  
 



Re: Do not see KVM Hosts after 4.9.3 -> 4.11.2

2019-05-30 Thread Richard Lawley
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,  wrote:

> 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 agent.log on the KVM (CentOS 7) looks good.  We can see a list of
> running VMs in CloudStack and their Running/Stopped statuses look good.  We
> can see Zones/Pods/Clusters, just not Hosts.  The "Infrastructure" page
> also correctly says "2" in the Host Count.  But when we Click Hosts it just
> says:
>
> No data to show
>
> Any ideas?
>
> Thanks
> Sean
>
>
>
>
>
>


Do not see KVM Hosts after 4.9.3 -> 4.11.2

2019-05-30 Thread Sean Lair
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 agent.log on the KVM (CentOS 7) looks good.  We can see a list of running 
VMs in CloudStack and their Running/Stopped statuses look good.  We can see 
Zones/Pods/Clusters, just not Hosts.  The "Infrastructure" page also correctly 
says "2" in the Host Count.  But when we Click Hosts it just says:

No data to show

Any ideas?

Thanks
Sean