0 Replies Latest reply on Aug 10, 2018 3:51 AM by RAKESH KR

    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

    RAKESH KR Newbie

      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:-

      standalone.xml DB configuration