[MDEV-30653] With wsrep_mode=REPLICATE_ARIA only part of mixed-engine transactions is replicated Created: 2023-02-14  Updated: 2023-12-05

Status: Stalled
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.6.12
Fix Version/s: 10.6

Type: Bug Priority: Critical
Reporter: Hartmut Holzgraefe Assignee: Julius Goryavsky
Resolution: Unresolved Votes: 0
Labels: None


 Description   

When updating both an Aria and InnoDB table in a single transaction only the Aria change seems to get replicated to the other nodes, but not the InnoDB ones.

create table t1 (id serial, val int) engine=innodb;
 
create table t2 (id serial, val int) engine=aria;
 
 
 
insert into t1 values(1, 23);
 
insert into t2 values(2, 42);
 
 
 
begin;
 
update t1 set val=24 where id=1;
 
update t2 set val=41 where id=2;
 
commit;

The node I ran the transaction shows the expected results:

MariaDB [test]> select * from t1;
 
+----+------+
 
| id | val  |
 
+----+------+
 
|  1 |   24 |
 
+----+------+
 
1 row in set (0.000 sec)
 
 
 
MariaDB [test]> select * from t2;
 
+----+------+
 
| id | val  |
 
+----+------+
 
|  2 |   41 |
 
+----+------+
 
1 row in set (0.000 sec)

But the other nodes only have the Aria table changed:

MariaDB [test]> select * from t1;
 
+----+------+
 
| id | val  |
 
+----+------+
 
|  1 |   23 |
 
+----+------+
 
1 row in set (0.000 sec)
 
 
 
MariaDB [test]> select * from t2;
 
+----+------+
 
| id | val  |
 
+----+------+
 
|  2 |   41 |
 
+----+------+
 
1 row in set (0.000 sec)



 Comments   
Comment by JiraAutomate [ 2023-12-05 ]

Automated message:
----------------------------
Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

Generated at Thu Feb 08 10:17:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.