Issues

Select view

Select search mode

 
50 of

Review replication testing

Done

Description

Like title says, ensure all replication tests exist and pass.

 See similar task TDB-65

Environment

None

Smart Checklist

Details

Assignee

Reporter

Labels

Components

Fix versions

Priority

Smart Checklist

Created June 23, 2017 at 7:01 PM
Updated December 27, 2018 at 1:42 PM
Resolved July 12, 2017 at 9:58 PM

Activity

Show:

George Lorch September 13, 2017 at 3:35 PM
Edited

George Lorch June 28, 2017 at 6:29 PM
Edited

New tests ported from extra/rpl:

  • rpl_auto_increment (stm_mixed, and row) - added .opt files to force rocksdb_unsafe_for_binlog=true for stm_mixed

  • rpl_commit_after_flush

  • rpl_crash_safe (stm_mixed, and row) - added .opt files to force transaction_isolation=READ-COMMITTED for missing GAP LOCK, and rocksdb_unsafe_for_binlog=true for stm_mixed

  • rpl_extra_col_master

  • rpl_extra_col_slave

  • rpl_insert_ignore (stm_mixed, and row) - added .opt files to force transaction_isolation=READ-COMMITTED for missing GAP LOCK and rocksdb_unsafe_for_binlog=true for stm_mixed

  • rpl_log (stm, row)

  • rpl_lower_case_table_names (stm_mixed, row)

  • rpl_mixed_ddl - added .opt files to force rocksdb_strict_collation_check=off

  • rpl_multi_update (stm_mixed, row) added .opt files to force transaction_level=READ-COMMITTED for missing GAP LOCK, rocksdb_unsafe_for_binlog=true for mixed

  • rpl_multi_update2 (mixed, row) added .opt files to force transaction_level=READ-COMMITTED for missing GAP LOCK, stm will not work with this ISO forced, rocksdb_unsafe_for_binlog=true for mixed

  • rpl_multi_update3 (mixed, row) added .opt files to force transaction_level=READ-COMMITTED for missing GAP LOCK, stm will not work with this ISO forced, rocksdb_unsafe_for_binlog=true for mixed

  • rpl_not_null

  • rpl_parallel_ddl

  • rpl_record_compare

  • rpl_row_basic - added .opt files to force rocksdb_strict_collation_check=off and transaction_isolation=READ-COMMITTED for missing GAP LOCK

  • rpl_row_blob

  • rpl_row_sp003

  • rpl_row_sp007

  • rpl_row_trig004

  • rpl_row_tabledefs

  • rpl_set_null (mixed, row) added .opt files to force rocksdb_unsafe_for_binlog=true for mixed

  • rpl_sv_relay_space (stm_mixed, and row) - added .opt files to force rocksdb_unsafe_for_binlog=true for stm_mixed

  • rpl_truncate (stm_mixed, and row) - added .opt files to force rocksdb_unsafe_for_binlog=true for stm_mixed

George Lorch June 28, 2017 at 5:34 PM
Edited

Tests not ported from extra/rpl_tests:

  • gtid_disconnect_drop_temporary_table - not multi-engine

  • rpl_autoinc_func_invokes_trigger - not multi-engine

  • rpl_auto_increment_insert_view - not multi-engine

  • rpl_auto_increment_invoke_trigger - not multi-engine

  • rpl_binlog_max_cache_size - not multi-engine

  • rpl_blackhole - not multi-engine

  • rpl_change_master - not multi-engine

  • rpl_charset - unneeded to test with additional engines

  • rpl_conflicts - not multi-engine

  • rpl_ddl - not multi-engine for system tables

  • rpl_deadlock - requires GAP LOCK functionality for test to create deadlock situation, altering transaction_isolation via .opt files level alters the behavior of the test and causes other failures.

  • rpl_delete_no_where - doesn't really test anything engine specific, just rpl/binlog event

  • rpl_drop_create_temp_table - not multi-engine

  • rpl_drop_temp - not multi-engine

  • rpl_EE_err - unneeded to test with additional engines

  • rpl_failed_optimize - unneeded to test with additional engines

  • rpl_filters - not multi-engine

  • rpl_flsh_tables - not multi-engine

  • rpl_foreign_key - requires FOREIGN KEY support (or at east no FOREIGN KEY error on creation). See . Unneeded to test with additional engines.

  • rpl_generate_mts_gap - not multi-engine

  • rpl_get_master_version_and_clock - not multi-engine

  • rpl_gtid_mts_relay_log_recovery - not multi-engine

  • rpl_gtids_restart_slave_io_lost_trx - not multi-engine

  • rpl_implicit_commit_binlog - unneeded to test with additional engines

  • rpl_innodb|tokudb - needs refactoring to engine agnostic template.

  • rpl_insert_id_pk - requires FOREIGN KEY support (or at east no FOREIGN KEY error on creation). See . A good test to have on multiple engines.

  • rpl_insert_id - requires FOREIGN KEY support (or at east no FOREIGN KEY error on creation). See . A good test to have on multiple engines.

  • rpl_loaddata - requires ability to create table with UNIQUE INDEX and no PRIMARY KEY. See . unneeded to test with additional engines.

  • rpl_loadfile - not multi-engine

  • rpl_max_relay_size - not multi-engine

  • rpl_mixed_dml - skipped, requires ROLLBACK TO SAVEPOINT support. See

  • rpl_mixing_engines - skipped, requires GAP LOCK and ROLLBACK TO SAVEPOINT support. See . Looks like a good test to have on multiple engines.

  • rpl_mts_crash_safe_slave - not multi-engine, but looks like it could be

  • rpl_mts_relay_log_recovery - not multi-engine

  • rpl_multi_query - not multi-engine

  • rpl_multi_source_generate_mts_gap - not multi-engine

  • rpl_parallel_load_innodb|tokudb - needs refactoring to engine agnostic template.

  • rpl_parallel_recovery_core - not multi-engine

  • rpl_partition - MyRocks test fails on ALTER TABLE ... EXCHANGE PARTITION, reported upstream https://github.com/facebook/mysql-5.6/issues/643. See 

  • rpl_relayrotate - doesn't really test anything engine specific.

  • rpl_reset_slave - not multi-engine

  • rpl_rewrt_db - not multi-engine

  • rpl_row_001 - unneeded to test with additional engines

  • rpl_row_empty_imgs - unneeded to test with additional engines

  • rpl_row_func003 - unneeded to test with additional engines

  • rpl_row_idempotency - not multi-engine

  • rpl_row_img_blobs - requires ability to create table with UNIQUE INDEX and no PRIMARY KEY. See . Probably a good test to have when supported.

  • rpl_row_img_diff_indexes - requires ability to create table with UNIQUE INDEX and no PRIMARY KEY. See . Probably a good test to have when supported.

  • rpl_row_img - requires ability to create table with UNIQUE INDEX and no PRIMARY KEY. See . Probably a good test to have when supported.

  • rpl_row_sp002 - skipped, requires FOREIGN KEY support (or at east no FOREIGN KEY error on creation). See 

  • rpl_row_sp006 - requires ability to create table with UNIQUE INDEX and no PRIMARY KEY. See .

  • rpl_row_UUID - unneeded to test with additional engines

  • rpl_semi_sync_after_sync - not multi-engine, unneeded to test with additional engines

  • rpl_semi_sync_deadlock - not multi-engine, unneeded to test with additional engines

  • rpl_split_statements - not multi-engine

  • rpl_sp - unneeded to test with additional engines

  • rpl_start_stop_slave - not multi-engine, unneeded to test with additional engines

  • rpl_stm_create_if_not_exists - not multi-engine

  • rpl_stm_EE_err2 - unneeded to test with additional engines

  • rpl_stop_middle_group - not multi-engine, unneeded to test with additional engines

  • rpl_stop_slave - not multi-engine, unneeded to test with additional engines

  • rpl_temporary - not multi-engine, unneeded to test with additional engines

  • rpl_tmp_table_and_DDL - not multi-engine, unneeded to test with additional engines

  • rpl_variables_stm - unneeded to test with additional engines

  • type_conversion - not multi-engine, unneeded to test with additional engines

Loading...