com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 39.228.530 milliseconds ago. The last packet sent successfully to the server was 39.228.530 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

Stack Overflow | Felipe | 4 months ago
  1. 0

    Jpa(Hibernate) Lost DB Connection after +- 24 Hours

    Stack Overflow | 4 months ago | Felipe
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 39.228.530 milliseconds ago. The last packet sent successfully to the server was 39.228.530 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  2. 0

    Backend stopped

    GitHub | 2 years ago | jakubklimek
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was72817 seconds ago.The last packet sent successfully to the server was 72817 seconds ago, which is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem. Error Code: 0 Call: SELECT ID FROM dpu_instance WHERE (ID = ?) bind => [2008] Query: DoesExistQuery(referenceClass=DPUInstanceRecord sql="SELECT ID FROM dpu_instance WHERE (ID = ?)")
  3. 0

    Hibernate failed to execute query afte 1 day

    Stack Overflow | 5 years ago | Pankaj Rastogi
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was59461 milliseconds ago.The last packet sent successfully to the server was 59461 milliseconds ago, which is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Connection to Database closed: Software caused connection abort: socket write error

    Stack Overflow | 3 years ago | user2766373
    org.hibernate.exception.JDBCConnectionException: could not execute query
  6. 0

    JDBC connection timeout cannot reconnect

    Stack Overflow | 2 years ago | Stephane Eybert
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 63,313,144 milliseconds ago. The last packet sent successfully to the server was 63,313,144 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

  1. mauritius 2 times, last 9 months ago
  2. kuldeep 4 times, last 2 months ago
  3. esaar 1 times, last 4 months ago
16 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

    Broken pipe

    at java.net.SocketOutputStream.socketWrite0()
  2. Java RT
    BufferedOutputStream.flush
    1. java.net.SocketOutputStream.socketWrite0(Native Method)
    2. java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
    3. java.net.SocketOutputStream.write(SocketOutputStream.java:153)
    4. java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
    5. java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
    5 frames
  3. MySQL jdbc
    MysqlIO.send
    1. com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3634)
    1 frame
  4. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:422)
    4 frames
  5. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
    2. com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:981)
    3. com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3652)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2460)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
    7. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
    8. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
    8 frames
  6. Hibernate
    ResultSetReturnImpl.extract
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
    1 frame