[ovirt-devel] Fwd: Fwd: DWH cannot gain hourly history data from db because of the bloody time problem.

Wed Nov 19 09:50:59 UTC 2014

please run: 
# date 
in console and on postgres: 
# SELECT CURRENT_TIMESTAMP; 
and send outputs. 

Also run: 
# sudo su - postgres 
# psql 
# \list 
and send output. 

I think the error are happening because you manually created databases and either Encoding is not UTF8, Collate is not en_US.UTF-8 or Ctype is not en_US.UTF-8. 

We only support that. 

Yaniv 

----- Original Message -----

> From: "张亚琪" <zhangyingyun001 at gmail.com>
> To: "Shirly Radco" <sradco at redhat.com>, Devel at ovirt.org
> Sent: Wednesday, November 19, 2014 2:57:19 AM
> Subject: [ovirt-devel] Fwd: Fwd: DWH cannot gain hourly history data from db
> because of the bloody time problem.

> ---------- Forwarded message ----------
> From: 张亚琪 < zhangyingyun001 at gmail.com >
> Date: 2014-11-19 8:54 GMT+08:00
> Subject: Re: [ovirt-devel] Fwd: DWH cannot gain hourly history data from db
> because of the bloody time problem.
> To: Shirly Radco < sradco at redhat.com >

> hi Shirly, thank you for your reply and sorry for my late.
> I will show u all things u require and something I want to prove my view.

> 0. Log

> 0.1. engine.log （about reports）

> > > 2014-11-18 18:00:45,569 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 vms.*
> > > FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as
> > > T1
> > > OFFSET (1 -1) LIMIT 100]; nested exception is
> > > org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
> > > BY表达式
> > 
> 
> > > Position: 62 : org.springframework.jdbc.BadSqlGrammarException:
> > > StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
> > > FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as
> > > T1
> > > OFFSET (1 -1) LIMIT 100]; nested exception is
> > > org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
> > > BY表达式
> > 
> 
> > > Position: 62: org.springframework.jdbc.BadSqlGrammarException:
> > > StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
> > > FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as
> > > T1
> > > OFFSET (1 -1) LIMIT 100]; nested exception is
> > > org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
> > > BY表达式
> > 
> 
> > > Position: 62
> > 
> 
> > > 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.VmDAODbFacadeImpl.getAllUsingQuery(VmDAODbFacadeImpl.java:175)
> > > [dal.jar:]
> > 
> 
> > > at
> > > org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:156)
> > > [bll.jar:]
> > 
> 
> > > at
> > > org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:65)
> > > [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:492)
> > > [bll.jar:]
> > 
> 
> > > at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:466)
> > > [bll.jar:]
> > 
> 
> > > at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
> > > [:1.7.0_71]
> > 
> 
> > > at
> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > > [rt.jar:1.7.0_71]
> > 
> 
> > > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> > 
> 
> > > 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.GeneratedMethodAccessor67.invoke(Unknown Source)
> > > [:1.7.0_71]
> > 
> 
> > > at
> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > > [rt.jar:1.7.0_71]
> > 
> 
> > > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> > 
> 
> > > 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.InterceptorContext.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$$$view6.runQuery(Unknown
> > > Source) [common.jar:]
> > 
> 
> > > at
> > > org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56)
> > 
> 
> > > at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)
> > > [:1.7.0_71]
> > 
> 
> > > at
> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > > [rt.jar:1.7.0_71]
> > 
> 
> > > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> > 
> 
> > > 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.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
> > > [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
> > 
> 
> > > 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.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:75)
> > > [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:63)
> > > [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.StandardEngineValve.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_71]
> > 
> 
> > > Caused by: org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT
> > > DISTINCT,
> > > ORDER BY表达式
> > 
> 
> > > Position: 62
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
> > 
> 
> > > at
> > > org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)
> > 
> 
> > > at
> > > org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
> > > [spring-jdbc.jar:3.1.1.RELEASE]
> > 
> 
> > > at
> > > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
> > > [spring-jdbc.jar:3.1.1.RELEASE]
> > 
> 
> > > ... 113 more
> > 
> 
> > > 2014-11-18 18:00:50,595 ERROR [org.ovirt.engine.core.bll.SearchQuery]
> > > (ajp--127.0.0.1-8702-4) Query SearchQuery failed. Exception message is
> > > StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
> > > FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as
> > > T1
> > > OFFSET (1 -1) LIMIT 100]; nested exception is
> > > org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
> > > BY表达式
> > 
> 
> > > Position: 62 : org.springframework.jdbc.BadSqlGrammarException:
> > > StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
> > > FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as
> > > T1
> > > OFFSET (1 -1) LIMIT 100]; nested exception is
> > > org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
> > > BY表达式
> > 
> 
> > > Position: 62: org.springframework.jdbc.BadSqlGrammarException:
> > > StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
> > > FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as
> > > T1
> > > OFFSET (1 -1) LIMIT 100]; nested exception is
> > > org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
> > > BY表达式
> > 
> 
> > > Position: 62
> > 
> 
> > > 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.VmDAODbFacadeImpl.getAllUsingQuery(VmDAODbFacadeImpl.java:175)
> > > [dal.jar:]
> > 
> 
> > > at
> > > org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:156)
> > > [bll.jar:]
> > 
> 
> > > at
> > > org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:65)
> > > [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:492)
> > > [bll.jar:]
> > 
> 
> > > at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:466)
> > > [bll.jar:]
> > 
> 
> > > at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
> > > [:1.7.0_71]
> > 
> 
> > > at
> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > > [rt.jar:1.7.0_71]
> > 
> 
> > > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> > 
> 
> > > 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.GeneratedMethodAccessor67.invoke(Unknown Source)
> > > [:1.7.0_71]
> > 
> 
> > > at
> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > > [rt.jar:1.7.0_71]
> > 
> 
> > > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> > 
> 
> > > 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.InterceptorContext.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$$$view6.runQuery(Unknown
> > > Source) [common.jar:]
> > 
> 
> > > at
> > > org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56)
> > 
> 
> > > at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)
> > > [:1.7.0_71]
> > 
> 
> > > at
> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > > [rt.jar:1.7.0_71]
> > 
> 
> > > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> > 
> 
> > > 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.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
> > > [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
> > 
> 
> > > 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.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:75)
> > > [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:63)
> > > [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.StandardEngineValve.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_71]
> > 
> 
> > > Caused by: org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT
> > > DISTINCT,
> > > ORDER BY表达式
> > 
> 
> > > Position: 62
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
> > 
> 
> > > at
> > > org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)
> > 
> 
> > > at
> > > org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
> > > [spring-jdbc.jar:3.1.1.RELEASE]
> > 
> 
> > > at
> > > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
> > > [spring-jdbc.jar:3.1.1.RELEASE]
> > 
> 
> > > ... 113 more
> > 
> 
> > > 2014-11-18 18:00:56,627 ERROR [org.ovirt.engine.core.bll.SearchQuery]
> > > (ajp--127.0.0.1-8702-1) Query SearchQuery failed. Exception message is
> > > StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
> > > FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as
> > > T1
> > > OFFSET (1 -1) LIMIT 100]; nested exception is
> > > org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
> > > BY表达式
> > 
> 
> > > Position: 62 : org.springframework.jdbc.BadSqlGrammarException:
> > > StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
> > > FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as
> > > T1
> > > OFFSET (1 -1) LIMIT 100]; nested exception is
> > > org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
> > > BY表达式
> > 
> 
> > > Position: 62: org.springframework.jdbc.BadSqlGrammarException:
> > > StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
> > > FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as
> > > T1
> > > OFFSET (1 -1) LIMIT 100]; nested exception is
> > > org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
> > > BY表达式
> > 
> 
> > > Position: 62
> > 
> 
> > > 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.VmDAODbFacadeImpl.getAllUsingQuery(VmDAODbFacadeImpl.java:175)
> > > [dal.jar:]
> > 
> 
> > > at
> > > org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:156)
> > > [bll.jar:]
> > 
> 
> > > at
> > > org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:65)
> > > [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:492)
> > > [bll.jar:]
> > 
> 
> > > at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:466)
> > > [bll.jar:]
> > 
> 
> > > at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
> > > [:1.7.0_71]
> > 
> 
> > > at
> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > > [rt.jar:1.7.0_71]
> > 
> 
> > > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> > 
> 
> > > 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.GeneratedMethodAccessor67.invoke(Unknown Source)
> > > [:1.7.0_71]
> > 
> 
> > > at
> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > > [rt.jar:1.7.0_71]
> > 
> 
> > > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> > 
> 
> > > 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.InterceptorContext.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$$$view6.runQuery(Unknown
> > > Source) [common.jar:]
> > 
> 
> > > at
> > > org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56)
> > 
> 
> > > at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)
> > > [:1.7.0_71]
> > 
> 
> > > at
> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > > [rt.jar:1.7.0_71]
> > 
> 
> > > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> > 
> 
> > > 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.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
> > > [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
> > 
> 
> > > 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.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:75)
> > > [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:63)
> > > [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.StandardEngineValve.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_71]
> > 
> 
> > > Caused by: org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT
> > > DISTINCT,
> > > ORDER BY表达式
> > 
> 
> > > Position: 62
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
> > 
> 
> > > at
> > > org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)
> > 
> 
> > > at
> > > org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
> > > [spring-jdbc.jar:3.1.1.RELEASE]
> > 
> 
> > > at
> > > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
> > > [spring-jdbc.jar:3.1.1.RELEASE]
> > 
> 
> > > ... 113 more
> > 
> 
> 0.2. ovirt-engine-dwh.log

> > > 2014-11-18
> > > 12:36:00|NmaVBj|ZdLGGX|gX18vw|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
> > > Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tRunJob_4
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at ovirt_engine_dwh.samplerunjobs_3_5. SampleRunJobs.tRunJob
> > > _4Process(SampleRunJobs.java:953)
> > 
> 
> > > at ovirt_engine_dwh.samplerunjobs_3_5. SampleRunJobs.tJDBCConnection
> > > _2Process(SampleRunJobs.java:762)
> > 
> 
> > > at ovirt_engine_dwh.samplerunjobs_3_5. SampleRunJobs.tJDBCConnection
> > > _1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 12:36:00|gX18vw|ZdLGGX|iY0VVa|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
> > > Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tRunJob_1
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at ovirt_engine_dwh.sampletimekeepingjob_3_5.
> > > SampleTimeKeepingJob.tRunJob
> > > _1Process(SampleTimeKeepingJob.java:5941)
> > 
> 
> > > at ovirt_engine_dwh.sampletimekeepingjob_3_5.
> > > SampleTimeKeepingJob.tJDBCInput
> > > _2Process(SampleTimeKeepingJob.java:5707)
> > 
> 
> > > at ovirt_engine_dwh.sampletimekeepingjob_3_5.
> > > SampleTimeKeepingJob.tJDBCConnection
> > > _1Process(SampleTimeKeepingJob.java:4340)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
> > 
> 
> > > at ovirt_engine_dwh.sampletimekeepingjob_3_5.
> > > SampleTimeKeepingJob.tRowGenerator
> > > _2Process(SampleTimeKeepingJob.java:4092)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
> > 
> 
> > > at ovirt_engine_dwh.sampletimekeepingjob_3_5. SampleTimeKeepingJob
> > > $2.run(SampleTimeKeepingJob.java:9546)
> > 
> 
> > > 2014-11-18
> > > 12:36:00|iY0VVa|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
> > > Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tJDBCOutput_3
> > 
> 
> > > org.postgresql.util.PSQLException: 致命错误: 由于管理员命令中断联接
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1844)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1383)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 12:37:00|xrgPmR|ZdLGGX|pSvwg0|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
> > > Exception|tJDBCOutput_3|org.postgresql.util.PSQLException:致命错误:
> > > 由于管理员命令中断联接|1
> > 
> 
> > > Exception in component tRunJob_4
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 12:37:00|pSvwg0|ZdLGGX|K3fwaz|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
> > > Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tRunJob_1
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
> > 
> 
> > > 2014-11-18
> > > 12:37:05|K3fwaz|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
> > > Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tJDBCInput_6
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at ovirt_engine_dwh.aggregationtohourly_3_5.
> > > AggregationToHourly.tJDBCInput
> > > _6Process(AggregationToHourly.java:19335)
> > 
> 
> > > at ovirt_engine_dwh.aggregationtohourly_3_5.
> > > AggregationToHourly.tJDBCConnection
> > > _1Process(AggregationToHourly.java:18891)
> > 
> 
> > > at ovirt_engine_dwh.aggregationtohourly_3_5. AggregationToHourly.tPrejob
> > > _1Process(AggregationToHourly.java:18770)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:25642)
> > 
> 
> > > at ovirt_engine_dwh.aggregationtohourly_3_5. AggregationToHourly.runJob
> > > (AggregationToHourly.java:25464)
> > 
> 
> > > at ovirt_engine_dwh.hourlytimekeepingjob_3_5.
> > > HourlyTimeKeepingJob.tRunJob
> > > _1Process(HourlyTimeKeepingJob.java:2541)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_6|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tJDBCInput_1
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_1Process(AggregationToHourly.java:2377)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$2.run(AggregationToHourly.java:25665)
> > 
> 
> > > Exception in component tJDBCInput_3
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_3Process(AggregationToHourly.java:8231)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$4.run(AggregationToHourly.java:25757)
> > 
> 
> > > Exception in component tJDBCInput_2
> > 
> 
> > > Exception in component tJDBCInput_9
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_2Process(AggregationToHourly.java:5968)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$3.run(AggregationToHourly.java:25711)
> > 
> 
> > > Exception in component tJDBCInput_13
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_3|java.lang.NullPointerException:null|1
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_1|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_9Process(AggregationToHourly.java:20681)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$9.run(AggregationToHourly.java:25987)
> > 
> 
> > > Exception in component tJDBCInput_10
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_2|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_13Process(AggregationToHourly.java:18186)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$8.run(AggregationToHourly.java:25941)
> > 
> 
> > > Exception in component tJDBCInput_5
> > 
> 
> > > Exception in component tJDBCInput_11
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_9|java.lang.NullPointerException:null|1
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_10Process(AggregationToHourly.java:24091)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$10.run(AggregationToHourly.java:26033)
> > 
> 
> > > Exception in component tJDBCInput_4
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_13|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_11Process(AggregationToHourly.java:15308)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$7.run(AggregationToHourly.java:25895)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_5Process(AggregationToHourly.java:13356)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$6.run(AggregationToHourly.java:25849)
> > 
> 
> > > java.lang.NullPointerException2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_10|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_4Process(AggregationToHourly.java:11256)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$5.run(AggregationToHourly.java:25803)
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_11|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_5|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tJDBCOutput_6
> > 
> 
> > > org.postgresql.util.PSQLException: An I/O error occured while sending to
> > > the
> > > backend.
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
> > 
> 
> > > at ovirt_engine_dwh.aggregationtohourly_3_5.
> > > AggregationToHourly.tRowGenerator
> > > _1Process(AggregationToHourly.java:19905)
> > 
> 
> > > at ovirt_engine_dwh.aggregationtohourly_3_5. AggregationToHourly.tPostjob
> > > _1Process(AggregationToHourly.java:19496)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:26081)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJob(AggregationToHourly.java:25464)
> > 
> 
> > > at ovirt_engine_dwh.hourlytimekeepingjob_3_5.
> > > HourlyTimeKeepingJob.tRunJob
> > > _1Process(HourlyTimeKeepingJob.java:2541)
> > 
> 
> > > at ovirt_engine_dwh.hourlytimekeepingjob_3_5.
> > > HourlyTimeKeepingJob.tJDBCInput
> > > _1Process(HourlyTimeKeepingJob.java:2369)
> > 
> 
> > > at ovirt_engine_dwh.hourlytimekeepingjob_3_5.
> > > HourlyTimeKeepingJob.tJDBCConnection
> > > _1Process(HourlyTimeKeepingJob.java:1822)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
> > 
> 
> > > Caused by: java.net.SocketException: Broken pipe
> > 
> 
> > > at java.net.SocketOutputStream.socketWrite0(Native Method)
> > 
> 
> > > at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
> > 
> 
> > > at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
> > 
> 
> > > at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
> > 
> 
> > > at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
> > 
> 
> > > at org.postgresql.core.PGStream.flush(PGStream.java:521)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1134)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254)
> > 
> 
> > > ... 12 more
> > 
> 
> > > 2014-11-18
> > > 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCOutput_6|org.postgresql.util.PSQLException:An I/O error
> > > occured while sending to the backend.|1
> > 
> 
> > > Exception in component tRunJob_1
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2566)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
> > 
> 
> > > An I/O error occured while sending to the backend.An I/O error occured
> > > while
> > > sending to the backend.2014-11-18
> > > 13:00:00|Qb7Vkj|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|6|Java
> > > Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tJDBCInput_4
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at ovirt_engine_dwh.sampletimekeepingjob_3_5.
> > > SampleTimeKeepingJob.tJDBCInput
> > > _4Process(SampleTimeKeepingJob.java:2121)
> > 
> 
> > > at ovirt_engine_dwh.sampletimekeepingjob_3_5.
> > > SampleTimeKeepingJob.tJDBCConnection
> > > _3Process(SampleTimeKeepingJob.java:1537)
> > 
> 
> > > at ovirt_engine_dwh.sampletimekeepingjob_3_5. SampleTimeKeepingJob
> > > $2.run(SampleTimeKeepingJob.java:9546)
> > 
> 
> > > 2014-11-18
> > > 13:30:00|xb5OGC|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
> > > Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tJDBCInput_4
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1371)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 13:31:00|tetatR|ZdLGGX|Aaa74D|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
> > > Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tRunJob_4
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 13:31:00|Aaa74D|ZdLGGX|jYGdcg|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
> > > Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tRunJob_1
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
> > 
> 
> > > 2014-11-18
> > > 13:31:00|jYGdcg|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
> > > Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tJDBCOutput_3
> > 
> 
> > > org.postgresql.util.PSQLException: 致命错误: 由于管理员命令中断联接
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1844)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1383)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 13:32:00|AJFmu7|ZdLGGX|n34YZo|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
> > > Exception|tJDBCOutput_3|org.postgresql.util.PSQLException:致命错误:
> > > 由于管理员命令中断联接|1
> > 
> 
> > > Exception in component tRunJob_4
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 13:32:00|n34YZo|ZdLGGX|XZy3yU|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
> > > Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tRunJob_1
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
> > 
> 
> > > 2014-11-18
> > > 13:32:05|XZy3yU|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
> > > Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tJDBCInput_4
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2121)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
> > 
> 
> > > 2014-11-18
> > > 16:29:01|R7YvSQ|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
> > > Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tJDBCInput_4
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at ovirt_engine_dwh.osenumupdate_3_5. OsEnumUpdate.tJDBCInput
> > > _4Process(OsEnumUpdate.java:1371)
> > 
> 
> > > at ovirt_engine_dwh.osenumupdate_3_5. OsEnumUpdate.tJDBCConnection
> > > _1Process(OsEnumUpdate.java:862)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
> > 
> 
> > > at ovirt_engine_dwh.osenumupdate_3_5. OsEnumUpdate.runJob
> > > (OsEnumUpdate.java:4144)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 16:30:01|AvgrjL|ZdLGGX|4eSwoN|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
> > > Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tRunJob_4
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 16:30:01|4eSwoN|ZdLGGX|VtZtjF|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
> > > Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tRunJob_1
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
> > 
> 
> > > 2014-11-18
> > > 16:30:01|VtZtjF|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
> > > Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tJDBCOutput_3
> > 
> 
> > > org.postgresql.util.PSQLException: 致命错误: 由于管理员命令中断联接
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
> > 
> 
> > > at ovirt_engine_dwh.osenumupdate_3_5. OsEnumUpdate.tRowGenerator
> > > _1Process(OsEnumUpdate.java:1844)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1383)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
> > 
> 
> > > at
> > > ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 16:31:01|Jc5by2|ZdLGGX|r5BRqk|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
> > > Exception|tJDBCOutput_3|org.postgresql.util.PSQLException:致命错误:
> > > 由于管理员命令中断联接|1
> > 
> 
> > > Exception in component tRunJob_4
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
> > 
> 
> > > at
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
> > 
> 
> > > 2014-11-18
> > > 16:31:01|r5BRqk|ZdLGGX|uyMqI5|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
> > > Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tRunJob_1
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
> > 
> 
> > > at
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
> > 
> 
> > > 2014-11-18
> > > 16:31:06|uyMqI5|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
> > > Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tJDBCInput_6
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_6Process(AggregationToHourly.java:19335)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCConnection_1Process(AggregationToHourly.java:18891)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tPrejob_1Process(AggregationToHourly.java:18770)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:25642)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJob(AggregationToHourly.java:25464)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2541)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
> > 
> 
> > > 2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_6|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tJDBCInput_1
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_1Process(AggregationToHourly.java:2377)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$2.run(AggregationToHourly.java:25665)
> > 
> 
> > > Exception in component tJDBCInput_11
> > 
> 
> > > Exception in component tJDBCInput_9
> > 
> 
> > > Exception in component tJDBCInput_10
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_11Process(AggregationToHourly.java:15308)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$7.run(AggregationToHourly.java:25895)
> > 
> 
> > > Exception in component tJDBCInput_13
> > 
> 
> > > 2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_1|java.lang.NullPointerException:null|1
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_10Process(AggregationToHourly.java:24091)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$10.run(AggregationToHourly.java:26033)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > 2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_11|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_9Process(AggregationToHourly.java:20681)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$9.run(AggregationToHourly.java:25987)
> > 
> 
> > > Exception in component tJDBCInput_4
> > 
> 
> > > Exception in component tJDBCInput_3
> > 
> 
> > > java.lang.NullPointerException2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_10|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_13Process(AggregationToHourly.java:18186)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$8.run(AggregationToHourly.java:25941)
> > 
> 
> > > Exception in component tJDBCInput_52014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_9|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tJDBCInput_2
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_3Process(AggregationToHourly.java:8231)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$4.run(AggregationToHourly.java:25757)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > 2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_13|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_4Process(AggregationToHourly.java:11256)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$5.run(AggregationToHourly.java:25803)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_2Process(AggregationToHourly.java:5968)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$3.run(AggregationToHourly.java:25711)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > 2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_3|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_5Process(AggregationToHourly.java:13356)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$6.run(AggregationToHourly.java:25849)
> > 
> 
> > > 2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_2|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCInput_5|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tJDBCOutput_6
> > 
> 
> > > org.postgresql.util.PSQLException: An I/O error occured while sending to
> > > the
> > > backend.
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
> > 
> 
> > > at
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tRowGenerator_1Process(AggregationToHourly.java:19905)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tPostjob_1Process(AggregationToHourly.java:19496)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:26081)
> > 
> 
> > > at
> > > ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJob(AggregationToHourly.java:25464)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2541)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
> > 
> 
> > > Caused by: java.net.SocketException: Broken pipe
> > 
> 
> > > at java.net.SocketOutputStream.socketWrite0(Native Method)
> > 
> 
> > > at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
> > 
> 
> > > at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
> > 
> 
> > > at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
> > 
> 
> > > at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
> > 
> 
> > > at org.postgresql.core.PGStream.flush(PGStream.java:521)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1134)
> > 
> 
> > > at
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254)
> > 
> 
> > > ... 12 more
> > 
> 
> > > 2014-11-18
> > > 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
> > > Exception|tJDBCOutput_6|org.postgresql.util.PSQLException:An I/O error
> > > occured while sending to the backend.|1
> > 
> 
> > > Exception in component tRunJob_1
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2566)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
> > 
> 
> > > at
> > > ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
> > 
> 
> > > An I/O error occured while sending to the backend.An I/O error occured
> > > while
> > > sending to the backend.2014-11-18
> > > 17:00:00|P66Bbl|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|6|Java
> > > Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> > > Exception in component tJDBCInput_5
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at ovirt_engine_dwh.dailytimekeepingjob_3_5.
> > > DailyTimeKeepingJob.tJDBCInput
> > > _5Process(DailyTimeKeepingJob.java:3066)
> > 
> 
> > > at
> > > ovirt_engine_dwh.dailytimekeepingjob_3_5.DailyTimeKeepingJob.tJDBCInput_1Process(DailyTimeKeepingJob.java:2535)
> > 
> 
> > > at ovirt_engine_dwh.dailytimekeepingjob_3_5.
> > > DailyTimeKeepingJob.tJDBCConnection
> > > _1Process(DailyTimeKeepingJob.java:1914)
> > 
> 
> > > at
> > > ovirt_engine_dwh.dailytimekeepingjob_3_5.DailyTimeKeepingJob.tJDBCConnection_2Process(DailyTimeKeepingJob.java:1793)
> > 
> 
> > > at
> > > ovirt_engine_dwh.dailytimekeepingjob_3_5.DailyTimeKeepingJob$2.run(DailyTimeKeepingJob.java:6687)
> > 
> 
> > > 2014-11-19
> > > 00:00:00|qXv21T|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|DailyTimeKeepingJob|Default|6|Java
> > > Exception|tJDBCInput_5|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tJDBCInput_1
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at ovirt_engine_dwh.historydelete_3_5. HistoryDelete.tJDBCInput
> > > _1Process(HistoryDelete.java:1592)
> > 
> 
> > > at ovirt_engine_dwh.historydelete_3_5. HistoryDelete
> > > $2.run(HistoryDelete.java:13315)
> > 
> 
> > > Exception in component tJDBCInput_20
> > 
> 
> > > Exception in component tJDBCInput_21
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_21Process(HistoryDelete.java:9981)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$22.run(HistoryDelete.java:14235)
> > 
> 
> > > Exception in component tJDBCInput_19
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_19Process(HistoryDelete.java:9142)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$20.run(HistoryDelete.java:14143)
> > 
> 
> > > Exception in component tJDBCInput_26
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_26Process(HistoryDelete.java:12295)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$27.run(HistoryDelete.java:14465)
> > 
> 
> > > Exception in component tJDBCInput_10
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_10Process(HistoryDelete.java:5367)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$11.run(HistoryDelete.java:13729)
> > 
> 
> > > Exception in component tJDBCInput_9
> > 
> 
> > > Exception in component tJDBCInput_12
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_12Process(HistoryDelete.java:6207)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$13.run(HistoryDelete.java:13821)
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_1|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tJDBCInput_14
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_26|java.lang.NullPointerException:null|1
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_14Process(HistoryDelete.java:7045)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$15.run(HistoryDelete.java:13913)
> > 
> 
> > > Exception in component tJDBCInput_23
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_23Process(HistoryDelete.java:11035)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$24.run(HistoryDelete.java:14327)
> > 
> 
> > > Exception in component tJDBCInput_13
> > 
> 
> > > Exception in component tJDBCInput_7
> > 
> 
> > > Exception in component tJDBCInput_11
> > 
> 
> > > Exception in component tJDBCInput_8
> > 
> 
> > > Exception in component tJDBCInput_4
> > 
> 
> > > Exception in component tJDBCInput_5
> > 
> 
> > > Exception in component tJDBCInput_6
> > 
> 
> > > Exception in component tJDBCInput_2
> > 
> 
> > > Exception in component tJDBCInput_3
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_2Process(HistoryDelete.java:2011)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$3.run(HistoryDelete.java:13361)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_6Process(HistoryDelete.java:3689)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$7.run(HistoryDelete.java:13545)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_5Process(HistoryDelete.java:3270)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$6.run(HistoryDelete.java:13499)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_4Process(HistoryDelete.java:2850)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$5.run(HistoryDelete.java:13453)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_8Process(HistoryDelete.java:4528)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$9.run(HistoryDelete.java:13637)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_11Process(HistoryDelete.java:5787)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$12.run(HistoryDelete.java:13775)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_7Process(HistoryDelete.java:4108)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$8.run(HistoryDelete.java:13591)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_13Process(HistoryDelete.java:6626)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$14.run(HistoryDelete.java:13867)
> > 
> 
> > > Exception in component tJDBCInput_22
> > 
> 
> > > Exception in component tJDBCInput_24
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_9Process(HistoryDelete.java:4947)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$10.run(HistoryDelete.java:13683)
> > 
> 
> > > Exception in component tJDBCInput_25
> > 
> 
> > > Exception in component tJDBCInput_16
> > 
> 
> > > Exception in component tJDBCInput_15
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_15Process(HistoryDelete.java:7464)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$16.run(HistoryDelete.java:13959)
> > 
> 
> > > Exception in component tJDBCInput_17
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_20Process(HistoryDelete.java:9562)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$21.run(HistoryDelete.java:14189)
> > 
> 
> > > Exception in component tJDBCInput_18
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_17Process(HistoryDelete.java:8303)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$18.run(HistoryDelete.java:14051)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_16Process(HistoryDelete.java:7884)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$17.run(HistoryDelete.java:14005)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_25Process(HistoryDelete.java:11875)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$26.run(HistoryDelete.java:14419)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_24Process(HistoryDelete.java:11455)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$25.run(HistoryDelete.java:14373)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_22Process(HistoryDelete.java:10615)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$23.run(HistoryDelete.java:14281)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_18Process(HistoryDelete.java:8723)
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$19.run(HistoryDelete.java:14097)
> > 
> 
> > > java.lang.NullPointerException
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_19|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_3Process(HistoryDelete.java:2431)2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_18|java.lang.NullPointerException:null|1
> > 
> 
> > > at
> > > ovirt_engine_dwh.historydelete_3_5.HistoryDelete$4.run(HistoryDelete.java:13407)
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_22|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_24|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_25|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_16|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_17|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_20|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_15|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_9|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_13|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_3|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_7|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_11|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_8|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_5|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_6|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_2|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_23|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_14|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_12|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_21|java.lang.NullPointerException:null|1
> > 
> 
> > > 2014-11-19
> > > 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
> > > Exception|tJDBCInput_10|java.lang.NullPointerException:null|1
> > 
> 
> > > Exception in component tRunJob_2
> > 
> 
> > > java.lang.RuntimeException: Child job running failed
> > 
> 
> > > at ovirt_engine_dwh.deletetimekeepingjob_3_5.
> > > DeleteTimeKeepingJob.tRunJob
> > > _2Process(DeleteTimeKeepingJob.java:2794)
> > 
> 
> > > at ovirt_engine_dwh.deletetimekeepingjob_3_5.
> > > DeleteTimeKeepingJob.tJDBCInput
> > > _1Process(DeleteTimeKeepingJob.java:2589)
> > 
> 
> > > at ovirt_engine_dwh.deletetimekeepingjob_3_5.
> > > DeleteTimeKeepingJob.tJDBCConnection
> > > _1Process(DeleteTimeKeepingJob.java:2001)
> > 
> 
> > > at
> > > ovirt_engine_dwh.deletetimekeepingjob_3_5.DeleteTimeKeepingJob.tJDBCConnection_2Process(DeleteTimeKeepingJob.java:1880)
> > 
> 
> > > at
> > > ovirt_engine_dwh.deletetimekeepingjob_3_5.DeleteTimeKeepingJob$2.run(DeleteTimeKeepingJob.java:9473)
> > 
> 
> > > 2014-11-19
> > > 03:00:00|5DCU4k|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|DeleteTimeKeepingJob|Default|6|Java
> > > Exception|tRunJob_2|java.lang.RuntimeException:Child job running failed|1
> > 
> 
> 0.3. ovirt-engine-reports.log
> There is no useful info in jasperserver.log & reports.log

