geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajesh (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (GERONIMO-6562) Geronimo: RecoverTask is throwing an XAException in the jboss fuse when using transactionManager
Date Mon, 15 May 2017 06:31:04 GMT

    [ https://issues.apache.org/jira/browse/GERONIMO-6562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16010028#comment-16010028
] 

Rajesh commented on GERONIMO-6562:
----------------------------------

Getting the below exception when tried to connect to mysql server version 5.1.73. We are using
fuse 6.2.1 and tried with mysql connector versions 5.1.37 and 5.1.7. The records are inserted
to table but getting the below exception while trying to rollback.

2017-05-15 11:48:44,260 | WARN  | #0 - timer://foo | TransactionErrorHandler          | 2755
- org.apache.camel.camel-core - 2.15.1.redhat-621084 | Transaction rollback (0x7a1ae0c2) redelivered(unknown)
for (MessageId: ID-INNR90G4CSP-63455-1494829119981-0-1 on ExchangeId: ID-INNR90G4CSP-63455-1494829119981-0-2)
caught: JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception
is javax.transaction.RollbackException: Unable to commit: transaction marked for rollback
2017-05-15 11:48:44,262 | WARN  | #0 - timer://foo | TimerConsumer                    | 2755
- org.apache.camel.camel-core - 2.15.1.redhat-621084 | Error processing exchange. Exchange[Message:
[Body is null]]. Caused by: [org.springframework.transaction.UnexpectedRollbackException -
JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is javax.transaction.RollbackException:
Unable to commit: transaction marked for rollback]
org.springframework.transaction.UnexpectedRollbackException: JTA transaction unexpectedly
rolled back (maybe due to a timeout); nested exception is javax.transaction.RollbackException:
Unable to commit: transaction marked for rollback
	at org.springframework.transaction.jta.JtaTransactionManager.doCommit(JtaTransactionManager.java:1015)[2827:org.apache.servicemix.bundles.spring-tx:3.2.12.RELEASE_2]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)[2827:org.apache.servicemix.bundles.spring-tx:3.2.12.RELEASE_2]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)[2827:org.apache.servicemix.bundles.spring-tx:3.2.12.RELEASE_2]
	at org.apache.aries.transaction.internal.AriesPlatformTransactionManager.commit(AriesPlatformTransactionManager.java:75)[2749:org.apache.aries.transaction.manager:1.3.0]
	at Proxy1e473060_2645_484b_aee2_46318c257c4a.commit(Unknown Source)[:]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:148)[2827:org.apache.servicemix.bundles.spring-tx:3.2.12.RELEASE_2]
	at org.apache.camel.spring.spi.TransactionErrorHandler.doInTransactionTemplate(TransactionErrorHandler.java:174)[2768:org.apache.camel.camel-spring:2.15.1.redhat-621084]
	at org.apache.camel.spring.spi.TransactionErrorHandler.processInTransaction(TransactionErrorHandler.java:134)[2768:org.apache.camel.camel-spring:2.15.1.redhat-621084]
	at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:103)[2768:org.apache.camel.camel-spring:2.15.1.redhat-621084]
	at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:112)[2768:org.apache.camel.camel-spring:2.15.1.redhat-621084]
	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[2755:org.apache.camel.camel-core:2.15.1.redhat-621084]
	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[2755:org.apache.camel.camel-core:2.15.1.redhat-621084]
	at org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:165)[2755:org.apache.camel.camel-core:2.15.1.redhat-621084]
	at org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:73)[2755:org.apache.camel.camel-core:2.15.1.redhat-621084]
	at java.util.TimerThread.mainLoop(Timer.java:555)[:1.7.0_25]
	at java.util.TimerThread.run(Timer.java:505)[:1.7.0_25]
Caused by: javax.transaction.RollbackException: Unable to commit: transaction marked for rollback
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272)[2749:org.apache.aries.transaction.manager:1.3.0]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)[2749:org.apache.aries.transaction.manager:1.3.0]
	at org.springframework.transaction.jta.JtaTransactionManager.doCommit(JtaTransactionManager.java:1012)[2827:org.apache.servicemix.bundles.spring-tx:3.2.12.RELEASE_2]
	... 15 more
Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: XAER_INVAL: Invalid arguments (or
unsupported command)
	at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:602)[2925:wrap_file__C__Users_1473568_.m2_repository_mysql_mysql-connector-java_5.1.7_mysql-connector-java-5.1.7.jar:0.0.0]
	at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:585)[2925:wrap_file__C__Users_1473568_.m2_repository_mysql_mysql-connector-java_5.1.7_mysql-connector-java-5.1.7.jar:0.0.0]
	at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:525)[2925:wrap_file__C__Users_1473568_.m2_repository_mysql_mysql-connector-java_5.1.7_mysql-connector-java-5.1.7.jar:0.0.0]
	at org.apache.geronimo.transaction.manager.WrapperNamedXAResource.start(WrapperNamedXAResource.java:111)[2749:org.apache.aries.transaction.manager:1.3.0]
	at org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:202)[2749:org.apache.aries.transaction.manager:1.3.0]
	at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:60)[2790:org.apache.geronimo.components.geronimo-connector:3.1.1]
	at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:101)[2790:org.apache.geronimo.components.geronimo-connector:3.1.1]
	at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)[2790:org.apache.geronimo.components.geronimo-connector:3.1.1]
	at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)[2790:org.apache.geronimo.components.geronimo-connector:3.1.1]
	at org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66)[2790:org.apache.geronimo.components.geronimo-connector:3.1.1]
	at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:81)[2790:org.apache.geronimo.components.geronimo-connector:3.1.1]
	at org.tranql.connector.jdbc.TranqlDataSource.getConnection(TranqlDataSource.java:62)[2748:org.apache.aries.transaction.jdbc:2.1.1]
	at Proxy534a7235_c919_4387_b10f_68db8b285de8.getConnection(Unknown Source)[:]
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)[2825:org.apache.servicemix.bundles.spring-jdbc:3.2.12.RELEASE_2]


> Geronimo: RecoverTask is throwing an XAException in the jboss fuse when using transactionManager
> ------------------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-6562
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-6562
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: Aries
>         Environment: ALL
>            Reporter: Rajesh
>         Attachments: msql-xasample.zip, XA-Aries-transactions-Mysql-6.3.zip
>
>
> I am getting the below error keep printing in the log when application uses TransactionManager
that comes with the jboss fuse server
> 2017-02-28 22:07:15,475 | ERROR | RetryTimer       | RecoveryController             
 | 11623 - org.apache.aries.transaction.manager - 1.3.0 | Recovery error: null
> my application uses blueprint and camel. And i have printed the datasource confuguration
in the blueprint below
> 	<bean id="oracleXaDataSource" class="oracle.jdbc.xa.client.OracleXADataSource" destroy-method="close">
> 	    <property name="user" value="${datasource.user}" />
> 	    <property name="password" value="${datasource.password}" />
> 	    <property name="URL" value="${datasource.url}" />
> 	</bean>
> 	
> 	
> 	 <service interface="javax.sql.XADataSource" ref="oracleXaDataSource">
> 		<service-properties>
> 			<entry key="osgi.jndi.service.name" value="jdbc/oracleDB" />
> 			<entry key="datasource.name" value="oracleDB" />
> 			<entry key="aries.xa.name" value="oracleDB" />
> 			<entry key="aries.xa.username" value="${datasource.user}" />
> 			<entry key="aries.xa.password" value="${datasource.password}" />
> 			<entry key="aries.xa.pooling" value="true" />
> 			<entry key="aries.xa.poolMinSize" value="0" />
> 			<entry key="aries.xa.poolMaxSize" value="20" />
> 			<!-- <entry key="aries.xa.exceptionSorter" value="${aries.xa.exceptionSorter}"
/> -->
> 			<entry key="aries.xa.transaction" value="none" />					
> 		</service-properties>
> 	</service>



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message