[MDEV-12641] Slave_Parallel_Mode being reported wrong in SHOW ALL SLAVES STATUS Created: 2017-04-29  Updated: 2017-05-12  Resolved: 2017-05-12

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.1.22
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: robert andersson Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

debian jessie


 Description   

I have MariaDB master/slave replication running, I have enabled parallel replication.

I have set slave_parallel_mode = optimistic in my.cnf

show variables like 'slave_parallel_mode' shows that it's set to optimistic.

show all slaves status show the slave running Parallel_Mode = conservative..

It seems like mariadb is ignoring my setting or?

I have restarted a million times...

I have enabled GTID on the slave as well.. (have tried without it as well)

Any ideas why SHOW ALL SLAVES STATUS is showing Parallel_mode = conservative? Is it a bug? or did i miss something? I have checked the error logs for clues.. nothing.

 Comments   
Comment by robert andersson [ 2017-04-29 ]

Found problem/solution!

stop all slaves;
set global connection_name.slave_parallel_mode = 'optmistic';
start all slaves;
show all slaves status;

The key is connection_name before slave_parallel_mode. .. I guess that's required because I have named connections..

I see it now in the official documentation .. @@connection_name ... I missed that! Doh!

Delete this bug from jira please !

Generated at Thu Feb 08 07:59:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.