连接oracle创建数据库数据库时出现Socket read timed out错误
点击联系发帖人
时间：2014-10-26 19:33
weblogic报错，主要关于&BEA-000449&Closing socket as no data read、java.net.SocketTimeoutException: Read timed out的错误，接着产生大量阻塞进程。 - DropEye | 云眼 - IT中文问答社区
weblogic报错，主要关于&BEA-000449&Closing socket as no data read、java.net.SocketTimeoutException: Read timed out的错误，接着产生大量阻塞进程。
& 上午10时45分27秒 CST& &Warning& &Socket& &BEA-000449& &Closing socket as no data read from it on 10.122.6.70:32,373 during the configured idle timeout of 5 secs&
[default][ 10:45:58,611][ERROR][com.eos.access.http.InterceptorFilter:132] /default/common.remote
java.net.SocketTimeoutException: Read timed out
&&& at java.net.SocketInputStream.socketRead0(Native Method)
&&& at java.net.SocketInputStream.read(SocketInputStream.java:129)
&&& at weblogic.servlet.internal.PostInputStream.read(PostInputStream.java:194)
&&& at weblogic.servlet.internal.ServletInputStreamImpl.read(ServletInputStreamImpl.java:228)
&&& at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2269)
&&& at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2282)
&&& at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2753)
&&& at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:777)
&&& at java.io.ObjectInputStream.&init&(ObjectInputStream.java:277)
&&& at com.primeton.access.client.monServiceProcessor.process(CommonServiceProcessor.java:47)
&&& at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:111)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:133)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:120)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
&&& at com.bps.client.user.WFInterceptorFilter.doFilter(WFInterceptorFilter.java:153)
&&& at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
&&& at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
&&& at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
&&& at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
&&& at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
&&& at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
&&& at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
&&& at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
&&& at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
&&& at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
& 上午10时45分58秒 CST& &Error& &HTTP& &BEA-101017& &[ServletContext@[app:default module:default path:/default spec-version:2.5]] Root cause of ServletException.
java.net.SocketTimeoutException: Read timed out
&&& at java.net.SocketInputStream.socketRead0(Native Method)
&&& at java.net.SocketInputStream.read(SocketInputStream.java:129)
&&& at weblogic.servlet.internal.PostInputStream.read(PostInputStream.java:194)
&&& at weblogic.servlet.internal.ServletInputStreamImpl.read(ServletInputStreamImpl.java:228)
&&& at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2269)
&&& Truncated. see log file for complete stacktrace
10:49:21 ClientCommunicatorAdmin Checker-run
警告: Failed to check the connection: java.net.SocketTimeoutException: Read timed out
& 上午10时58分57秒 CST& &Error& &WebLogicServer& &BEA-000337& &[STUCK] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "645" seconds working on the request "Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 645747 ms
GET /workspace/frame/permission/login.jsp HTTP/1.1
Cache-Control: no-cache
Pragma: no-cache
User-Agent: Java/1.5.0_22
Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
Connection: keep-alive
]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
&&& java.net.SocketInputStream.socketRead0(Native Method)
&&& java.net.SocketInputStream.read(SocketInputStream.java:129)
&&& java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
&&& java.io.BufferedInputStream.read1(BufferedInputStream.java:258)
&&& java.io.BufferedInputStream.read(BufferedInputStream.java:317)
&&& weblogic.net.http.MessageHeader.isHTTP(MessageHeader.java:224)
&&& weblogic.net.http.MessageHeader.parseHeader(MessageHeader.java:148)
&&& weblogic.net.http.HttpClient.parseHTTP(HttpClient.java:468)
&&& weblogic.net.http.HttpURLConnection.getInputStream(HttpURLConnection.java:401)
&&& weblogic.net.http.SOAPHttpURLConnection.getInputStream(SOAPHttpURLConnection.java:37)
&&& com.primeton.access.client.impl.transport.HttpToolKit.callCommonService(HttpToolKit.java:93)
&&& com.primeton.access.client.impl.transport.HttpTransportSender.doSend(HttpTransportSender.java:32)
&&& com.primeton.access.client.impl.transport.AbstractTransportSender.send(AbstractTransportSender.java:29)
&&& com.primeton.ext.access.client.ServiceClient.send(ServiceClient.java:53)
&&& com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:87)
&&& com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
&&& com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:48)
&&& com.sun.proxy.$Proxy120.isMultitenancyEnable(Unknown Source)
&&& sun.reflect.GeneratedMethodAccessor392.invoke(Unknown Source)
&&& sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
&&& java.lang.reflect.Method.invoke(Method.java:597)
&&& com.ponent.manager.api.impl.MgrInvokeProxy.invoke(MgrInvokeProxy.java:86)
&&& com.sun.proxy.$Proxy121.isMultitenancyEnable(Unknown Source)
&&& com.primeton.bps.workspace.frame.processserver.ProcessServerHelper.getMultiServerMap(ProcessServerHelper.java:18)
&&& jsp_servlet._frame._permission.__login._jspService(__login.java:242)
&&& weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
&&& weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
&&& weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
&&& weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
&&& weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
&&& weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:50)
&&& com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:133)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.primeton.workflow.web.handler.WebIntegratedFilter.doIntercept(WebIntegratedFilter.java:58)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:120)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
&&& weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
&&& weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
&&& weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
&&& weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
&&& weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
&&& weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
&&& weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
&&& weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
&&& weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
&&& weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
(150,070 积分)
官方解释如下：
BEA-000449
Warning: Closing socket as no data read from it on host:port during the configured idle timeout of idleTimeout secs
Description
Closing socket as no data read from it on host:port during the configured idle timeout of idleTimeout secs
The WebLogic Server or the network may be overloaded which is causing the socket to idle timeout.
Capacity tuning of the server is required.
BEA-101017
Error: [context] Root cause of ServletException.
Description
[context] Root cause of ServletException, which the Web application container caught while servicing the request.
The Web application container caught an unexpected exception.
Check the exception for the exact error message.
(150,070 积分)
(150,070 积分)
(150,070 积分)
(150,070 积分)
(150,070 积分)
(150,070 积分)
&| Snow Theme by
Powered by带你认识更牛的人下载即送20张免费照片冲印
扫码下载App
温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
LOFTER精选
网易考拉推荐
CauseThe /etc/resolv.conf contains invalid ip addresses of the DNS server（我将DNSip改为了本机ip，问题解决）SolutionVerify the error is reproducible&using the attached CheckConnection.class
1.&Download the attached&CheckConnection.class to any directory i.e. /usr/checkconnection/ 2. Check the TNS entry in the tnsnames.ora i.e. VIS1211= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=mmoreno-)(PORT=1551)) (CONNECT_DATA= (SID=VIS1211))) 3. Export the CLASSPATH environment variable i.e. $ export CLASSPATH=$CLASSPATH:/usr/checkconnection 4. Run CheckConnection to verify if the error is reproducible i.e. $ java CheckConnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mmoreno-)(PORT=1551))(CONNECT_DATA= (SID=VIS1211)))" apps &apps_password&
Verify that /etc/resolv.conf contains correct entries
nameserver 140.100.100.1 nameserver 140.100.100.2
Verify that nslookup gives correct output
$ nslookup mmoreno-au Server: 140.100.100.1 Address: 140.100.100.1#53 Name: mmoreno- Address: 140.1.1.143
Make sure it matches the entry in /etc/hosts
127.0.0.1 localhost.localdomain localhost 140.1.1.143 mmoreno- mmoreno-au References
Attachments
Oracle E-Business Suite & Applications Technology & Lifecycle Management & Application Install
TIME~OUT; DATABASEERROR; T4CCONNECTION; JAVA.SQL.SQLEXCEPTION; THROWSQLEXCEPTION; NEWSQLEXCEPTION; SOCKET; GETCONNECTION还可以在resolve.conf中添加如下内容，以避免以上错误DNS参数设置&&&&&&& #vi /etc/resolv.conf，增加内容按以下格式设置：&&&&&&& options attempts:5&&&&&&& options timeout:15&&&&&&& 以上设置可避免某些数据库连接失败的错误提示。
阅读(2065)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
在LOFTER的更多文章
loftPermalink:'',
id:'fks_087069',
blogTitle:'Getting Socket Read Timed Out Error When Applying A Patch Using Adpatch [ID ]',
blogAbstract:'
Modified 27-APR-2010&&&&&Type PROBLEM&&&&&Status PUBLISHED
In this Document&&
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}谈MongoDB读取连接超时的异常 - 李克华 - 博客园
云计算高级群:
交流：Hadoop、NoSQL、分布式、lucene、solr、nutch
今天在现场的哥们发来异常，让我解决，错误信息如下：
HTTP Status 500 - Read operation to server 192.168.1.110:20001 fai nested exception is com.mongodb.MongoException$Network: Read operation to server 192.168.1.110:20001 failed on database wpdb
--------------------------------------------------------------------------------
type Exception report
message Read operation to server 192.168.1.110:20001 fai nested exception is com.mongodb.MongoException$Network: Read operation to server 192.168.1.110:20001 failed on database wpdb
description The server encountered an internal error that prevented it from fulfilling this request.
org.springframework.dao.DataAccessResourceFailureException: Read operation to server 192.168.1.110:20001 fai nested exception is com.mongodb.MongoException$Network: Read operation to server 192.168.1.110:20001 failed on database wpdb
org.springframework.data.mongodb.core.MongoExceptionTranslator.translateExceptionIfPossible(MongoExceptionTranslator.java:56)
org.springframework.data.mongodb.core.MongoTemplate.potentiallyConvertRuntimeException(MongoTemplate.java:1913)
org.springframework.data.mongodb.core.MongoTemplate.executeFindOneInternal(MongoTemplate.java:1743)
org.springframework.data.mongodb.core.MongoTemplate.doFindOne(MongoTemplate.java:1557)
org.springframework.data.mongodb.core.MongoTemplate.findOne(MongoTemplate.java:497)
com.geoway.ime.tile.dao.impl.TileDaoImpl.getTile(TileDaoImpl.java:60)
com.geoway.ime.tile.service.impl.TileServiceImpl.getTile(TileServiceImpl.java:105)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:211)
org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:66)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy50.getTile(Unknown Source)
com.geoway.ime.server.rest.TileServer.getTileKVP(TileServer.java:60)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
root cause
com.mongodb.MongoException$Network: Read operation to server 192.168.1.110:20001 failed on database wpdb
com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:308)
com.mongodb.DBTCPConnector.call(DBTCPConnector.java:279)
com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:84)
com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:66)
com.mongodb.DBCollection.findOne(DBCollection.java:870)
com.mongodb.DBCollection.findOne(DBCollection.java:844)
com.mongodb.DBCollection.findOne(DBCollection.java:790)
org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:1980)
org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:1965)
org.springframework.data.mongodb.core.MongoTemplate.executeFindOneInternal(MongoTemplate.java:1739)
org.springframework.data.mongodb.core.MongoTemplate.doFindOne(MongoTemplate.java:1557)
org.springframework.data.mongodb.core.MongoTemplate.findOne(MongoTemplate.java:497)
com.geoway.ime.tile.dao.impl.TileDaoImpl.getTile(TileDaoImpl.java:60)
com.geoway.ime.tile.service.impl.TileServiceImpl.getTile(TileServiceImpl.java:105)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:211)
org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:66)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy50.getTile(Unknown Source)
com.geoway.ime.server.rest.TileServer.getTileKVP(TileServer.java:60)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
root cause
java.net.SocketTimeoutException: Read timed out
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:129)
java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
java.io.BufferedInputStream.read1(BufferedInputStream.java:258)
java.io.BufferedInputStream.read(BufferedInputStream.java:317)
org.bson.io.Bits.readFully(Bits.java:48)
org.bson.io.Bits.readFully(Bits.java:35)
org.bson.io.Bits.readFully(Bits.java:30)
com.mongodb.Response.&init&(Response.java:42)
com.mongodb.DBPort$1.execute(DBPort.java:141)
com.mongodb.DBPort$1.execute(DBPort.java:135)
com.mongodb.DBPort.doOperation(DBPort.java:164)
com.mongodb.DBPort.call(DBPort.java:135)
com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:300)
com.mongodb.DBTCPConnector.call(DBTCPConnector.java:279)
com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:84)
com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:66)
com.mongodb.DBCollection.findOne(DBCollection.java:870)
com.mongodb.DBCollection.findOne(DBCollection.java:844)
com.mongodb.DBCollection.findOne(DBCollection.java:790)
org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:1980)
org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:1965)
org.springframework.data.mongodb.core.MongoTemplate.executeFindOneInternal(MongoTemplate.java:1739)
org.springframework.data.mongodb.core.MongoTemplate.doFindOne(MongoTemplate.java:1557)
org.springframework.data.mongodb.core.MongoTemplate.findOne(MongoTemplate.java:497)
com.geoway.ime.tile.dao.impl.TileDaoImpl.getTile(TileDaoImpl.java:60)
com.geoway.ime.tile.service.impl.TileServiceImpl.getTile(TileServiceImpl.java:105)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:211)
org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:66)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy50.getTile(Unknown Source)
com.geoway.ime.server.rest.TileServer.getTileKVP(TileServer.java:60)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.41 logs.
由异常来看，是由于MongoDB连接超时造成的。于是，往MongoDB上找原因。首先上MongoDB的配置文件：
mongodb.replica-set=192.98.12.242:.12.245:30007
mongodb.hostname=192.98.12.245
mongodb.port=30007
mongodb.connections-per-host=1000
mongodb.threads-allowed-to-block-for-connection-multiplier=200
mongodb.connect-timeout=2000
mongodb.max-wait-time=2000
mongodb.auto-connect-retry=true
mongodb.socket-keep-alive=true
mongodb.socket-timeout=1500
mongodb.slave-ok=true
mongodb.write-number=1
mongodb.write-timeout=1000
mongodb.write-fsync=true
mongodb.dbname=shardvectordb
mongodb.dbuser=
mongodb.dbpassword=
连接时间2秒。然后在定位mongodb的查询，结果为6、7秒。原来是这个原因。然后定位，一个查询为什么耗时那么久呢？
经过排查，原来是查询字段没有创建索引。然后把索引创建，查询几十毫秒，ok问题全部解决。
随笔 - 239}
weblogic报错，主要关于&BEA-000449&Closing socket as no data read、java.net.SocketTimeoutException: Read timed out的错误，接着产生大量阻塞进程。
& 上午10时45分27秒 CST& &Warning& &Socket& &BEA-000449& &Closing socket as no data read from it on 10.122.6.70:32,373 during the configured idle timeout of 5 secs&
[default][ 10:45:58,611][ERROR][com.eos.access.http.InterceptorFilter:132] /default/common.remote
java.net.SocketTimeoutException: Read timed out
&&& at java.net.SocketInputStream.socketRead0(Native Method)
&&& at java.net.SocketInputStream.read(SocketInputStream.java:129)
&&& at weblogic.servlet.internal.PostInputStream.read(PostInputStream.java:194)
&&& at weblogic.servlet.internal.ServletInputStreamImpl.read(ServletInputStreamImpl.java:228)
&&& at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2269)
&&& at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2282)
&&& at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2753)
&&& at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:777)
&&& at java.io.ObjectInputStream.&init&(ObjectInputStream.java:277)
&&& at com.primeton.access.client.monServiceProcessor.process(CommonServiceProcessor.java:47)
&&& at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:111)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:133)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:120)
&&& at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
&&& at com.bps.client.user.WFInterceptorFilter.doFilter(WFInterceptorFilter.java:153)
&&& at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
&&& at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
&&& at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
&&& at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
&&& at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
&&& at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
&&& at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
&&& at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
&&& at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
&&& at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
& 上午10时45分58秒 CST& &Error& &HTTP& &BEA-101017& &[ServletContext@[app:default module:default path:/default spec-version:2.5]] Root cause of ServletException.
java.net.SocketTimeoutException: Read timed out
&&& at java.net.SocketInputStream.socketRead0(Native Method)
&&& at java.net.SocketInputStream.read(SocketInputStream.java:129)
&&& at weblogic.servlet.internal.PostInputStream.read(PostInputStream.java:194)
&&& at weblogic.servlet.internal.ServletInputStreamImpl.read(ServletInputStreamImpl.java:228)
&&& at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2269)
&&& Truncated. see log file for complete stacktrace
10:49:21 ClientCommunicatorAdmin Checker-run
警告: Failed to check the connection: java.net.SocketTimeoutException: Read timed out
& 上午10时58分57秒 CST& &Error& &WebLogicServer& &BEA-000337& &[STUCK] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "645" seconds working on the request "Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 645747 ms
GET /workspace/frame/permission/login.jsp HTTP/1.1
Cache-Control: no-cache
Pragma: no-cache
User-Agent: Java/1.5.0_22
Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
Connection: keep-alive
]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
&&& java.net.SocketInputStream.socketRead0(Native Method)
&&& java.net.SocketInputStream.read(SocketInputStream.java:129)
&&& java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
&&& java.io.BufferedInputStream.read1(BufferedInputStream.java:258)
&&& java.io.BufferedInputStream.read(BufferedInputStream.java:317)
&&& weblogic.net.http.MessageHeader.isHTTP(MessageHeader.java:224)
&&& weblogic.net.http.MessageHeader.parseHeader(MessageHeader.java:148)
&&& weblogic.net.http.HttpClient.parseHTTP(HttpClient.java:468)
&&& weblogic.net.http.HttpURLConnection.getInputStream(HttpURLConnection.java:401)
&&& weblogic.net.http.SOAPHttpURLConnection.getInputStream(SOAPHttpURLConnection.java:37)
&&& com.primeton.access.client.impl.transport.HttpToolKit.callCommonService(HttpToolKit.java:93)
&&& com.primeton.access.client.impl.transport.HttpTransportSender.doSend(HttpTransportSender.java:32)
&&& com.primeton.access.client.impl.transport.AbstractTransportSender.send(AbstractTransportSender.java:29)
&&& com.primeton.ext.access.client.ServiceClient.send(ServiceClient.java:53)
&&& com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:87)
&&& com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
&&& com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:48)
&&& com.sun.proxy.$Proxy120.isMultitenancyEnable(Unknown Source)
&&& sun.reflect.GeneratedMethodAccessor392.invoke(Unknown Source)
&&& sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
&&& java.lang.reflect.Method.invoke(Method.java:597)
&&& com.ponent.manager.api.impl.MgrInvokeProxy.invoke(MgrInvokeProxy.java:86)
&&& com.sun.proxy.$Proxy121.isMultitenancyEnable(Unknown Source)
&&& com.primeton.bps.workspace.frame.processserver.ProcessServerHelper.getMultiServerMap(ProcessServerHelper.java:18)
&&& jsp_servlet._frame._permission.__login._jspService(__login.java:242)
&&& weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
&&& weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
&&& weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
&&& weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
&&& weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
&&& weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:50)
&&& com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:133)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.primeton.workflow.web.handler.WebIntegratedFilter.doIntercept(WebIntegratedFilter.java:58)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:120)
&&& com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
&&& com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
&&& weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
&&& weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
&&& weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
&&& weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
&&& weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
&&& weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
&&& weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
&&& weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
&&& weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
&&& weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
(150,070 积分)
官方解释如下：
BEA-000449
Warning: Closing socket as no data read from it on host:port during the configured idle timeout of idleTimeout secs
Description
Closing socket as no data read from it on host:port during the configured idle timeout of idleTimeout secs
The WebLogic Server or the network may be overloaded which is causing the socket to idle timeout.
Capacity tuning of the server is required.
BEA-101017
Error: [context] Root cause of ServletException.
Description
[context] Root cause of ServletException, which the Web application container caught while servicing the request.
The Web application container caught an unexpected exception.
Check the exception for the exact error message.
(150,070 积分)
(150,070 积分)
(150,070 积分)
(150,070 积分)
(150,070 积分)
(150,070 积分)
&| Snow Theme by
Powered by带你认识更牛的人下载即送20张免费照片冲印
扫码下载App
温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
LOFTER精选
网易考拉推荐
CauseThe /etc/resolv.conf contains invalid ip addresses of the DNS server（我将DNSip改为了本机ip，问题解决）SolutionVerify the error is reproducible&using the attached CheckConnection.class
1.&Download the attached&CheckConnection.class to any directory i.e. /usr/checkconnection/ 2. Check the TNS entry in the tnsnames.ora i.e. VIS1211= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=mmoreno-)(PORT=1551)) (CONNECT_DATA= (SID=VIS1211))) 3. Export the CLASSPATH environment variable i.e. $ export CLASSPATH=$CLASSPATH:/usr/checkconnection 4. Run CheckConnection to verify if the error is reproducible i.e. $ java CheckConnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mmoreno-)(PORT=1551))(CONNECT_DATA= (SID=VIS1211)))" apps &apps_password&
Verify that /etc/resolv.conf contains correct entries
nameserver 140.100.100.1 nameserver 140.100.100.2
Verify that nslookup gives correct output
$ nslookup mmoreno-au Server: 140.100.100.1 Address: 140.100.100.1#53 Name: mmoreno- Address: 140.1.1.143
Make sure it matches the entry in /etc/hosts
127.0.0.1 localhost.localdomain localhost 140.1.1.143 mmoreno- mmoreno-au References
Attachments
Oracle E-Business Suite & Applications Technology & Lifecycle Management & Application Install
TIME~OUT; DATABASEERROR; T4CCONNECTION; JAVA.SQL.SQLEXCEPTION; THROWSQLEXCEPTION; NEWSQLEXCEPTION; SOCKET; GETCONNECTION还可以在resolve.conf中添加如下内容，以避免以上错误DNS参数设置&&&&&&& #vi /etc/resolv.conf，增加内容按以下格式设置：&&&&&&& options attempts:5&&&&&&& options timeout:15&&&&&&& 以上设置可避免某些数据库连接失败的错误提示。
阅读(2065)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
在LOFTER的更多文章
loftPermalink:'',
id:'fks_087069',
blogTitle:'Getting Socket Read Timed Out Error When Applying A Patch Using Adpatch [ID ]',
blogAbstract:'
Modified 27-APR-2010&&&&&Type PROBLEM&&&&&Status PUBLISHED
In this Document&&
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}谈MongoDB读取连接超时的异常 - 李克华 - 博客园
云计算高级群:
交流：Hadoop、NoSQL、分布式、lucene、solr、nutch
今天在现场的哥们发来异常，让我解决，错误信息如下：
HTTP Status 500 - Read operation to server 192.168.1.110:20001 fai nested exception is com.mongodb.MongoException$Network: Read operation to server 192.168.1.110:20001 failed on database wpdb
--------------------------------------------------------------------------------
type Exception report
message Read operation to server 192.168.1.110:20001 fai nested exception is com.mongodb.MongoException$Network: Read operation to server 192.168.1.110:20001 failed on database wpdb
description The server encountered an internal error that prevented it from fulfilling this request.
org.springframework.dao.DataAccessResourceFailureException: Read operation to server 192.168.1.110:20001 fai nested exception is com.mongodb.MongoException$Network: Read operation to server 192.168.1.110:20001 failed on database wpdb
org.springframework.data.mongodb.core.MongoExceptionTranslator.translateExceptionIfPossible(MongoExceptionTranslator.java:56)
org.springframework.data.mongodb.core.MongoTemplate.potentiallyConvertRuntimeException(MongoTemplate.java:1913)
org.springframework.data.mongodb.core.MongoTemplate.executeFindOneInternal(MongoTemplate.java:1743)
org.springframework.data.mongodb.core.MongoTemplate.doFindOne(MongoTemplate.java:1557)
org.springframework.data.mongodb.core.MongoTemplate.findOne(MongoTemplate.java:497)
com.geoway.ime.tile.dao.impl.TileDaoImpl.getTile(TileDaoImpl.java:60)
com.geoway.ime.tile.service.impl.TileServiceImpl.getTile(TileServiceImpl.java:105)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:211)
org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:66)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy50.getTile(Unknown Source)
com.geoway.ime.server.rest.TileServer.getTileKVP(TileServer.java:60)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
root cause
com.mongodb.MongoException$Network: Read operation to server 192.168.1.110:20001 failed on database wpdb
com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:308)
com.mongodb.DBTCPConnector.call(DBTCPConnector.java:279)
com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:84)
com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:66)
com.mongodb.DBCollection.findOne(DBCollection.java:870)
com.mongodb.DBCollection.findOne(DBCollection.java:844)
com.mongodb.DBCollection.findOne(DBCollection.java:790)
org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:1980)
org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:1965)
org.springframework.data.mongodb.core.MongoTemplate.executeFindOneInternal(MongoTemplate.java:1739)
org.springframework.data.mongodb.core.MongoTemplate.doFindOne(MongoTemplate.java:1557)
org.springframework.data.mongodb.core.MongoTemplate.findOne(MongoTemplate.java:497)
com.geoway.ime.tile.dao.impl.TileDaoImpl.getTile(TileDaoImpl.java:60)
com.geoway.ime.tile.service.impl.TileServiceImpl.getTile(TileServiceImpl.java:105)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:211)
org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:66)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy50.getTile(Unknown Source)
com.geoway.ime.server.rest.TileServer.getTileKVP(TileServer.java:60)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
root cause
java.net.SocketTimeoutException: Read timed out
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:129)
java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
java.io.BufferedInputStream.read1(BufferedInputStream.java:258)
java.io.BufferedInputStream.read(BufferedInputStream.java:317)
org.bson.io.Bits.readFully(Bits.java:48)
org.bson.io.Bits.readFully(Bits.java:35)
org.bson.io.Bits.readFully(Bits.java:30)
com.mongodb.Response.&init&(Response.java:42)
com.mongodb.DBPort$1.execute(DBPort.java:141)
com.mongodb.DBPort$1.execute(DBPort.java:135)
com.mongodb.DBPort.doOperation(DBPort.java:164)
com.mongodb.DBPort.call(DBPort.java:135)
com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:300)
com.mongodb.DBTCPConnector.call(DBTCPConnector.java:279)
com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:84)
com.mongodb.DBCollectionImpl.find(DBCollectionImpl.java:66)
com.mongodb.DBCollection.findOne(DBCollection.java:870)
com.mongodb.DBCollection.findOne(DBCollection.java:844)
com.mongodb.DBCollection.findOne(DBCollection.java:790)
org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:1980)
org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:1965)
org.springframework.data.mongodb.core.MongoTemplate.executeFindOneInternal(MongoTemplate.java:1739)
org.springframework.data.mongodb.core.MongoTemplate.doFindOne(MongoTemplate.java:1557)
org.springframework.data.mongodb.core.MongoTemplate.findOne(MongoTemplate.java:497)
com.geoway.ime.tile.dao.impl.TileDaoImpl.getTile(TileDaoImpl.java:60)
com.geoway.ime.tile.service.impl.TileServiceImpl.getTile(TileServiceImpl.java:105)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:211)
org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:66)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
com.sun.proxy.$Proxy50.getTile(Unknown Source)
com.geoway.ime.server.rest.TileServer.getTileKVP(TileServer.java:60)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.41 logs.
由异常来看，是由于MongoDB连接超时造成的。于是，往MongoDB上找原因。首先上MongoDB的配置文件：
mongodb.replica-set=192.98.12.242:.12.245:30007
mongodb.hostname=192.98.12.245
mongodb.port=30007
mongodb.connections-per-host=1000
mongodb.threads-allowed-to-block-for-connection-multiplier=200
mongodb.connect-timeout=2000
mongodb.max-wait-time=2000
mongodb.auto-connect-retry=true
mongodb.socket-keep-alive=true
mongodb.socket-timeout=1500
mongodb.slave-ok=true
mongodb.write-number=1
mongodb.write-timeout=1000
mongodb.write-fsync=true
mongodb.dbname=shardvectordb
mongodb.dbuser=
mongodb.dbpassword=
连接时间2秒。然后在定位mongodb的查询，结果为6、7秒。原来是这个原因。然后定位，一个查询为什么耗时那么久呢？
经过排查，原来是查询字段没有创建索引。然后把索引创建，查询几十毫秒，ok问题全部解决。
随笔 - 239}
我要回帖
更多关于 oracle数据库教程 的文章
更多推荐
- ·找英文歌mv是到婚礼现场去唱的，上过billboard的，MV是一对情侣出车祸？
- ·怎么在小天才手表上下第三方软件d2怎样下载更多应用
- ·朋友，在美团、饿了么卖成人用品需要什么资质上卖情趣健康品的前景怎么样？
- ·华佗有哪些小故事的故事，还有很多你熟悉哪个？
- ·求一部小时候鬼片看过的恐怖电影的名字 时间应该是 98 年之前的，应该是亚洲地区的。
- ·武警部队旗里数据表是什么意思
- ·谁想考体育学院？我想考有人和我一起飞翔吗？
- ·认识的帮忙看看这个鞋标是gman咀嚼片真的假的的？
- ·想开一家餐馆用品店家汽车用品店，具体要投资多少钱及进货渠道，请有经验的前辈回答？ 谢谢
- ·iphone5s无法使用4g 2g和4g网络无法自动切换
- ·喜欢腿短穿七分裤裤和跑鞋的女孩是什么类型的
- ·怎样去除眼部鱼尾纹鱼尾纹;怎么才能？感谢？
- ·belle70晶清鞋子多少钱3v315大概多少钱?
- ·这图片是张真人照片片，是用什么美图工具做出来的呢！有知道的吗？
- ·490柴油机水路是燕子坞怎么走水路的
- ·图片找鞋子子！！！！！！
- ·跪求如鹏网MySQL，mysql odbc驱动 32位，SQLyon..
- ·大行折叠车412折叠车中轴禧玛诺什么型号匹配
- ·164可以1.60能骑公路赛吗吗？谢谢
- ·连接oracle创建数据库数据库时出现Socket read timed out错误
- ·2k14为什么开球时老是开给2k14中锋招牌技能?
- ·奔跑吧第三期预告兄弟第三期里的棒球衫是什么牌子的
- ·贴小灯笼果的胶水有没有毒啊,它有经过高温煮过的呢
- ·牛皮劳保手套批发市场拿货多少钱一双
- ·danny macaskill和三个人一起玩的游戏车的视频
- ·为什么卡洛驰尺码穿久了就容易脚臭？买了2双都是这样的
- ·新2足球代理qq邮箱网址打不开怎么打不开
- ·还有八颗麻将赢牌技巧没上来是怎么一回事
- ·买泳衣应该注意哪些问题？哪个牌子的泳衣好好？求专业人士解答！
- ·侧面描写的好处运球是什么意思？侧面描写的好处运球有什么好处？
- ·如何举报在新泰夜间荧光跑跑的车
- ·干扰普通麻将遥控设备需要多婚纱多少钱一套套
- ·20149.26拜仁对门送来绿豆糕兴角球数是怎么受让
- ·7911100u7110xab926一cd宝马nbt主机接线图图
