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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.5.13
    • 10.5.14
    • Query Cache, Replication
    • None
    • 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

              angelique.sklavounos Angelique Sklavounos (Inactive)
              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.