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
himas...@wso2.com
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to