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

master server starts slave parallel threads

    Details

      Description

      When you run this command in a slave
      set global slave_parallel_threads=10;
      you get a rightful error

      ERROR 1198 (HY000): This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first

      However, if you run the same command in a master, the statement is accepted, and the thread started.

      master [localhost] {msandbox} ((none)) > select ID, DB, state, time_ms, memory_used from information_schema .PROCESSLIST where USER='system user';
      Empty set (0.01 sec)
       
      master [localhost] {msandbox} ((none)) > set global slave_parallel_threads=10;
      Query OK, 0 rows affected (0.00 sec)
       
      master [localhost] {msandbox} ((none)) > select ID, DB, state, time_ms, memory_used from information_schema .PROCESSLIST where USER='system user';
      +----+------+----------------------------------+----------+-------------+
      | ID | DB   | state                            | time_ms  | memory_used |
      +----+------+----------------------------------+----------+-------------+
      | 47 | NULL | Waiting for work from SQL thread | 2207.683 |       34704 |
      | 46 | NULL | Waiting for work from SQL thread | 2207.686 |       34704 |
      | 45 | NULL | Waiting for work from SQL thread | 2207.722 |       34704 |
      | 44 | NULL | Waiting for work from SQL thread | 2207.723 |       34704 |
      | 43 | NULL | Waiting for work from SQL thread | 2207.754 |       34704 |
      | 42 | NULL | Waiting for work from SQL thread | 2207.757 |       34704 |
      | 41 | NULL | Waiting for work from SQL thread | 2207.765 |       34704 |
      | 40 | NULL | Waiting for work from SQL thread | 2207.801 |       34704 |
      | 39 | NULL | Waiting for work from SQL thread | 2207.843 |       34704 |
      | 38 | NULL | Waiting for work from SQL thread | 2207.851 |       34704 |
      +----+------+----------------------------------+----------+-------------+
      10 rows in set (0.01 sec)

        Attachments

          Activity

            People

            • Assignee:
              knielsen Kristian Nielsen
              Reporter:
              datacharmer Giuseppe Maxia
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: