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

binlog.binlog_commit_wait fails sporadically in buildbot

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.0, 10.1, 10.2
    • Fix Version/s: 10.0, 10.1, 10.2
    • Component/s: Tests
    • Labels:
      None
    • Sprint:
      10.2.1-5, 10.0.26

      Description

      The failure (at least the "too much time' part) has been happening for over a year, although rarely.

      http://buildbot.askmonty.org/buildbot/builders/p8-rhel6-bintar/builds/1493/steps/test/logs/stdio

      binlog.binlog_commit_wait 'mix,xtradb'   w1 [ fail ]
              Test ended at 2016-05-29 02:24:59
       
      CURRENT_TEST: binlog.binlog_commit_wait
      --- /home/buildbot/maria-slave/power8-vlp01-bintar/build/mysql-test/suite/binlog/r/binlog_commit_wait.result	2016-05-29 00:55:03.660077666 -0400
      +++ /home/buildbot/maria-slave/power8-vlp01-bintar/build/mysql-test/suite/binlog/r/binlog_commit_wait.reject	2016-05-29 02:24:58.820077667 -0400
      @@ -99,11 +99,11 @@
       SET @b= unix_timestamp(current_timestamp()) - unix_timestamp(@a);
       SELECT IF(@b < 20, "Ok", CONCAT("Error: too much time elapsed: ", @b, " seconds >= 20"));
       IF(@b < 20, "Ok", CONCAT("Error: too much time elapsed: ", @b, " seconds >= 20"))
      -Ok
      +Error: too much time elapsed: 20 seconds >= 20
       SELECT variable_value - @group_commits FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commits';
       variable_value - @group_commits
      -3
      +4
       SELECT variable_value - @group_commit_trigger_count FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commit_trigger_count';
       variable_value - @group_commit_trigger_count
      @@ -111,7 +111,7 @@
       SELECT variable_value - @group_commit_trigger_timeout FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commit_trigger_timeout';
       variable_value - @group_commit_trigger_timeout
      -0
      +1
       SELECT variable_value - @group_commit_trigger_lock_wait FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commit_trigger_lock_wait';
       variable_value - @group_commit_trigger_lock_wait
      @@ -127,19 +127,19 @@
       SET @b= unix_timestamp(current_timestamp()) - unix_timestamp(@a);
       SELECT IF(@b < 20, "Ok", CONCAT("Error: too much time elapsed: ", @b, " seconds >= 20"));
       IF(@b < 20, "Ok", CONCAT("Error: too much time elapsed: ", @b, " seconds >= 20"))
      -Ok
      +Error: too much time elapsed: 20 seconds >= 20
       SELECT variable_value - @group_commits FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commits';
       variable_value - @group_commits
      -4
      +5
       SELECT variable_value - @group_commit_trigger_count FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commit_trigger_count';
       variable_value - @group_commit_trigger_count
      -2
      +1
       SELECT variable_value - @group_commit_trigger_timeout FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commit_trigger_timeout';
       variable_value - @group_commit_trigger_timeout
      -0
      +2
       SELECT variable_value - @group_commit_trigger_lock_wait FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commit_trigger_lock_wait';
       variable_value - @group_commit_trigger_lock_wait
      @@ -159,15 +159,15 @@
       SELECT variable_value - @group_commits FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commits';
       variable_value - @group_commits
      -5
      +6
       SELECT variable_value - @group_commit_trigger_count FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commit_trigger_count';
       variable_value - @group_commit_trigger_count
      -2
      +1
       SELECT variable_value - @group_commit_trigger_timeout FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commit_trigger_timeout';
       variable_value - @group_commit_trigger_timeout
      -1
      +3
       SELECT variable_value - @group_commit_trigger_lock_wait FROM information_schema.global_status
       WHERE variable_name = 'binlog_group_commit_trigger_lock_wait';
       variable_value - @group_commit_trigger_lock_wait
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Elkin Andrei Elkin
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: