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 <himas...@wso2.com> 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>
> himas...@wso2.com
>



-- 
Himasha Guruge
Senior Software Engineer
WS*O2* *Inc.*
Mobile: +94 777459299
himas...@wso2.com
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to