Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
-
None
-
RHEL 8.6
Description
After updating MariaDB 10.4 to 10.5 there are lots of retried transaction(few thousand per hour) and lags in replication, switching slave_parallel_mode from optimistic back to conservative as was default on MariaDB 10.4 helps.
I stop replication change every slave connection to "conservative" and start, also change server global variable slave_parallel_mode to "conservative" and add "slave_parallel_mode = conservative" to my.cnf but after server restart all conection are again in "optimistic" mode global variable is correctly set to "conservative".
MTR test case and cnf
--source include/not_embedded.inc
|
|
--connect (slave1,127.0.0.1,root,,,$SERVER_MYPORT_3)
|
--connect (master1,127.0.0.1,root,,,$SERVER_MYPORT_1)
|
--connect (master2,127.0.0.1,root,,,$SERVER_MYPORT_2)
|
|
--connection slave1
|
--replace_result $SERVER_MYPORT_1 MYPORT_1
|
eval CHANGE MASTER 'x1' TO master_port=$SERVER_MYPORT_1, master_host='127.0.0.1', master_user='root'; |
eval CHANGE MASTER '' TO master_port=$SERVER_MYPORT_2, master_host='127.0.0.1', master_user='root'; |
|
set default_master_connection = ''; |
--source include/start_slave.inc
|
--let $status_items= Parallel_Mode
|
# will show minimal
|
--source include/show_slave_status.inc
|
|
set default_master_connection = 'x1'; |
--source include/start_slave.inc
|
--let $status_items= Parallel_Mode
|
# should be minimal, but shows optimistic (>=10.5) or conservative (<10.5) |
--source include/show_slave_status.inc
|
|
--source include/reset_master_slave.inc
|
--disconnect slave1
|
|
--connection master1
|
--source include/reset_master_slave.inc
|
--disconnect master1
|
|
--connection master2
|
--source include/reset_master_slave.inc
|
--disconnect master2 |
!include my.cnf
|
|
[mysqld.3]
|
slave_parallel_mode=minimal
|