> 1. The version of my environment
> [root at zhangyingyun ovirt-engine-reports]# rpm -qa|grep ovirt
> ovirt-release35-snapshot-002-0.0.master.noarch
> ovirt-engine-setup-plugin-ovirt-engine-common-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-backend-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-cli-3.5.0.6-0.1.20141107.gitcf7f1a1.el6.noarch
> ovirt-engine-setup-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-reports-3.5.1-0.2.master.20141112075822.20141112075822.gitac69a8b.el6.noarch
> ovirt-engine-dwh-setup-3.5.1-0.0.master.20141107092205.git2cf5ee9.el6.noarch
> ovirt-optimizer-ui-0.6-1.el6.noarch
> ovirt-engine-dwh-3.5.1-0.0.master.20141107092205.git2cf5ee9.el6.noarch
> ovirt-engine-lib-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-setup-plugin-ovirt-engine-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-extensions-api-impl-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-webadmin-portal-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-iso-uploader-3.5.1-0.0.master.20140926055817.git472e66e.el6.noarch
> ovirt-engine-setup-plugin-websocket-proxy-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-reports-setup-3.5.1-0.2.master.20141112075822.20141112075822.gitac69a8b.el6.noarch
> ovirt-engine-restapi-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-dbscripts-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-host-deploy-java-1.3.1-0.0.master.20141117013215.git57b2b0b.el6.noarch
> ovirt-engine-jboss-as-7.1.1-1.el6.x86_64
> ovirt-guest-agent-1.0.10.2-1.el6.noarch
> ovirt-image-uploader-3.5.1-0.0.master.20141027101643.git1b30d59.el6.noarch
> ovirt-engine-sdk-python-3.5.0.9-0.1.20141111.gitd6eb612.el6.noarch
> ovirt-engine-websocket-proxy-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-tools-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-host-deploy-1.3.1-0.0.master.20141117013215.git57b2b0b.el6.noarch
> ovirt-release35-002-0.0.master.noarch
> ovirt-engine-setup-base-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-engine-userportal-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
> ovirt-guest-tools-3.5.0-0.5.master.noarch

> 2. the timezone for my machine
> [root at zhangyingyun ovirt-engine-reports]# date -R
> Wed, 19 Nov 2014 08:19:34 +0800

> and my dbtime is normal too:
> postgres=# select now();
> now
> -------------------------------
> 2014-11-19 08:20:44.849422+08
> (1 row)

> 3. But I will show u something that can prove my opinion.

> The following is DWH development environment:

> and I checked db according to its tips, contents are as follows:

> > > ovirt_engine_history=# select distinct var_name, var_datetime from
> > > history_configuration where var_name = 'lastHourAggr';
> > 
> 
> > > var_name | var_datetime
> > 
> 
> > > --------------+------------------------
> > 
> 
> > > lastHourAggr | 2014-11-19 21:00:00+08
> > 
> 
> > > (1 row)
> > 
> 
> the next is:

> the sql in this pic is:

> > > "SELECT history_id,
> > 
> 
> > > history_datetime,
> > 
> 
> > > datacenter_id,
> > 
> 
> > > datacenter_status,
> > 
> 
> > > minutes_in_status,
> > 
> 
> > > datacenter_configuration_version
> > 
> 
> > > FROM datacenter_samples_history
> > 
> 
> > > WHERE history_datetime >= '"+context.lastHourAggr+"'
> > 
> 
> > > AND history_datetime < '"+TalendDate.addDate(context.lastHourAggr,
> > > 1,"HH")+"'
> > 
> 
> > > ORDER BY history_datetime,
> > 
> 
> > > datacenter_id,
> > 
> 
> > > datacenter_status"
> > 
> 
> the lastest info as follows:
> ovirt_engine_history=# select history_datetime from
> datacenter_samples_history;
> history_datetime
> ----------------------------
> 2014-11-19 08:26:01.964+08
> 2014-11-19 08:27:01.988+08
> 2014-11-19 08:28:01.953+08
> 2014-11-19 08:29:01.962+08
> 2014-11-19 08:30:01.95+08
> 2014-11-19 08:31:01.949+08
> 2014-11-19 08:32:01.965+08
> 2014-11-19 08:33:01.98+08
> 2014-11-19 08:34:01.955+08
> 2014-11-19 08:35:01.969+08
> 2014-11-19 08:36:01.967+08
> 2014-11-19 08:37:01.958+08
> 2014-11-19 08:38:01.974+08
> 2014-11-19 08:39:01.974+08
> 2014-11-19 08:40:01.964+08
> 2014-11-19 08:41:01.961+08
> 2014-11-19 08:42:01.977+08
> 2014-11-19 08:43:01.96+08
> (1994 rows)

> so the result is clear. history_datetime < lastHourAggr , so the data cannot
> be written to the db be from datacenter_samples_history to
> datacenter_hourly_history.
> Looking forward your reply . Thank you very much.

> 2014-11-17 14:31 GMT+08:00 Shirly Radco < sradco at redhat.com > :

> > Hi,
> 

> > UTC time is the coordinated Universal Time,
> 
> > and we recommend syncing the machines according to it,
> 
> > so the data will not be affected when changing the clock from summer time
> > to
> > winter time and back.
> 

> > All reports can be shown in the local time you choose in the reports
> > portal.
> 

> > But still, this should not cause issues with hourly reports not showing.
> 

> > Please attach all logs. Should be located at:
> 

> > /var/log/ovirt-engine
> 
> > /var/log/ovirt-engine-dwh
> 
> > /var/log/ovirt-engine-reports
> 

> > Also please let us know what ovirt 3.5 version you are using:
> 
> > rpm -qa |grep ovirt
> 

> > For ovirt-engine-dwh, ovirt-engine-reports and ovirt-engine.
> 

> > Last, please let us now what timezone is set currently for your machine.
> 

> > Best regards,
> 
> > ---
> 
> > Shirly Radco
> 
> > BI Software Engineer
> 
> > Red Hat Israel Ltd.
> 

