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

Create temporary sequence can cause inconsistency

    XMLWordPrintable

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.

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            seppo Seppo Jaakola
            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.