MySQL database based bug tracking software
Bugzero one-for-all bug tracking and help desk support system
 
Q: With MySQL, after a long time of in-activity, I got
   java.sql.SQLException: Communication link failure: java.net.SocketException.

A: This happens because of a connection timeout on the MySQL side.
   You need add "autoReconnect=true" in the jdbc url. You may also want configure
   your mysql server and add an entry 

        set-variable = interactive_timeout=50000

   in the file my.cnf (the default is 28800, 8hr).

   Note that, in later Bugzero versions, this exception shall not cause any
   real harm. It will simply try re-connect. It is logged in the log file, but
   end-user does not see it.
   

   You may also see a similar java.sql.SQLException:
   Communication link failure: java.io.IOException.




* Reference brought to you by Bugzero, it's more than just defect tracking software!

Home - FAQs