[jira] [Commented] (GERONIMO-6562) Geronimo: RecoverTask is throwing an XAException in the jboss fuse when using transactionManager

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (GERONIMO-6562) Geronimo: RecoverTask is throwing an XAException in the jboss fuse when using transactionManager

JIRA jira@apache.org

    [ 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)