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

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

    XMLWordPrintable

Details

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

    Description

      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
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: