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

Compressed binary log with two-phase alter events cannot be replayed

    XMLWordPrintable

Details

    Description

      --source include/have_log_bin.inc
       
      set @min_len= @@log_bin_compress_min_len, @compress= @@log_bin_compress, @two_phase= @@binlog_alter_two_phase;
      set global log_bin_compress_min_len=40, log_bin_compress=on, binlog_alter_two_phase=ON;
      reset master;
       
      --connect (con1,localhost,root,,)
      create table t (a int);
      alter table t add b int, add c int, add d int;
      flush binary logs;
      drop table t;
      --let $datadir= `select @@datadir`
      --exec $MYSQL_BINLOG $datadir/master-bin.000001 | $MYSQL test
       
      # Cleanup
      drop table t;
      --disconnect con1
      --connection default
      set global log_bin_compress_min_len=@min_len, log_bin_compress=@compress, binlog_alter_two_phase=@two_phase;
      

      10.9 42738f5f

      ERROR 1730 (HY000) at line 45: Only Format_description_log_event and row events are allowed in BINLOG statements (but Query_compressed was provided)
      

      Replication works somehow, so probably it is a clients' problem.

      Attachments

        Activity

          People

            bnestere Brandon Nesterenko
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.