Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.11, 10.4(EOL), 10.5(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
./mtr --mysqld=--debug=d,ib_log_checkpoint_avoid_hard rpl.rpl_semi_sync_shutdown_await_ack
|
rpl.rpl_semi_sync_shutdown_await_ack 'mix' [ fail ]
|
Test ended at 2022-11-17 14:51:03
|
|
|
CURRENT_TEST: rpl.rpl_semi_sync_shutdown_await_ack
|
--- /home/parallels/dev/build-10.11-828394/build1/mysql-test/suite/rpl/r/rpl_semi_sync_shutdown_await_ack.result 2022-11-17 09:51:19.000000000 -0500
|
+++ /home/parallels/dev/build-10.11-828394/build1/mysql-test/suite/rpl/r/rpl_semi_sync_shutdown_await_ack.reject 2022-11-17 14:51:03.211813166 -0500
|
@@ -110,18 +110,18 @@
|
#-- Re-synchronize slaves with master and disable semi-sync
|
#-- Stop slaves
|
connection server_2;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_slave_enabled= 0;
|
include/stop_slave.inc
|
connection server_3;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_slave_enabled= 0;
|
include/stop_slave.inc
|
#-- Bring the master back up
|
connection server_1_con2;
|
connection default;
|
connection server_1;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_master_enabled = 0;
|
show status like 'Rpl_semi_sync_master_status';
|
Variable_name Value
|
@@ -227,18 +227,18 @@
|
#-- Re-synchronize slaves with master and disable semi-sync
|
#-- Stop slaves
|
connection server_2;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_slave_enabled= 0;
|
include/stop_slave.inc
|
connection server_3;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_slave_enabled= 0;
|
include/stop_slave.inc
|
#-- Bring the master back up
|
connection server_1_con2;
|
connection default;
|
connection server_1;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_master_enabled = 0;
|
show status like 'Rpl_semi_sync_master_status';
|
Variable_name Value
|
@@ -345,18 +345,18 @@
|
#-- Re-synchronize slaves with master and disable semi-sync
|
#-- Stop slaves
|
connection server_2;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_slave_enabled= 0;
|
include/stop_slave.inc
|
connection server_3;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_slave_enabled= 0;
|
include/stop_slave.inc
|
#-- Bring the master back up
|
connection server_1_con2;
|
connection default;
|
connection server_1;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_master_enabled = 0;
|
show status like 'Rpl_semi_sync_master_status';
|
Variable_name Value
|
@@ -469,18 +469,18 @@
|
#-- Re-synchronize slaves with master and disable semi-sync
|
#-- Stop slaves
|
connection server_2;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_slave_enabled= 0;
|
include/stop_slave.inc
|
connection server_3;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_slave_enabled= 0;
|
include/stop_slave.inc
|
#-- Bring the master back up
|
connection server_1_con2;
|
connection default;
|
connection server_1;
|
-SET @@GLOBAL.debug_dbug= "";
|
+SET @@GLOBAL.debug_dbug= "d,ib_log_checkpoint_avoid_hard";
|
SET @@GLOBAL.rpl_semi_sync_master_enabled = 0;
|
show status like 'Rpl_semi_sync_master_status';
|
Variable_name Value
|
|
|
mysqltest: Result length mismatch
|
The problem appears to be the --eval SET @@GLOBAL.debug_dbug= "$sav_server_2_dbug" (et al) statement in rpl_semi_sync_shutdown_await_ack.inc, so there might be other tests with the same issue.
The test failure would appear to be resolved by not using the --eval, but the test might still be affected by MDEV-28543.