RHEA-2013:0926 - Product Enhancement Advisory

Topic

An updated rhevm-dwh package that fixes various bugs is now available.

Description

The Red Hat Enterprise Virtualization Manager data warehouse package provides
the ETL process and DB scripts to create a historic database API. Enables SQL BI
reports creation for management and monitoring.

This update fixes the following bugs:

• When a virtual machine's IP exceeded 255 characters, it was not reported in

the history database. The virtual machine IP column has been changed to text,
allowing almost unlimited characters. The history database can now be populated
with data for virtual machines with multiple IP addresses. (BZ#953148)

• rhevm-dwh-setup previously failed because of a syntax error in the upgrade

from Red Hat Enterprise Virtualization 3.1 to 3.2 which was not compatible with
PostgreSql 8.4. This syntax error has been fixed, and upgrading from Red Hat
Enterprise Virtualization 3.1 to 3.2 no longer breaks compatibility with
PostgreSQL 8.4 (BZ#892278)

• Previously, no statisitics appeared in Red Hat Enterprise Virtualization

reports in the v3_2_statistics_vms_users_usage report. A patch fixes this, and
statistics now appear in the v3_2_statistics_vms_users_usage report. (BZ#894716)

• The pid (1077) is now displayed in the rhevm-dwhd service message. (BZ#889755)
• Previously, rhevm-dwhd log wrote exceptions logs but showed no events or logs

in the audit_log reports table. The audit_log reports table now contains the
information that is written to the exceptions logs. (BZ#902028)

• The is_auto_suspend field has been removed from Red Hat Enterprise

Virtualization reports. (BZ#885640)

• Previously, upgrading the rhevm-dwh package produced an error which prevented

the database warehouse service from starting. This was caused by a requirement
for the engine service to be running when the rhevm-dwhd was started. This
requirement has been removed, so after the upgrade rhevm-dwh runs as expected.
(BZ#913384)

• Previously, the database incorrectly stored "Mixed" databases (3) as

"Inactive" (2). The webadmin portal displayed the correct value, but the value
was incorrect in the history database in the
statistics_storage_domains_resources_usage_samples field. The database now
stores the correct database status. (BZ#922499)

• rhevm-dwh previously reported the names of SPICE sessions incorrectly. When

reporting the name of the SPICE session, rhevm-dwh previously collected the
value of guest_cur_user_name from the vm_dynamics table, but it should have been
collecting the value of console_curr_username. rhevm-dwh now collects the value
of console_curr_username and reports it as the name of the SPICE session.
(BZ#926952)

• The status field is now used in the history database to display the history of

Storage Domains' statuses. (BZ#846272)

All Red Hat Enterprise Virtualization reports and data warehouse users are
advised to upgrade to this updated package which address these issues.

Solution

Before applying this update, make sure all previously-released errata
relevant to your system have been applied.

Affected Products

• Red Hat Virtualization 3.2 x86_64

Fixes

• BZ - 846272 - PRD32 - [rhevm-dwh] - RFE - Add storage domains status in the History DB
• BZ - 885640 - please remove is_auto_suspend field
• BZ - 889755 - [rhevm-dwh] - Service - Add "pid" string in /etc/init.d/ovirt-engine-dwhd service message [TEXT]
• BZ - 892278 - [ovirt-engine-dwh] dwh-setup fails.
• BZ - 894716 - [rhevm-dwh] - History DB - No Statisitics in hourly and daily tables
• BZ - 902028 - [rhevm-dwh] - Table audit_log - No Logs in table for an exception (Blocks DNS using iptables)
• BZ - 913384 - [rhevm] - Upgrade - Error Can't start the ovirt-engine-dwhd service (Upgrade from si25.4 to si27.1)
• BZ - 921445 - [rhevm-dwh] - Update manifest file for 3.2
• BZ - 922499 - [rhevm-dwh] - History DB - Storage Domain Status "Mixed" is not saved correctly (in statistics_storage_domains_samples)
• BZ - 926952 - [rhevm-dwh] - BR45 - DWH Saves incorrect username for spice session
• BZ - 953148 - ETL does not populate the dwh db.

CVEs

(none)

References

(none)