[AMQ-8121] Configuring JDBC to send information queues to DB SQL

• Type: Bug
• Status: Reopened
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 5.15.0
• Component/s: JDBC
• Assignee: Unassigned
• Reporter: Eduardo
• Created: 14/Jan/21 20:34
• Updated: 03/Mar/21 17:00

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