[MDEV-10150] binlog.binlog_commit_wait fails sporadically in buildbot Created: 2016-05-29  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Andrei Elkin
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled
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


Generated at Thu Feb 08 07:40:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.