Add support for JOIN clause in XA START
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Triaged
|
Wishlist
|
Unassigned | |||
5.6 |
Triaged
|
Wishlist
|
Unassigned | |||
5.7 |
Triaged
|
Wishlist
|
Unassigned |
Bug Description
Documentation of all MySQL versions says (see http://
"For XA START, the JOIN and RESUME clauses are not supported"
This limitation causes a well known problem for Weblogic that looks like the following error message from various Connector/J version used:
Xid:bea1-
XAResource.
XAResource.
XAResource.
####<2015-
com.mysql.
at com.mysql.
at com.mysql.
at com.mysql.
at weblogic.
See
https:/
https:/
https:/
https:/
for more details and test case.
Basically, this fails at server level:
mysql> XA START 0x8a00000000000
ERROR 1398 (XAE05): XAER_INVAL: Invalid arguments (or unsupported command)
mysql> select version();
+-----------------+
| version() |
+-----------------+
| 5.6.26-74.0-log |
+-----------------+
1 row in set (0.03 sec)
There is no way to join XA transaction and Weblogic needs this to work.
This is a feature request to add proper support for this clause in Percona Server.
tags: | added: i59616 xa |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-2472