Bug 1238174

Summary:

[Admin Portal] broken search in UI

Product:

[Retired] oVirt

Reporter:

Jiri Belka <jbelka>

Component:

ovirt-engine-core

Assignee:

Alexander Wels <awels>

Status:

CLOSED CURRENTRELEASE

QA Contact:

Jiri Belka <jbelka>

Severity:

high

Docs Contact:

Priority:

unspecified

Version:

3.6

CC:

awels, bugs, ecohen, gklein, lsurette, masayag, oourfali, rbalakri, yeylon

Target Milestone:

---

Keywords:

Regression

Target Release:

3.6.0

Hardware:

Unspecified

OS:

Unspecified

Whiteboard:

infra

Fixed In Version:

3.6.0-4_alpha3

Doc Type:

Bug Fix

Doc Text:

Story Points:

---

Clone Of:

Environment:

Last Closed:

2015-11-04 11:46:06 UTC

Type:

Bug

Regression:

---

Mount Type:

---

Documentation:

---

CRM:

Verified Versions:

Category:

---

oVirt Team:

Infra

RHEL 7.3 requirements from Atomic Host:

Cloudforms Team:

---

Target Upstream Version:

Embargoed:

Attachments:

Description	Flags
engine.log, server.log	none

Description Jiri Belka 2015-07-01 10:44:42 UTC

Created attachment 1044977 [details]
engine.log, server.log

Description of problem:

Events: message = "*has available for updates*" does nothing in UI but sql select itself works OK

* ovirt-engine-backend-3.6.0-0.0.master.20150627185750.git6f063c1.el6.noarch

# tail -f /var/log/ovirt-engine/engine.log | grep 'SELECT.*available'
2015-07-01 12:39:19,197 TRACE [org.ovirt.engine.core.searchbackend.SyntaxChecker] (default task-2) [] Search: SELECT * FROM ((SELECT distinct audit_log.* FROM  audit_log   WHERE  audit_log.message ILIKE '%has available updates%'  AND not deleted)  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100
2015-07-01 12:39:19,197 DEBUG [org.ovirt.engine.core.bll.SearchQuery] (default task-2) [] Executing generic query: SELECT * FROM ((SELECT distinct audit_log.* FROM  audit_log   WHERE  audit_log.message ILIKE '%has available updates%'  AND not deleted)  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100

it seems related to this line in server.log

# tail -f /var/log/ovirt-engine/server.log | grep -i search
2015-07-01 12:23:41,694 DEBUG [org.jboss.weld.Bean] (default task-32) WELD-001529: An InjectionTarget is created for a class org.ovirt.engine.core.bll.SearchQuery which does not have any appropriate constructor. It will not be possible to produce instances of this type!

Version-Release number of selected component (if applicable):
ovirt-engine-backend-3.6.0-0.0.master.20150627185750.git6f063c1.el6.noarch
ovirt-engine-wildfly-8.2.0-1.el6.x86_64

How reproducible:
100%

Steps to Reproduce:
1. Events: message = "*$pattern*"
2.
3.

Actual results:
no output in ui

Expected results:
should return lines with pattern

Additional info:
this also works

# curl -s -k -X GET -H "Accept: application/xml" -H "Content-Type: application/xml" -u admin@internal:xxxxxx https://jb-ovirt36-2.rhev.lab.eng.brq.redhat.com/api/events\?search\="*has available updates*" | grep description
        <description>Host 'dell-r210ii-04.rhev.lab.eng.brq.redhat.com' has available updates.</description>
        <description>Host 'dell-r210ii-04.rhev.lab.eng.brq.redhat.com' has available updates.</description>
        <description>Host 'dell-r210ii-04.rhev.lab.eng.brq.redhat.com' has available updates.</description>

Comment 1 Eli Mesika 2015-07-05 10:02:43 UTC

Seems as the whole search in UI Events TAB is broken 
No matter what I am looking for, the call does not even reach the backend code 
When I testing other TABs (like DC for example), it is working as expected 
Seems as a pure UX regression 

Einav, can you assign anybody from the UX team to investigate that ?

Comment 2 Einav Cohen 2015-07-09 18:45:12 UTC

Alexander will take a look.

Comment 3 Alexander Wels 2015-07-09 20:23:51 UTC

It appears that:
https://gerrit.ovirt.org/#/c/42457

broke the search. Well the search was attached to the bottom event panel, instead of the main events tabs.

Comment 4 Jiri Belka 2015-09-16 16:40:13 UTC

ok, rhevm-backend-3.6.0-0.15.master.el6.noarch

looks ok in UI and restapi

[root@jb-rhevm36 tmp]# tail -f /var/log/ovirt-engine/engine.log | egrep 'Data.*Center'
2015-09-16 18:38:24,115 DEBUG [org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl] (ajp-/127.0.0.1:8702-7) [] Query type 'Search', Parameters 'SearchParameters:{refresh='false', filtered='false', searchType='AuditLog', searchPattern='Events: message = "*Data Center*"', caseSensitive='false', from='0', max='100'}'
2015-09-16 18:38:24,116 TRACE [org.ovirt.engine.core.bll.SearchQuery] (ajp-/127.0.0.1:8702-7) [] START, SearchQuery(SearchParameters:{refresh='false', filtered='false', searchType='AuditLog', searchPattern='Events: message = "*Data Center*"', caseSensitive='false', from='0', max='100'}), log id: 198b85d
2015-09-16 18:38:24,117 DEBUG [org.ovirt.engine.core.bll.SearchQuery] (ajp-/127.0.0.1:8702-7) [] ResourceManager::searchBusinessObjects(''Events: message = "*Data Center*"'') - entered
2015-09-16 18:38:24,118 TRACE [org.ovirt.engine.core.searchbackend.SyntaxChecker] (ajp-/127.0.0.1:8702-7) [] Search: SELECT * FROM ((SELECT distinct audit_log.* FROM  audit_log   WHERE  audit_log.message ILIKE '%Data Center%'  AND not deleted)  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100
2015-09-16 18:38:24,118 DEBUG [org.ovirt.engine.core.bll.SearchQuery] (ajp-/127.0.0.1:8702-7) [] Executing generic query: SELECT * FROM ((SELECT distinct audit_log.* FROM  audit_log   WHERE  audit_log.message ILIKE '%Data Center%'  AND not deleted)  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100

# curl -s -k -X GET -H "Accept: application/xml" -H "Content-Type: application/xml" -u admin@internal:xxxxxx https://jb-rhevm36.rhev.lab.eng.brq.redhat.com/api/events\?search\="*Data Center*" | grep description | head
        <description>Invalid status on Data Center Default. Setting status to Non Responsive.</description>
        <description>Invalid status on Data Center Default. Setting status to Non Responsive.</description>
        <description>Invalid status on Data Center Default. Setting Data Center status to Non Responsive (On host dell-r210ii-13.rhev.lab.eng.brq.redhat.com, Error: Network error during communication with the Host.).</description>
        <description>Invalid status on Data Center Default. Setting Data Center status to Non Responsive (On host dell-r210ii-13.rhev.lab.eng.brq.redhat.com, Error: Network error during communication with the Host.).</description>
        <description>Invalid status on Data Center Default. Setting status to Non Responsive.</description>
        <description>Invalid status on Data Center Default. Setting Data Center status to Non Responsive (On host dell-r210ii-13.rhev.lab.eng.brq.redhat.com, Error: Network error during communication with the Host.).</description>
        <description>Invalid status on Data Center Default. Setting Data Center status to Non Responsive (On host dell-r210ii-13.rhev.lab.eng.brq.redhat.com, Error: Network error during communication with the Host.).</description>
        <description>Host dell-r210ii-13.rhev.lab.eng.brq.redhat.com cannot access the Storage Domain(s) &lt;UNKNOWN&gt; attached to the Data Center Default. Setting Host state to Non-Operational.</description>
        <description>Invalid status on Data Center Default. Setting Data Center status to Non Responsive (On host dell-r210ii-13.rhev.lab.eng.brq.redhat.com, Error: Network error during communication with the Host.).</description>
        <description>Invalid status on Data Center Default. Setting status to Non Responsive.</description>

Comment 5 Sandro Bonazzola 2015-11-04 11:46:06 UTC

oVirt 3.6.0 has been released on November 4th, 2015 and should fix this issue.
If problems still persist, please open a new BZ and reference this one.