No utilization data on Ovirt report 3.4
Dear Expert, I have upgraded my ovirt to 3.4, now Ovirt Report portal is opening but I could not see any utilization data. It says no data available. Screen shot attached below. Thanks & Regards Chandrahasa S =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
Hi Chandrahasa, Please provide me with a few details. 1. Is the dwh service running (ovirt-engine-dwhd) ? 2. What version of rpms are installed ? rpm -qa |grep ovirt 3. Is the data collected correctly to the history database? you can check specifically in v3_4_statistics_vms_resources_usage_samples, v3_4_statistics_vms_resources_usage_hourly, v3_4_statistics_vms_resources_usage_daily 4. Can you see other reports? 5. Please attach the dwh and reports logs if you see errors there (at /var/log/) Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. ----- Original Message -----
From: "Chandrahasa S" <chandrahasa.s@tcs.com> To: users@ovirt.org Sent: Wednesday, November 19, 2014 12:17:21 PM Subject: [ovirt-users] No utilization data on Ovirt report 3.4
Dear Expert,
I have upgraded my ovirt to 3.4, now Ovirt Report portal is opening but I could not see any utilization data. It says no data available.
Screen shot attached below.
Thanks & Regards Chandrahasa S
=====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
On 11/19/2014 7:29 AM, Shirly Radco wrote:
Hi Chandrahasa,
Please provide me with a few details.
1. Is the dwh service running (ovirt-engine-dwhd) ?
2. What version of rpms are installed ? rpm -qa |grep ovirt
3. Is the data collected correctly to the history database? you can check specifically in v3_4_statistics_vms_resources_usage_samples, v3_4_statistics_vms_resources_usage_hourly, v3_4_statistics_vms_resources_usage_daily
4. Can you see other reports?
5. Please attach the dwh and reports logs if you see errors there (at /var/log/)
Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd.
I had a similar problem with a fresh install of oVirt 3.5.0 on RHEL 6.6 bare metal. I installed the Engine, then DWH and Reports on the same host. Oddly, reports for Hosts worked, but reports for for Virtual Machines did not collect data (for example, report BR10C = Resource Usage of Virtual Machine --- by Hour of Day). I looked at logs DHW, vdsm, engine, etc logs, and I did not see any errors relating to database connectivity, pollers not collecting data, etc. The service ovirt-engine-dwhd was running. So, yesterday, I made the assumption that perhaps there was a problem with the installer and re-ran "engine-setup". This morning, I checked the report BR10C, and the graphs for "CPU Usage by Hour of Day", "Memory Usage by Hour of Day" now have bar graphs (they work!). However, the "Top Five Busiest Disks Usage by Hour of Day" and "Top Three Businest Network Interfaces Usage" report "No Data Available". The VM does have the oVirt 3.5 guest software installed. How do I troubleshoot the "No Data Available" for 'Disk Usage' and 'Network Interfaces'? Output of my re-running of engine-setup: # engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20141119085759-rah3nk.log Version: otopi-1.3.0 (otopi-1.3.0-1.el6) [ INFO ] Stage: Environment packages setup [ INFO ] Stage: Programs detection [ INFO ] Stage: Environment setup [ INFO ] Stage: Environment customization --== PRODUCT OPTIONS ==-- --== PACKAGES ==-- [ INFO ] Checking for product updates... [ INFO ] No product updates found --== ALL IN ONE CONFIGURATION ==-- --== NETWORK CONFIGURATION ==-- Setup can automatically configure the firewall on this system. Note: automatic configuration of the firewall may overwrite current settings. Do you want Setup to configure the firewall? (Yes, No) [Yes]: No --== DATABASE CONFIGURATION ==-- The detected DWH database size is 99 MB. Setup can backup the existing database. The time and space required for the database backup depend on its size. This process takes time, and in some cases (for instance, when the size is few GBs) may take several hours to complete. If you choose to not back up the database, and Setup later fails for some reason, it will not be able to restore the database and all DWH data will be lost. Would you like to backup the existing database before upgrading it? (Yes, No) [Yes]: Yes --== OVIRT ENGINE CONFIGURATION ==-- Skipping storing options as database already prepared --== PKI CONFIGURATION ==-- --== APACHE CONFIGURATION ==-- --== SYSTEM CONFIGURATION ==-- --== MISC CONFIGURATION ==-- --== END OF CONFIGURATION ==-- [ INFO ] Stage: Setup validation During execution engine service will be stopped (OK, Cancel) [OK]: [WARNING] Less than 16384MB of memory is available [ INFO ] Cleaning stale zombie tasks --== CONFIGURATION PREVIEW ==-- Datacenter storage type : False Firewall manager : iptables Update Firewall : False Host FQDN : ovirt-engine-01.local Engine database name : engine Engine database secured connection : False Engine database host : localhost Engine database user name : engine Engine database host name validation : False Engine database port : 5432 Engine installation : True NFS mount point : /var/lib/exports/iso DWH installation : True DWH database name : ovirt_engine_history DWH database secured connection : False DWH database host : localhost DWH database user name : ovirt_engine_history DWH database host name validation : False Backup DWH database : True DWH database port : 5432 Reports installation : True Reports database name : ovirt_engine_reports Reports database secured connection : False Reports database host : localhost Reports database user name : ovirt_engine_reports Reports database host name validation : False Reports database port : 5432 Engine Host FQDN : ovirt-engine-01.local Configure WebSocket Proxy : True Please confirm installation settings (OK, Cancel) [OK]: [ INFO ] Cleaning async tasks and compensations [ INFO ] Checking the Engine database consistency [ INFO ] Stage: Transaction setup [ INFO ] Stopping dwh service [ INFO ] Stopping reports service [ INFO ] Stopping engine service [ INFO ] Stopping ovirt-fence-kdump-listener service [ INFO ] Stopping websocket-proxy service [ INFO ] Stage: Misc configuration [ INFO ] Stage: Package installation [ INFO ] Stage: Misc configuration [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20141119085842.u1Phs_.dump'. [ INFO ] Creating/refreshing Engine database schema [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20141119085913._kRKcn.dump'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Regenerating Jasper's build configuration files [ INFO ] Exporting data out of Jasper [ INFO ] Backing up database localhost:ovirt_engine_reports to '/var/lib/ovirt-engine-reports/backups/reports-20141119090042.jhX3mx.dump'. [ INFO ] Deploying Jasper [ INFO ] Importing data into Jasper [ INFO ] Configuring Jasper Java resources [ INFO ] Configuring Jasper Database resources [ INFO ] Customizing Jasper [ INFO ] Customizing Jasper metadata [ INFO ] Configuring WebSocket Proxy [ INFO ] Generating post install configuration file '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf' [ INFO ] Stage: Transaction commit [ INFO ] Stage: Closing up --== SUMMARY ==-- [WARNING] Less than 16384MB of memory is available SSH fingerprint: XX:XX:XX... Internal CA XX:XX:XX... Web access is enabled at: http://ovirt-engine-01.local:80/ovirt-engine https://ovirt-engine-01.local:443/ovirt-engine --== END OF SUMMARY ==-- [ INFO ] Starting engine service [ INFO ] Restarting httpd [ INFO ] Starting dwh service [ INFO ] Starting reports service [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20141119085759-rah3nk.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20141119090434-setup.conf' [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ INFO ] Execution of setup completed successfully
Hi, Please try to restart the VM by performing a shut down or power off, power on, and verify that the service is started by running. sudo systemctl status ovirt-guest-agent.service Please update me if the data is now being collected to the history database. You can check v3_6_statistics_vms_resources_usage_hourly view. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. ----- Original Message -----
From: "Scott Worthington" <scott.c.worthington@gmail.com> To: users@ovirt.org Sent: Thursday, November 20, 2014 4:14:07 PM Subject: Re: [ovirt-users] No utilization data on Ovirt report 3.4
On 11/19/2014 7:29 AM, Shirly Radco wrote:
Hi Chandrahasa,
Please provide me with a few details.
1. Is the dwh service running (ovirt-engine-dwhd) ?
2. What version of rpms are installed ? rpm -qa |grep ovirt
3. Is the data collected correctly to the history database? you can check specifically in v3_4_statistics_vms_resources_usage_samples, v3_4_statistics_vms_resources_usage_hourly, v3_4_statistics_vms_resources_usage_daily
4. Can you see other reports?
5. Please attach the dwh and reports logs if you see errors there (at /var/log/)
Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd.
I had a similar problem with a fresh install of oVirt 3.5.0 on RHEL 6.6 bare metal. I installed the Engine, then DWH and Reports on the same host.
Oddly, reports for Hosts worked, but reports for for Virtual Machines did not collect data (for example, report BR10C = Resource Usage of Virtual Machine --- by Hour of Day).
I looked at logs DHW, vdsm, engine, etc logs, and I did not see any errors relating to database connectivity, pollers not collecting data, etc. The service ovirt-engine-dwhd was running.
So, yesterday, I made the assumption that perhaps there was a problem with the installer and re-ran "engine-setup". This morning, I checked the report BR10C, and the graphs for "CPU Usage by Hour of Day", "Memory Usage by Hour of Day" now have bar graphs (they work!).
However, the "Top Five Busiest Disks Usage by Hour of Day" and "Top Three Businest Network Interfaces Usage" report "No Data Available". The VM does have the oVirt 3.5 guest software installed.
How do I troubleshoot the "No Data Available" for 'Disk Usage' and 'Network Interfaces'?
Output of my re-running of engine-setup:
# engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20141119085759-rah3nk.log Version: otopi-1.3.0 (otopi-1.3.0-1.el6) [ INFO ] Stage: Environment packages setup [ INFO ] Stage: Programs detection [ INFO ] Stage: Environment setup [ INFO ] Stage: Environment customization
--== PRODUCT OPTIONS ==--
--== PACKAGES ==--
[ INFO ] Checking for product updates... [ INFO ] No product updates found
--== ALL IN ONE CONFIGURATION ==--
--== NETWORK CONFIGURATION ==--
Setup can automatically configure the firewall on this system. Note: automatic configuration of the firewall may overwrite current settings. Do you want Setup to configure the firewall? (Yes, No) [Yes]: No
--== DATABASE CONFIGURATION ==--
The detected DWH database size is 99 MB. Setup can backup the existing database. The time and space required for the database backup depend on its size. This process takes time, and in some cases (for instance, when the size is few GBs) may take several hours to complete. If you choose to not back up the database, and Setup later fails for some reason, it will not be able to restore the database and all DWH data will be lost. Would you like to backup the existing database before upgrading it? (Yes, No) [Yes]: Yes
--== OVIRT ENGINE CONFIGURATION ==--
Skipping storing options as database already prepared
--== PKI CONFIGURATION ==--
--== APACHE CONFIGURATION ==--
--== SYSTEM CONFIGURATION ==--
--== MISC CONFIGURATION ==--
--== END OF CONFIGURATION ==--
[ INFO ] Stage: Setup validation During execution engine service will be stopped (OK, Cancel) [OK]: [WARNING] Less than 16384MB of memory is available [ INFO ] Cleaning stale zombie tasks
--== CONFIGURATION PREVIEW ==--
Datacenter storage type : False Firewall manager : iptables Update Firewall : False Host FQDN : ovirt-engine-01.local Engine database name : engine Engine database secured connection : False Engine database host : localhost Engine database user name : engine Engine database host name validation : False Engine database port : 5432 Engine installation : True NFS mount point : /var/lib/exports/iso DWH installation : True DWH database name : ovirt_engine_history DWH database secured connection : False DWH database host : localhost DWH database user name : ovirt_engine_history DWH database host name validation : False Backup DWH database : True DWH database port : 5432 Reports installation : True Reports database name : ovirt_engine_reports Reports database secured connection : False Reports database host : localhost Reports database user name : ovirt_engine_reports Reports database host name validation : False Reports database port : 5432 Engine Host FQDN : ovirt-engine-01.local Configure WebSocket Proxy : True
Please confirm installation settings (OK, Cancel) [OK]: [ INFO ] Cleaning async tasks and compensations [ INFO ] Checking the Engine database consistency [ INFO ] Stage: Transaction setup [ INFO ] Stopping dwh service [ INFO ] Stopping reports service [ INFO ] Stopping engine service [ INFO ] Stopping ovirt-fence-kdump-listener service [ INFO ] Stopping websocket-proxy service [ INFO ] Stage: Misc configuration [ INFO ] Stage: Package installation [ INFO ] Stage: Misc configuration [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20141119085842.u1Phs_.dump'. [ INFO ] Creating/refreshing Engine database schema [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20141119085913._kRKcn.dump'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Regenerating Jasper's build configuration files [ INFO ] Exporting data out of Jasper [ INFO ] Backing up database localhost:ovirt_engine_reports to '/var/lib/ovirt-engine-reports/backups/reports-20141119090042.jhX3mx.dump'. [ INFO ] Deploying Jasper [ INFO ] Importing data into Jasper [ INFO ] Configuring Jasper Java resources [ INFO ] Configuring Jasper Database resources [ INFO ] Customizing Jasper [ INFO ] Customizing Jasper metadata [ INFO ] Configuring WebSocket Proxy [ INFO ] Generating post install configuration file '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf' [ INFO ] Stage: Transaction commit [ INFO ] Stage: Closing up
--== SUMMARY ==--
[WARNING] Less than 16384MB of memory is available SSH fingerprint: XX:XX:XX... Internal CA XX:XX:XX... Web access is enabled at: http://ovirt-engine-01.local:80/ovirt-engine https://ovirt-engine-01.local:443/ovirt-engine
--== END OF SUMMARY ==--
[ INFO ] Starting engine service [ INFO ] Restarting httpd [ INFO ] Starting dwh service [ INFO ] Starting reports service [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20141119085759-rah3nk.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20141119090434-setup.conf' [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ INFO ] Execution of setup completed successfully _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Hi Scott, Chandrahasa, Did you manage to resolve this issue? Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. ----- Original Message -----
From: "Shirly Radco" <sradco@redhat.com> To: "Scott Worthington" <scott.c.worthington@gmail.com> Cc: users@ovirt.org Sent: Sunday, November 23, 2014 11:14:05 AM Subject: Re: [ovirt-users] No utilization data on Ovirt report 3.4
Hi,
Please try to restart the VM by performing a shut down or power off, power on, and verify that the service is started by running.
sudo systemctl status ovirt-guest-agent.service
Please update me if the data is now being collected to the history database.
You can check v3_6_statistics_vms_resources_usage_hourly view.
Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd.
----- Original Message -----
From: "Scott Worthington" <scott.c.worthington@gmail.com> To: users@ovirt.org Sent: Thursday, November 20, 2014 4:14:07 PM Subject: Re: [ovirt-users] No utilization data on Ovirt report 3.4
On 11/19/2014 7:29 AM, Shirly Radco wrote:
Hi Chandrahasa,
Please provide me with a few details.
1. Is the dwh service running (ovirt-engine-dwhd) ?
2. What version of rpms are installed ? rpm -qa |grep ovirt
3. Is the data collected correctly to the history database? you can check specifically in v3_4_statistics_vms_resources_usage_samples, v3_4_statistics_vms_resources_usage_hourly, v3_4_statistics_vms_resources_usage_daily
4. Can you see other reports?
5. Please attach the dwh and reports logs if you see errors there (at /var/log/)
Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd.
I had a similar problem with a fresh install of oVirt 3.5.0 on RHEL 6.6 bare metal. I installed the Engine, then DWH and Reports on the same host.
Oddly, reports for Hosts worked, but reports for for Virtual Machines did not collect data (for example, report BR10C = Resource Usage of Virtual Machine --- by Hour of Day).
I looked at logs DHW, vdsm, engine, etc logs, and I did not see any errors relating to database connectivity, pollers not collecting data, etc. The service ovirt-engine-dwhd was running.
So, yesterday, I made the assumption that perhaps there was a problem with the installer and re-ran "engine-setup". This morning, I checked the report BR10C, and the graphs for "CPU Usage by Hour of Day", "Memory Usage by Hour of Day" now have bar graphs (they work!).
However, the "Top Five Busiest Disks Usage by Hour of Day" and "Top Three Businest Network Interfaces Usage" report "No Data Available". The VM does have the oVirt 3.5 guest software installed.
How do I troubleshoot the "No Data Available" for 'Disk Usage' and 'Network Interfaces'?
Output of my re-running of engine-setup:
# engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20141119085759-rah3nk.log Version: otopi-1.3.0 (otopi-1.3.0-1.el6) [ INFO ] Stage: Environment packages setup [ INFO ] Stage: Programs detection [ INFO ] Stage: Environment setup [ INFO ] Stage: Environment customization
--== PRODUCT OPTIONS ==--
--== PACKAGES ==--
[ INFO ] Checking for product updates... [ INFO ] No product updates found
--== ALL IN ONE CONFIGURATION ==--
--== NETWORK CONFIGURATION ==--
Setup can automatically configure the firewall on this system. Note: automatic configuration of the firewall may overwrite current settings. Do you want Setup to configure the firewall? (Yes, No) [Yes]: No
--== DATABASE CONFIGURATION ==--
The detected DWH database size is 99 MB. Setup can backup the existing database. The time and space required for the database backup depend on its size. This process takes time, and in some cases (for instance, when the size is few GBs) may take several hours to complete. If you choose to not back up the database, and Setup later fails for some reason, it will not be able to restore the database and all DWH data will be lost. Would you like to backup the existing database before upgrading it? (Yes, No) [Yes]: Yes
--== OVIRT ENGINE CONFIGURATION ==--
Skipping storing options as database already prepared
--== PKI CONFIGURATION ==--
--== APACHE CONFIGURATION ==--
--== SYSTEM CONFIGURATION ==--
--== MISC CONFIGURATION ==--
--== END OF CONFIGURATION ==--
[ INFO ] Stage: Setup validation During execution engine service will be stopped (OK, Cancel) [OK]: [WARNING] Less than 16384MB of memory is available [ INFO ] Cleaning stale zombie tasks
--== CONFIGURATION PREVIEW ==--
Datacenter storage type : False Firewall manager : iptables Update Firewall : False Host FQDN : ovirt-engine-01.local Engine database name : engine Engine database secured connection : False Engine database host : localhost Engine database user name : engine Engine database host name validation : False Engine database port : 5432 Engine installation : True NFS mount point : /var/lib/exports/iso DWH installation : True DWH database name : ovirt_engine_history DWH database secured connection : False DWH database host : localhost DWH database user name : ovirt_engine_history DWH database host name validation : False Backup DWH database : True DWH database port : 5432 Reports installation : True Reports database name : ovirt_engine_reports Reports database secured connection : False Reports database host : localhost Reports database user name : ovirt_engine_reports Reports database host name validation : False Reports database port : 5432 Engine Host FQDN : ovirt-engine-01.local Configure WebSocket Proxy : True
Please confirm installation settings (OK, Cancel) [OK]: [ INFO ] Cleaning async tasks and compensations [ INFO ] Checking the Engine database consistency [ INFO ] Stage: Transaction setup [ INFO ] Stopping dwh service [ INFO ] Stopping reports service [ INFO ] Stopping engine service [ INFO ] Stopping ovirt-fence-kdump-listener service [ INFO ] Stopping websocket-proxy service [ INFO ] Stage: Misc configuration [ INFO ] Stage: Package installation [ INFO ] Stage: Misc configuration [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20141119085842.u1Phs_.dump'. [ INFO ] Creating/refreshing Engine database schema [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20141119085913._kRKcn.dump'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Regenerating Jasper's build configuration files [ INFO ] Exporting data out of Jasper [ INFO ] Backing up database localhost:ovirt_engine_reports to '/var/lib/ovirt-engine-reports/backups/reports-20141119090042.jhX3mx.dump'. [ INFO ] Deploying Jasper [ INFO ] Importing data into Jasper [ INFO ] Configuring Jasper Java resources [ INFO ] Configuring Jasper Database resources [ INFO ] Customizing Jasper [ INFO ] Customizing Jasper metadata [ INFO ] Configuring WebSocket Proxy [ INFO ] Generating post install configuration file '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf' [ INFO ] Stage: Transaction commit [ INFO ] Stage: Closing up
--== SUMMARY ==--
[WARNING] Less than 16384MB of memory is available SSH fingerprint: XX:XX:XX... Internal CA XX:XX:XX... Web access is enabled at: http://ovirt-engine-01.local:80/ovirt-engine https://ovirt-engine-01.local:443/ovirt-engine
--== END OF SUMMARY ==--
[ INFO ] Starting engine service [ INFO ] Restarting httpd [ INFO ] Starting dwh service [ INFO ] Starting reports service [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20141119085759-rah3nk.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20141119090434-setup.conf' [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ INFO ] Execution of setup completed successfully _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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. Thanks in advance.
----- Original Message -----
From: "Scott Worthington" <scott.c.worthington@gmail.com> To: "Shirly Radco" <sradco@redhat.com> Cc: users@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (4)
-
Chandrahasa S -
Scott Worthington -
Shirly Radco -
Yaniv Dary