MySql server non-responsive, JDBC Client unable to establish connection

java.sql.SQLException
Javadoc

An exception that provides information on a database access error or other errors.

Each SQLException provides several kinds of information:

  • a string describing the error. This is used as the Java Exception message, available via the method getMesasge.
  • a "SQLstate" string, which follows either the XOPEN SQLstate conventions or the SQL:2003 conventions. The values of the SQLState string are described in the appropriate spec. The DatabaseMetaData method getSQLStateType can be used to discover whether the driver returns the XOPEN type or the SQL:2003 type.
  • an integer error code that is specific to each vendor. Normally this will be the actual error code returned by the underlying database.
  • a chain to a next Exception. This can be used to provide additional error information.
  • the causal relationship, if any for this SQLException.
at com.mysql.jdbc.Connection.createNewIO
at com.mysql.jdbc.Connection.<init>

Typical Exception Messages

  1. Unable to connect to any hosts due to exception: java.security.AccessControlException: access denied (java.util.PropertyPermission file.encoding read)
  2. Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect
  3. Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused
  4. Server connection failure during transaction. Attemtped reconnect 3 times. Giving up.
  5. <No message>
  6. java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.sql.S QLException: General error, message from server: "Unknown database 'xplanner'"' . \[java\] Attempted reconnect 3 times. Giving up.
  7. Server connection failure during transaction. Attempted reconnect 3 times. Giving up.
  8. Unable to connect to any hosts due to exception: java.lang.ArrayIndexOutOfBoundsException: 41
  9. java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.SocketException: Invalid argument or cannot assign requested address
  10. java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.ConnectException: Connection refused'. Attempted reconnect 3 times. Giving up.

Specific cases

External results for this pattern (35)

  1. joaonadaisfeupvia GitHub1 month ago
    Server connection failure during transaction. Attemtped reconnect 3 times. Giving up.
    Show stack trace
  2. Unknown authorvia sourceforge.net4 months ago
    No message found for this stack trace.
    Show stack trace
  3. Bruce Scottvia Hibernate JIRA4 months ago
    Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect
    Show stack trace
  4. 807581via Oracle Community4 months ago
    Unable to connect to any hosts due to exception: java.net.ConnectException: Connection timed out: connect
    Show stack trace
  5. 843854via Oracle Community4 months ago
    Unable to connect to any hosts due to exception: java.net.ConnectException: Connectio
    Show stack trace
  6. 843854via Oracle Community4 months ago
    Unable to connect to any hosts due to exception: java.security.AccessControlException: access denied (java.util.PropertyPermission file.encoding read)
    Show stack trace
  7. 843854via Oracle Community4 months ago
    Unable to connect to any hosts due to exception: java.security.AccessControlException: access denied (java.util.PropertyPermission file.encoding read)
    Show stack trace
  8. 843835via Oracle Community4 months ago
    Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect
    Show stack trace
  9. 843854via Oracle Community4 months ago
    Unable to connect to any hosts due to exception: java.security.AccessControlException: access denied (java.util.PropertyPermission file.encoding read)
    Show stack trace
  10. 843854via Oracle Community4 months ago
    Unable to connect to any hosts due to exception: java.net.SocketException: Connection reset by peer: connect
    Show stack trace