mariadb/mysql-test/suite/multi_source
Brandon Nesterenko 74c189c312 MDEV-35304: Fix multi_source.connects_tried
Test multi_source.connects tried would sporadically fail with a result
mismatch resembling the following diff:

@@ -29,6 +29,7 @@
 SELECT @time_begin, CURRENT_TIMESTAMP(1)
 WHERE TIMESTAMPDIFF(SECOND, @time_begin, CURRENT_TIMESTAMP(1)) < 1;
 @time_begin  CURRENT_TIMESTAMP(1)
+2025-04-28 17:10:08.3  2025-04-28 17:10:09.2
 CREATE TEMPORARY TABLE status_sleep AS SELECT 'named' Connection_name, Connects_Tried Connects_Tried;
 SET @@SESSION.default_master_connection= '';
 include/wait_for_slave_param.inc [Connects_Tried]

This happened due to the reference variable @time_begin being set
_after_ the slave was started. That is, @time_begin was used as the
anchor point at which the time should start ticking for when
Connects_Tried should be incremented; however, MTR may not actually
be able to set it for some time after the slave had started due to
OS scheduling or heavy server load. The failure can be reproduced by
adding a 0.1s sleep statement in-between the aformentioned statements.

The fix is to set @time_begin before starting the slave so it is at
least always valid to reference as the start of the test case.
2025-04-29 11:00:37 -06:00
..
change_master.result Failed change master could leave around old relay log files 2021-09-14 13:43:50 +03:00
change_master.test Failed change master could leave around old relay log files 2021-09-14 13:43:50 +03:00
connects_tried.result MDEV-35304: Fix multi_source.connects_tried 2025-04-29 11:00:37 -06:00
connects_tried.test MDEV-35304: Fix multi_source.connects_tried 2025-04-29 11:00:37 -06:00
disabled.def MDEV-20101 Assertion failure on select @@global.'m2'.replicate_ignore_table; 2019-08-05 16:03:33 +04:00
gtid.cnf MDEV-26: Global Transaction ID. 2013-02-27 18:38:42 +01:00
gtid.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
gtid.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
gtid_ignore_duplicates.cnf MDEV-8354: out-of-order error with --gtid-ignore-duplicates and row-based replication 2015-06-24 16:52:50 +02:00
gtid_ignore_duplicates.result Merge branch '11.2' into 11.4 2024-05-21 19:38:51 +02:00
gtid_ignore_duplicates.test Merge 10.11 into 11.4 2025-01-09 07:58:08 +02:00
gtid_slave_pos.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
gtid_slave_pos.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
info_logs-master.opt MDEV-5277 - Ensure that all MySQL 5.6 options are supported by the 2013-11-25 18:49:40 +04:00
info_logs.result MDEV-35304: Add Connects_Tried and Master_Retry_Count to SSS 2025-02-26 20:37:53 -07:00
info_logs.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
load_data.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
load_data.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
master_info_file.opt MDEV-36238 Functional Tests for --master-info-file and --show-slave-auth-info 2025-03-18 18:17:02 -06:00
master_info_file.result fix for post-test check of multi_source.master_info_file 2025-04-18 09:41:23 +02:00
master_info_file.test fix for post-test check of multi_source.master_info_file 2025-04-18 09:41:23 +02:00
mdev-8874.cnf MDEV-8874 Replication filters configured in my.cnf are ignored if slave reset and reconfigured 2019-06-27 09:54:20 +05:30
mdev-8874.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
mdev-8874.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
mdev-9544.cnf MDEV-9544 FLUSH [RELAY] LOGS does not rotate logs for a named slave 2017-06-05 13:11:10 +05:30
mdev-9544.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
mdev-9544.test Merge branch '11.3' into 11.4 2024-02-15 13:53:21 +01:00
multi_parallel.cnf Mdev-10664 Add statuses about optimistic parallel replication stalls 2018-04-19 16:04:23 +05:30
multi_parallel.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
multi_parallel.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
multi_parallel_loop.inc Mdev-10664 Add statuses about optimistic parallel replication stalls 2018-04-19 16:04:23 +05:30
multi_source_slave_alias_replica.result MDEV-35304: Add Connects_Tried and Master_Retry_Count to SSS 2025-02-26 20:37:53 -07:00
multi_source_slave_alias_replica.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
multisource.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
multisource.test Move mysql-test-run/extra/rpl_tests to suite/rpl/include 2018-03-29 13:59:44 +03:00
multisource_for_channel.result Revert "MDEV-7850: Extend GTID Binlog Events with Thread Id" 2024-02-05 05:56:53 -07:00
multisource_for_channel.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
my.cnf test.cnf files should !include default_my.cnf 2024-02-03 11:22:20 +01:00
relaylog_events.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
relaylog_events.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
replicate_rewrite_db_dynamic.cnf MDEV-15530: Variable replicate_rewrite_db cannot be found in "show global variables" 2022-10-21 14:49:05 -06:00
replicate_rewrite_db_dynamic.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
replicate_rewrite_db_dynamic.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
reset_slave.result MDEV-35304: Add Connects_Tried and Master_Retry_Count to SSS 2025-02-26 20:37:53 -07:00
reset_slave.test Revert "MDEV-7850: Extend GTID Binlog Events with Thread Id" 2024-02-05 05:56:53 -07:00
show_slave_auth_info.cnf MDEV-36238 Functional Tests for --master-info-file and --show-slave-auth-info 2025-03-18 18:17:02 -06:00
show_slave_auth_info.result Merge 10.11 into 11.4 2025-03-28 13:55:21 +02:00
show_slave_auth_info.test Merge 10.11 into 11.4 2025-03-28 13:55:21 +02:00
simple.result MDEV-35304: Add Connects_Tried and Master_Retry_Count to SSS 2025-02-26 20:37:53 -07:00
simple.test MDEV-21858: START/STOP ALL SLAVES does not return access errors 2024-12-05 12:08:12 +01:00
skip_counter.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
skip_counter.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
status_vars.result MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
status_vars.test MDEV-31857 enable --ssl-verify-server-cert by default in the internal client 2024-02-04 22:19:19 +01:00
syntax.result MDEV-35304: Add Connects_Tried and Master_Retry_Count to SSS 2025-02-26 20:37:53 -07:00
syntax.test MDEV-4865 Change related to --log option/variable was merged partially 2013-08-13 13:35:36 +02:00