[MDEV-24587] xa transactions can commit in read_only Created: 2021-01-14 Updated: 2023-04-27 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | XA |
| Affects Version/s: | 10.2.36, 10.2, 10.3, 10.4, 10.5 |
| Fix Version/s: | 10.4, 10.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Sergei Golubchik |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
A non-XA transaction would of errored on the `COMMIT`. XA has no such limitations. |
| Comments |
| Comment by Alice Sherepa [ 2021-01-14 ] | ||||||||||||||||||||||||||||||||||||||||||
|
Repeatable on 10.2-10.5, but I am not sure what the expected behaviour should be here.
| ||||||||||||||||||||||||||||||||||||||||||
| Comment by Daniel Black [ 2021-01-14 ] | ||||||||||||||||||||||||||||||||||||||||||
|
thanks for confirming alice. On expectant behaviour I'd expect the "XA PREPARE" to fail. In XA I though the commit was never meant to fail. I also noticed that read_only=1 doesn't wait on standard transactions that have updates that aren't committed either (while investigating |