Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28212

Query Cache on Primary-Secondary-Secondary not invalidated on updates

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.5.13
    • Fix Version/s: 10.5.14
    • Component/s: Query Cache, Replication
    • Labels:
      None
    • Environment:
      bitnami/mariadb Helm Chart on Kubernetes running on Linux

      Description

      When running Primary-Secondary-Secondary setup DML operations on Primary do not trigger query caches on Secondaries to be invalidated when binary log is in ROW format.

      Reproduce as follows (given a table ):

      On Primary:

      insert into test values (123);
      select * from test; #=> gives 123
      

      On Secondaries:

      select * from test; => gives nothing
      select * from test where 1=1; # or select SQL_NO_CACHE * from test; => gives 123
      

      Excerpt from my.cnf for Primary and Secondaries:

      binlog_format=row
      query_cache_type=1
      query_cache_limit=4M
      query_cache_size=256M
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              angelique.sklavounos Angelique Sklavounos
              Reporter:
              tbienias Tim Bienias
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.