java.sql.SQLNonTransientConnectionException: Could not read resultset: Connection reset

  1. 0

    mariadb - Configuration to stop mysql sleep - Database Administrators Stack Exchange

    stackexchange.com | 7 months ago
    java.sql.SQLNonTransientConnectionException: Could not read resultset: Connection reset
  2. 0

    Configuration to stop mysql sleep

    Database Administrators | 2 years ago | Biscuit128
    java.sql.SQLNonTransientConnectionException: Could not read resultset: Connection reset
  3. 0

    My JAVA application is run on Tomcat Server with a single MongoDB. This error occurs some times a day. - Here is an exception message. ---------------------------------------------------------------------------------------------------- com.mongodb.DBPortPool gotError WARNING: emptying DBPortPool to /172.20.1.4:27017 b/c of error java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:189) at java.net.SocketInputStream.read(SocketInputStream.java:121) at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) at java.io.BufferedInputStream.read1(BufferedInputStream.java:286) at java.io.BufferedInputStream.read(BufferedInputStream.java:345) at org.bson.io.Bits.readFully(Bits.java:46) at org.bson.io.Bits.readFully(Bits.java:33) at org.bson.io.Bits.readFully(Bits.java:28) at com.mongodb.Response.<init>(Response.java:40) at com.mongodb.DBPort.go(DBPort.java:142) at com.mongodb.DBPort.call(DBPort.java:92) at com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:244) at com.mongodb.DBTCPConnector.call(DBTCPConnector.java:216) at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:288) at com.mongodb.DB.command(DB.java:262) at com.mongodb.DB.command(DB.java:244) at com.mongodb.DBCollection.getCount(DBCollection.java:985) at com.mongodb.DBCursor.size(DBCursor.java:602) at com.mysema.query.mongodb.MongodbQuery.list(MongodbQuery.java:271) at org.springframework.data.mongodb.repository.support.QueryDslMongoRepository.findAll(QueryDslMongoRepository.java:93) at sun.reflect.GeneratedMethodAccessor6078.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:358) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:343) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy586.findAll(Unknown Source) ---------------------------------------------------------------------------------------------------- - The code about connecting MongoDB is not different. Here is the code. MongoClientOptions options = MongoClientOptions.builder() .connectionsPerHost(50).build(); MongoClient client = new MongoClient(new ServerAddress(dbHost, dbPort), Arrays.asList(credential), options); ---------------------------------------------------------------------------------------------------- I can't even guess whether it's caused by a Network problem or a MongoDB java driver. This issue is really worrying..Please, help me.

    JIRA | 2 years ago | Claire Lee
    java.net.SocketException: Connection reset
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    My JAVA application is run on Tomcat Server with a single MongoDB. This error occurs some times a day. - Here is an exception message. ---------------------------------------------------------------------------------------------------- com.mongodb.DBPortPool gotError WARNING: emptying DBPortPool to /172.20.1.4:27017 b/c of error java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:189) at java.net.SocketInputStream.read(SocketInputStream.java:121) at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) at java.io.BufferedInputStream.read1(BufferedInputStream.java:286) at java.io.BufferedInputStream.read(BufferedInputStream.java:345) at org.bson.io.Bits.readFully(Bits.java:46) at org.bson.io.Bits.readFully(Bits.java:33) at org.bson.io.Bits.readFully(Bits.java:28) at com.mongodb.Response.<init>(Response.java:40) at com.mongodb.DBPort.go(DBPort.java:142) at com.mongodb.DBPort.call(DBPort.java:92) at com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:244) at com.mongodb.DBTCPConnector.call(DBTCPConnector.java:216) at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:288) at com.mongodb.DB.command(DB.java:262) at com.mongodb.DB.command(DB.java:244) at com.mongodb.DBCollection.getCount(DBCollection.java:985) at com.mongodb.DBCursor.size(DBCursor.java:602) at com.mysema.query.mongodb.MongodbQuery.list(MongodbQuery.java:271) at org.springframework.data.mongodb.repository.support.QueryDslMongoRepository.findAll(QueryDslMongoRepository.java:93) at sun.reflect.GeneratedMethodAccessor6078.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:358) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:343) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy586.findAll(Unknown Source) ---------------------------------------------------------------------------------------------------- - The code about connecting MongoDB is not different. Here is the code. MongoClientOptions options = MongoClientOptions.builder() .connectionsPerHost(50).build(); MongoClient client = new MongoClient(new ServerAddress(dbHost, dbPort), Arrays.asList(credential), options); ---------------------------------------------------------------------------------------------------- I can't even guess whether it's caused by a Network problem or a MongoDB java driver. This issue is really worrying..Please, help me.

    JIRA | 2 years ago | Claire Lee
    java.net.SocketException: Connection reset
  6. 0

    My JAVA application is run on Tomcat Server with a single MongoDB. This error occurs some times a day. - Here is an exception message. ---------------------------------------------------------------------------------------------------- com.mongodb.DBPortPool gotError WARNING: emptying DBPortPool to /172.20.1.4:27017 b/c of error java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:189) at java.net.SocketInputStream.read(SocketInputStream.java:121) at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) at java.io.BufferedInputStream.read1(BufferedInputStream.java:286) at java.io.BufferedInputStream.read(BufferedInputStream.java:345) at org.bson.io.Bits.readFully(Bits.java:46) at org.bson.io.Bits.readFully(Bits.java:33) at org.bson.io.Bits.readFully(Bits.java:28) at com.mongodb.Response.<init>(Response.java:40) at com.mongodb.DBPort.go(DBPort.java:142) at com.mongodb.DBPort.call(DBPort.java:92) at com.mongodb.DBTCPConnector.innerCall(DBTCPConnector.java:244) at com.mongodb.DBTCPConnector.call(DBTCPConnector.java:216) at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:288) at com.mongodb.DB.command(DB.java:262) at com.mongodb.DB.command(DB.java:244) at com.mongodb.DBCollection.getCount(DBCollection.java:985) at com.mongodb.DBCursor.size(DBCursor.java:602) at com.mysema.query.mongodb.MongodbQuery.list(MongodbQuery.java:271) at org.springframework.data.mongodb.repository.support.QueryDslMongoRepository.findAll(QueryDslMongoRepository.java:93) at sun.reflect.GeneratedMethodAccessor6078.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:358) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:343) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy586.findAll(Unknown Source) ---------------------------------------------------------------------------------------------------- - The code about connecting MongoDB is not different. Here is the code. MongoClientOptions options = MongoClientOptions.builder() .connectionsPerHost(50).build(); MongoClient client = new MongoClient(new ServerAddress(dbHost, dbPort), Arrays.asList(credential), options); ---------------------------------------------------------------------------------------------------- I can't even guess whether it's caused by a Network problem or a MongoDB java driver. This issue is really worrying..Please, help me.

    JIRA | 2 years ago | Claire Lee
    java.net.SocketException: Connection reset

  1. Andreas Häber 4 times, last 2 months ago
  2. sriharshakiran 1 times, last 7 months ago
