Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2150

maxctrl alter service commands does not impact existing connections

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 2.3.0
    • N/A
    • N/A
    • 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.

      Attachments

        Activity

          People

            markus makela markus makela
            dshjoshi Dipti Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.