Bug 1949543

Summary: rhv-log-collector-analyzer fails to run MAC Pools rule
Product: Red Hat Enterprise Virtualization Manager Reporter: Jaroslav Spanko <jspanko>
Component: ovirt-engine-db-queryAssignee: Douglas Schilling Landgraf <dougsland>
Status: CLOSED NEXTRELEASE QA Contact: Guilherme Santos <gdeolive>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 4.4.6CC: bretm, gdeolive
Target Milestone: ovirt-4.4.6Keywords: FieldEngineering, ZStream
Target Release: 4.4.6   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: engine-db-query-1.6.3-1.el8ev Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-05-12 13:23:44 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:

Description Jaroslav Spanko 2021-04-14 14:01:46 UTC
Created attachment 1771906 [details]
html report

Description of problem:
rhv-log-collector-analyzer fails to run MAC Pools rule as it seems it takes even comments as table contains sql query itself and not the result

Version-Release number of selected component (if applicable):
rhvm-4.4.4.7-0.2.el8ev.noarch
rhv-log-collector-analyzer-1.0.6-1.el8ev.noarch

How reproducible:
100%

Steps to Reproduce:
1. run rhv-log-collector-analyzer 
2. check html report
3. MAC Pools table contains sql query itself 

Actual results:
sql query output itself

Expected results:
sql query output

Additional info:
adding report.html to the BZ

Comment 1 Douglas Schilling Landgraf 2021-04-19 19:19:14 UTC
https://gerrit.ovirt.org/c/engine-db-query/+/114356