----- Original Message ----- > From: "Jorick Astrego" <j.astr...@netbulae.eu> > To: "Simone Tiraboschi" <stira...@redhat.com> > Cc: users@ovirt.org > Sent: Friday, April 3, 2015 12:13:13 PM > Subject: Re: [ovirt-users] postgresql error on glance image repo > > > > On 04/03/2015 10:07 AM, Simone Tiraboschi wrote: > > > > ----- Original Message ----- > >> From: "Jorick Astrego" <j.astrego@ netbulae.eu > > >> To: users@ ovirt.org > >> Sent: Friday, April 3, 2015 10:00:58 AM > >> Subject: [ovirt-users] postgresql error on glance image repo > >> > >> Hi, > >> > >> Running a fresh ovirt 3.5.2rc3 install. When I select the default > >> ovirt-image-repository on the storage tab, the images list keeps loading > >> and > >> I see the following errors in the log: > > Hi, > > I tried it and I'm not able to reproduce, at least on fedora 20. > > I'm able to see image list and I'm able to import cirros template. > > Could you please attach setup logs? > > > > thanks, > > Simone > > Hmm strange after clicking away and selecting again, I get the images > without the sql error. > > I attached the logs.
Query seems OK , please try to have a clear reproducible scenario for this one thanks Eli > > > >> 2015-04-03 09:53:27,150 ERROR [org.ovirt.engine.core.bll.SearchQuery] > >> (ajp--127.0.0.1-8702-10) Query SearchQuery failed. Exception message is > >> StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct > >> providers.* FROM providers WHERE providers.name LIKE > >> 'ovirt-image-repository' ) 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 WHERE > >> providers.name LIKE 'ovirt-image-repository' ) 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 WHERE providers.name LIKE > >> 'ovirt-image-repository' ) 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] > >> at > >> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) > >> [spring-jdbc.jar:3.1.1.RELEASE] > >> at > >> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) > >> [spring-jdbc.jar:3.1.1.RELEASE] > >> at > >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) > >> [spring-jdbc.jar:3.1.1.RELEASE] > >> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) > >> [spring-jdbc.jar:3.1.1.RELEASE] > >> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464) > >> [spring-jdbc.jar:3.1.1.RELEASE] > >> at > >> org.ovirt.engine.core.dao.DiskDaoDbFacadeImpl.getAllWithQuery(DiskDaoDbFacadeImpl.java:103) > >> [dal.jar:] > >> at > >> org.ovirt.engine.core.bll.SearchQuery.genericSearch(SearchQuery.java:269) > >> [bll.jar:] > >> at > >> org.ovirt.engine.core.bll.SearchQuery.genericSearch(SearchQuery.java:257) > >> [bll.jar:] > >> at org.ovirt.engine.core.bll.SearchQuery.searchDisk(SearchQuery.java:299) > >> [bll.jar:] > >> at > >> org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:117) > >> [bll.jar:] > >> at > >> org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:73) > >> [bll.jar:] > >> at > >> org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:31) > >> [dal.jar:] > >> at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:497) > >> [bll.jar:] > >> at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:471) [bll.jar:] > > >> at sun.reflect.GeneratedMethodAccessor40.invoke(Unknown Source) > >> [:1.7.0_75] > >> at > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > >> [rt.jar:1.7.0_75] > >> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75] > >> at > >> org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:114) > >> [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:125) > >> [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135) > >> [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.ovirt.engine.core.bll.interceptors.ThreadLocalSessionCleanerInterceptor.injectWebContextToThreadLocal(ThreadLocalSessionCleanerInterceptor.java:13) > >> [bll.jar:] > >> at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source) > >> [:1.7.0_75] > >> at > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > >> [rt.jar:1.7.0_75] > >> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75] > >> at > >> org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82) > >> [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.In > terceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53) > >> [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:211) > >> [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:363) > >> [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:194) > >> [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) > >> [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) > >> [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) > >> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] > >> at > >> org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72) > >> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] > >> at > >> org.ovirt.engine.core.common.interfaces.BackendLocal$$$view8.runQuery(Unknown > >> Source) [common.jar:] > >> at > >> org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56) > >> at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source) > >> [:1.7.0_75] > >> at > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > >> [rt.jar:1.7.0_75] > >> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75] > >> at com.google.gwt.rpc.server.RPC.invokeAndStreamResponse(RPC.java:196) > >> at com.google.gwt.rpc.server.RpcServlet.processCall(RpcServlet.java:172) > >> at com.google.gwt.rpc.server.RpcServlet.processPost(RpcServlet.java:233) > >> at > >> com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java: > 754) > >> [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) > >> [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.ovirt.engine.core.utils.servlet.HeaderFilter.doFilter(HeaderFilter.java:94) > >> [utils.jar:] > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.ovirt.engine.ui.frontend.server.gwt.GwtCachingFilter.doFilter(GwtCachingFilter.java:132) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:72) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:64) > >> [utils.jar:] > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.ovirt.engine.core.aaa.filters.SessionMgmtFilter.doFilter(SessionMgmtFilter.java:31) > >> [aaa.jar:] > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.ovirt.engine.core.aaa.filters.LoginFilter.doFilter(LoginFilter.java:74) > >> [aaa.jar:] > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.ovirt.engine.core.aaa.filters.NegotiationFilter.doFilter(NegotiationFilter.java:113) > >> [aaa.jar:] > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.ovirt.engine.core.aaa.filters.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:90) > >> [aaa.jar:] > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.ovirt.engine.core.aaa.filters.SessionValidationFilter.doFilter(SessionValidationFilter.java:73) > >> [aaa.jar:] > >> at > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) > >> at > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) > >> at > >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) > >> at > >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) > >> at > >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489) > >> at > >> org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) > >> at > >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) > >> at > >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > >> at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466) > >> at > >> org.apache.catalina.core.Sta > ndardEngineValve.invoke(StandardEngineValve.java:109) > >> at > >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) > >> at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:505) > >> at > >> org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:445) > >> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) > >> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75] > >> Caused by: org.postgresql.util.PSQLException: The column name > >> disk_storage_type was not found in this ResultSet. > >> at > >> org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2542) > >> at > >> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:2406) > >> at > >> org.jboss.jca.adapters.jdbc.WrappedResultSet.getInt(WrappedResultSet.java:1073) > >> at > >> org.ovirt.engine.core.dao.DiskDaoDbFacadeImpl$DiskRowMapper.mapRow(DiskDaoDbFacadeImpl.java:116) > >> [dal.jar:] > >> at > >> org.ovirt.engine.core.dao.DiskDaoDbFacadeImpl$DiskRowMapper.mapRow(DiskDaoDbFacadeImpl.java:106) > >> [dal.jar:] > >> at > >> org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92) > >> [spring-jdbc.jar:3.1.1.RELEASE] > >> at > >> org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1) > >> [spring-jdbc.jar:3.1.1.RELEASE] > >> at > >> org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:446) > >> [spring-jdbc.jar:3.1.1.RELEASE] > >> at > >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) > >> [spring-jdbc.jar:3.1.1.RELEASE] > >> ... 112 more > >> > >> > >> > >> > >> Met vriendelijke groet, With kind regards, > >> > >> Jorick Astrego > >> > >> Netbulae Virtualization Experts > >> > >> Tel: 053 20 30 270 info@ netbulae.eu Staalsteden 4-3A KvK 08198180 > >> Fax: 053 20 30 271 www.netbulae.eu 7547 TA Enschede BTW NL821234584B01 > >> > >> > >> > >> _______________________________________________ > >> Users mailing list > >> Users@ ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > >> > > > > > Met vriendelijke groet, With kind regards, > > Jorick Astrego > > Netbulae Virtualization Experts > > Tel: 053 20 30 270 i...@netbulae.eu Staalsteden 4-3A KvK > 08198180 > Fax: 053 20 30 271 www.netbulae.eu 7547 TA Enschede > BTW NL821234584B01 > > > > _______________________________________________ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users