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

galera.galera_slave_replay MTR failed: WSREP: Unknown parameter 'dbug'

Details

    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
      

      Attachments

        Activity

          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
          

          stepan.patryshev Stepan Patryshev (Inactive) added a comment - 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

          People

            jplindst Jan Lindström (Inactive)
            stepan.patryshev Stepan Patryshev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.