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

binlog.binlog_bug36391 fails on 2nd repeat with --repeat 2

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.11, 11.2(EOL), 11.4, 11.6(EOL), 11.7
    • 10.5, 10.6, 10.11, 11.4
    • Binary Protocol
    • None

    Description

      ./mtr binlog.binlog_bug36391 --repeat=2
      

      binlog.binlog_bug36391 'mix'             [ pass ]     38
      binlog.binlog_bug36391 'mix'             [ 2 fail ]
              Test ended at 2022-12-29 23:30:39
       
      CURRENT_TEST: binlog.binlog_bug36391
      ERROR 1051 (42S02) at line 38: Unknown table 'test.t1'
      mysqltest: At line 26: exec of '/home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/bin/mariadb-binlog --defaults-file=/home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/mysql-test/var/my.cnf --local-load=/home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/mysql-test/var/tmp /home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/mysql-test/var/mysqld.1/data/master-bin.000002 | /home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/bin/mariadb --defaults-file=/home/angelique/dev/build-10.5-MDEV-26382-7487c3/build1/mysql-test/var/my.cnf test' failed, error: 256, status: 1, errno: 11
      Output from before failure:
      DROP TABLE t1;
       
       
       
      The result from queries just before the failure was:
      CREATE TABLE t1(id INT);
      SHOW TABLES;
      Tables_in_test
      t1
      FLUSH LOGS;
      DROP TABLE t1;
      

      On 11.0 0529784d3 it fails with an extra Error message. Unsure if this is related to MDEV-29803:

      binlog.binlog_bug36391 'mix'             [ 2 fail ]
              Test ended at 2022-12-29 23:38:51
       
      CURRENT_TEST: binlog.binlog_bug36391
      ERROR: Found out of order GTID. Got 0-1-1 after 0-1-2
      ERROR 1051 (42S02) at line 38: Unknown table 'test.t1'
      mysqltest: At line 26: exec of '/home/angelique/dev/build-11.0-0529784d3/build1/bin/mariadb-binlog --defaults-file=/home/angelique/dev/build-11.0-0529784d3/build1/mysql-test/var/my.cnf --local-load=/home/angelique/dev/build-11.0-0529784d3/build1/mysql-test/var/tmp /home/angelique/dev/build-11.0-0529784d3/build1/mysql-test/var/mysqld.1/data/master-bin.000002 | /home/angelique/dev/build-11.0-0529784d3/build1/bin/mariadb --defaults-file=/home/angelique/dev/build-11.0-0529784d3/build1/mysql-test/var/my.cnf test' failed, error: 256, status: 1, errno: 11
      Output from before failure:
      DROP TABLE t1;
      

      binlog.binlog_base64_flag also has the same problem (not sure if it's related, but just putting here for now):

      ./mtr binlog.binlog_base64_flag --repeat=2
      

      binlog.binlog_base64_flag 'mix'          [ pass ]     64
      binlog.binlog_base64_flag 'mix'          [ 2 fail ]
              Test ended at 2022-12-30 02:33:11
       
      CURRENT_TEST: binlog.binlog_base64_flag
      mysqltest: At line 43: query 'BINLOG '
      SVtYRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
      SVtYRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+AgAAAA==
      '' succeeded - should have failed with errno 1609...
       
      The result from queries just before the failure was:
      call mtr.add_suppression("BINLOG_BASE64_EVENT: According to the master's version");
      call mtr.add_suppression("BINLOG_BASE64_EVENT: Column 1 of table 'test.char128_utf8' cannot be converted");
      DROP TABLE IF EXISTS t1;
      ==== Test BUG#32407 ====
      select * from t1;
      a
      1
      1
      ==== Test BINLOG statement w/o FD event ====
      BINLOG '
      SVtYRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
      SVtYRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+AgAAAA==
      ';
      

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              angelique.sklavounos Angelique Sklavounos (Inactive)
              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.