Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.5
-
install master/slave replication
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
Field | Original Value | New Value |
---|---|---|
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) |
When you run this command in a slave set global slave_parallel_threads=10; you get a rightful error {code:sql} ERROR 1198 (HY000): This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first {code} However, if you run the same command in a master, the statement is accepted, and the thread started. {code:sql} 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) {code} |
Fix Version/s | 10.0.7 [ 14100 ] | |
Assignee | Kristian Nielsen [ knielsen ] |
Resolution | Won't Fix [ 2 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Resolution | Won't Fix [ 2 ] | |
Status | Closed [ 6 ] | Reopened [ 4 ] |
Priority | Critical [ 2 ] | Minor [ 4 ] |
Fix Version/s | 10.0.8 [ 14200 ] | |
Fix Version/s | 10.0.7 [ 14100 ] |
Fix Version/s | 10.0.9 [ 14400 ] | |
Fix Version/s | 10.0.8 [ 14200 ] |
Fix Version/s | 10.0.10 [ 14500 ] | |
Fix Version/s | 10.0.9 [ 14400 ] |
Fix Version/s | 10.0.11 [ 15200 ] | |
Fix Version/s | 10.0.10 [ 14500 ] |
Fix Version/s | 10.0.12 [ 15201 ] | |
Fix Version/s | 10.0.11 [ 15200 ] |
Workflow | defaullt [ 29717 ] | MariaDB v2 [ 43620 ] |
Status | Reopened [ 4 ] | Stalled [ 10000 ] |
Fix Version/s | 10.0.13 [ 16000 ] | |
Fix Version/s | 10.0.12 [ 15201 ] |
Priority | Minor [ 4 ] | Major [ 3 ] |
Fix Version/s | 10.0 [ 16000 ] |
Fix Version/s | 10.0 [ 16000 ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Component/s | Replication [ 10100 ] | |
Fix Version/s | 10.0.18 [ 18702 ] | |
Fix Version/s | 10.0 [ 16000 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Workflow | MariaDB v2 [ 43620 ] | MariaDB v3 [ 66779 ] |
Workflow | MariaDB v3 [ 66779 ] | MariaDB v4 [ 147229 ] |
Is it wrong? There is no slave running on the master (I assume there is none, right?), so why would it throw ER_SLAVE_MUST_STOP?
And we can't forbid setting the option before configuring server as a slave, because then it will be impossible to put the value in the config file.
Maybe I misunderstand the nature of the problem, could you please elaborate on it?