Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
2.3.0
-
None
Description
(1) Make a connection to MaxScale configured with ReadWriteSplit and causal_reads=false
(2) Send following SQL from this connection
SET @i=1;
(3) Send following SQL repeatedly from this connection
INSERT INTO t1 @i;
SELECT * from t1;
SET @i=@i+1;
(4) Since Causal_reads is false, the "SELECT *" is not giving consistent results
(5) In a separate window, maxctrl alter service Splitter-Service causal_reads true
(6) Even though causal_reads is turned ON, the results on (3) continues to show inconsistent reads
(7) now if we disconnect and connect again, and do (2) & (3) the results are consistent
This causal_reads service parameter change did not have effect on ongoing connection.