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

Parallel replication causes slave threads to not pick up new global config after restart

    XMLWordPrintable

Details

    Description

      This issue only occurs when parallel replication is enabled. It seems configuration changes are not picked up after restarting the slave.

      Reproduce:
      On slave:
      Configuration:

      sql_mode='STRICT_TRANS_TABLES'
      group_concat_max_len=1024

      On master:

      SET SESSION binlog_format=statement;
      drop table if exists testbreak; drop table if exists testdata;
      create table testbreak (big text not null) engine=MyISAM;
      create table testdata (part varchar(1024) not null) engine=MyISAM;
      insert into testdata VALUES (REPEAT('a', 1024));
      insert into testdata VALUES (REPEAT('a', 1024));
      insert into testdata VALUES (REPEAT('a', 1024));
      set session group_concat_max_len=4096;
      insert into testbreak SELECT group_concat(part) FROM testdata;

      On slave, witness:

      Last_SQL_Error: Error 'Row 2 was cut by GROUP_CONCAT()' on query. Default database: 'mariadb_test'. Query: 'insert into testbreak SELECT group_concat(part) FROM testdata'

      On slave, execute:

      STOP SLAVE;
      SET GLOBAL group_concat_max_len=4096;
      START SLAVE;

      On slave, witness:

      Last_SQL_Error: Error 'Row 2 was cut by GROUP_CONCAT()' on query. Default database: 'mariadb_test'. Query: 'insert into testbreak SELECT group_concat(part) FROM testdata'

      On slave, execute:

      STOP SLAVE;
      SET GLOBAL slave_parallel_threads=0;
      START SLAVE;

      Error goes away.

      Attachments

        Issue Links

          Activity

            People

              knielsen Kristian Nielsen
              michaeldg Michaël de groot
              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.