Bug 1541924 – Ovirt-engine-dwh fails to collect statistics due to high number in database sequences.

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

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...

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Enterprise Virtualization Manager
Classification:	Red Hat
Component:	ovirt-engine-dwh (Show other bugs)
Sub Component:
Version:	4.2.1
Hardware:	Unspecified Unspecified

Priority	unspecified Severity high
Target Milestone:	ovirt-4.2.2
Target Release:	---
Assigned To:	Shirly Radco
QA Contact:	Lucie Leistnerova
Docs Contact:

URL:
Whiteboard:
Keywords:

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2018-02-05 03:42 EST by Roman Hodain
Modified:	2018-05-15 13:35 EDT (History)
CC List:	10 users (show)

See Also:
Fixed In Version:	ovirt-engine-dwh-4.2.2-1.el7ev
Doc Type:	Bug Fix
Doc Text:	Ovirt-engine-dwh now correctly collects statistics.
Story Points:	---
Clone Of:
Environment:
Last Closed:	2018-05-15 13:35:46 EDT
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	Metrics
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Red Hat Knowledge Base (Solution)	3345141	None	None	None	2018-02-06 04:00 EST
oVirt gerrit	87139	master	MERGED	history: Update stat. table history_id to bigint	2018-02-08 07:33 EST
Red Hat Product Errata	RHEA-2018:1487	None	None	None	2018-05-15 13:35 EDT

Groups: None (edit)

Description Roman Hodain 2018-02-05 03:42:12 EST

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 03:59:53 EST

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 04:50:42 EST

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 13:35:46 EDT

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

Note You need to log in before you can comment on or make changes to this bug.