[MXS-4292] Read-only transaction are not synchronized by causal_reads=universal Created: 2022-09-14  Updated: 2022-09-16  Resolved: 2022-09-16

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: 22.08.1
Fix Version/s: 22.08.2

Type: Bug Priority: Major
Reporter: markus makela Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None


 Description   

The fix to MXS-4260 broke causal_reads=universal in a way that now makes it ineffective when read-only transactions are open.

The synchronization query is treated as being a part of the read-only transaction and it ends up being routed "correctly" to the server that's executing the read-only transaction. The GTID synchronization query relies on the routing hint taking precedence over the normal transaction handling logic which previously caused the query to be routed to the currently selected master server. This change won't cause visible problems apart from a lack of synchronization but it will cause a debug assertion to be hit if the current master server fails during the sync query.


Generated at Thu Feb 08 04:27:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.