Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5.13, 10.6.5
-
CentOS 8
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
Issue Links
- is duplicated by
-
MDEV-28212 Query Cache on Primary-Secondary-Secondary not invalidated on updates
- Closed