| Summary: | All tabs in UI are empty with exception is org.postgresql.util.PSQLException | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [oVirt] ovirt-engine | Reporter: | Meni Yakove <myakove> | ||||
| Component: | Backend.Core | Assignee: | Eli Mesika <emesika> | ||||
| Status: | CLOSED WORKSFORME | QA Contact: | meital avital <mavital> | ||||
| Severity: | urgent | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 4.1.0 | CC: | bugs, mperina, myakove, oourfali | ||||
| Target Milestone: | ovirt-4.1.0-alpha | Keywords: | Regression | ||||
| Target Release: | --- | Flags: | oourfali:
ovirt-4.1?
rule-engine: blocker? myakove: planning_ack? myakove: devel_ack? myakove: testing_ack? |
||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2016-11-07 09:07:32 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: | |||||
| Attachments: |
|
||||||
Eli, can you please take a look? This bug report has Keywords: Regression or TestBlocker. Since no regressions or test blockers are allowed between releases, it is also being identified as a blocker for this release. Please resolve ASAP. Not able to reproduce with latest master (commit hash f2d0733) Closing as WORKSFORME, feel free to reopen if problem persists |
Created attachment 1214989 [details] engine log Description of problem: All tabs in UI are empty Version-Release number of selected component (if applicable): ovirt-engine-4.1.0-0.0.master.20161027231312.git5b34632.el7.centos.noarch How reproducible: 100% Steps to Reproduce: 1. Open the engine UI 2. Go to any tab Actual results: Expected results: Additional info: 2016-10-28 15:19:37,535 ERROR [org.ovirt.engine.core.bll.SearchQuery] (default task-6) [] Query 'SearchQuery' failed: StatementCallback; bad SQL grammar [SELECT * FROM ( {1}) as T1 {2}]; nes ted exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "{" Position: 17 2016-10-28 15:19:37,535 ERROR [org.ovirt.engine.core.bll.SearchQuery] (default task-6) [] Exception: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELE CT * FROM ( {1}) as T1 {2}]; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "{" Position: 17 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) [spring-jdbc.jar:4.2.4.RELEASE] at org.ovirt.engine.core.dao.VmDaoImpl.getAllUsingQuery(VmDaoImpl.java:159) [dal.jar:] at org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:152) [bll.jar:] at org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:80) [bll.jar:] at org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:103) [bll.jar:] at org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:33) [dal.jar:] at org.ovirt.engine.core.bll.executor.DefaultBackendQueryExecutor.execute(DefaultBackendQueryExecutor.java:14) [bll.jar:] at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:577) [bll.jar:] at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:548) [bll.jar:] at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source) [:1.8.0_102] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_102] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_102]