Destroying connection that is not valid, due to the following exception: com.mysql.cj.jdbc.ha.MultiHostMySQLConnection@5e10f030: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communicat ions link failure

rakeshkr2 Aug 10, 2018 3:51 AM

Getting following exception in JBoss Version 11.

2018-08-10 00:01:08,588 WARN  [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (CommonSchedulerThread Processing) IJ030027: Destroying connection that
 is not valid, due to the following exception: com.mysql.cj.jdbc.ha.MultiHostMySQLConnection@5e10f030: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communicat
ions link failure

The last packet successfully received from the server was 4,694,929 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
        at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:590)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:57)
        at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
        at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1936)
        at com.mysql.cj.jdbc.ha.MultiHostMySQLConnection.execSQL(MultiHostMySQLConnection.java:177)
        at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
        at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
        at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.mysql.cj.jdbc.ha.MultiHostConnectionProxy$JdbcInterfaceProxy.invoke(MultiHostConnectionProxy.java:93)

This is my standalone.xml configuration:-