Was able to get it working after setting below property in EI/wso2/lib/transactions.properties file and using mysql driver 5.1.5.
com.atomikos.icatch.serial_jta_transactions=false Thanks, Himasha On Wed, Feb 14, 2018 at 1:50 PM, Himasha Guruge <[email protected]> wrote: > Hi, > > I have configured master-datasources.xml and used transaction mediator > similar to [1] with MYSQL. In a scenario , where we restart MYSQL server > while executing a transaction following error is displayed and we cannot > perform any more transactions without a EI server restart. > > Caused by: com.atomikos.datasource.ResourceException: XA resource > 'TXDB1': resume for XID > '3132372E302E302E312E746D30303030383030303639:3132372E302E302E312E746D38' > raised -7: the XA resource has become unavailable > > at com.atomikos.datasource.xa.XAResourceTransaction.resume( > XAResourceTransaction.java:505) > > > According to [2] it seems to be a known issue with MYSQL XA transactions > ,which occurs when we try to access the same database multiple times using > the same transaction. It also suggests a workaround of setting some > properties, however this does not solve the issue.(Tried with > mysql-connector-java-6.0.6.jar) Appreciate any feedback on this. > > [1] https://docs.wso2.com/display/EI611/Transaction+Mediator+Example > [2] https://www.atomikos.com/Documentation/KnownProblems#JTDS_XA_Driver_ > Problems > > Thanks, > Himasha Guruge > Senior Software Engineer > WS*O2* *Inc.* > Mobile: +94 777459299 <+94%2077%20745%209299> > [email protected] > -- Himasha Guruge Senior Software Engineer WS*O2* *Inc.* Mobile: +94 777459299 [email protected]
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
