[MDEV-10690] multi_source.reset_slave failed in buildbot Created: 2016-08-27  Updated: 2020-12-25  Resolved: 2020-11-12

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Sujatha Sivakumar (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-4633 multi_source.simple test fails sporad... Closed
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled
relates to MDEV-10042 multi_source.info_logs sporadically f... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-amd64/builds/196/steps/test_5/logs/stdio

multi_source.reset_slave                 w1 [ fail ]
 
        Test ended at 2016-07-11 15:52:10
 
 
 
CURRENT_TEST: multi_source.reset_slave
 
--- /usr/share/mysql/mysql-test/suite/multi_source/reset_slave.result	2016-07-11 13:07:08.000000000 -0400
 
+++ /dev/shm/var/1/log/reset_slave.reject	2016-07-11 15:52:10.437753327 -0400
 
@@ -11,14 +11,14 @@
 
 stop slave 'master1';
 
 show slave 'master1' status;
 
 Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	Master_SSL_Verify_Server_Cert	Last_IO_Errno	Last_IO_Error	Last_SQL_Errno	Last_SQL_Error	Replicate_Ignore_Server_Ids	Master_Server_Id	Master_SSL_Crl	Master_SSL_Crlpath	Using_Gtid	Gtid_IO_Pos	Replicate_Do_Domain_Ids	Replicate_Ignore_Domain_Ids	Parallel_Mode
 
-	127.0.0.1	root	MYPORT_1	60	master-bin.000001	<read_master_log_pos>	mysqld-relay-bin-master1.000002	<relay_log_pos>	master-bin.000001	No	No							0		0	<read_master_log_pos>	<relay_log_space>	None		0	No						NULL	No	0		0			1			No				conservative
 
+	127.0.0.1	root	MYPORT_1	60	master-bin.000001	<read_master_log_pos>	mysqld-relay-bin-master1.000002	<relay_log_pos>	master-bin.000001	No	No							0		0	<read_master_log_pos>	1374	None		0	No						NULL	No	0		0			1			No				conservative
 
 mysqld-relay-bin-master1.000001
 
 mysqld-relay-bin-master1.000002
 
 mysqld-relay-bin-master1.index
 
 reset slave 'master1';
 
 show slave 'master1' status;
 
 Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	Master_SSL_Verify_Server_Cert	Last_IO_Errno	Last_IO_Error	Last_SQL_Errno	Last_SQL_Error	Replicate_Ignore_Server_Ids	Master_Server_Id	Master_SSL_Crl	Master_SSL_Crlpath	Using_Gtid	Gtid_IO_Pos	Replicate_Do_Domain_Ids	Replicate_Ignore_Domain_Ids	Parallel_Mode
 
-	127.0.0.1	root	MYPORT_1	60		4		<relay_log_pos>		No	No							0		0	0	<relay_log_space>	None		0	No						NULL	No	0		0			1			No				conservative
 
+	127.0.0.1	root	MYPORT_1	60		4		<relay_log_pos>		No	No							0		0	0	1374	None		0	No						NULL	No	0		0			1			No				conservative
 
 reset slave 'master1' all;
 
 show slave 'master1' status;
 
 ERROR HY000: There is no master connection 'master1'
 
 
 
mysqltest: Result length mismatch
 
 
 
 - saving '/dev/shm/var/1/log/multi_source.reset_slave/' to '/dev/shm/var/log/multi_source.reset_slave/'



 Comments   
Comment by Elena Stepanova [ 2018-01-27 ]

on 10.0:
http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-amd64/builds/9034/steps/test/logs/stdio

multi_source.reset_slave                 w4 [ fail ]
 
        Test ended at 2018-01-24 19:44:55
 
 
 
CURRENT_TEST: multi_source.reset_slave
 
--- /usr/local/mariadb-10.0.34-linux-x86_64/mysql-test/suite/multi_source/reset_slave.result	2018-01-24 18:27:36.000000000 +0200
 
+++ /usr/local/mariadb-10.0.34-linux-x86_64/mysql-test/suite/multi_source/reset_slave.reject	2018-01-24 19:44:55.668952894 +0200
 
@@ -11,14 +11,14 @@
 
 stop slave 'master1';
 
 show slave 'master1' status;
 
 Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	Master_SSL_Verify_Server_Cert	Last_IO_Errno	Last_IO_Error	Last_SQL_Errno	Last_SQL_Error	Replicate_Ignore_Server_Ids	Master_Server_Id	Master_SSL_Crl	Master_SSL_Crlpath	Using_Gtid	Gtid_IO_Pos
 
-	127.0.0.1	root	MYPORT_1	60	master-bin.000001	802	mysqld-relay-bin-master1.000002	1090	master-bin.000001	No	No							0		0	802	1396	None		0	No						NULL	No	0		0			1			No	
+	127.0.0.1	root	MYPORT_1	60	master-bin.000001	802	mysqld-relay-bin-master1.000002	1090	master-bin.000001	No	No							0		0	802	1371	None		0	No						NULL	No	0		0			1			No	
 mysqld-relay-bin-master1.000001
 
 mysqld-relay-bin-master1.000002
 
 mysqld-relay-bin-master1.index
 
 reset slave 'master1';
 
 show slave 'master1' status;
 
 Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	Master_SSL_Verify_Server_Cert	Last_IO_Errno	Last_IO_Error	Last_SQL_Errno	Last_SQL_Error	Replicate_Ignore_Server_Ids	Master_Server_Id	Master_SSL_Crl	Master_SSL_Crlpath	Using_Gtid	Gtid_IO_Pos
 
-	127.0.0.1	root	MYPORT_1	60		4		1090		No	No							0		0	0	1396	None		0	No						NULL	No	0		0			1			No	
+	127.0.0.1	root	MYPORT_1	60		4		1090		No	No							0		0	0	1371	None		0	No						NULL	No	0		0			1			No	
 reset slave 'master1' all;
 
 show slave 'master1' status;
 
 ERROR HY000: There is no master connection 'master1'
 
 
 
mysqltest: Result content mismatch
 
 
 
 - saving '/usr/local/mariadb-10.0.34-linux-x86_64/mysql-test/var/4/log/multi_source.reset_slave/' to '/usr/local/mariadb-10.0.34-linux-x86_64/mysql-test/var/log/multi_source.reset_slave/'
 
 
 
Retrying test multi_source.reset_slave, attempt(2/3)...

Comment by Andrei Elkin [ 2019-10-31 ]

The failure is still present and it is caused by invocation of asynchronous STOP SLAVE
https://github.com/MariaDB/server/blob/1bb857089fdcd3a08cb166cb6d75f3e1dbb76f27/mysql-test/suite/multi_source/reset_slave.test#L36
instead of a synchronized mtr macro.

Actually the whole multi-source suite does it this way and that should be refined along with
this test.

More specifically mtr/include/ 's
start_slave.inc
stop_slave.inc
and its callees down to wait_for_slave_param.inc should be aware of the source parameter and handle that. Specifically to the bottom-most wait_for_slave_param.inc it should built a sourced version of SHOW SLAVE /* source name if any at this place*/ STATUS.

Comment by Andrei Elkin [ 2019-12-11 ]

The previous comment revealed my ignorance about @@default_master_connection role in mariadb multi-source replication management. Please disregard.

Comment by Alice Sherepa [ 2020-10-08 ]

on 10.3 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-x86/builds/8270/steps/mtr/logs/stdio

Comment by Sujatha Sivakumar (Inactive) [ 2020-11-12 ]

Fix is implemented as part of MDEV-4633

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