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

Flaky binlog.binlog_gtid_index test

    XMLWordPrintable

Details

    Description

      https://buildbot.mariadb.org/#/builders/846/builds/7209

      CURRENT_TEST: binlog.binlog_gtid_index
      Cannot read file: 
      mysqltest: At line 117: command "perl" failed with error: 255  my_errno: 0  errno: 0
       
      The result from queries just before the failure was:
      < snip >
      +++ GTID Lookup in good index.
      Gtid_Lookup_Ok
      1
      SHOW STATUS LIKE 'binlog_gtid_index_%';
      Variable_name	Value
      Binlog_gtid_index_hit	1
      Binlog_gtid_index_miss	0
      +++ GTID Lookup, index file is missing.
      Gtid_Lookup_Ok
      1
      SHOW STATUS LIKE 'binlog_gtid_index_%';
      Variable_name	Value
      Binlog_gtid_index_hit	1
      Binlog_gtid_index_miss	1
      FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
      INSERT INTO t1 VALUES (306);
      SET @gtid_pos= @@GLOBAL.gtid_binlog_pos;
      INSERT INTO t1 VALUES (307);
      INSERT INTO t1 VALUES (308);
      FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
       
      More results from queries before failure can be found in /home/buildbot/s390x-sles-1506/build/mysql-test/var/8/log/binlog_gtid_index.log
       
       - saving '/home/buildbot/s390x-sles-1506/build/mysql-test/var/8/log/binlog.binlog_gtid_index-mix/' to '/home/buildbot/s390x-sles-1506/build/mysql-test/var/log/binlog.binlog_gtid_index-mix/'
      

      The key bit here is the "Cannot read file" in the output. The corresponds to the perl die command inside the test.

      sysread(F, $buf, 1)
        or die "Cannot read file: $!\n";
      

      Because the output doesn't include "$!" having a value, The sysread is at an EOF condition.

      Repeatable localy on 12.3 debug+asan 1 in 400 tries.

      Resulting files are 4k

        5819705      4 -rw-rw----   1 dan      dan          4096 May 28 13:33 mysql-test/var/log/binlog.binlog_gtid_index-mix/mysqld.1/data/master-bin.000349.idx
        5819700      4 -rw-rw----   1 dan      dan          4096 May 28 13:33 mysql-test/var/log/binlog.binlog_gtid_index-mix/mysqld.1/data/master-bin.000348.idx
        5819701      4 -rw-rw----   1 dan      dan          4096 May 28 13:33 mysql-test/var/log/binlog.binlog_gtid_index-mix/mysqld.1/data/master-bin.000346.idx
        5819659      4 -rw-rw----   1 dan      dan          4096 May 28 13:33 mysql-test/var/log/binlog.binlog_gtid_index-mix/mysqld.1/data/master-bin.000345.idx
      

      as where ones out of buildbot.

      Does "FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;" not do a fdatasync?

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              danblack Daniel Black
              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.