Details
Description
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/'
|
Attachments
Issue Links
- duplicates
-
MDEV-4633 multi_source.simple test fails sporadically
-
- Closed
-
- relates to
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Closed
-
-
-
- Closed
-
Activity
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.
The previous comment revealed my ignorance about @@default_master_connection role in mariadb multi-source replication management. Please disregard.
on 10.3 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-x86/builds/8270/steps/mtr/logs/stdio
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:55CURRENT_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 Nomysqld-relay-bin-master1.000001mysqld-relay-bin-master1.000002mysqld-relay-bin-master1.indexreset 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 Noreset 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)...