Bug 1114992
| Summary: | ERROR: missing FROM-clause entry for table "vms_with_tags" | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Retired] oVirt | Reporter: | Martin Pavlik <mpavlik> | ||||
| Component: | ovirt-engine-core | Assignee: | Barak <bazulay> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Jiri Belka <jbelka> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 3.5 | CC: | bazulay, gklein, iheim, jbelka, oourfali, rbalakri, yeylon | ||||
| Target Milestone: | --- | ||||||
| Target Release: | 3.5.0 | ||||||
| Hardware: | x86_64 | ||||||
| OS: | Linux | ||||||
| Whiteboard: | infra | ||||||
| Fixed In Version: | ovirt-3.5.0-beta1.1 | Doc Type: | Bug Fix | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2014-10-17 12:36: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: |
|
||||||
found in oVirt Engine Version: 3.5.0-0.0.master.20140629172257.git0b16ed7.el6 ok, ovirt-engine-backend-3.5.0-0.0.master.20140804172041.git23b558e.el6.noarch mac search works, valid syntax is: Vms: Vnic.mac = <pattern> oVirt 3.5 has been released and should include the fix for this issue. |
Created attachment 913730 [details] log_collector Description of problem: Invalid user input in Filter: field is causing org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "vms_with_tags" Version-Release number of selected component (if applicable): How reproducible: 100% Steps to Reproduce: 1.enter following in Filter/Search filed Vms: mac=00:1a:4a:d4:53:90 or Vms: a=b Actual results: exception Expected results: search query is not accepted in incorrect format Additional info: Caused by: org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "vms_with_tags" Position: 52 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) [spring-jdbc.jar:3.1.1.RELEASE] ... 111 more 2014-07-01 13:45:59,896 ERROR [org.ovirt.engine.core.bll.SearchQuery] (ajp--127.0.0.1-8702-4) Query SearchQuery failed. Exception message is StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT vms.* FROM vms WHERE ( vms_with_tags.vm_pool_name ILIKE '%a=b%' OR vms_with_tags.run_on_vds_name ILIKE '%a=b%' OR vms_with_tags.vm_fqdn ILIKE '%a=b%' OR vms_with_tags.tag_name ILIKE '%a=b%' OR vms_with_tags.guest_cur_user_name ILIKE '%a=b%' OR vms_with_tags.vm_name ILIKE '%a=b%' OR vms_with_tags.vm_description ILIKE '%a=b%' OR vms_with_tags.quota_name ILIKE '%a=b%' OR vms_with_tags.vm_host ILIKE '%a=b%' OR vms_with_tags.vm_ip ILIKE '%a=b%' OR vms_with_tags.storage_pool_name ILIKE '%a=b%' OR vms_with_tags.vds_group_name ILIKE '%a=b%' OR vms_with_tags.vm_comment ILIKE '%a=b%' ) ) ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "vms_with_tags" Position: 52 : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT vms.* FROM vms WHERE ( vms_with_tags.vm_pool_name ILIKE '%a=b%' OR vms_with_tags.run_on_vds_name ILIKE '%a=b%' OR vms_with_tags.vm_fqdn ILIKE '%a=b%' OR vms_with_tags.tag_name ILIKE '%a=b%' OR vms_with_tags.guest_cur_user_name ILIKE '%a=b%' OR vms_with_tags.vm_name ILIKE '%a=b%' OR vms_with_tags.vm_description ILIKE '%a=b%' OR vms_with_tags.quota_name ILIKE '%a=b%' OR vms_with_tags.vm_host ILIKE '%a=b%' OR vms_with_tags.vm_ip ILIKE '%a=b%' OR vms_with_tags.storage_pool_name ILIKE '%a=b%' OR vms_with_tags.vds_group_name ILIKE '%a=b%' OR vms_with_tags.vm_comment ILIKE '%a=b%' ) ) ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "vms_with_tags" Position: 52: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT vms.* FROM vms WHERE ( vms_with_tags.vm_pool_name ILIKE '%a=b%' OR vms_with_tags.run_on_vds_name ILIKE '%a=b%' OR vms_with_tags.vm_fqdn ILIKE '%a=b%' OR vms_with_tags.tag_name ILIKE '%a=b%' OR vms_with_tags.guest_cur_user_name ILIKE '%a=b%' OR vms_with_tags.vm_name ILIKE '%a=b%' OR vms_with_tags.vm_description ILIKE '%a=b%' OR vms_with_tags.quota_name ILIKE '%a=b%' OR vms_with_tags.vm_host ILIKE '%a=b%' OR vms_with_tags.vm_ip ILIKE '%a=b%' OR vms_with_tags.storage_pool_name ILIKE '%a=b%' OR vms_with_tags.vds_group_name ILIKE '%a=b%' OR vms_with_tags.vm_comment ILIKE '%a=b%' ) ) ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "vms_with_tags"