Uploaded image for project: 'AMQ Broker'
  1. AMQ Broker
  2. ENTMQBR-3690

[EAP - mysql80] Failed acquire of lock ; Communications link failure

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • None
    • AMQ 7.7.0.GA
    • jdbc
    • None

      During the most of the test runs, one of the brokers fails to acquire the lock on the DB and that is most likely causing all other failures. Afterwards the connection is closed and followup attempts to work with DB and journal will fail.

      16:17:02,293 ERROR [org.apache.activemq.artemis.core.server] (AMQ229000: Activation for server ActiveMQServerImpl::serverUUID=23b13ec5-b549-11ea-b49b-fa163eed8c96) AMQ224000: Failure in initialisation: java.lang.IllegalStateException: java.sql.SQLException: IJ031013: Interrupted attempting lock: org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@26a6a42e
      	at org.apache.activemq.artemis.core.server.impl.jdbc.JdbcLeaseLock.tryAcquire(JdbcLeaseLock.java:209) [artemis-server-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.core.server.impl.jdbc.LeaseLock.tryAcquire(LeaseLock.java:91) [artemis-server-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.core.server.impl.jdbc.LeaseLock.tryAcquire(LeaseLock.java:109) [artemis-server-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.core.server.impl.jdbc.JdbcNodeManager.lock(JdbcNodeManager.java:320) [artemis-server-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.core.server.impl.jdbc.JdbcNodeManager.startBackup(JdbcNodeManager.java:413) [artemis-server-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.core.server.impl.SharedStoreBackupActivation.run(SharedStoreBackupActivation.java:62) [artemis-server-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl$ActivationThread.run(ActiveMQServerImpl.java:3907) [artemis-server-2.13.0.jar:2.13.0.redhat-00006]
      Caused by: java.sql.SQLException: IJ031013: Interrupted attempting lock: org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@26a6a42e
      	at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.tryLock(BaseWrapperManagedConnection.java:405)
      	at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:165)
      	at org.jboss.jca.adapters.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:839)
      	at org.apache.activemq.artemis.core.server.impl.jdbc.JdbcLeaseLock.tryAcquire(JdbcLeaseLock.java:206) [artemis-server-2.13.0.jar:2.13.0.redhat-00006]
      	... 6 more
      
      16:18:38,544 WARN  [org.apache.activemq.artemis.jdbc.store.journal.JDBCJournalImpl] (Thread-0 (ActiveMQ-server-org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl$6@391506e1)) Communications link failure
      
      The last packet successfully received from the server was 20,023 milliseconds ago. The last packet sent successfully to the server was 20,023 milliseconds ago.: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
      
      The last packet successfully received from the server was 20,023 milliseconds ago. The last packet sent successfully to the server was 20,023 milliseconds ago.
      	at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
      	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
      	at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:814)
      	at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1072)
      	at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:895)
      	at org.apache.activemq.artemis.jdbc.store.journal.JDBCJournalImpl.sync(JDBCJournalImpl.java:253) [artemis-jdbc-store-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.jdbc.store.journal.JDBCJournalImpl$JDBCJournalSync.run(JDBCJournalImpl.java:1054) [artemis-jdbc-store-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.core.server.ActiveMQScheduledComponent$2.run(ActiveMQScheduledComponent.java:306) [artemis-commons-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:42) [artemis-commons-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:31) [artemis-commons-2.13.0.jar:2.13.0.redhat-00006]
      	at org.apache.activemq.artemis.utils.actors.ProcessorBase.executePendingTasks(ProcessorBase.java:65) [artemis-commons-2.13.0.jar:2.13.0.redhat-00006]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_242]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_242]
      	at org.apache.activemq.artemis.utils.ActiveMQThreadFactory$1.run(ActiveMQThreadFactory.java:118) [artemis-commons-2.13.0.jar:2.13.0.redhat-00006]
      Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
      

            rhn-support-jbertram Justin Bertram
            rvais Roman Vais
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: