[
https://issues.apache.org/jira/browse/AMQ-8121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jean-Baptiste Onofré resolved AMQ-8121.
---------------------------------------
Resolution: Not A Problem
As I have several production using JDBC master-slave store, I'm pretty sure it
works fine. I'm suspecting environment or configuration issue. Please, provide
the resources I will help to fix this up with you.
> Configuring JDBC to send information queues to DB SQL
> -----------------------------------------------------
>
> Key: AMQ-8121
> URL: https://issues.apache.org/jira/browse/AMQ-8121
> Project: ActiveMQ
> Issue Type: Bug
> Components: JDBC
> Reporter: Eduardo
> Priority: Major
>
> 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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
