US and Worldwide: +1 (866) 660-7555
Results 1 to 5 of 5

Thread: Analysis socket write error after some downtime

  1. #1
    Join Date
    Apr 2013
    Posts
    8

    Unhappy Analysis socket write error after some downtime

    Hi

    I am seeing the following error when running an analytical report via the user web interface, after an hour or so of no user activity . I can't even say no server activity since I purposefully have a report running in the background. every 20 minutes just to try and keep it active. I am running mysql in for both "hibernate" report metadata and actual warehouse data. I am running c3p0 for"hibernate" repository and have gone through that whole path of re mediating the so called 8 hour error. This is driving me nuts and delaying production release. Sorry if this is a well known thing , I have not been able to find it elsewhere.



    2013-09-30 13:31:20,183 DEBUG [mondrian.rolap.RolapUtil] HighCardSqlTupleReader.readTuples [[Measurement_Date].[Measurement_month]]: done executing sql [select `measurement_month`.`measurement_month` as `c0` from `measurement_month` as `measurement_month`, `careteam_measure` as `careteam_measure` where `careteam_measure`.`MEASUREMENT_MONTH` = `measurement_month`.`measurement_month` group by `measurement_month`.`measurement_month` having (NOT((sum(`careteam_measure`.`denominator`) is null)) OR NOT((sum(`careteam_measure`.`numerator`) is null)) ) order by ISNULL(`measurement_month`.`measurement_month`) ASC, `measurement_month`.`measurement_month` ASC], exec+fetch 0 ms, 0 rows, ex=11, close=11, open=[]
    2013-09-30 13:31:20,184 DEBUG [mondrian.rolap.RolapUtil] HighCardSqlTupleReader.readTuples [[Measurement_Date].[Measurement_month]]: executing sql [select `measurement_month`.`measurement_month` as `c0` from `measurement_month` as `measurement_month`, `careteam_measure` as `careteam_measure` where `careteam_measure`.`MEASUREMENT_MONTH` = `measurement_month`.`measurement_month` group by `measurement_month`.`measurement_month` having (NOT((sum(`careteam_measure`.`denominator`) is null)) OR NOT((sum(`careteam_measure`.`numerator`) is null)) ) order by ISNULL(`measurement_month`.`measurement_month`) ASC, `measurement_month`.`measurement_month` ASC], failed (com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


    The last packet successfully received from the server was 1,877,214 milliseconds ago. The last packet sent successfully to the server was 1,877,278 milliseconds ago.)
    2013-09-30 13:31:20,417 ERROR [com.pentaho.analyzer.a.j] Ticket Number: 1380562280417
    2013-09-30 13:31:20,418 ERROR [com.pentaho.analyzer.a.j] Exception in AJAX handler.
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.net.SocketException: Connection reset by peer: socket write error
    at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:216)
    at com.pentaho.analyzer.content.controller.c.a(SourceFile:282)
    at com.pentaho.analyzer.content.controller.n.ee(SourceFile:182)
    at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:199)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.pentaho.platform.web.http.context.WebSpringPentahoObjectFactory$a.invoke(SourceFile:288)
    at $Proxy29.createContent(Unknown Source)
    at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
    at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:72)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)
    Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.net.SocketException: Connection reset by peer: socket write error
    at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:232)
    at java.util.concurrent.FutureTask.get(FutureTask.java:91)
    at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:174)
    ... 73 more
    Caused by: java.lang.RuntimeException: java.net.SocketException: Connection reset by peer: socket write error
    at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:299)
    at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:298)
    at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(SourceFile:358)
    at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:122)
    at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:93)
    at com.pentaho.analyzer.report.ReportRequestService$c.bq(SourceFile:268)
    at com.pentaho.analyzer.report.ReportRequestService$c.call(SourceFile:258)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    ... 1 more
    Caused by: java.net.SocketException: Connection reset by peer: socket write error
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
    at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
    at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3832)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2471)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2728)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2678)
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    at mondrian.rolap.SqlStatement.execute(SqlStatement.java:182)
    at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:332)
    at mondrian.rolap.HighCardSqlTupleReader.prepareTuples(HighCardSqlTupleReader.java:77)
    at mondrian.rolap.HighCardSqlTupleReader.readMembers(HighCardSqlTupleReader.java:135)
    at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:233)
    at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:176)
    at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:118)
    at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50)
    at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919)
    at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88)
    at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61)
    at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
    at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:109)
    at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
    at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919)
    at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88)
    at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61)
    at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
    at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:201)
    at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
    at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:919)
    at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:88)
    at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:61)
    at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98)
    at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:817)
    at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:642)
    at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:598)
    at mondrian.rolap.RolapResult.<init>(RolapResult.java:286)
    at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:680)
    at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
    at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:631)
    at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:630)
    ... 5 more

  2. #2
    Join Date
    Jan 2013
    Posts
    548

    Default

    Are you using connection pooling? It sounds like a stale connection is being used.

    If you are using connection pooling, you could try adding the JDBC parameters

    testOnBorrow="true"
    validationQuery="SELECT 1"

  3. #3
    Join Date
    Apr 2013
    Posts
    8

    Default

    I have both statements in my "hibernate" connection and my jndi data connection. Still get the error

  4. #4
    Join Date
    Apr 2013
    Posts
    8

    Default

    Really know one else has seen this before ? It is most annoying and defies all my efforts to defeat it.

  5. #5
    Join Date
    Nov 2008
    Posts
    777

    Default

    Do you have this at the end of your JDBC URL? That has solved the issue for me with MySQL.
    Code:
    ?autoReconnect=true
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •