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