Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
22.08.8, 23.02.4
-
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.