mysql connection timeout

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • tulika dutta
    New Member
    • Jun 2007
    • 3
    #1

    mysql connection timeout

    after 8 hrs my MySQL connection with JDBC gets time out. It gives the error

    java.sql.SQLExc eption: No operations allowed after connection closed.Connecti on was implicitly closed due to underlying exception/error:


    ** BEGIN NESTED EXCEPTION **

    com.mysql.jdbc. CommunicationsE xception
    MESSAGE: Communications link failure due to underlying exception:

    ** BEGIN NESTED EXCEPTION **

    java.io.EOFExce ption

    STACKTRACE:

    java.io.EOFExce ption
    at com.mysql.jdbc. MysqlIO.readFul ly(MysqlIO.java :1905)
    at com.mysql.jdbc. MysqlIO.reuseAn dReadPacket(Mys qlIO.java:2351)
    at com.mysql.jdbc. MysqlIO.checkEr rorPacket(Mysql IO.java:2862)
    at com.mysql.jdbc. MysqlIO.sendCom mand(MysqlIO.ja va:1571)
    at com.mysql.jdbc. MysqlIO.sqlQuer yDirect(MysqlIO .java:1666)
    at com.mysql.jdbc. Connection.exec SQL(Connection. java:2988)
    at com.mysql.jdbc. Connection.exec SQL(Connection. java:2917)
    at com.mysql.jdbc. Statement.execu teQuery(Stateme nt.java:824)
    at com.mvc.ntier.r eqdis.events.Lo ginEventHandler .process(LoginE ventHandler.jav a:49)
    at com.mvc.ntier.r eqdis.Controlle r.doPost(Contro ller.java:118)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:709)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
    at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:252)
    at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:173)
    at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:213)
    at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:178)
    at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:12 6)
    at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:10 5)
    at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:107)
    at org.apache.cata lina.connector. CoyoteAdapter.s ervice(CoyoteAd apter.java:148)
    at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:856)
    at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.processConn ection(Http11Pr otocol.java:744 )
    at org.apache.tomc at.util.net.Poo lTcpEndpoint.pr ocessSocket(Poo lTcpEndpoint.ja va:527)
    at org.apache.tomc at.util.net.Lea derFollowerWork erThread.runIt( LeaderFollowerW orkerThread.jav a:80)
    at org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n(ThreadPool.ja va:684)
    at java.lang.Threa d.run(Unknown Source)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 16 ms ago.

    STACKTRACE:

    com.mysql.jdbc. CommunicationsE xception: Communications link failure due to underlying exception:

    ** BEGIN NESTED EXCEPTION **

    java.io.EOFExce ption

    STACKTRACE:

    java.io.EOFExce ption
    at com.mysql.jdbc. MysqlIO.readFul ly(MysqlIO.java :1905)
    at com.mysql.jdbc. MysqlIO.reuseAn dReadPacket(Mys qlIO.java:2351)
    at com.mysql.jdbc. MysqlIO.checkEr rorPacket(Mysql IO.java:2862)
    at com.mysql.jdbc. MysqlIO.sendCom mand(MysqlIO.ja va:1571)
    at com.mysql.jdbc. MysqlIO.sqlQuer yDirect(MysqlIO .java:1666)
    at com.mysql.jdbc. Connection.exec SQL(Connection. java:2988)
    at com.mysql.jdbc. Connection.exec SQL(Connection. java:2917)
    at com.mysql.jdbc. Statement.execu teQuery(Stateme nt.java:824)
    at com.mvc.ntier.r eqdis.events.Lo ginEventHandler .process(LoginE ventHandler.jav a:49)
    at com.mvc.ntier.r eqdis.Controlle r.doPost(Contro ller.java:118)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:709)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
    at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:252)
    at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:173)
    at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:213)
    at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:178)
    at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:12 6)
    at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:10 5)
    at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:107)
    at org.apache.cata lina.connector. CoyoteAdapter.s ervice(CoyoteAd apter.java:148)
    at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:856)
    at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.processConn ection(Http11Pr otocol.java:744 )
    at org.apache.tomc at.util.net.Poo lTcpEndpoint.pr ocessSocket(Poo lTcpEndpoint.ja va:527)
    at org.apache.tomc at.util.net.Lea derFollowerWork erThread.runIt( LeaderFollowerW orkerThread.jav a:80)
    at org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n(ThreadPool.ja va:684)
    at java.lang.Threa d.run(Unknown Source)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 16 ms ago.
    at com.mysql.jdbc. MysqlIO.reuseAn dReadPacket(Mys qlIO.java:2563)
    at com.mysql.jdbc. MysqlIO.checkEr rorPacket(Mysql IO.java:2862)
    at com.mysql.jdbc. MysqlIO.sendCom mand(MysqlIO.ja va:1571)
    at com.mysql.jdbc. MysqlIO.sqlQuer yDirect(MysqlIO .java:1666)
    at com.mysql.jdbc. Connection.exec SQL(Connection. java:2988)
    at com.mysql.jdbc. Connection.exec SQL(Connection. java:2917)
    at com.mysql.jdbc. Statement.execu teQuery(Stateme nt.java:824)
    at com.mvc.ntier.r eqdis.events.Lo ginEventHandler .process(LoginE ventHandler.jav a:49)
    at com.mvc.ntier.r eqdis.Controlle r.doPost(Contro ller.java:118)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:709)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
    at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:252)
    at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:173)
    at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:213)
    at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:178)
    at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:12 6)
    at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:10 5)
    at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:107)
    at org.apache.cata lina.connector. CoyoteAdapter.s ervice(CoyoteAd apter.java:148)
    at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:856)
    at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.processConn ection(Http11Pr otocol.java:744 )
    at org.apache.tomc at.util.net.Poo lTcpEndpoint.pr ocessSocket(Poo lTcpEndpoint.ja va:527)
    at org.apache.tomc at.util.net.Lea derFollowerWork erThread.runIt( LeaderFollowerW orkerThread.jav a:80)
    at org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n(ThreadPool.ja va:684)
    at java.lang.Threa d.run(Unknown Source)


    ** END NESTED EXCEPTION **
    Tags: None
    • Atli
      Recognized Expert Expert
      • Nov 2006
      • 5062
      #2
      Ok, this sounds like a Java error. So I'm gona move this to the Java forums.

      Moderator

        Comment

        • grizzlor
          New Member
          • Jun 2007
          • 2
          #3
          I have exactly the same problem, can annyone help us please ;-)

          I found something here:
          404 Not Found
          http://md.webuni.de/?mod=topic&id=13328&pid=last&newsession=1&kicked=1


          [PHP]jdbc:mysql://gletscher/mentortest?auto Reconnect=true

          // i'm implemeted it like this:
          con = java.sql.Driver Manager.getConn ection("jdbc:my sql://" + database+"?auto Reconnect=true" , databaseUser, databasePass);
          [/PHP]

          maybe this can help us ... but i have to wait 8 houres now.


          i will leave a message if it works like this


          cu

          Grizzlor

            Comment

            • grizzlor
              New Member
              • Jun 2007
              • 2
              #4
              Originally posted by grizzlor
              I have exactly the same problem, can annyone help us please ;-)

              I found something here:
              404 Not Found
              http://md.webuni.de/?mod=topic&id=13328&pid=last&newsession=1&kicked=1


              [PHP]jdbc:mysql://gletscher/mentortest?auto Reconnect=true

              // i'm implemeted it like this:
              con = java.sql.Driver Manager.getConn ection("jdbc:my sql://" + database+"?auto Reconnect=true" , databaseUser, databasePass);
              [/PHP]

              maybe this can help us ... but i have to wait 8 houres now.


              i will leave a message if it works like this


              cu

              Grizzlor
              Ok it doesn't work this way ...

                Comment

                Previous template Next
                Working...