14 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.net.SocketException

    Connection reset

    at java.net.SocketInputStream.read()
  2. Java RT
    BufferedInputStream.read
    1. java.net.SocketInputStream.read(SocketInputStream.java:189)
    2. java.net.SocketInputStream.read(SocketInputStream.java:121)
    3. java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
    4. java.io.BufferedInputStream.read1(BufferedInputStream.java:286)
    5. java.io.BufferedInputStream.read(BufferedInputStream.java:345)
    5 frames
  3. mariadb-java-client
    MySQLStatement.executeQuery
    1. org.mariadb.jdbc.internal.common.packet.buffer.ReadUtil.readFully(ReadUtil.java:82)
    2. org.mariadb.jdbc.internal.common.packet.buffer.ReadUtil.readFully(ReadUtil.java:92)
    3. org.mariadb.jdbc.internal.common.packet.RawPacket.nextPacket(RawPacket.java:77)
    4. org.mariadb.jdbc.internal.common.packet.SyncPacketFetcher.getRawPacket(SyncPacketFetcher.java:67)
    5. org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:894)
    6. org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:991)
    7. org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:281)
    8. org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:302)
    9. org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:361)
    9 frames
  4. Commons DBCP
    DelegatingStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    2. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    2 frames
  5. com.swifte.database
    DBFactory.authenticate
    1. com.swifte.database.DBFactory.attemptLoginWithTempPasswordDetails(DBFactory.java:183)
    2. com.swifte.database.DBFactory.authenticate(DBFactory.java:133)
    2 frames
  6. com.swifte.service
    ExposedFunctions.login
    1. com.swifte.service.ExposedFunctions.login(ExposedFunctions.java:132)
    1 frame
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:483)
    4 frames
  8. RESTEasy JAX-RS Implementation
    HttpServletDispatcher.service
    1. org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
    2. org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269)
    3. org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227)
    4. org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216)
    5. org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
    6. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
    7. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
    8. org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
    9. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
    10. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
    10 frames
  9. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
    1 frame
  10. Glassfish Core
    StandardContextValve.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
    4 frames
  11. JBoss Web
    SecurityContextAssociationValve.invoke
    1. org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
    1 frame
  12. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)
    2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
    3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
    4. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
    4 frames
  13. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)
    3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)
    3 frames
  14. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame