Hide Forgot
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]
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