Bug 1519541
Summary: | log-collector-analyzer: ERROR: column v.agent_ip does not exist | ||
---|---|---|---|
Product: | [oVirt] ovirt-log-collector | Reporter: | Douglas Schilling Landgraf <dougsland> |
Component: | analyzer | Assignee: | Ala Hino <ahino> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | David Necpal <dnecpal> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | 4.2.0 | CC: | ahino, bugs, dougsland, lsvaty, lveyde, ylavi |
Target Milestone: | ovirt-4.2.2 | Flags: | rule-engine:
ovirt-4.2+
rule-engine: exception+ dnecpal: testing_plan_complete- ylavi: planning_ack+ sbonazzo: devel_ack+ lsvaty: testing_ack+ |
Target Release: | 4.2.3 | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Fixed In Version: | ovirt-log-collector-4.2.3 | Doc Type: | Bug Fix |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2018-03-29 11:12:30 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | Integration | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: | |||
Bug Depends On: | |||
Bug Blocks: | 1456888 |
Description
Douglas Schilling Landgraf
2017-11-30 21:11:47 UTC
Just a hint from: inventory_report/produceReport/sqls/hosts_query_all.sql -- We might have cases where engine db's like 3.2, 3.3, 3.4, 3.5 have -- vds table with column ip and 3.6 or later with column agent_ip. -- -- To avoid a second SQL query when going to compat mode let's -- change the column name in our own local temp. db. IF EXISTS (SELECT column_name FROM information_schema.columns WHERE table_name='vds' and column_name='ip') THEN ALTER TABLE vds RENAME COLUMN ip TO agent_ip; END IF; Please make sure you don't break compatibility with 3.x which is the main use case of the analyzer right now. Verified on version ovirt-log-collector-analyzer-4.2.4-3.el7ev.noarch 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. |