[MDEV-11532] wsrep.binlog_format failed in buildbot Created: 2016-12-10  Updated: 2018-07-19  Resolved: 2018-07-19

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.1, 10.2
Fix Version/s: 10.1.35, 10.2.17, 10.3.9

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/2519/steps/test_5/logs/stdio

wsrep.binlog_format                      w1 [ fail ]
        Test ended at 2016-12-02 19:03:52
 
CURRENT_TEST: wsrep.binlog_format
 
 
Could not execute 'check-testcase' before testcase 'wsrep.binlog_format' (res: 1):
mysqltest: Logging to '/dev/shm/var/1/tmp/check-mysqld_1.log'.
mysqltest: Results saved in '/dev/shm/var/1/tmp/check-mysqld_1.result'.
mysqltest: Connecting to server localhost:16060 (socket /dev/shm/var/tmp/1/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: At line 78: query 'call mtr.check_testcase()' failed: 1047: WSREP has not yet prepared node for application use
not ok
mysqltest failed but provided no output



 Comments   
Comment by Jan Lindström (Inactive) [ 2017-04-27 ]

wsrep.binlog_format                      w1 [ fail ]
        Test ended at 2017-04-26 21:56:44
 
CURRENT_TEST: wsrep.binlog_format
mysqltest: At line 12: query 'SET binlog_format=STATEMENT' failed: 1231: Variable 'binlog_format' can't be set to the value of 'STATEMENT'
 
The result from queries just before the failure was:
call mtr.add_suppression("WSREP: MariaDB Galera and flashback do not support binlog format.*");
call mtr.add_suppression("WSREP: Cannot get fake transaction ID from storage engine.");
#
# MDEV-4227: Galera server should stop crashing on setting binlog_format STATEMENT
#
SHOW VARIABLES LIKE 'binlog_format';
Variable_name	Value
binlog_format	ROW
SET binlog_format=STATEMENT;
 
 - saving '/dev/shm/var/1/log/wsrep.binlog_format/' to '/dev/shm/var/log/wsrep.binlog_format/'

Comment by Elena Stepanova [ 2017-09-22 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/4803

wsrep.binlog_format                      w1 [ fail ]
        Test ended at 2017-09-07 07:42:06
 
CURRENT_TEST: wsrep.binlog_format
 
 
Could not execute 'check-testcase' before testcase 'wsrep.binlog_format' (res: 1):
mysqltest: Logging to '/dev/shm/var/1/tmp/check-mysqld_1.log'.
mysqltest: Results saved in '/dev/shm/var/1/tmp/check-mysqld_1.result'.
mysqltest: Connecting to server localhost:16000 (socket /dev/shm/var/tmp/1/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: At line 81: query 'call mtr.check_testcase()' failed: 1047: WSREP has not yet prepared node for application use
not ok
mysqltest failed but provided no output
 
 
 - saving '/dev/shm/var/1/log/wsrep.binlog_format/' to '/dev/shm/var/log/wsrep.binlog_format/'

Comment by Jan Lindström (Inactive) [ 2018-07-19 ]

This issue is already fixed.

jan@jan-laptop-asus:~/mysql/10.1-galera/mysql-test$ ./mtr wsrep.binlog_format --repeat=20
Logging: ./mtr  wsrep.binlog_format --repeat=20
vardir: /home/jan/mysql/10.1-galera/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/jan/mysql/10.1-galera/mysql-test/var'...
Checking supported features...
MariaDB Version 10.1.35-MariaDB-debug
 - SSL connections supported
 - binaries are debug compiled
Sphinx 'indexer' binary not found, sphinx suite will be skipped
Collecting tests...
sh: 1: ctest: not found
Installing system database...
 
==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
wsrep.binlog_format                      [ pass ]     21
wsrep.binlog_format                      [ pass ]     20
wsrep.binlog_format                      [ pass ]     22
wsrep.binlog_format                      [ pass ]     20
wsrep.binlog_format                      [ pass ]     19
wsrep.binlog_format                      [ pass ]     23
wsrep.binlog_format                      [ pass ]     23
wsrep.binlog_format                      [ pass ]     22
wsrep.binlog_format                      [ pass ]     22
wsrep.binlog_format                      [ pass ]     21
wsrep.binlog_format                      [ pass ]     22
wsrep.binlog_format                      [ pass ]     26
wsrep.binlog_format                      [ pass ]     25
wsrep.binlog_format                      [ pass ]     26
wsrep.binlog_format                      [ pass ]     38
wsrep.binlog_format                      [ pass ]     32
wsrep.binlog_format                      [ pass ]     29
wsrep.binlog_format                      [ pass ]     39
wsrep.binlog_format                      [ pass ]     32
wsrep.binlog_format                      [ pass ]     32
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.514 of 11 seconds executing testcases
 
Completed: All 20 tests were successful.

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