> > ----- Original Message -----
> 
> > > From: "张亚琪" < zhangyingyun001 at gmail.com >
> 
> > > To: Devel at ovirt.org
> 
> > > Sent: Monday, November 17, 2014 3:51:07 AM
> 
> > > Subject: [ovirt-devel] Fwd: DWH cannot gain hourly history data from db
> > > because of the bloody time problem.
> 
> > >
> 
> > >
> 
> > > ---------- Forwarded message ----------
> 
> > > From: 张亚琪 < zhangyingyun001 at gmail.com >
> 
> > > Date: 2014-11-16 20:04 GMT+08:00
> 
> > > Subject: Re: [ovirt-devel] DWH cannot gain hourly history data from db
> 
> > > because of the bloody time problem.
> 
> > > To: Yaniv Dary < ydary at redhat.com >
> 
> > >
> 
> > >
> 
> > > hi, Yaniv. Thank you for your reply. However, I think that there is no
> > > sync
> 
> > > problem in my setup, because the engine, dwh and reports are in the same
> 
> > > machine. As a new, I am not familiar with UTM time.
> 
> > > And please see the attachment. Looking forward your reply. Thanks a lot.
> 
> > >
> 
> > >
> 
> > > 2014-11-16 7:31 GMT+08:00 Yaniv Dary < ydary at redhat.com > :
> 
> > >
> 
> > >
> 
> > >
> 
> > > Are all your servers sync to the same ntp and in UTM time?
> 
> > > Can you attach logs?
> 
> > >
> 
> > >
> 
> > > Yaniv
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > > From: "张亚琪" < zhangyingyun001 at gmail.com >
> 
> > > To: Devel at ovirt.org
> 
> > > Sent: Friday, November 14, 2014 11:22:38 AM
> 
> > > Subject: [ovirt-devel] DWH cannot gain hourly history data from db
> > > because
> > > of
> 
> > > the bloody time problem.
> 
> > >
> 
> > >
> 
> > > hi everybody,
> 
> > > Recently, I have tested oVirt Reports. And I encountered a problem about
> > > some
> 
> > > reports that cannot show data. And then I setup the DWH development
> 
> > > environment. I found maybe this reason for missing data is the
> 
> > > AggregationToHourly3.5. When data from datacenter_samples_history were
> 
> > > inserted to datacenter_hourly_history, u will find nothing happened.
> > > Because
> 
> > > the select sql before inserting data reads：
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > > "SELECT history_id,
> 
> > >
> 
> > > history_datetime,
> 
> > >
> 
> > > datacenter_id,
> 
> > >
> 
> > > datacenter_status,
> 
> > >
> 
> > > minutes_in_status,
> 
> > >
> 
> > > datacenter_configuration_version
> 
> > >
> 
> > > FROM datacenter_samples_history
> 
> > >
> 
> > > WHERE history_datetime >= '"+context.lastHourAggr+ "'
> 
> > >
> 
> > > AND history_datetime < '"+TalendDate.addDate(context.lastHourAggr,
> > > 1,"HH")+"'
> 
> > >
> 
> > > ORDER BY history_datetime,
> 
> > >
> 
> > >
> 
> > >
> 
> > > datacenter_id,
> 
> > >
> 
> > >
> 
> > >
> 
> > > datacenter_status"
> 
> > >
> 
> > >
> 
> > > And then I queried the table of datacenter_samples_history &
> 
> > > history_configuration (has the field of lastHourAggr) in the db of
> 
> > > ovirt_engine_history. The results are as follows:
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > > ovirt_engine_history=# select * from history_configuration;
> 
> > >
> 
> > > var_name | var_value | var_datetime
> 
> > >
> 
> > > -------------------+-----------+------------------------
> 
> > >
> 
> > > MinimalETLVersion | 3.5.0 |
> 
> > >
> 
> > > default_language | en_US |
> 
> > >
> 
> > > firstSync | false | 2014-10-13 19:42:00+08
> 
> > >
> 
> > > lastDayAggr | | 2014-11-14 00:00:00+08
> 
> > >
> 
> > > lastHourAggr | | 2014- 11-15 06:00:00+08
> 
> > >
> 
> > > HourlyAggFailed | false |
> 
> > >
> 
> > > (6 rows)
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > > ovirt_engine_history=# select history_datetime from
> 
> > > datacenter_samples_history;
> 
> > >
> 
> > > history_datetime
> 
> > >
> 
> > > ----------------------------
> 
> > >
> 
> > > 2014- 11-13 03:07:00.23+08
> 
> > >
> 
> > > 2014-11-13 03:08:00.238+08
> 
> > >
> 
> > > 2014-11-13 03:09:00.229+08
> 
> > >
> 
> > > 2014-11-13 03:10:00.221+08
> 
> > >
> 
> > > 2014-11-13 03:11:00.229+08
> 
> > >
> 
> > > 2014-11-13 03:12:00.221+08
> 
> > >
> 
> > > 2014-11-13 03:13:00.237+08
> 
> > >
> 
> > > 2014-11-13 03:14:00.22+08
> 
> > >
> 
> > > 2014-11-13 03:15:00.221+08
> 
> > >
> 
> > > 2014-11-13 03:16:00.238+08
> 
> > >
> 
> > > 2014-11-13 03:17:00.238+08
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > > Obviously， history_datetime < lastHourAggr , the data will never be
> > > inserted
> 
> > > to the datacenter_hourly_history. And the place where I bold is the root
> 
> > > cause of the error. Then , I try to update the lastHourAggr in the table
> > > of
> 
> > > history_configuration. Reports works successfully. However, the
> > > lastHourAggr
> 
> > > will change to 2014-11-15 afterwards. But u know Today is 2014-11-14 ! I
> 
> > > have no idea about why the value of lastHourAggr is 2014-11-15. Would u
> > > help
> 
> > > me solve this problem. Thanks a lot !
> 
> > >
> 
> > > _______________________________________________
> 
> > > Devel mailing list
> 
> > > Devel at ovirt.org
> 
> > > http://lists.ovirt.org/mailman/listinfo/devel
> 
> > >
> 
> > >
> 
> > >
> 
> > >
> 
> > > _______________________________________________
> 
> > > Devel mailing list
> 
> > > Devel at ovirt.org
> 
> > > http://lists.ovirt.org/mailman/listinfo/devel
> 

> _______________________________________________
> Devel mailing list
> Devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20141119/99d108f1/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mywork1.png
Type: image/png
Size: 125363 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20141119/99d108f1/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mywork2.png
Type: image/png
Size: 72419 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20141119/99d108f1/attachment-0003.png>