[MXS-4734] SET TRANSACTION READ ONLY is classified as a session command Created: 2023-08-30 Updated: 2023-09-04 Resolved: 2023-09-04 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | readwritesplit |
| Affects Version/s: | 22.08.8, 23.02.4 |
| Fix Version/s: | 22.08.9, 23.02.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | markus makela | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
The SET TRANSACTION READ ONLY command modifies the next transaction to be a read-only one. This is currently classified in MaxScale as a session command which means it will get routed to all nodes. This has the unintended side-effect of causing the next transaction on all nodes to be a read-only one which can result in unexpected read-only errors. |