Guest User

I am downloading a large amount of excel, but thread still exists for a couple of days.
Every time it piles up, I used to reload the container. I would like to know what caused a problem.
java.net.SocketInputStream.socketRead0(Native Method) 
java.net.SocketInputStream.read(SocketInputStream.java:141) 
com.javaservice.lwst.SocketWrapper$InputStreamWrap.read(Unknown Source) 
oracle.net.ns.Packet.receive(Packet.java:308) 
oracle.net.ns.DataPacket.receive(DataPacket.java:106) 
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:324) 
oracle.net.ns.NetInputStream.read(NetInputStream.java:268) 
oracle.net.ns.NetInputStream.read(NetInputStream.java:190) 
oracle.net.ns.NetInputStream.read(NetInputStream.java:107) 
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124) 
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80) 
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137) 
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350) 
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) 
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) 
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) 
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:879) 
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) 
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608) 
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3709) 
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1090) 
net.sf.log4jdbc.PreparedStatementSpy.execute(PreparedStatementSpy.java:414) 
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) 
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) 
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) 
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) 
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139) 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) 
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) 
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:295) 
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java) 
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200) 
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293) 
nurimsoft.webapp.StatHtmlDAO.getSelectDownData(StatHtmlDAO.java:651) 
nurimsoft.stat.manager.MakeDownLarge.getMakeExcel(MakeDownLarge.java:114) 
nurimsoft.webapp.StatHtmlService.getMakeExcel(StatHtmlService.java:1261) 
nurimsoft.webapp.StatHtmlService$$FastClassByCGLIB$$3aa9b6ca.invoke( < generated > ) 
net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) 
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617) 
nurimsoft.webapp.StatHtmlService$$EnhancerByCGLIB$$f5c01797.getMakeExcel( < generated > ) 
nurimsoft.webapp.controller.StatHtmlController.makeLargeFile(StatHtmlController.java:1142) 
nurimsoft.webapp.controller.StatHtmlController.makeLarge(StatHtmlController.java:1080) 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
java.lang.reflect.Method.invoke(Method.java:600) 
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) 
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) 
javax.servlet.http.HttpServlet.service(HttpServlet.java:725) 
javax.servlet.http.HttpServlet.service(HttpServlet.java:818) 
jeus.servlet.engine.ServletWrapper.executeServlet(ServletWrapper.java:329) 
jeus.servlet.filter.FilterChainImpl.internalDoFilter(FilterChainImpl.java:138) 
jeus.servlet.filter.FilterChainImpl.doFilter(FilterChainImpl.java:90) 
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) 
jeus.servlet.filter.FilterChainImpl.internalDoFilter(FilterChainImpl.java:121) 
jeus.servlet.filter.FilterChainImpl.doFilter(FilterChainImpl.java:90) 
jeus.servlet.engine.ServletWrapper.execute(ServletWrapper.java:205) 
jeus.servlet.engine.WebtobRequestProcessor.run(WebtobRequestProcessor.java:252)

Khalid Saeed

It would exist under the socket read status.
Once the read status is over, the related thread will not appear.