[MDEV-21807] galera.galera_slave_replay MTR failed: WSREP: Unknown parameter 'dbug' Created: 2020-02-24  Updated: 2020-05-05  Resolved: 2020-04-22

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.2.32, 10.3.23
Fix Version/s: 10.2.32, 10.3.23, 10.4.13, 10.5.3

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

kvm-rpm-centos74-amd64-debug



 Description   

galera.galera_slave_replay failed on bb: WSREP: Unknown parameter 'dbug'.

stdio.log:

10.2.32 4618c974e4b467624d38bb256c2993afb4ac93b1

galera.galera_slave_replay 'innodb'      w2 [ fail ]
        Test ended at 2020-02-23 10:17:39
 
CURRENT_TEST: galera.galera_slave_replay
mysqltest: In included file "./include/galera_set_sync_point.inc": 
included from /usr/share/mysql-test/suite/galera/t/galera_slave_replay.test at line 74:
At line 1: query 'SET GLOBAL wsrep_provider_options = 'dbug=d,$galera_sync_point'' failed: 1210: Incorrect arguments to SET
 
The result from queries just before the failure was:
< snip >
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(1)) engine=innodb;
INSERT INTO t1 VALUES (1, 'a');
INSERT INTO t1 VALUES (3, 'a');
set binlog_format=STATEMENT;
SET AUTOCOMMIT=ON;
START TRANSACTION;
SELECT * FROM t1  FOR UPDATE;
f1	f2
1	a
3	a
UPDATE t1 SET f2 = 'c' WHERE f1 > 1;
connection node_2a;
SET SESSION wsrep_sync_wait = 0;
connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
connection node_3;
SET SESSION wsrep_sync_wait = 0;
connection node_2a;
SET GLOBAL wsrep_provider_options = 'dbug=d,commit_monitor_enter_sync';
 
More results from queries before failure can be found in /dev/shm/var/2/log/galera_slave_replay.log
 
 - saving '/dev/shm/var/2/log/galera.galera_slave_replay-innodb/' to '/dev/shm/var/log/galera.galera_slave_replay-innodb/'
 
Retrying test galera.galera_slave_replay, attempt(2/3)...
 
worker[2] > Restart  - not started
worker[2] > Restart  - not started
worker[2] > Restart  - not started
***Warnings generated in error logs during shutdown after running tests: galera.galera_slave_replay
 
2020-02-23 10:17:39 140194025371392 [Warning] WSREP: Unknown parameter 'dbug'
2020-02-23 10:17:39 140194025371392 [ERROR] WSREP: Set options returned 7
 
File /usr/share/mysql-test/suite/galera/r/galera_sst_rsync2.result is read-only; trying to patch anyway
worker[2] > Restart  - using different config file
worker[2] > Restart  - using different config file
worker[2] > Restart  - using different config file
galera.galera_slave_replay 'innodb'      w2 [ retry-fail ]
        Test ended at 2020-02-23 10:17:47
 
CURRENT_TEST: galera.galera_slave_replay
mysqltest: In included file "./include/galera_set_sync_point.inc": 
included from /usr/share/mysql-test/suite/galera/t/galera_slave_replay.test at line 74:
At line 1: query 'SET GLOBAL wsrep_provider_options = 'dbug=d,$galera_sync_point'' failed: 1210: Incorrect arguments to SET
 
The result from queries just before the failure was:
< snip >
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(1)) engine=innodb;
INSERT INTO t1 VALUES (1, 'a');
INSERT INTO t1 VALUES (3, 'a');
set binlog_format=STATEMENT;
SET AUTOCOMMIT=ON;
START TRANSACTION;
SELECT * FROM t1  FOR UPDATE;
f1	f2
1	a
3	a
UPDATE t1 SET f2 = 'c' WHERE f1 > 1;
connection node_2a;
SET SESSION wsrep_sync_wait = 0;
connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
connection node_3;
SET SESSION wsrep_sync_wait = 0;
connection node_2a;
SET GLOBAL wsrep_provider_options = 'dbug=d,commit_monitor_enter_sync';
 
More results from queries before failure can be found in /dev/shm/var/2/log/galera_slave_replay.log
 
 - skipping '/dev/shm/var/2/log/galera.galera_slave_replay-innodb/'
 
Test galera.galera_slave_replay has failed 2 times, no more retries!
 
***Warnings generated in error logs during shutdown after running tests: galera.galera_slave_replay
 
2020-02-23 10:17:46 140083860535040 [Warning] WSREP: Unknown parameter 'dbug'
2020-02-23 10:17:46 140083860535040 [ERROR] WSREP: Set options returned 7
 
worker[2] > Restart [mysqld.1 - pid: 18985, winpid: 18985] - using different config file
worker[2] > Restart [mysqld.2 - pid: 19021, winpid: 19021] - using different config file



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-03-10 ]

It is failed also on 10.3 on bb.

stdio.log:

10.3.23 fd2dc9c3fdfb73fa450db9fecd72044bb0554040

galera.galera_slave_replay 'innodb'      w2 [ fail ]
        Test ended at 2020-03-10 01:35:56
 
CURRENT_TEST: galera.galera_slave_replay
mysqltest: In included file "./include/galera_set_sync_point.inc": 
included from /usr/share/mysql-test/suite/galera/t/galera_slave_replay.test at line 74:
At line 1: query 'SET GLOBAL wsrep_provider_options = 'dbug=d,$galera_sync_point'' failed: 1210: Incorrect arguments to SET
 
The result from queries just before the failure was:
< snip >
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(1)) engine=innodb;
INSERT INTO t1 VALUES (1, 'a');
INSERT INTO t1 VALUES (3, 'a');
set binlog_format=STATEMENT;
SET AUTOCOMMIT=ON;
START TRANSACTION;
SELECT * FROM t1  FOR UPDATE;
f1	f2
1	a
3	a
UPDATE t1 SET f2 = 'c' WHERE f1 > 1;
connection node_2a;
SET SESSION wsrep_sync_wait = 0;
connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
connection node_3;
SET SESSION wsrep_sync_wait = 0;
connection node_2a;
SET GLOBAL wsrep_provider_options = 'dbug=d,commit_monitor_enter_sync';
 
More results from queries before failure can be found in /dev/shm/var/2/log/galera_slave_replay.log
 
 - saving '/dev/shm/var/2/log/galera.galera_slave_replay-innodb/' to '/dev/shm/var/log/galera.galera_slave_replay-innodb/'
 
Retrying test galera.galera_slave_replay, attempt(2/3)...
 
worker[2] > Restart  - not started
worker[2] > Restart  - not started
worker[2] > Restart  - not started

Generated at Thu Feb 08 09:09:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.