| Summary: | [rhevm] Webadmin - Events - Search box with value "Events: Templates =*" gives error (Exception message is StatementCallback) | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | David Botzer <dbotzer> | ||||||
| Component: | ovirt-engine-webadmin-portal | Assignee: | Ravi Nori <rnori> | ||||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Jiri Belka <jbelka> | ||||||
| Severity: | medium | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 3.3.0 | CC: | aberezin, acathrow, bazulay, ecohen, iheim, jbelka, pstehlik, Rhev-m-bugs, rnori, srevivo, yeylon, yzaslavs | ||||||
| Target Milestone: | --- | Keywords: | Reopened, Triaged | ||||||
| Target Release: | 3.3.0 | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| Whiteboard: | infra | ||||||||
| Fixed In Version: | is31 | Doc Type: | Bug Fix | ||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2014-01-21 22:11:15 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: | |||||||
| Bug Depends On: | |||||||||
| Bug Blocks: | 1056111 | ||||||||
| Attachments: |
|
||||||||
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 This did not pass verification and the bug is still present in IS30 (rhevm-3.3.0-0.43.el6ev.noarch). Created attachment 846020 [details]
engine.log
The patch http://gerrit.ovirt.org/#/c/20396 for bug BZ 1003804 has over written the changes made to fix this issue. ok, is31. Closing - RHEV 3.3 Released |
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