Created attachment 962235[details]
sosreport
Description of problem:
Added a glance external provide, didn't test its authentication (public repository). The action caused a PSQL exception which flooded engine.log
Version-Release number of selected component (if applicable):
rhev 3.5 vt12
How reproducible:
Happened once
Steps to Reproduce:
1. Add an external provider, choose openstach image
2.
3.
Actual results:
It seems that the provider was added successfully but checking engine.log revealed it had caused a PSQL exception which flooded the log file
2014-11-27 19:57:35,165 INFO [org.ovirt.engine.core.bll.provider.AddProviderCommand] (ajp-/127.0.0.1:8702-7) [11ad947c] Running command: AddProviderCommand internal: false. Entities affected : ID: aaa00000-0000-0000-0000-123456789aaa Type: SystemAction group CREATE_STORAGE_POOL with role type ADMIN
2014-11-27 19:57:35,192 INFO [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (ajp-/127.0.0.1:8702-7) [11ad947c] Correlation ID: 11ad947c, Call Stack: null, Custom Event ID: -1, Message: Provider glance was added. (User: admin)
2014-11-27 19:57:35,366 ERROR [org.ovirt.engine.core.bll.SearchQuery] (ajp-/127.0.0.1:8702-3) Query SearchQuery failed. Exception message is StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct providers.* FROM providers ) ORDER BY name ASC) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: The column name disk_storage_type was not found in this ResultSet. : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct providers.* FROM providers ) ORDER BY name ASC) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: The column name disk_storage_type was not found in this ResultSet.: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct providers.* FROM providers ) ORDER BY name ASC) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: The column name disk_storage_type was not found in this ResultSet.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) [spring-jdbc.jar:3.1.1.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE]
Additional info:
sosreport
(In reply to Daniel Erez from comment #5)
> Hi Elad,
>
> Is the described issue reproduces after refreshing the browser? I couldn't
> reproduce it on a 3.5 build.
Actually, I'm not sure under what circumstances it occurs. It happened once.
(In reply to Elad from comment #6)
> (In reply to Daniel Erez from comment #5)
> > Hi Elad,
> >
> > Is the described issue reproduces after refreshing the browser? I couldn't
> > reproduce it on a 3.5 build.
>
> Actually, I'm not sure under what circumstances it occurs. It happened once.
OK, so I'll close it as a duplicate of bug 1047850 (see comment #5) as the error is similar. Please reopen if can be reproduced.
*** This bug has been marked as a duplicate of bug 1047850 ***
Created attachment 962235 [details] sosreport Description of problem: Added a glance external provide, didn't test its authentication (public repository). The action caused a PSQL exception which flooded engine.log Version-Release number of selected component (if applicable): rhev 3.5 vt12 How reproducible: Happened once Steps to Reproduce: 1. Add an external provider, choose openstach image 2. 3. Actual results: It seems that the provider was added successfully but checking engine.log revealed it had caused a PSQL exception which flooded the log file 2014-11-27 19:57:35,165 INFO [org.ovirt.engine.core.bll.provider.AddProviderCommand] (ajp-/127.0.0.1:8702-7) [11ad947c] Running command: AddProviderCommand internal: false. Entities affected : ID: aaa00000-0000-0000-0000-123456789aaa Type: SystemAction group CREATE_STORAGE_POOL with role type ADMIN 2014-11-27 19:57:35,192 INFO [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (ajp-/127.0.0.1:8702-7) [11ad947c] Correlation ID: 11ad947c, Call Stack: null, Custom Event ID: -1, Message: Provider glance was added. (User: admin) 2014-11-27 19:57:35,366 ERROR [org.ovirt.engine.core.bll.SearchQuery] (ajp-/127.0.0.1:8702-3) Query SearchQuery failed. Exception message is StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct providers.* FROM providers ) ORDER BY name ASC) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: The column name disk_storage_type was not found in this ResultSet. : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct providers.* FROM providers ) ORDER BY name ASC) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: The column name disk_storage_type was not found in this ResultSet.: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct providers.* FROM providers ) ORDER BY name ASC) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: The column name disk_storage_type was not found in this ResultSet. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE] Additional info: sosreport