From: 张亚琪 <zhangyingyun001@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@redhat.com>
hi Shirly, thank you for your reply and sorry for my late.
and I checked db according to its tips, contents are as follows:
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.
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: 62at 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: 62at 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 more2014-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: 62at 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: 62at 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 more2014-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: 62at 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: 62at 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|1Exception in component tRunJob_4java.lang.RuntimeException: Child job running failedat 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|1Exception in component tRunJob_1java.lang.RuntimeException: Child job running failedat 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|1Exception in component tJDBCOutput_3org.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:致命错误: 由于管理员命令中断联接|1Exception in component tRunJob_4java.lang.RuntimeException: Child job running failedat 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|1Exception in component tRunJob_1java.lang.RuntimeException: Child job running failedat 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|1Exception in component tJDBCInput_6java.lang.NullPointerExceptionat 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|1Exception in component tJDBCInput_1java.lang.NullPointerExceptionat 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_3java.lang.NullPointerExceptionat 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_2Exception in component tJDBCInput_9java.lang.NullPointerExceptionat 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_132014-11-18 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_3|java.lang.NullPointerException:null|1java.lang.NullPointerException2014-11-18 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_1|java.lang.NullPointerException:null|1at 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_10java.lang.NullPointerException2014-11-18 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_2|java.lang.NullPointerException:null|1at 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_5Exception in component tJDBCInput_112014-11-18 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_9|java.lang.NullPointerException:null|1java.lang.NullPointerExceptionat 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_4java.lang.NullPointerException2014-11-18 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_13|java.lang.NullPointerException:null|1at 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.NullPointerExceptionat 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|1at 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|12014-11-18 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_5|java.lang.NullPointerException:null|12014-11-18 13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|1Exception in component tJDBCOutput_6org.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 pipeat 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 more2014-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.|1Exception in component tRunJob_1java.lang.RuntimeException: Child job running failedat 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|1Exception in component tJDBCInput_4java.lang.NullPointerExceptionat 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|1Exception in component tJDBCInput_4java.lang.NullPointerExceptionat 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|1Exception in component tRunJob_4java.lang.RuntimeException: Child job running failedat 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|1Exception in component tRunJob_1java.lang.RuntimeException: Child job running failedat 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|1Exception in component tJDBCOutput_3org.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:致命错误: 由于管理员命令中断联接|1Exception in component tRunJob_4java.lang.RuntimeException: Child job running failedat 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|1Exception in component tRunJob_1java.lang.RuntimeException: Child job running failedat 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|1Exception in component tJDBCInput_4java.lang.NullPointerExceptionat 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|1Exception in component tJDBCInput_4java.lang.NullPointerExceptionat 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|1Exception in component tRunJob_4java.lang.RuntimeException: Child job running failedat 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|1Exception in component tRunJob_1java.lang.RuntimeException: Child job running failedat 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|1Exception in component tJDBCOutput_3org.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:致命错误: 由于管理员命令中断联接|1Exception in component tRunJob_4java.lang.RuntimeException: Child job running failedat 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|1Exception in component tRunJob_1java.lang.RuntimeException: Child job running failedat 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|1Exception in component tJDBCInput_6java.lang.NullPointerExceptionat 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|1Exception in component tJDBCInput_1java.lang.NullPointerExceptionat 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_11Exception in component tJDBCInput_9Exception in component tJDBCInput_10java.lang.NullPointerExceptionat 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_132014-11-18 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_1|java.lang.NullPointerException:null|1java.lang.NullPointerExceptionat 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.NullPointerException2014-11-18 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_11|java.lang.NullPointerException:null|1at 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_4Exception in component tJDBCInput_3java.lang.NullPointerException2014-11-18 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_10|java.lang.NullPointerException:null|1at 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|1Exception in component tJDBCInput_2java.lang.NullPointerExceptionat 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.NullPointerException2014-11-18 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_13|java.lang.NullPointerException:null|1at 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.NullPointerExceptionat 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.NullPointerException2014-11-18 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_3|java.lang.NullPointerException:null|1at 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|12014-11-18 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_2|java.lang.NullPointerException:null|12014-11-18 17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_5|java.lang.NullPointerException:null|1Exception in component tJDBCOutput_6org.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 pipeat 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 more2014-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.|1Exception in component tRunJob_1java.lang.RuntimeException: Child job running failedat 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|1Exception in component tJDBCInput_5java.lang.NullPointerExceptionat 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|1Exception in component tJDBCInput_1java.lang.NullPointerExceptionat 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_20Exception in component tJDBCInput_21java.lang.NullPointerExceptionat 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_19java.lang.NullPointerExceptionat 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_26java.lang.NullPointerExceptionat 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_10java.lang.NullPointerExceptionat 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_9Exception in component tJDBCInput_12java.lang.NullPointerExceptionat 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|1Exception in component tJDBCInput_142014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_26|java.lang.NullPointerException:null|1java.lang.NullPointerExceptionat 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_23java.lang.NullPointerExceptionat 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_13Exception in component tJDBCInput_7Exception in component tJDBCInput_11Exception in component tJDBCInput_8Exception in component tJDBCInput_4Exception in component tJDBCInput_5Exception in component tJDBCInput_6Exception in component tJDBCInput_2Exception in component tJDBCInput_3java.lang.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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_22Exception in component tJDBCInput_24java.lang.NullPointerExceptionat 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_25Exception in component tJDBCInput_16Exception in component tJDBCInput_15java.lang.NullPointerExceptionat 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_17java.lang.NullPointerExceptionat 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_18java.lang.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerExceptionat 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.NullPointerException2014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_19|java.lang.NullPointerException:null|1at 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|1at 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|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_24|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_25|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_16|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_17|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_20|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_15|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_9|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_13|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_3|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_7|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_11|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_8|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_5|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_6|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_2|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_23|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_14|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_12|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_21|java.lang.NullPointerException:null|12014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_10|java.lang.NullPointerException:null|1Exception in component tRunJob_2java.lang.RuntimeException: Child job running failedat 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@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@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_versionFROM datacenter_samples_historyWHERE 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)
Looking forward your reply . Thank you very much.
2014-11-17 14:31 GMT+08:00 Shirly Radco <sradco@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@gmail.com>
> To: Devel@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@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@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@redhat.com > :
>
>
>
> Are all your servers sync to the same ntp and in UTM time?
> Can you attach logs?
>
>
> Yaniv
>
>
>
>
> lastHourAggr | | 2014- 11-15 06:00:00+08> From: "张亚琪" < zhangyingyun001@gmail.com >
> To: Devel@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
>
>
> 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@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
>
>
>
>
> _______________________________________________
> Devel mailing list
> Devel@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel