«

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

时间：2024-3-1 22:01     作者：韩俊     分类： Mysql

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

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)

    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:30007,192.98.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问题全部解决。

标签: mysql mongodb

热门推荐

1 PHP读MYSQL中文乱码的快速解决方法
2 mysql 全文检索中文解决方法及实例代码
3 Mysql中自定义函数的创建和执行方法是什么
4 centos 6.4下使用rpm离线安装mysql
5 MySql登录时闪退的快速解决办法
6 Redis在人工智能中的应用场景分析
7 生产库自动化MySQL5.6安装部署详细教程
8 MySQL常用命令 MySQL处理数据库和表的命令
9 JavaScript按日期查询MongoDB中的数据的要点示例
10 故障的机器修好后重启，狂拉主库binlog，导致网络问题的解决方法

日历

标签

hbase maven eclipse sybase PostgreSQL spring emcache oracle mongodb redis nginx golang java vue android ios mysql linux 微信小程序 css html php教程 javascript python php

搜索

最新文章

热门文章