Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.10, 10.2.11, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
standard docker image
-
5.5.59
Description
It appears it's not possible to restore to an savepoint within in a XA transaction
create table t1( |
c1 int |
) engine=innodb;
|
|
|
XA START 'xa1'; |
SAVEPOINT savepoint1;
|
INSERT INTO t1 (c1) VALUES (1),(2),(3),(4); |
|
|
ROLLBACK TO SAVEPOINT savepoint1; |
this gives error:
Error Code: 1399. XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state
When i try the exact same query in mysql (5.7), this produces no errors, also the transaction is restored to the actual savepoint.
When savepoints wouldn't be supported in XA transactions, i would expect the SAVEPOINT x would already result in an error.
Attachments
Issue Links
- links to
Activity
| Field | Original Value | New Value |
|---|---|---|
| Labels | 10.2-ga Compatibility | Compatibility |
| Labels | Compatibility | Compatibility upstream-fixed |
| Fix Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 5.5 [ 15800 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Description |
It appears it's not possible to restore to an savepoint within in a XA transaction {code:sql} create table t1( c1 int ) engine=innodb; XA START 'xa1'; SAVEPOINT savepoint1; INSERT INTO t1 (c1) VALUES (1),(2),(3),(4); ROLLBACK TO SAVEPOINT savepoint1; {code} this gives error: Error Code: 1399. XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state When i try the exact same query in mysql (5.7), this produces no errors, also the transaction is restored to the actual savepoint. When savepoints wouldn't be supported in XA transactions, i would expect the SAVEPOINT x would already result in an error. |
It appears it's not possible to restore to an savepoint within in a XA transaction
{code:sql} create table t1( c1 int ) engine=innodb; XA START 'xa1'; SAVEPOINT savepoint1; INSERT INTO t1 (c1) VALUES (1),(2),(3),(4); ROLLBACK TO SAVEPOINT savepoint1; {code} this gives error: Error Code: 1399. XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state When i try the exact same query in mysql (5.7), this produces no errors, also the transaction is restored to the actual savepoint. When savepoints wouldn't be supported in XA transactions, i would expect the SAVEPOINT x would already result in an error. |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Fix Version/s | 5.5 [ 15800 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] |
| Sprint | 5.5.59 [ 221 ] |
| Assignee | Alexander Barkov [ bar ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2018-01-15 09:53:22.0 | 2018-01-15 09:53:22.945 |
| Fix Version/s | 5.5.59 [ 22612 ] | |
| Fix Version/s | 10.0.34 [ 22613 ] | |
| Fix Version/s | 10.3.4 [ 22904 ] | |
| Fix Version/s | 10.1.31 [ 22907 ] | |
| Fix Version/s | 10.2.13 [ 22910 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 5.5 [ 15800 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
See also "git show 1a7e7a0f756d34a94d35c8cbf03823fb68d10044" in MySQL code base:
This patch fixes the bug#13737343 (formerly known as 64374): XA TRANSACTIONS AND SAVEPOINT.
| Remote Link | This issue links to "The same bug in MySQL (Web Link)" [ 28322 ] |
| Workflow | MariaDB v3 [ 84351 ] | MariaDB v4 [ 153322 ] |
It's also reproducible on MySQL 5.5, but apparently the behavior has changed since 5.6.