1 2 3 Previous Next 30 Replies Latest reply: Mar 6, 2007 11:07 AM by 3004 RSS

    Connection reset by peer: socket write error

    3004

      Hi,
      I am seeing the behaviour the Number of Active Connections in the Connection Pool
      keeps increasing with time and eventually the Connection Pool is exhausted.

      I think the following is causing this problem: If an operation is invoked which
      gets a Connection and if at that time the following error occurs:
      "weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking to the server,
      java.net.SocketException: Connection reset by peer: socket write error"
      that connection never gets cleared from the Connection Pool.

      Before asking the DBA's of other Organization (This Database belongs to another
      orgainzation I need to determine the following:
      1. Is there a way I can replicate this and confirm that this really is the case.
      2. is there a work-around that BEA can provide for such an error


      Attached below is the stack trace.


      ****************************************************************
      weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking to the server,
      java.net.SocketException: Connection reset by peer: socket write error
      at weblogic.jdbc.mssqlserver4.TdsStatement.cancel(TdsStatement.java:429)
      at weblogic.jdbc.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java:826)
      at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:210)
      at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:1497)
      at weblogic.jdbc.mssqlserver4.TdsConnection.setAutoCommit(TdsConnection.java:204)
      at weblogic.jdbc.wrapper.JTSConnection.init(JTSConnection.java:80)
      at weblogic.jdbc.jts.Driver.newConnection(Driver.java:630)
      at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:195)
      at weblogic.jdbc.jts.Driver.connect(Driver.java:153)
      at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298)
      at gov.cdc.srp.util.ResourceFactory.getConnection(ResourceFactory.java)
      at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
      at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
      at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
      at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
      at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
      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:324)
      at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
      at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
      at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
      at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
      at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
      at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
      at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
      java.lang.NullPointerException
      at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
      at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
      at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
      at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
      at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
      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:324)
      at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
      at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
      at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
      at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
      at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
      at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
      at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
      2004-07-07 09:28:58,488 DEBUG RequestProcessor - processForwardConfig(ForwardConfig[name=createBox,path=/AliquotBoxInfo,redirect=false,contextRelative=false])

      *******************************************
      Thanks
      Rashmi

        • 1. Re: Connection reset by peer: socket write error
          3004


          Rashmi wrote:
          Hi,
          I am seeing the behaviour the Number of Active Connections in the Connection Pool
          keeps increasing with time and eventually the Connection Pool is exhausted.

          I think the following is causing this problem: If an operation is invoked which
          gets a Connection and if at that time the following error occurs:
          "weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking to the server,
          java.net.SocketException: Connection reset by peer: socket write error"
          that connection never gets cleared from the Connection Pool.

          Before asking the DBA's of other Organization (This Database belongs to another
          orgainzation I need to determine the following:
          1. Is there a way I can replicate this and confirm that this really is the case.
          2. is there a work-around that BEA can provide for such an error


          Attached below is the stack trace.
          What version of weblogic are you running?
          Joe

          >
          ****************************************************************
          weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking to the server,
          java.net.SocketException: Connection reset by peer: socket write error
          at weblogic.jdbc.mssqlserver4.TdsStatement.cancel(TdsStatement.java:429)
          at weblogic.jdbc.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java:826)
          at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:210)
          at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:1497)
          at weblogic.jdbc.mssqlserver4.TdsConnection.setAutoCommit(TdsConnection.java:204)
          at weblogic.jdbc.wrapper.JTSConnection.init(JTSConnection.java:80)
          at weblogic.jdbc.jts.Driver.newConnection(Driver.java:630)
          at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:195)
          at weblogic.jdbc.jts.Driver.connect(Driver.java:153)
          at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298)
          at gov.cdc.srp.util.ResourceFactory.getConnection(ResourceFactory.java)
          at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
          at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
          at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
          at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
          at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
          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:324)
          at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
          at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
          at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
          at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
          at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
          at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
          at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
          at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
          at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
          at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
          at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
          at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
          at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
          at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
          java.lang.NullPointerException
          at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
          at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
          at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
          at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
          at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
          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:324)
          at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
          at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
          at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
          at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
          at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
          at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
          at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
          at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
          at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
          at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
          at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
          at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
          at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
          at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
          2004-07-07 09:28:58,488 DEBUG RequestProcessor - processForwardConfig(ForwardConfig[name=createBox,path=/AliquotBoxInfo,redirect=false,contextRelative=false])

          *******************************************
          Thanks
          Rashmi
          • 2. Re: Connection reset by peer: socket write error
            3004

            Weblogic 8.1 - No Service Pack

            Joe Weinstein <joeNOSPAM@bea.com> wrote:
            >
            >
            Rashmi wrote:
            Hi,
            I am seeing the behaviour the Number of Active Connections in the Connection
            Pool
            keeps increasing with time and eventually the Connection Pool is exhausted.

            I think the following is causing this problem: If an operation is invoked
            which
            gets a Connection and if at that time the following error occurs:
            "weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
            to the server,
            java.net.SocketException: Connection reset by peer: socket write error"
            that connection never gets cleared from the Connection Pool.

            Before asking the DBA's of other Organization (This Database belongs
            to another
            orgainzation I need to determine the following:
            1. Is there a way I can replicate this and confirm that this really
            is the case.
            2. is there a work-around that BEA can provide for such an error


            Attached below is the stack trace.
            What version of weblogic are you running?
            Joe
            ****************************************************************
            weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
            to the server,
            java.net.SocketException: Connection reset by peer: socket write error
            at weblogic.jdbc.mssqlserver4.TdsStatement.cancel(TdsStatement.java:429)
            at weblogic.jdbc.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java:826)
            at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:210)
            at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:1497)
            at weblogic.jdbc.mssqlserver4.TdsConnection.setAutoCommit(TdsConnection.java:204)
            at weblogic.jdbc.wrapper.JTSConnection.init(JTSConnection.java:80)
            at weblogic.jdbc.jts.Driver.newConnection(Driver.java:630)
            at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:195)
            at weblogic.jdbc.jts.Driver.connect(Driver.java:153)
            at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298)
            at gov.cdc.srp.util.ResourceFactory.getConnection(ResourceFactory.java)
            at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
            at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
            at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
            at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
            at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
            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:324)
            at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
            at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
            at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
            at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
            at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
            at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
            at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
            at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
            at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
            at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
            at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
            at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
            at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
            at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
            java.lang.NullPointerException
            at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
            at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
            at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
            at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
            at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
            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:324)
            at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
            at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
            at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
            at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
            at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
            at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
            at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
            at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
            at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
            at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
            at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
            at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
            at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
            at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
            2004-07-07 09:28:58,488 DEBUG RequestProcessor - processForwardConfig(ForwardConfig[name=createBox,path=/AliquotBoxInfo,redirect=false,contextRelative=false])

            *******************************************
            Thanks
            Rashmi
            • 3. Re: Connection reset by peer: socket write error
              3004


              Rashmi wrote:
              Weblogic 8.1 - No Service Pack
              Hi. Ok. Yes, you are correct. It seems that if the connection
              fails during that call, we may leak connections from the pool.
              I will file a CR. If the solution exists in a later service pack,
              will you upgrade?
              Joe

              Joe Weinstein <joeNOSPAM@bea.com> wrote:
              Rashmi wrote:

              Hi,
              I am seeing the behaviour the Number of Active Connections in the Connection
              Pool
              keeps increasing with time and eventually the Connection Pool is exhausted.

              I think the following is causing this problem: If an operation is invoked
              which
              gets a Connection and if at that time the following error occurs:
              "weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
              to the server,
              java.net.SocketException: Connection reset by peer: socket write error"
              that connection never gets cleared from the Connection Pool.

              Before asking the DBA's of other Organization (This Database belongs
              to another
              orgainzation I need to determine the following:
              1. Is there a way I can replicate this and confirm that this really
              is the case.
              2. is there a work-around that BEA can provide for such an error


              Attached below is the stack trace.
              What version of weblogic are you running?
              Joe

              ****************************************************************
              weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
              to the server,
              java.net.SocketException: Connection reset by peer: socket write error
              at weblogic.jdbc.mssqlserver4.TdsStatement.cancel(TdsStatement.java:429)
              at weblogic.jdbc.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java:826)
              at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:210)
              at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:1497)
              at weblogic.jdbc.mssqlserver4.TdsConnection.setAutoCommit(TdsConnection.java:204)
              at weblogic.jdbc.wrapper.JTSConnection.init(JTSConnection.java:80)
              at weblogic.jdbc.jts.Driver.newConnection(Driver.java:630)
              at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:195)
              at weblogic.jdbc.jts.Driver.connect(Driver.java:153)
              at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298)
              at gov.cdc.srp.util.ResourceFactory.getConnection(ResourceFactory.java)
              at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
              at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
              at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
              at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
              at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
              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:324)
              at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
              at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
              at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
              at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
              at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
              at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
              at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
              at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
              at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
              at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
              at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
              at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
              at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
              at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
              at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
              at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
              java.lang.NullPointerException
              at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
              at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
              at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
              at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
              at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
              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:324)
              at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
              at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
              at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
              at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
              at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
              at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
              at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
              at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
              at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
              at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
              at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
              at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
              at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
              at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
              at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
              at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
              2004-07-07 09:28:58,488 DEBUG RequestProcessor - processForwardConfig(ForwardConfig[name=createBox,path=/AliquotBoxInfo,redirect=false,contextRelative=false])

              *******************************************
              Thanks
              Rashmi
              • 4. Re: Connection reset by peer: socket write error
                3004


                Rashmi wrote:
                Weblogic 8.1 - No Service Pack
                Hi. Another thing. I think you can avoid this problem if you
                define your pool to test connections during reserve. Can you do
                that?
                thanks,
                Joe


                >
                Joe Weinstein <joeNOSPAM@bea.com> wrote:
                Rashmi wrote:

                Hi,
                I am seeing the behaviour the Number of Active Connections in the Connection
                Pool
                keeps increasing with time and eventually the Connection Pool is exhausted.

                I think the following is causing this problem: If an operation is invoked
                which
                gets a Connection and if at that time the following error occurs:
                "weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
                to the server,
                java.net.SocketException: Connection reset by peer: socket write error"
                that connection never gets cleared from the Connection Pool.

                Before asking the DBA's of other Organization (This Database belongs
                to another
                orgainzation I need to determine the following:
                1. Is there a way I can replicate this and confirm that this really
                is the case.
                2. is there a work-around that BEA can provide for such an error


                Attached below is the stack trace.
                What version of weblogic are you running?
                Joe

                ****************************************************************
                weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
                to the server,
                java.net.SocketException: Connection reset by peer: socket write error
                at weblogic.jdbc.mssqlserver4.TdsStatement.cancel(TdsStatement.java:429)
                at weblogic.jdbc.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java:826)
                at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:210)
                at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:1497)
                at weblogic.jdbc.mssqlserver4.TdsConnection.setAutoCommit(TdsConnection.java:204)
                at weblogic.jdbc.wrapper.JTSConnection.init(JTSConnection.java:80)
                at weblogic.jdbc.jts.Driver.newConnection(Driver.java:630)
                at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:195)
                at weblogic.jdbc.jts.Driver.connect(Driver.java:153)
                at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298)
                at gov.cdc.srp.util.ResourceFactory.getConnection(ResourceFactory.java)
                at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
                at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
                at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
                at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
                at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
                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:324)
                at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
                at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
                at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
                at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
                at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
                at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
                at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
                at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
                at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
                at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
                at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
                at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
                at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
                at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
                at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
                at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
                java.lang.NullPointerException
                at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
                at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
                at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
                at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
                at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
                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:324)
                at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
                at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
                at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
                at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
                at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
                at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
                at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
                at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
                at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
                at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
                at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
                at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
                at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
                at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
                at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
                at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
                2004-07-07 09:28:58,488 DEBUG RequestProcessor - processForwardConfig(ForwardConfig[name=createBox,path=/AliquotBoxInfo,redirect=false,contextRelative=false])

                *******************************************
                Thanks
                Rashmi
                • 5. Re: Connection reset by peer: socket write error
                  3004

                  Hi ,

                  Thanks for the reply.

                  I had TestConnections on Reserve as 'True'. But I still got the same error. Is
                  tehre any other setting that needs to be set.

                  Thanks
                  Rashmi
                  Joe Weinstein <joeNOSPAM@bea.com> wrote:
                  >
                  >
                  Rashmi wrote:
                  Weblogic 8.1 - No Service Pack
                  Hi. Another thing. I think you can avoid this problem if you
                  define your pool to test connections during reserve. Can you do
                  that?
                  thanks,
                  Joe

                  Joe Weinstein <joeNOSPAM@bea.com> wrote:
                  Rashmi wrote:

                  Hi,
                  I am seeing the behaviour the Number of Active Connections in the
                  Connection
                  Pool
                  keeps increasing with time and eventually the Connection Pool is exhausted.

                  I think the following is causing this problem: If an operation is
                  invoked
                  which
                  gets a Connection and if at that time the following error occurs:
                  "weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
                  to the server,
                  java.net.SocketException: Connection reset by peer: socket write error"
                  that connection never gets cleared from the Connection Pool.

                  Before asking the DBA's of other Organization (This Database belongs
                  to another
                  orgainzation I need to determine the following:
                  1. Is there a way I can replicate this and confirm that this really
                  is the case.
                  2. is there a work-around that BEA can provide for such an error


                  Attached below is the stack trace.
                  What version of weblogic are you running?
                  Joe

                  ****************************************************************
                  weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
                  to the server,
                  java.net.SocketException: Connection reset by peer: socket write error
                  at weblogic.jdbc.mssqlserver4.TdsStatement.cancel(TdsStatement.java:429)
                  at weblogic.jdbc.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java:826)
                  at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:210)
                  at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:1497)
                  at weblogic.jdbc.mssqlserver4.TdsConnection.setAutoCommit(TdsConnection.java:204)
                  at weblogic.jdbc.wrapper.JTSConnection.init(JTSConnection.java:80)
                  at weblogic.jdbc.jts.Driver.newConnection(Driver.java:630)
                  at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:195)
                  at weblogic.jdbc.jts.Driver.connect(Driver.java:153)
                  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298)
                  at gov.cdc.srp.util.ResourceFactory.getConnection(ResourceFactory.java)
                  at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
                  at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
                  at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
                  at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
                  at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
                  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:324)
                  at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
                  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
                  at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
                  at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
                  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
                  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                  at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
                  at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
                  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                  at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
                  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
                  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
                  at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
                  at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
                  at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
                  at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
                  java.lang.NullPointerException
                  at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
                  at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
                  at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
                  at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
                  at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
                  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:324)
                  at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
                  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
                  at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
                  at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
                  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
                  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                  at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
                  at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
                  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                  at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
                  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
                  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
                  at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
                  at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
                  at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
                  at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
                  2004-07-07 09:28:58,488 DEBUG RequestProcessor - processForwardConfig(ForwardConfig[name=createBox,path=/AliquotBoxInfo,redirect=false,contextRelative=false])

                  *******************************************
                  Thanks
                  Rashmi
                  • 6. Re: Connection reset by peer: socket write error
                    3004


                    Rashmi wrote:
                    Hi ,

                    Thanks for the reply.

                    I had TestConnections on Reserve as 'True'. But I still got the same error. Is
                    tehre any other setting that needs to be set.
                    Ok, how easily duplicable is this problem? Will you please turn on jdbc logging,
                    and do the mimnimum necessary to duplicate the problem, then show me the
                    jdbc.log file. You should verify that your DAO code obtains a pool connection
                    each time a user invokes it, and that the DAO closes the connection regardless of
                    results, by the end of the user invoke.
                    If you have test-on-reserve set true, then it means that we verified the connection
                    was OK, just before giving it to the code that fails, so whatever happened killed
                    the connection very quickly between our testing it and our code that sets the
                    autoCommit state... What is your pool's test table? Can you show me your pool definition
                    from the config file?

                    Joe


                    >
                    Thanks
                    Rashmi
                    Joe Weinstein <joeNOSPAM@bea.com> wrote:
                    Rashmi wrote:

                    Weblogic 8.1 - No Service Pack
                    Hi. Another thing. I think you can avoid this problem if you
                    define your pool to test connections during reserve. Can you do
                    that?
                    thanks,
                    Joe


                    Joe Weinstein <joeNOSPAM@bea.com> wrote:

                    Rashmi wrote:


                    Hi,
                    I am seeing the behaviour the Number of Active Connections in the
                    Connection
                    Pool

                    keeps increasing with time and eventually the Connection Pool is exhausted.

                    I think the following is causing this problem: If an operation is
                    invoked
                    which

                    gets a Connection and if at that time the following error occurs:
                    "weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
                    to the server,

                    java.net.SocketException: Connection reset by peer: socket write error"
                    that connection never gets cleared from the Connection Pool.

                    Before asking the DBA's of other Organization (This Database belongs
                    to another

                    orgainzation I need to determine the following:
                    1. Is there a way I can replicate this and confirm that this really
                    is the case.

                    2. is there a work-around that BEA can provide for such an error


                    Attached below is the stack trace.
                    What version of weblogic are you running?
                    Joe


                    ****************************************************************
                    weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
                    to the server,

                    java.net.SocketException: Connection reset by peer: socket write error
                    at weblogic.jdbc.mssqlserver4.TdsStatement.cancel(TdsStatement.java:429)
                    at weblogic.jdbc.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java:826)
                    at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:210)
                    at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:1497)
                    at weblogic.jdbc.mssqlserver4.TdsConnection.setAutoCommit(TdsConnection.java:204)
                    at weblogic.jdbc.wrapper.JTSConnection.init(JTSConnection.java:80)
                    at weblogic.jdbc.jts.Driver.newConnection(Driver.java:630)
                    at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:195)
                    at weblogic.jdbc.jts.Driver.connect(Driver.java:153)
                    at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298)
                    at gov.cdc.srp.util.ResourceFactory.getConnection(ResourceFactory.java)
                    at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
                    at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
                    at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
                    at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
                    at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
                    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:324)
                    at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
                    at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
                    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
                    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
                    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
                    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                    at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
                    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
                    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                    at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
                    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
                    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
                    at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
                    at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
                    at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
                    at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
                    java.lang.NullPointerException
                    at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
                    at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
                    at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
                    at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
                    at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
                    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:324)
                    at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
                    at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
                    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
                    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
                    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
                    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                    at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
                    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
                    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                    at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
                    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
                    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
                    at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
                    at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
                    at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
                    at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
                    2004-07-07 09:28:58,488 DEBUG RequestProcessor - processForwardConfig(ForwardConfig[name=createBox,path=/AliquotBoxInfo,redirect=false,contextRelative=false])

                    *******************************************
                    Thanks
                    Rashmi
                    • 7. Re: Connection reset by peer: socket write error
                      3004

                      Hi,

                      I saw some instances of our code where connection was not being closed. Today
                      we will place the fixes for this in Production.

                      Alos, at the time when the Connection Pool was exhausting I saw one more error
                      in the log
                      java.sql.SQLException: start() failed on resource 'weblogic.jdbc.wrapper.JTSXAResourceImpl':
                      XAER_RMFAIL : Resource manager is unavailable

                      I was told by BEA Support that this is a known issue and patch is available.

                      So, I will keep monitoring the Pools and report if the Connection Reset By Peer
                      Error reappears.

                      Thanks
                      rashmi
                      Joe Weinstein <joeNOSPAM@bea.com> wrote:
                      >
                      >
                      Rashmi wrote:
                      Hi ,

                      Thanks for the reply.

                      I had TestConnections on Reserve as 'True'. But I still got the same
                      error. Is
                      tehre any other setting that needs to be set.
                      Ok, how easily duplicable is this problem? Will you please turn on jdbc
                      logging,
                      and do the mimnimum necessary to duplicate the problem, then show me
                      the
                      jdbc.log file. You should verify that your DAO code obtains a pool connection
                      each time a user invokes it, and that the DAO closes the connection regardless
                      of
                      results, by the end of the user invoke.
                      If you have test-on-reserve set true, then it means that we verified
                      the connection
                      was OK, just before giving it to the code that fails, so whatever happened
                      killed
                      the connection very quickly between our testing it and our code that
                      sets the
                      autoCommit state... What is your pool's test table? Can you show me your
                      pool definition
                      from the config file?

                      Joe

                      Thanks
                      Rashmi
                      Joe Weinstein <joeNOSPAM@bea.com> wrote:
                      Rashmi wrote:

                      Weblogic 8.1 - No Service Pack
                      Hi. Another thing. I think you can avoid this problem if you
                      define your pool to test connections during reserve. Can you do
                      that?
                      thanks,
                      Joe


                      Joe Weinstein <joeNOSPAM@bea.com> wrote:

                      Rashmi wrote:


                      Hi,
                      I am seeing the behaviour the Number of Active Connections in the
                      Connection
                      Pool

                      keeps increasing with time and eventually the Connection Pool is
                      exhausted.
                      I think the following is causing this problem: If an operation is
                      invoked
                      which

                      gets a Connection and if at that time the following error occurs:
                      "weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
                      to the server,

                      java.net.SocketException: Connection reset by peer: socket write
                      error"
                      that connection never gets cleared from the Connection Pool.

                      Before asking the DBA's of other Organization (This Database belongs
                      to another

                      orgainzation I need to determine the following:
                      1. Is there a way I can replicate this and confirm that this really
                      is the case.

                      2. is there a work-around that BEA can provide for such an error


                      Attached below is the stack trace.
                      What version of weblogic are you running?
                      Joe


                      ****************************************************************
                      weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking
                      to the server,

                      java.net.SocketException: Connection reset by peer: socket write
                      error
                      at weblogic.jdbc.mssqlserver4.TdsStatement.cancel(TdsStatement.java:429)
                      at weblogic.jdbc.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java:826)
                      at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:210)
                      at weblogic.jdbc.mssqlserver4.TdsStatement.execute(TdsStatement.java:1497)
                      at weblogic.jdbc.mssqlserver4.TdsConnection.setAutoCommit(TdsConnection.java:204)
                      at weblogic.jdbc.wrapper.JTSConnection.init(JTSConnection.java:80)
                      at weblogic.jdbc.jts.Driver.newConnection(Driver.java:630)
                      at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:195)
                      at weblogic.jdbc.jts.Driver.connect(Driver.java:153)
                      at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298)
                      at gov.cdc.srp.util.ResourceFactory.getConnection(ResourceFactory.java)
                      at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
                      at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
                      at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
                      at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
                      at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
                      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:324)
                      at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
                      at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
                      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
                      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
                      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
                      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                      at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
                      at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
                      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
                      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                      at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
                      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
                      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
                      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
                      at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
                      at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
                      at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
                      at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
                      java.lang.NullPointerException
                      at gov.cdc.srp.ras.model.RASDAO.getBoxInfo(RASDAO.java)
                      at gov.cdc.srp.ras.rasmanager.RASManagerBean.getBoxInfo(RASManagerBean.java)
                      at gov.cdc.srp.ras.rasmanager.RASManagerBean_djr5e6_EOImpl.getBoxInfo(RASManagerBean_djr5e6_EOImpl.java:370)
                      at gov.cdc.srp.ras.RAS_BD.getBoxInfo(RAS_BD.java)
                      at gov.cdc.srp.ras.CreateDistributionBoxAction.getBoxInfo(CreateDistributionBoxAction.java)
                      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:324)
                      at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
                      at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
                      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
                      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
                      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
                      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                      at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
                      at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
                      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
                      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                      at gov.cdc.srp.ras.SecureFilter.doFilter(SecureFilter.java)
                      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
                      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6297)
                      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
                      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
                      at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
                      at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2573)
                      at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
                      at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)
                      2004-07-07 09:28:58,488 DEBUG RequestProcessor - processForwardConfig(ForwardConfig[name=createBox,path=/AliquotBoxInfo,redirect=false,contextRelative=false])

                      *******************************************
                      Thanks
                      Rashmi
                      • 8. Re: Connection reset by peer: socket write error
                        666705
                        I was told by BEA Support that this is a known issue >>and patch is available.
                        I had the same problem. Could you please to tell which patch do you mean?
                        • 9. Re: Connection reset by peer: socket write error
                          666705
                          Hi. Just an FYI, I already have my connection pool set to test connections on reserve and I still get this error. We're running 8.1 sp2. Is there any downside to this situation that throws the error? Can I just ignore it? Thanks,
                          Maggie
                          • 10. Re: Connection reset by peer: socket write error
                            666705
                            Could it be that the test on reserve is failing? It's strange but the job where this occurs seems to run OK even though it encounters this error. How can you tell that the test on reserve went ok?

                            Thanks. Maggie
                            • 11. Re: Connection reset by peer: socket write error
                              3004
                              "Maggie Verdier" <noaddress@noaddress.given> wrote in message news:610305.1094171292576.JavaMail.root@jserv5...
                              Could it be that the test on reserve is failing? It's strange but the job where this occurs seems to run OK even though it
                              encounters this error. How can you tell that the test on reserve went ok?
                              >

                              You can tell this by the fact that your application
                              operates normally.

                              Could you post the pool's configuration and the a full stack
                              trace for the exception?

                              Regards,

                              Slava Imeshev


                              • 12. Re: Connection reset by peer
                                666705
                                I am getting a lot of Connection reset by peer messages on WebLogic 8.1 SP1 and SP2. I was wondering if you found a solution to this problem.

                                Thanks,
                                Kevin.
                                • 13. Re: Connection reset by peer
                                  3004


                                  Kevin Joseph wrote:
                                  I am getting a lot of Connection reset by peer messages on WebLogic 8.1 SP1 and SP2. I was wondering if you found a solution to this problem.

                                  Thanks,
                                  Kevin.
                                  Hi Kevin. That sort of message is typically caused by something outside WebLogic and
                                  outside the JDBC driver, killing the socket between the driver and the DBMS. Check
                                  if the DBMS or a firewall has an idle-session-disconnect limit.
                                  Joe

                                  • 14. Re: Connection reset by peer
                                    666705
                                    I am getting similar problem with tomcat and SQL Server. I checked SQL Server logs, nothing fishy there.
                                    Its definately not timeout, since it happens during the transaction.
                                    There is no firewall between the application server and db server.
                                    Though it has nothing to do with BEA Weblogic but its very similar to the current thread's discussion. I was hoping if i can get some leads to figure out whats the root cause of the problem.

                                    Message was edited by adnan06 at Dec 26, 2004 9:17 PM
                                    1 2 3 Previous Next