MongoDB查询字段没有创建索引导致的连接超时异常解案例分享

今天在现场的哥们发来异常，让我解决，错误信息如下：

复制代码代码如下:

HTTP Status 500 - Read operation to server 192.168.1.110:20001 failed on database wpdb; 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 failed on database wpdb; 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.

exception

org.springframework.dao.DataAccessResourceFailureException: Read operation to server 192.168.1.110:20001 failed on database wpdb; 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)