Bug 1511549
Summary: | ovirt-engine and ovirt-engine-dwh postgres processes do not support non default db names | ||
---|---|---|---|
Product: | [oVirt] ovirt-engine-metrics | Reporter: | Shirly Radco <sradco> |
Component: | Generic | Assignee: | Shirly Radco <sradco> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Lukas Svaty <lsvaty> |
Severity: | high | Docs Contact: | |
Priority: | medium | ||
Version: | 1.0.7 | CC: | bugs, lveyde, sradco, ylavi |
Target Milestone: | ovirt-4.2.2 | Flags: | rule-engine:
ovirt-4.2+
|
Target Release: | --- | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | ovirt-engine-metrics-1.1.2 | Doc Type: | Bug Fix |
Doc Text: |
Cause:
If the engine and ovirt_engine_history db names are not default, the processes plugin will not be able to report statistics about them.
Consequence:
The processes plugin will not be able to report statistics about them.
Fix:
Base the why we collect the db processes stats according to the actual db names.
Result:
Now non default db names are supported.
|
Story Points: | --- |
Clone Of: | Environment: | ||
Last Closed: | 2018-03-29 10:55:13 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | Metrics | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: | |||
Bug Depends On: | 1458700 | ||
Bug Blocks: | 1475135 |
Description
Shirly Radco
2017-11-09 14:45:42 UTC
I don't believe many customers change the default and this has a clear workaround with a manual edit. Reproduction steps: 1. Migrate database to another one -> lsvaty 2. change vars in /etc/ovirt-engine/engine.conf.d/10-setup-database.conf ENGINE_DB_HOST="localhost" ENGINE_DB_PORT="5432" ENGINE_DB_USER="engine" ENGINE_DB_PASSWORD="password" ENGINE_DB_DATABASE="lsvaty" ENGINE_DB_SECURED="False" ENGINE_DB_SECURED_VALIDATION="False" ENGINE_DB_DRIVER="org.postgresql.Driver" ENGINE_DB_URL="jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory" 3. Check if collectd configuration is updated? FAIL -> still the same credentials in: grep -R engine /etc/collectd.d ./20-builtins-conf-for-ovirt-engine.conf: ProcessMatch pg_engine "postgres: engine engine" 4. samples are still reported though -> Shirly why? 5. Rerun metrics configuration to align the configuration 6. Check collectd configuration grep -R engine /etc/collectd.d ./20-builtins-conf-for-ovirt-engine.conf: ProcessMatch pg_engine "postgres: engine lsvaty" samples ps_data are not being recorded by metrics store anymore tested in ovirt-engine-metrics-1.1.2.2-1.el7ev.noarch I found out my migration of the engine actually broke the engine, thus I would like to reverify this one as of functionality. Moving back to ON_QA However, the metrics configuration script still should be triggered by migration of database. Shirly is there any way to support this? Maybe documentation update on the migration of DB? verified in ovirt-engine-metrics-1.1.3.3-1.el7ev.noarch on both non-default engine and dwh db names This bugzilla is included in oVirt 4.2.2 release, published on March 28th 2018. Since the problem described in this bug report should be resolved in oVirt 4.2.2 release, it has been closed with a resolution of CURRENT RELEASE. If the solution does not work for you, please open a new bug report. |