Bug 1389751 - All tabs in UI are empty with exception is org.postgresql.util.PSQLException
Summary: All tabs in UI are empty with exception is org.postgresql.util.PSQLException
Keywords:
Status: CLOSED WORKSFORME
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Backend.Core
Version: 4.1.0
Hardware: Unspecified
OS: Unspecified
unspecified
urgent vote
Target Milestone: ovirt-4.1.0-alpha
: ---
Assignee: Eli Mesika
QA Contact: meital avital
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-10-28 12:25 UTC by Meni Yakove
Modified: 2019-04-28 08:36 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-11-07 09:07:32 UTC
oVirt Team: Infra
oourfali: ovirt-4.1?
rule-engine: blocker?
myakove: planning_ack?
myakove: devel_ack?
myakove: testing_ack?


Attachments (Terms of Use)
engine log (839.44 KB, application/zip)
2016-10-28 12:25 UTC, Meni Yakove
no flags Details

Description Meni Yakove 2016-10-28 12:25:38 UTC
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]

Comment 1 Oved Ourfali 2016-10-29 04:05:48 UTC
Eli, can you please take a look?

Comment 2 Red Hat Bugzilla Rules Engine 2016-10-29 04:05:55 UTC
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.

Comment 3 Eli Mesika 2016-10-31 12:30:02 UTC
Not able to reproduce with latest master (commit hash f2d0733)

Comment 4 Martin Perina 2016-11-07 09:07:32 UTC
Closing as WORKSFORME, feel free to reopen if problem persists


Note You need to log in before you can comment on or make changes to this bug.