[MDEV-30027] [Draft] rpl.rpl_semi_sync_shutdown_await_ack fails when --mysqld=--debug is set - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
Fix Version/s: 10.5.26, 10.6.19, 10.11.9, 11.1.6, 11.2.5, 11.4.3
Component/s: Replication, Tests
Labels:
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.

Attachments

Activity

Ascending order - Click to sort in descending order

Angelique Sklavounos (Inactive) created issue - 2022-11-17 19:59

Angelique Sklavounos (Inactive) made changes - 2022-11-17 20:05

Field	Original Value	New Value
Description	{noformat} ./mtr --mysqld=--debug=d,ib_log_checkpoint_avoid_hard rpl.rpl_semi_sync_shutdown_await_ack {noformat} {noformat} 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 {noformat}	{noformat} ./mtr --mysqld=--debug=d,ib_log_checkpoint_avoid_hard rpl.rpl_semi_sync_shutdown_await_ack {noformat} {noformat} 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 {noformat} 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.

Angelique Sklavounos (Inactive) made changes - 2022-11-17 20:06

Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.7 [ 24805 ]
Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]
Affects Version/s		10.11 [ 27614 ]

Angelique Sklavounos (Inactive) made changes - 2022-11-17 20:06

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]

Julien Fritsch made changes - 2023-03-03 17:29

Fix Version/s

10.7 [ 24805 ]

Julien Fritsch made changes - 2023-04-27 14:49

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2023-11-28 10:22

Fix Version/s

10.9 [ 26905 ]

Julien Fritsch made changes - 2023-11-28 10:31

Fix Version/s

10.10 [ 27530 ]

Andrei Elkin made changes - 2024-07-02 07:58

Assignee

Angelique Sklavounos [ JIRAUSER50741 ]

Brandon Nesterenko [ JIRAUSER48702 ]

Andrei Elkin added a comment - 2024-07-02 07:59

bnestere, I am sending it to you though hopefully it's gone by the recent refactoring.

Andrei Elkin added a comment - 2024-07-02 07:59 bnestere , I am sending it to you though hopefully it's gone by the recent refactoring.

Brandon Nesterenko added a comment - 2024-07-09 12:08

Fixed with commit for ~~MDEV-29369~~: 03d1346e7f5

Brandon Nesterenko added a comment - 2024-07-09 12:08 Fixed with commit for MDEV-29369 : 03d1346e7f5

Brandon Nesterenko made changes - 2024-07-09 12:08

Fix Version/s		10.5.26 [ 29832 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.11 [ 27614 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

JiraAutomate made changes - 2024-07-09 12:08

Fix Version/s		10.6.19 [ 29833 ]
Fix Version/s		10.11.9 [ 29834 ]
Fix Version/s		11.1.6 [ 29835 ]
Fix Version/s		11.2.5 [ 29836 ]
Fix Version/s		11.4.3 [ 29837 ]

People

Assignee:: Brandon Nesterenko

Reporter:: Angelique Sklavounos (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2022-11-17 19:59

Updated:: 2024-07-09 12:08

Resolved:: 2024-07-09 12:08

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration