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

binlog.binlog_commit_wait fails sporadically in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.0, 10.1, 10.2
    • N/A
    • Tests
    • None
    • 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

              Elkin Andrei Elkin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.