Bug 1541924 - Ovirt-engine-dwh fails to collect statistics due to high number in database sequences.
Summary: Ovirt-engine-dwh fails to collect statistics due to high number in database s...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh
Version: 4.2.1
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ovirt-4.2.2
: ---
Assignee: Shirly Radco
QA Contact: Lucie Leistnerova
URL:
Whiteboard:
Depends On:
Blocks: 1631202
TreeView+ depends on / blocked
 
Reported: 2018-02-05 08:42 UTC by Roman Hodain
Modified: 2021-03-11 20:07 UTC (History)
9 users (show)

Fixed In Version: ovirt-engine-dwh-4.2.2-1.el7ev
Doc Type: Bug Fix
Doc Text:
Ovirt-engine-dwh now correctly collects statistics.
Clone Of:
Environment:
Last Closed: 2018-05-15 17:35:46 UTC
oVirt Team: Metrics
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 3345141 0 None None None 2018-02-06 09:00:40 UTC
Red Hat Product Errata RHEA-2018:1487 0 None None None 2018-05-15 17:35:58 UTC
oVirt gerrit 87139 0 'None' 'MERGED' 'history: Update stat. table history_id to bigint' 2019-11-21 12:03:50 UTC

Description Roman Hodain 2018-02-05 08:42:12 UTC 
Description of problem:
Ovirt-engine-dwh fails with the following DB error:

    ERROR:  integer out of range
    STATEMENT:  INSERT INTO vm_interface_samples_history (history_datetime,vm_interface_id,receive_rate_percent,transmit_rate_percent,vm_interface_configuration_version) VALUES ($1,$2,$3,$4,$5)

Version-Release number of selected component (if applicable):

    ovirt-engine-dwh-4.2.1-1.el7ev.noarch

How reproducible:
    100%

Steps to Reproduce:
1. Long time of the environment usage or set the sequence to its maximum and start the DWH.

Actual results:
ERROR:  integer out of range

Expected results:
No error raised

Partially fixes in Bug 1121994
Comment 1 Shirly Radco 2018-02-08 08:59:53 UTC 
There was a spelling bug in the https://gerrit.ovirt.org/#/c/32941/ patch for the vm_interface samples/hourly and daily tables.
Comment 2 Lucie Leistnerova 2018-02-20 09:50:42 UTC 
Primary keys 'history_id' on big dwh tables are now bigint.

verified in ovirt-engine-dwh-4.2.2-1.el7ev.noarch
Comment 5 errata-xmlrpc 2018-05-15 17:35:46 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2018:1487
Comment 6 Franta Kust 2019-05-16 13:08:58 UTC 
BZ<2>Jira Resync
Note You need to log in before you can comment on or make changes to this bug.