Eduardo created AMQ-8121:
----------------------------
Summary: 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
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)
