Bug 1003796 - [rhevm] Webadmin - Events - Search box with value "Events: Templates =*" gives error (Exception message is StatementCallback)
Summary: [rhevm] Webadmin - Events - Search box with value "Events: Templates =*" give...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-webadmin-portal
Version: 3.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
: 3.3.0
Assignee: Ravi Nori
QA Contact: Jiri Belka
URL:
Whiteboard: infra
Depends On:
Blocks: rhev3.3ga
TreeView+ depends on / blocked
 
Reported: 2013-09-03 09:05 UTC by David Botzer
Modified: 2016-02-10 19:27 UTC (History)
12 users (show)

Fixed In Version: is31
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-01-21 22:11:15 UTC
oVirt Team: Infra
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
events-tab (122.00 KB, application/x-gzip)
2013-09-03 09:05 UTC, David Botzer
no flags Details
engine.log (38.81 KB, application/x-gzip)
2014-01-06 11:01 UTC, Jiri Belka
no flags Details


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 19220 0 None None None Never
oVirt gerrit 23049 0 None None None Never
oVirt gerrit 23051 0 None None None Never

Description David Botzer 2013-09-03 09:05:15 UTC
Created attachment 793072 [details]
events-tab

Description of problem:
[rhevm] Webadmin - Events - Search box with value "Events: Templates =*" gives error (Exception message is StatementCallback)

Version-Release number of selected component (if applicable):
3.3/is12
rhevm-3.3.0-0.18.master.el6ev.noarch

How reproducible:
always

Steps to Reproduce:
1.Select Events Tab
2.In Search Box type - Events: Templates =*

Actual results:
GUI loads forever, Messages Bar shows No error message
engine.log shows the below Error (Exception)

Expected results:
Should display all events filtered by all availalbe strings for template

Additional info:
2013-09-03 11:57:03,414 ERROR [org.ovirt.engine.core.bll.SearchQuery] (ajp-/127.0.0.1:8702-6) Query SearchQuery failed. Exception message is StatementCallback;
 bad SQL grammar [SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 0 and audit_log_id IN (SELECT audit_log.audit_log_id FROM  audit_log   LEFT OUT
ER JOIN vms_with_tags ON audit_log.vm_id=vms_with_tags.vm_guid    LEFT OUTER JOIN vm_templates_storage_domain ON vms_with_tags.vmt_guid=vm_templates_storage_do
main.vmt_guid    WHERE  (  vm_templates_storage_domain.storage_pool_name LIKE '%%%' OR  vm_templates_storage_domain.vds_group_name LIKE '%%%' OR  vm_templates_
storage_domain.name LIKE '%%%' OR  vm_templates_storage_domain.description LIKE '%%%' OR  vm_templates_storage_domain.quota_name LIKE '%%%' OR  vm_templates_st
orage_domain.free_text_comment LIKE '%%%' OR  vm_templates_storage_domain.os LIKE '%%%' OR  vm_templates_storage_domain.domain LIKE '%%%' ) ) and not deleted) 
 ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer ~~
 unknown
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 696

Comment 1 Shai Revivo 2013-09-29 07:39:05 UTC
This bug was fixed and is slated to be in the upcoming version. As we are focusing our testing at this phase on severe bugs, this bug was closed without going through its verification step

Comment 2 Jiri Belka 2014-01-06 11:00:30 UTC
This did not pass verification and the bug is still present in IS30 (rhevm-3.3.0-0.43.el6ev.noarch).

Comment 3 Jiri Belka 2014-01-06 11:01:03 UTC
Created attachment 846020 [details]
engine.log

Comment 4 Ravi Nori 2014-01-07 13:50:21 UTC
The patch http://gerrit.ovirt.org/#/c/20396 for bug BZ 1003804 has over written the changes made to fix this issue.

Comment 5 Jiri Belka 2014-01-13 15:42:13 UTC
ok, is31.

Comment 7 Itamar Heim 2014-01-21 22:11:15 UTC
Closing - RHEV 3.3 Released


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