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
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
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