Description of problem: Searching for 'Vms: status = up' fails with exception: 2017-03-27 22:04:42,984+03 ERROR [org.ovirt.engine.core.bll.SearchQuery] (default task-239) [574c2d50-3470-4e0c-9806-af30e8c87ac5] Exception: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; b ad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms WHERE vms.status = '1' ) ORDER BY elapsed_time DESC NULLS LAST,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql .util.PSQLException: ERROR: column "elapsed_time" does not exist Position: 87 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99) [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.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) [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:227) [bll.jar:] at org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:152) [bll.jar:] at org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:110) [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:579) [bll.jar:] at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:547) [bll.jar:] at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source) [:1.8.0_121] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_121] ... Caused by: org.postgresql.util.PSQLException: ERROR: column "elapsed_time" does not exist Position: 87 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) Version-Release number of selected component (if applicable): 4.1.0.4-0.1.el7
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.
This was already reported in bug 1416837 and fixed in 4.1.1. *** This bug has been marked as a duplicate of bug 1416837 ***