Uploaded image for project: 'ActiveMQ Classic'
  1. ActiveMQ Classic
  2. AMQ-8121

Configuring JDBC to send information queues to DB SQL

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Reopened
    • Major
    • Resolution: Unresolved
    • 5.15.0
    • None
    • JDBC
    • None

    Description

      I'm configuring ActiveMQ to send queues information from ActiveMQ to load into database SQL, but I'm getting next error at the logs.

      First time that I do this configuration.

      ActiveMQ version 5.15.0

       

      log information

      2020-12-04 18:52:07,884 | INFO | Apache ActiveMQ 5.15.0 (jdbcBroker, ID:devmx1mesmsb02.mx.aligntech.com-55247-1606979742282-0:3229) is shutting down | org.apache.activemq.broker.BrokerService | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:52:05,595 | INFO | jolokia-agent: Using policy access restrictor classpath:/jolokia-access.xml | /api | main
      2020-12-04 18:52:09,983 | INFO | Connector default stopped | org.apache.activemq.broker.TransportConnector | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:52:19,844 | INFO | PListStore:[/opt/apache-activemq-5.15.0/bin/activemq-data/jdbcBroker/tmp_storage] stopped | org.apache.activemq.store.kahadb.plist.PListStoreImpl | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:52:21,308 | INFO | Apache ActiveMQ 5.15.0 (jdbcBroker, ID:devmx1mesmsb02.mx.aligntech.com-55247-1606979742282-0:3229) uptime 55.241 seconds | org.apache.activemq.broker.BrokerService | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:52:23,257 | INFO | Apache ActiveMQ 5.15.0 (jdbcBroker, ID:devmx1mesmsb02.mx.aligntech.com-55247-1606979742282-0:3229) is shutdown | org.apache.activemq.broker.BrokerService | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:52:25,291 | INFO | Closing org.apache.activemq.xbean.XBeanBrokerFactory$1@129ba02a: startup date [Fri Dec 04 18:51:23 MST 2020]; root of context hierarchy | org.apache.activemq.xbean.XBeanBrokerFactory$1 | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:52:27,694 | INFO | Destroying Spring FrameworkServlet 'dispatcher' | /admin | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:52:35,398 | INFO | Refreshing org.apache.activemq.xbean.XBeanBrokerFactory$1@a3cffaa: startup date [Fri Dec 04 18:52:35 MST 2020]; root of context hierarchy | org.apache.activemq.xbean.XBeanBrokerFactory$1 | main
      2020-12-04 18:52:37,982 | INFO | Using Persistence Adapter: JDBCPersistenceAdapter(org.apache.commons.dbcp2.BasicDataSource@b61fe7c) | org.apache.activemq.broker.BrokerService | main
      2020-12-04 18:52:40,139 | INFO | Attempting to acquire the exclusive lock to become the Master broker | org.apache.activemq.store.jdbc.adapter.TransactDatabaseLocker | main
      2020-12-04 18:52:40,728 | INFO | Becoming the master on dataSource: org.apache.commons.dbcp2.BasicDataSource@b61fe7c | org.apache.activemq.store.jdbc.adapter.TransactDatabaseLocker | main
      2020-12-04 18:52:41,388 | INFO | PListStore:[/opt/apache-activemq-5.15.0/bin/activemq-data/jdbcBroker/tmp_storage] started | org.apache.activemq.store.kahadb.plist.PListStoreImpl | main
      2020-12-04 18:52:42,700 | INFO | Apache ActiveMQ 5.15.0 (jdbcBroker, ID:devmx1mesmsb02.mx.aligntech.com-55247-1606979742282-0:3230) is starting | org.apache.activemq.broker.BrokerService | main
      2020-12-04 18:52:44,790 | INFO | Listening for connections at: tcp://devmx1mesmsb02.mx.aligntech.com:61616?maximumConnections=1000&wireFormat.maxFrameSize=104857600 | org.apache.activemq.transport.TransportServerThreadSupport | main
      2020-12-04 18:52:47,633 | INFO | Connector default started | org.apache.activemq.broker.TransportConnector | main
      2020-12-04 18:52:49,992 | INFO | Apache ActiveMQ 5.15.0 (jdbcBroker, ID:devmx1mesmsb02.mx.aligntech.com-55247-1606979742282-0:3230) started | org.apache.activemq.broker.BrokerService | main
      2020-12-04 18:52:52,000 | INFO | For help or more information please see: http://activemq.apache.org | org.apache.activemq.broker.BrokerService | main
      2020-12-04 18:52:54,721 | INFO | No Spring WebApplicationInitializer types detected on classpath | /admin | main
      2020-12-04 18:53:03,057 | INFO | ActiveMQ WebConsole available at http://0.0.0.0:8161/ | org.apache.activemq.web.WebConsoleStarter | main
      2020-12-04 18:53:03,088 | INFO | ActiveMQ Jolokia REST API available at http://0.0.0.0:8161/api/jolokia/ | org.apache.activemq.web.WebConsoleStarter | main
      2020-12-04 18:53:03,125 | INFO | Initializing Spring FrameworkServlet 'dispatcher' | /admin | main
      2020-12-04 18:53:11,391 | ERROR | jdbcBroker, no longer able to keep the exclusive lock so giving up being a master | org.apache.activemq.broker.LockableServiceSupport | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:53:13,854 | INFO | Apache ActiveMQ 5.15.0 (jdbcBroker, ID:devmx1mesmsb02.mx.aligntech.com-55247-1606979742282-0:3230) is shutting down | org.apache.activemq.broker.BrokerService | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:53:11,428 | INFO | No Spring WebApplicationInitializer types detected on classpath | /api | main
      2020-12-04 18:53:16,045 | INFO | Connector default stopped | org.apache.activemq.broker.TransportConnector | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:53:16,027 | INFO | socketQueue interrupted - stopping | org.apache.activemq.transport.tcp.TcpTransportServer | ActiveMQ Transport Server Thread Handler: tcp://0.0.0.0:61616?maximumConnections=1000&wireFormat.maxFrameSize=104857600
      2020-12-04 18:53:26,774 | INFO | PListStore:[/opt/apache-activemq-5.15.0/bin/activemq-data/jdbcBroker/tmp_storage] stopped | org.apache.activemq.store.kahadb.plist.PListStoreImpl | ActiveMQ JDBC PA Scheduled Task
      2020-12-04 18:53:24,325 | INFO | jolokia-agent: Using policy access restrictor classpath:/jolokia-access.xml | /api | main
      2020-12-04 18:53:31,627 | INFO | Apache ActiveMQ 5.15.0 (jdbcBroker, ID:devmx1mesmsb02.mx.aligntech.com-55247-1606979742282-0:3230) uptime 53.645 seconds | org.apache.activemq.broker.BrokerService | ActiveMQ JDBC PA Scheduled Task

       

      Regards

      Eduardo

      Attachments

        1. activemq.xml
          7 kB
          Eduardo
        2. activemq.xml
          7 kB
          Eduardo

        Activity

          People

            Unassigned Unassigned
            lazaroe2009 Eduardo
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: