WL#9249: Move GTID enabled tests to separate rpl_gtid suite and GTID disabled tests to rpl_nogtid
Affects: Server-8.0
—
Status: Complete
Today, by default, rpl suite is run with different rpl configurations: for ex- gtid_mode = on, gtid_mode = off Few rpl tests runs with GTIDs enabled and gets skipped when those tests are run with GTIDs disabled. Few rpl tests runs with GTIDs disabled and gets skipped when those tests are run with GTIDs enabled. To avoid unnecessary tests runs/skips, the purpose of this work-log is to minimize these skips by creating 2 new suites rpl_gtid, rpl_nogtid. User Documentation ================== This work is for the test suite. No user documentation needed.
FR1. All rpl tests that DO require GTID_MODE=ON SHALL be moved to a new suite rpl_gtid. FR2. All rpl tests that DO require GTID_MODE=OFF SHALL be moved to a new suite rpl_nogtid. FR3. suite rpl_gtid WILL be added in the MTR default suite(s) list. FR4: suite rpl_nogtid WILL be added in the MTR default suite(s) list. FR5. rpl_gtid & rpl_nogtid WILL be run with 2 new configuration files (.cnf) with GTID enabled and GTID disabled respectively. FR6. Additonal runs SHALL be made in the MTR collection files for rpl_gtid and rpl_nogtid suite.
rpl suite has tests which: a) do not require GTIDs, but can run with or without GTIDs; b) do not support GTIDs; c) require GTIDs; This WL would do the following: 1.) move all (c) tests to the rpl_gtid suite,that runs only with GTIDs enabled. 2.) move all (b) tests to the rpl_nogtid suite,that runs only with GTIDs disabled. 3.) Tests in rpl suite will continue to run with GTIDs because of (a) tests. After this WL implementation, we will have 3 suites - rpl, rpl_gtid, rpl_nogtid.
Below 65 tests in the rpl suite runs only with GTIDs enabled. Following tests will be moved to a new suite rpl_gtid. rpl_apply_binlog_with_anonymous_gtid_when_gtid_mode_on.test rpl_check_gtid.test rpl_current_user.test rpl_drop_temp_gtid.test rpl_empty_multi_update.test rpl_explicit_modify_gtid_table.test rpl_gtid_binary_log_as_relay_log.test rpl_gtid_delete_memory_table_after_start_server.test rpl_gtid_do_table_filter_insensitive.test rpl_gtid_do_table_filter_sensitive.test rpl_gtid_drop_table.test rpl_gtid_dump_error.test rpl_gtid_execution.test rpl_gtid_heartbeat_2slave.test rpl_gtid_ignore_table_filter_insensitive.test rpl_gtid_ignore_table_filter_sensitive.test rpl_gtid_loaddata_s.test rpl_gtid_mts_replicate_same_server_id.test rpl_gtid_mysqlbinlog_rotate.test rpl_gtid_parallel.test rpl_gtid_purged_fail_to_connect.test rpl_gtid_purged_maintained.test rpl_gtid_replay_relaylog.test rpl_gtid_retrieve_last_trx.test rpl_gtid_row_event_max_size.test rpl_gtid_server_sighup.test rpl_gtid_spanned_trx.test rpl_gtid_split_statements.test rpl_gtid_sql_until_before_after.test rpl_gtids_table_disable_binlog_on_slave.test rpl_gtids_table_disable_log_slave_updates.test rpl_gtids_table.test rpl_gtid_stress_failover.test rpl_gtid_table_repository_split_trx.test rpl_gtid_temp_table.test rpl_gtid_transaction_split_across_relay_logs.test rpl_gtid_validate_slave_gtids.test rpl_low_slave_net_time_out.test rpl_master_errors.test rpl_master_pos_wait_after_startup.test rpl_mts_execute_partial_trx_with_auto_pos_off.test rpl_mts_execute_partial_trx_with_auto_pos_on_binlogless_slave.test rpl_mts_execute_partial_trx_with_auto_pos_on.test rpl_mts_logical_clock_wrong_start_pos.test rpl_mts_until.test rpl_mysqlbinlog_gtid_on.test rpl_partial_gtid_trx_followed_by_anonymous_trx_by_receiver.test rpl_partial_gtid_trx_followed_by_trx_at_startup.test rpl_perfschema_applier_status_by_worker_last_seen_transaction.test rpl_replication_observers_example_plugin_channels_receiver_thread.test rpl_replication_observers_example_plugin_channels.test rpl_replication_observers_example_plugin_server_requirements.test rpl_reset_slave_all_thread_safe.test rpl_rotate_gtid.test rpl_sbm_previous_gtid_event.test rpl_simulate_create_chunk_failure.test rpl_stm_until_pos_middle_gtid.test rpl_sync_relay_log_info.test rpl_tablespace.test rpl_transaction_before_commit_failure.test rpl_transaction_ctx_service.test rpl_trx_boundary_parser_row.test rpl_trx_boundary_parser_stmt.test rpl_wait_for_executed_gtid_set.test rpl_wait_for_gtid_executed_unknown_uuid.test Below 126 tests in the rpl suite runs only with GTIDs disabled. Following tests will be moved to a new suite rpl_nogtid. default_row_format_02.test rpl_000010.test rpl_alter_repository.test rpl_apply_binlog_with_gtid_when_gtid_mode_off.test rpl_auto_increment_bug33029.test rpl_begin_commit_rollback.test rpl_binlog_corruption.test rpl_binlog_gcommit_options.test rpl_binlog_index.test rpl_binlog_invalid_event.test rpl_binlog_json.test rpl_bug31076.test rpl_change_master_crash_safe.test rpl_change_master_relay_log_purge.test rpl_change_master.test rpl_checksum.test rpl_circular_for_4_hosts.test rpl_concurrency_error.test rpl_create_if_not_exists.test rpl_create_tmp_table_if_not_exists.test rpl_cross_version.test rpl_deadlock_innodb.test rpl_do_db_filter.test rpl_do_grant.test rpl_do_table_filter_insensitive.test rpl_do_table_filter_sensitive.test rpl_drop_temp.test rpl_extra_col_master_innodb.test rpl_extra_col_master_myisam.test rpl_extra_col_slave_innodb.test rpl_extra_col_slave_myisam.test rpl_failed_optimize.test rpl_filter_dbs_dynamic.test rpl_filter_tables_dynamic.test rpl_filter_tables_not_exist.test rpl_grant.test rpl_gtid_create_select.test rpl_gtid_mode.test rpl_gtid_not_yet_determined.test rpl_heartbeat_2slaves.test rpl_heartbeat_ssl.test rpl_ignore_db_filter.test rpl_ignore_table_filter_insensitive.test rpl_ignore_table_filter_sensitive.test rpl_ignore_table.test rpl_incident.test rpl_invoked_features.test rpl_loaddata_fatal.test rpl_loaddatalocal.test rpl_loaddata_s.test rpl_loaddata.test rpl_log_pos.test rpl_manual_change_index_file.test rpl_misc_functions.test rpl_mixed_binlog_max_cache_size.test rpl_mixed_ddl_dml.test rpl_mixed_drop_create_temp_table.test rpl_mixed_implicit_commit_binlog.test rpl_mixed_mixing_engines.test rpl_mts_debug.test rpl_mts_submode_switch.test rpl_multi_source_slave_skip_counter.test rpl_multi_update2.test rpl_multi_update4.test rpl_mysqlbinlog_relay_start_position.test rpl_no_gtid_delete_memory_table_after_start_server.test rpl_no_gtid_split_statements.test rpl_non_direct_mixed_mixing_engines.test rpl_non_direct_row_mixing_engines.test rpl_non_direct_stm_mixing_engines.test rpl_parallel_change_master.test rpl_parallel_load_data.test rpl_parallel_start_stop.test rpl_parallel_switch_sequential.test rpl_perfschema_applier_status_by_worker.test rpl_read_old_relay_log_info.test rpl_read_only.test rpl_relay_log_recovery_positions.test rpl_replicate_do.test rpl_replicate_ignore_db.test rpl_rotate_logs.test rpl_rotate_row_trans.test rpl_row_binlog_max_cache_size.test rpl_row_corruption.test rpl_row_create_select.test rpl_row_drop_create_temp_table.test rpl_row_event_max_size.test rpl_row_hash_scan.test rpl_row_ignorable_event.test rpl_row_img_eng_full.test rpl_row_implicit_commit_binlog.test rpl_row_lcase_tblnames.test rpl_row_mixing_engines.test rpl_row_mts_crash_safe.test rpl_row_mysqlbinlog.test rpl_row_tabledefs_2myisam.test rpl_row_tabledefs_3innodb.test rpl_row_until.test rpl_semi_sync.test rpl_server_uuid.test rpl_set_gtid_mode_on_after_implicit_pre_commit.test rpl_set_gtid_mode_ongoing_wait_function.test rpl_slave_server_id_equal_to_zero.test rpl_slave_skip.test rpl_sp_effects.test rpl_sporadic_master.test rpl_sql_thread_killed_waiting_commit_lock.test rpl_stm_000001.test rpl_stm_binlog_max_cache_size.test rpl_stm_drop_create_temp_table.test rpl_stm_implicit_commit_binlog.test rpl_stm_innodb.test rpl_stm_lcase_tblnames.test rpl_stm_loaddata_concurrent.test rpl_stm_mixed_mts_crash_safe.test rpl_stm_mixing_engines.test rpl_stm_start_stop_slave.test rpl_stm_stop_middle_group.test rpl_stop_slave.test rpl_switch_stm_row_mixed.test rpl_temporary.test rpl_temp_table_mix_row.test rpl_trigger.test rpl_typeconv.test rpl_xa_survive_disconnect_mixed_engines.test transactional_ddl_locking.test
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.