org.apache.openjpa.persistence.PersistenceException: The last packet successfully received from the server was 187,404,662 milliseconds ago. The last packet sent successfully to the server was 187,404,662 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.

openjpa-users | David Beer | 4 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    MySQL Timeout issue

    openjpa-users | 4 years ago | David Beer
    org.apache.openjpa.persistence.PersistenceException: The last packet successfully received from the server was 187,404,662 milliseconds ago. The last packet sent successfully to the server was 187,404,662 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 unregistered visitors

    Root Cause Analysis

    1. org.apache.openjpa.persistence.PersistenceException

      The last packet successfully received from the server was 187,404,662 milliseconds ago. The last packet sent successfully to the server was 187,404,662 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.

      at org.apache.openjpa.jdbc.sql.DBDictionary.narrow()
    2. OpenJPA Aggregate Jar
      DBDictionary.newStoreException
      1. org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918)
      2. org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
      2 frames