Please add auto-reconnect to database #8


  • New
  • Defect
Open
Assigned to andune
  • Psithief_ created this issue Apr 5, 2012

    What steps will reproduce the problem?
    1. Have a server with a lull period
    2. Have the MYSQL connection expire
    3. Attempt to log to the database.

    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after conn$
    2012-04-05 08:41:43 [SEVERE]    at sun.reflect.GeneratedConstructorAccessor139.newInstance(Unknown Source)
    2012-04-05 08:41:43 [SEVERE]    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java$
    2012-04-05 08:41:43 [SEVERE]    at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2012-04-05 08:41:43 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2012-04-05 08:41:43 [SEVERE]    at org.morganm.logores.Logger.DatabaseLogger.logEvent(DatabaseLogger.java:129)
    2012-04-05 08:41:43 [SEVERE]    at org.morganm.logores.LogEventProcessor.logEvent(LogEventProcessor.java:589)
    2012-04-05 08:41:43 [SEVERE]    at org.morganm.logores.LogEventProcessor.run(LogEventProcessor.java:568)
    2012-04-05 08:41:43 [SEVERE]    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    2012-04-05 08:41:43 [SEVERE]    at java.lang.Thread.run(Thread.java:679)
    2012-04-05 08:41:43 [SEVERE] Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet successfully received from the server was 16,046,573 milliseconds ago.

  • Psithief_ added the tags New Defect Apr 5, 2012
  • Psithief_ posted a comment Apr 5, 2012

    MySQL connections timeout after 4 and a bit hours. A reconnect check would be great. Thankyou.


To post a comment, please login or register a new account.