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

replication does not remove affected queries from query cache

    XMLWordPrintable

Details

    Description

      Since the upgrade to MariaDB 10.5.13 we are facing the problem where replication no longer removes affected queries from the query cache.

      We have this problem on at least two independent systems.

      How to reproduce

      On replication master:
      > create table test (number_col int);
      > insert into test set number_col=1;

      On slave:
      > select * from test;

      +------------+
      | number_col |
      +------------+
      |          1 |
      +------------+
      1 row in set (0.001 sec)

      On master:
      > insert into test set number_col=2;

      On slave:
      > select * from test;

      +------------+
      | number_col |
      +------------+
      |          1 |
      +------------+
      1 row in set (0.001 sec)

      > select SQL_NO_CACHE * from test;

      +------------+
      | number_col |
      +------------+
      |          1 |
      |          2 |
      +------------+
      2 rows in set (0.001 sec)

      with kind regards,

      Joerg

      Attachments

        1. db01.cnf
          0.8 kB
          Joerg Michels
        2. db03.cnf
          1.0 kB
          Joerg Michels

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              Joerg Michels Joerg Michels
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.