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

    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

              • Assignee:
                knielsen Kristian Nielsen
                Reporter:
                michaeldg Michaël de groot
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: