Details
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)
|
Attachments
Issue Links
- is caused by
-
MDEV-34647 'INSERT...SELECT' on MyISAM table suddenly replicated by Galera
- Closed