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

Create temporary sequence can cause inconsistency

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

          Descending order - Click to sort in ascending order
          janlindstrom Jan Lindström added a comment -

          https://github.com/MariaDB/server/pull/2647

          janlindstrom Jan Lindström added a comment - https://github.com/MariaDB/server/pull/2647
          janlindstrom Jan Lindström added a comment -

          This test case crashes on 10.4

          mysqld: /home/jan/work/mariadb/10.4/sql/wsrep_trans_observer.h:583: void wsrep_commit_empty(THD*, bool): Assertion `!wsrep_has_changes(thd) || (thd->lex->sql_command == SQLCOM_CREATE_TABLE && !thd->is_current_stmt_binlog_format_row()) || thd->wsrep_cs().transaction().state() == wsrep::transaction::s_aborted' failed.

          janlindstrom Jan Lindström added a comment - This test case crashes on 10.4 mysqld: /home/jan/work/mariadb/10.4/sql/wsrep_trans_observer.h:583: void wsrep_commit_empty(THD*, bool): Assertion `!wsrep_has_changes(thd) || (thd->lex->sql_command == SQLCOM_CREATE_TABLE && !thd->is_current_stmt_binlog_format_row()) || thd->wsrep_cs().transaction().state() == wsrep::transaction::s_aborted' failed.

          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.