[ovirt-users] No utilization data on Ovirt report 3.4
Yaniv Dary
ydary at redhat.com
Tue Nov 25 15:04:39 UTC 2014
----- Original Message -----
> From: "Scott Worthington" <scott.c.worthington at gmail.com>
> To: "Shirly Radco" <sradco at redhat.com>
> Cc: users at ovirt.org
> Sent: Tuesday, November 25, 2014 4:59:18 PM
> Subject: Re: [ovirt-users] No utilization data on Ovirt report 3.4
>
> On 11/25/2014 5:10 AM, Shirly Radco wrote:
> > Hi Scott, Chandrahasa,
> >
> > Did you manage to resolve this issue?
> >
> > Best regards,
> > ---
> > Shirly Radco
> > BI Software Engineer
> > Red Hat Israel Ltd.
>
> Hello,
>
> Running 3.5.0 DWH and Reports here (not HE, All-in-One).
>
> I have confirmed that data is being collected:
>
> # su - postgres
> $ pgsql ovirt_engine_history
>
> ovirt_engine_history=#
>
> SELECT DISTINCT(vm_disk_id)
> FROM v3_5_statistics_vms_disks_resources_usage_hourly
> ORDER BY vm_disk_id ;
>
> # From above query, I see data is being collected for disks
>
> # From below query, I can see data is being collected for the disks that are
> assigned to the VM guest:
>
> SELECT history_datetime, vm_disk_id , read_rate_bytes_per_second,
> write_rate_bytes_per_second
> FROM v3_5_statistics_vms_disks_resources_usage_hourly
> WHERE vm_disk_id IN
> (
> 'UUID-DISK-A',
> 'UUID-DISK-B',
> 'UUID-DISK-C',
> 'UUID-DISK-D',
> 'UUID-DISK-E',
> 'UUID-DISK-F',
> 'UUID-DISK-G',
> 'UUID-DISK-H',
> 'UUID-DISK-I',
> 'UUID-DISK-J'
> )
> ORDER BY history_datetime, vm_disk_id
> ;
>
> However, in the report "BR10C" "Single Virtual Machine Resources (Hour of
> Day)", the "Top Five Busiest Disks Usage by Hour of Day" reports "No Data
> Available". How do I troubleshoot the report that is creating that table?
>
> The data does exist in v3_5_statistics_vms_disks_resources_usage_hourly. Yes
> -- the VM guest does have ten (10) disks.
The next step is to debug the report. See link:
https://wiki.icinga.org/display/howtos/Debugging+JasperServer
then check logs and you will be able to recreate the query exactly and see why the data is not being displayed.
Yaniv
>
> Thanks in advance.
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
More information about the Users
mailing list