Details
Description
In 10.6 cluster following transaction causes inconsistency:
create table t (i int primary key, j int); |
set autocommit=0; |
insert into t values (3,0); |
create temporary sequence seq NOCACHE engine=innodb;
|
commit;
|
After this, the first node has the inserted row in table t, but other nodes do not have it.
Problem seems to be due to how implicit commit triggered by the create sequence, is handled in galera replication.
However, if the normal (i.e. not temporary) sequence is created, replication happens correctly.