Skip to content

Instantly share code, notes, and snippets.

@jpoetker
Created October 5, 2012 15:04
Show Gist options
  • Save jpoetker/3840345 to your computer and use it in GitHub Desktop.
Save jpoetker/3840345 to your computer and use it in GitHub Desktop.
XA MQ + Missing DataBase
From IBM @ http://www-01.ibm.com/support/docview.wss?uid=swg1PK30625
****************************************************************
* PROBLEM DESCRIPTION: When using WebSphere Application *
* Server Version 6.x with WebSphere MQ *
* Version 5.3 Fix Pack 12 (or later) *
* or WebSphere MQ Version 6.0 Refresh *
* Pack 1 (6.0.1.0) as the JMS provider, *
* the following error appears in the *
* application server's SystemOut.log *
* file when a message is rolled back: *
* *
* J2CA0027E: An exception occurred while *
* invoking rollback on an XA Resource *
* Adapter from dataSource <queue *
* connection factory>, within *
* transaction ID <XID>: *
* javax.transaction.xa.XAException: *
* XA operation failed, see errorCode *
* at com.ibm.mq.MQXAResource. *
* rollback(MQXAResource.java:379) *
* at com.ibm.ejs.jms. *
* JMSManagedSession$JMSXAResource. *
* rollback *
* (JMSManagedSession.java:1311) *
* at com.ibm.ejs.j2c. *
* XATransactionWrapper.rollback *
* (XATransactionWrapper.java:1266) *
* : : : : : : : : *
* Encountered an XA resource error *
* during an XA rollback operation: *
* error code: *
* XA_RBROLLBACK *
* javax.transaction.xa.XAException: XA *
* operation failed, see errorCode *
* at com.ibm.mq.MQXAResource. *
* rollback(MQXAResource.java:379) *
* at com.ibm.ejs.jms. *
* JMSManagedSession$JMSXAResource. *
* rollback *
* (JMSManagedSession.java:1311) *
* at com.ibm.ejs.j2c. *
* XATransactionWrapper.rollback *
* (XATransactionWrapper.java:1266) *
* at com.ibm.ejs.jts.jta.portable. *
* JTAXAResourceImpl.rollback *
* (JTAXAResourceImpl.java:616) *
* : : : : : : : : *
****************************************************************
* RECOMMENDATION: *
****************************************************************
This problem was caused by a change in behaviour introduced by
WebSphere MQ APAR IY76314 (shipped as part of WebSphere MQ
Version 5.3 Fix Pack 12 and WebSphere MQ Version 6.0 Refresh
Pack 1 (6.0.1.0)).
When WebSphere Application Server decides to roll back a
failed transaction, it issues an xa_end() followed by an
xa_rollback() to the queue manager. Any errors thrown by the
queue manager when xa_end() is called are ignored.
Prior to APAR IY76314, when the xa_end() was issued, the queue
manager simply marked the transaction for rollback. The
transaction would then be rolled back when xa_rollback() was
called.
However, when using WMQ 5.3 CSD12 (or later) or WMQ 6.0.1.0
(or later), the queue manager will actually roll back the
transaction when xa_end() is called. When the application
server then calls xa_rollback(), the queue manager returns
XA_RBROLLBACK, as the transaction has already been rolled back.
As the application server is not expecting this return code,
it throws the J2CA0027E error mentioned above.
However, it is perfectly valid for WMQ to return this return
code if it has previously told the application server that it
has rolled back the message while processing the xa_end(). It
does this by returning XA_RBROLLBACK from xa_end(). The
application server ignores this, as it is a valid return
value.
Problem conclusion
In order to fix the problem, the JMSManagedSession class has
been modified to store the ignored exception, should one be
returned from xa_end(). If an exception occurs in
xa_rollback(), a check is made to see if this is the same
exception as was previously received from xa_end(). If it is,
then the exception is swallowed up - however, if the
exceptions are different, it is rethrown to the caller.
The fix for this APAR is currently targeted for inclusion in
Fixpack 17 for WebSphere Application Server Version 6.0.2
(6.0.2.17) and Fixpack 3 for WebSphere Application Server
Version 6.1.0 (6.1.0.3). Please refer to the Recommended
Updates page for delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
0:24:34,198 | WARN | er[poc.queue.kv] | TransactionErrorHandler | ? ? | 59 - org.apache.camel.camel-core - 2.8.0.fuse-06-11 | Transaction rollback (0xa20bc2) for ExchangeId: ID-servicemix-49503-1349409759043-1-10 due exception: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to acquire a new connection from the pool
00:24:34,198 | ERROR | er[poc.queue.kv] | EndpointMessageListener | ? ? | 59 - org.apache.camel.camel-core - 2.8.0.fuse-06-11 | Caused by: [org.apache.camel.RuntimeCamelException - org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to acquire a new connection from the pool]
org.apache.camel.RuntimeCamelException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to acquire a new connection from the pool
at org.apache.camel.util.ObjectHelper.wrapRuntimeCamelException(ObjectHelper.java:1157)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler$1.doInTransactionWithoutResult(TransactionErrorHandler.java:174)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)[67:org.springframework.transaction:3.0.5.RELEASE]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)[67:org.springframework.transaction:3.0.5.RELEASE]
at org.apache.camel.spring.spi.TransactionErrorHandler.doInTransactionTemplate(TransactionErrorHandler.java:160)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.processInTransaction(TransactionErrorHandler.java:121)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:95)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:104)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DefaultChannel.process(DefaultChannel.java:304)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:78)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.Pipeline.process(Pipeline.java:116)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.Pipeline.process(Pipeline.java:79)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:78)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:69)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:85)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.component.jms.EndpointMessageListener.onMessage(EndpointMessageListener.java:91)[164:org.apache.camel.camel-jms:2.8.0.fuse-06-11]
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:560)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:498)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:243)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)[123:org.springframework.jms:3.0.5.RELEASE]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)[:1.6.0_24]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)[:1.6.0_24]
at java.lang.Thread.run(Thread.java:679)[:1.6.0_24]
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to acquire a new connection from the pool
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:572)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:867)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:875)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[:1.6.0_24]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[:1.6.0_24]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616)[:1.6.0_24]
at org.apache.aries.proxy.impl.ProxyHandler$1.invoke(ProxyHandler.java:50)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.DefaultWrapper.invoke(DefaultWrapper.java:31)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.ProxyHandler.invoke(ProxyHandler.java:78)[8:org.apache.aries.proxy:0.3.1]
at $Proxy57.update(Unknown Source)
at com.gafri.esb.poc.transaction.adapter.KeyValueProcessor.store(KeyValueProcessor.java:19)
at com.gafri.esb.poc.transaction.adapter.KeyValueProcessor.process(KeyValueProcessor.java:15)
at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616)[:1.6.0_24]
at org.apache.aries.proxy.impl.ProxyHandler$1.invoke(ProxyHandler.java:50)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.DefaultWrapper.invoke(DefaultWrapper.java:31)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.ProxyHandler.invoke(ProxyHandler.java:78)[8:org.apache.aries.proxy:0.3.1]
at $Proxy47.process(Unknown Source)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsyncProcessorBridge.process(AsyncProcessorTypeConverter.java:50)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:69)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:99)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.fabric.FabricTraceProcessor.process(FabricTraceProcessor.java:81)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:318)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:209)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.processByErrorHandler(TransactionErrorHandler.java:207)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:91)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:104)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DefaultChannel.process(DefaultChannel.java:304)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:318)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:209)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.processByErrorHandler(TransactionErrorHandler.java:207)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:91)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:104)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:99)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.fabric.FabricTraceProcessor.process(FabricTraceProcessor.java:81)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:318)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:209)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.processByErrorHandler(TransactionErrorHandler.java:207)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler$1.doInTransactionWithoutResult(TransactionErrorHandler.java:167)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
... 34 more
Caused by: java.sql.SQLException: Unable to acquire a new connection from the pool
at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:120)
at org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
at org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
... 112 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.6.0_24]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)[:1.6.0_24]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.6.0_24]
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)[:1.6.0_24]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.6.0_24]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)[:1.6.0_24]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.6.0_24]
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)[:1.6.0_24]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:440)
at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:138)
at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:108)
at com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.getXAConnection(MysqlXADataSource.java:48)
at org.apache.commons.dbcp.managed.DataSourceXAConnectionFactory.createConnection(DataSourceXAConnectionFactory.java:101)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:117)
... 116 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)[:1.6.0_24]
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)[:1.6.0_24]
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)[:1.6.0_24]
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)[:1.6.0_24]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)[:1.6.0_24]
at java.net.Socket.connect(Socket.java:546)[:1.6.0_24]
at java.net.Socket.connect(Socket.java:495)[:1.6.0_24]
at java.net.Socket.<init>(Socket.java:392)[:1.6.0_24]
at java.net.Socket.<init>(Socket.java:235)[:1.6.0_24]
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
... 136 more
00:24:34,210 | WARN | er[poc.queue.kv] | JmsMessageListenerContainer | ? ? | 123 - org.springframework.jms - 3.0.5.RELEASE | Execution of JMS message listener failed, and no ErrorHandler has been set.
org.apache.camel.RuntimeCamelException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to acquire a new connection from the pool
at org.apache.camel.util.ObjectHelper.wrapRuntimeCamelException(ObjectHelper.java:1157)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler$1.doInTransactionWithoutResult(TransactionErrorHandler.java:174)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)[67:org.springframework.transaction:3.0.5.RELEASE]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)[67:org.springframework.transaction:3.0.5.RELEASE]
at org.apache.camel.spring.spi.TransactionErrorHandler.doInTransactionTemplate(TransactionErrorHandler.java:160)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.processInTransaction(TransactionErrorHandler.java:121)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:95)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:104)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DefaultChannel.process(DefaultChannel.java:304)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:78)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.Pipeline.process(Pipeline.java:116)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.Pipeline.process(Pipeline.java:79)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:78)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:69)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:85)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.component.jms.EndpointMessageListener.onMessage(EndpointMessageListener.java:91)[164:org.apache.camel.camel-jms:2.8.0.fuse-06-11]
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:560)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:498)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:243)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)[123:org.springframework.jms:3.0.5.RELEASE]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)[:1.6.0_24]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)[:1.6.0_24]
at java.lang.Thread.run(Thread.java:679)[:1.6.0_24]
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to acquire a new connection from the pool
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:572)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:867)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:875)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[:1.6.0_24]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[:1.6.0_24]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616)[:1.6.0_24]
at org.apache.aries.proxy.impl.ProxyHandler$1.invoke(ProxyHandler.java:50)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.DefaultWrapper.invoke(DefaultWrapper.java:31)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.ProxyHandler.invoke(ProxyHandler.java:78)[8:org.apache.aries.proxy:0.3.1]
at $Proxy57.update(Unknown Source)
at com.gafri.esb.poc.transaction.adapter.KeyValueProcessor.store(KeyValueProcessor.java:19)
at com.gafri.esb.poc.transaction.adapter.KeyValueProcessor.process(KeyValueProcessor.java:15)
at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616)[:1.6.0_24]
at org.apache.aries.proxy.impl.ProxyHandler$1.invoke(ProxyHandler.java:50)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.DefaultWrapper.invoke(DefaultWrapper.java:31)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.ProxyHandler.invoke(ProxyHandler.java:78)[8:org.apache.aries.proxy:0.3.1]
at $Proxy47.process(Unknown Source)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsyncProcessorBridge.process(AsyncProcessorTypeConverter.java:50)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:69)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:99)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.fabric.FabricTraceProcessor.process(FabricTraceProcessor.java:81)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:318)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:209)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.processByErrorHandler(TransactionErrorHandler.java:207)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:91)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:104)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DefaultChannel.process(DefaultChannel.java:304)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:318)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:209)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.processByErrorHandler(TransactionErrorHandler.java:207)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:91)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:104)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:99)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.fabric.FabricTraceProcessor.process(FabricTraceProcessor.java:81)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:104)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:61)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:318)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:209)[59:org.apache.camel.camel-core:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler.processByErrorHandler(TransactionErrorHandler.java:207)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
at org.apache.camel.spring.spi.TransactionErrorHandler$1.doInTransactionWithoutResult(TransactionErrorHandler.java:167)[66:org.apache.camel.camel-spring:2.8.0.fuse-06-11]
... 34 more
Caused by: java.sql.SQLException: Unable to acquire a new connection from the pool
at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:120)
at org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
at org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
... 112 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.6.0_24]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)[:1.6.0_24]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.6.0_24]
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)[:1.6.0_24]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.6.0_24]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)[:1.6.0_24]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.6.0_24]
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)[:1.6.0_24]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:440)
at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:138)
at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:108)
at com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.getXAConnection(MysqlXADataSource.java:48)
at org.apache.commons.dbcp.managed.DataSourceXAConnectionFactory.createConnection(DataSourceXAConnectionFactory.java:101)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:117)
... 116 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)[:1.6.0_24]
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)[:1.6.0_24]
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)[:1.6.0_24]
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)[:1.6.0_24]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)[:1.6.0_24]
at java.net.Socket.connect(Socket.java:546)[:1.6.0_24]
at java.net.Socket.connect(Socket.java:495)[:1.6.0_24]
at java.net.Socket.<init>(Socket.java:392)[:1.6.0_24]
at java.net.Socket.<init>(Socket.java:235)[:1.6.0_24]
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
... 136 more
00:24:34,224 | WARN | er[poc.queue.kv] | Transaction | ? ? | 172 - org.apache.aries.transaction.manager - 0.3.1 | Error ending association for XAResource org.apache.geronimo.transaction.manager.WrapperNamedXAResource@16d6735; transaction will roll back. XA error code: 100
javax.transaction.xa.XAException: The method 'xa_end' has failed with errorCode '100'.
at com.ibm.mq.jmqi.JmqiXAResource.end(JmqiXAResource.java:511)
at org.apache.geronimo.transaction.manager.WrapperNamedXAResource.end(WrapperNamedXAResource.java:61)
at org.apache.geronimo.transaction.manager.TransactionImpl.endResources(TransactionImpl.java:569)
at org.apache.geronimo.transaction.manager.TransactionImpl.endResources(TransactionImpl.java:548)
at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:488)
at org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:265)
at org.springframework.transaction.jta.JtaTransactionManager.doRollback(JtaTransactionManager.java:1036)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:706)
at org.apache.aries.transaction.GeronimoPlatformTransactionManager.commit(GeronimoPlatformTransactionManager.java:76)
at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616)[:1.6.0_24]
at org.apache.aries.proxy.impl.ProxyHandler$1.invoke(ProxyHandler.java:50)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.DefaultWrapper.invoke(DefaultWrapper.java:31)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.ProxyHandler.invoke(ProxyHandler.java:78)[8:org.apache.aries.proxy:0.3.1]
at $Proxy24.commit(Unknown Source)[67:org.springframework.transaction:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:257)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)[123:org.springframework.jms:3.0.5.RELEASE]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)[:1.6.0_24]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)[:1.6.0_24]
at java.lang.Thread.run(Thread.java:679)[:1.6.0_24]
00:24:34,229 | ERROR | er[poc.queue.kv] | RollbackTask | ? ? | 172 - org.apache.aries.transaction.manager - 0.3.1 | Unexpected exception committing org.apache.geronimo.transaction.manager.WrapperNamedXAResource@16d6735; continuing to commit other RMs
javax.transaction.xa.XAException: The method 'xa_rollback' has failed with errorCode '100'.
at com.ibm.mq.jmqi.JmqiXAResource.rollback(JmqiXAResource.java:795)
at org.apache.geronimo.transaction.manager.WrapperNamedXAResource.rollback(WrapperNamedXAResource.java:100)
at org.apache.geronimo.transaction.manager.RollbackTask.run(RollbackTask.java:63)
at org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:584)
at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:491)
at org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:265)
at org.springframework.transaction.jta.JtaTransactionManager.doRollback(JtaTransactionManager.java:1036)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:706)
at org.apache.aries.transaction.GeronimoPlatformTransactionManager.commit(GeronimoPlatformTransactionManager.java:76)
at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616)[:1.6.0_24]
at org.apache.aries.proxy.impl.ProxyHandler$1.invoke(ProxyHandler.java:50)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.DefaultWrapper.invoke(DefaultWrapper.java:31)[8:org.apache.aries.proxy:0.3.1]
at org.apache.aries.proxy.impl.ProxyHandler.invoke(ProxyHandler.java:78)[8:org.apache.aries.proxy:0.3.1]
at $Proxy24.commit(Unknown Source)[67:org.springframework.transaction:3.0.5.RELEASE]
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:257)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)[123:org.springframework.jms:3.0.5.RELEASE]
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)[123:org.springframework.jms:3.0.5.RELEASE]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)[:1.6.0_24]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)[:1.6.0_24]
at java.lang.Thread.run(Thread.java:679)[:1.6.0_24]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment