From d925aec1c10cebf6c34825a7de50afe4e630aff4 Mon Sep 17 00:00:00 2001 From: Elena Stepanova Date: Thu, 31 Oct 2019 18:07:19 +0200 Subject: List of unstable tests for 10.1.42 release --- mysql-test/unstable-tests | 204 ++++++++++++++++++---------------------------- 1 file changed, 81 insertions(+), 123 deletions(-) (limited to 'mysql-test') diff --git a/mysql-test/unstable-tests b/mysql-test/unstable-tests index f09647523af..c7b40236127 100644 --- a/mysql-test/unstable-tests +++ b/mysql-test/unstable-tests @@ -23,10 +23,9 @@ # ############################################################################## # -# Based on 10.1 2382cd14a8c96cf8b4375d7338abfa6e1b333a86 +# Based on 10.1 1bb857089fdcd3a08cb166cb6d75f3e1dbb76f27 main.alter_table_trans : MDEV-12084 - timeout -main.analyze_stmt : Modified in 10.1.39 main.analyze_stmt_slow_query_log : MDEV-12237 - Wrong result main.auth_named_pipe : MDEV-14724 - System error 2 main.bootstrap : Modified in 10.1.41 @@ -34,139 +33,100 @@ main.connect_debug : Modified in 10.1.41 main.count_distinct2 : MDEV-11768 - timeout main.create_delayed : MDEV-10605 - failed with timeout main.create_drop_event : MDEV-16271 - Wrong result -main.create_drop_role : Modified in 10.1.39 -main.ctype_big5 : Include file modified in 10.1.39 -main.ctype_euckr : Include file modified in 10.1.39 -main.ctype_gb2312 : Include file modified in 10.1.39 -main.ctype_gbk : Include file modified in 10.1.39 -main.ctype_latin1 : Include file modified in 10.1.39 -main.ctype_sjis : Include file modified in 10.1.39 -main.ctype_tis620 : Include file modified in 10.1.39 -main.ctype_uca : Include file modified in 10.1.39 -main.ctype_ucs : Include file modified in 10.1.39 -main.ctype_ujis : Include file modified in 10.1.39 -main.ctype_utf16 : MDEV-10675: timeout or extra warnings; include file modified in 10.1.39 -main.ctype_utf16_uca : Include file modified in 10.1.39 -main.ctype_utf16le : Include file modified in 10.1.39 -main.ctype_utf32 : Include file modified in 10.1.39 -main.ctype_utf32_uca : Include file modified in 10.1.39 -main.ctype_utf8 : Include file modified in 10.1.39 +main.ctype_utf16 : MDEV-10675: timeout or extra warnings main.ctype_utf8_def_upgrade : Added in 10.1.41 -main.ctype_utf8mb4 : Include file modified in 10.1.39 -main.ctype_utf8mb4_heap : Include file modified in 10.1.39 -main.ctype_utf8mb4_innodb : Include file modified in 10.1.39 -main.ctype_utf8mb4_myisam : Include file modified in 10.1.39 -main.ddl_i18n_koi8r : Modified in 10.1.39 -main.ddl_i18n_utf8 : Modified in 10.1.39 main.debug_sync : MDEV-10607 - internal error main.derived : Modified in 10.1.41 main.derived_opt : MDEV-11768 - timeout main.derived_view : Modified in 10.1.41 main.dirty_close : MDEV-19368 - mysqltest failed but provided no output -main.events_1 : Modified in 10.1.39 +main.drop_bad_db_type : Modified in 10.1.42 +main.drop_debug : Modified in 10.1.42 main.events_2 : MDEV-13277 - Server crash main.events_bugs : MDEV-12892 - Crash in fill_schema_processlist main.events_restart : MDEV-12236 - Server shutdown problem main.events_slowlog : MDEV-12821 - Wrong result main.flush : MDEV-19368 - mysqltest failed but provided no output -main.func_gconcat : Modified in 10.1.39 -main.func_hybrid_type : Modified in 10.1.39 -main.func_math : Modified in 10.1.39 -main.func_str : Modified in 10.1.39 -main.func_time : Modified in 10.1.39 -main.gis : MDEV-13411 - wrong result on P8; modified in 10.1.39 -main.gis-precise : Modified in 10.1.39 -main.gis_notembedded : Added in 10.1.39 -main.grant4 : Modified in 10.1.39 +main.func_math : Modified in 10.1.42 +main.gis : MDEV-13411 - wrong result on P8 main.host_cache_size_functionality : MDEV-10606 - sporadic failure on shutdown main.index_intersect_innodb : MDEV-10643 - failed with timeout -main.index_merge_innodb : MDEV-7142 - Wrong execution plan, timeout with valgrind; modified in 10.1.39 -main.index_merge_myisam : Include files modified in 10.1.39 +main.index_merge_innodb : MDEV-7142 - Wrong execution plan, timeout with valgrind; modified in 10.1.42 +main.index_merge_myisam : Modified in 10.1.42 main.information_schema_parameters : Modified in 10.1.41 -main.information_schema_prepare : Added in 10.1.39 main.innodb_mysql_lock : MDEV-7861 - sporadic lock detection failure -main.join : Modified in 10.1.41 +main.join : Modified in 10.1.42 main.join_cache : Modified in 10.1.41 main.join_nested : Modified in 10.1.41 main.join_outer : Modified in 10.1.41 main.join_outer_innodb : Modified in 10.1.41 -main.kill_processlist-6619 : MDEV-10793 - wrong result in processlist; modified in 10.1.39 -main.loaddata : MDEV-19368 - mysqltest failed but provided no output; modified in 10.1.39 -main.log_slow : MDEV-13263 - Wrong result; modified in 10.1.39 -main.log_slow_debug : Added in 10.1.39 +main.kill_processlist-6619 : MDEV-10793 - wrong result in processlist +main.loaddata : MDEV-19368 - mysqltest failed but provided no output +main.locale : MDEV-20521 - Wrong result (missing warning) +main.log_slow : MDEV-13263 - Wrong result +main.log_slow_debug : Modified in 10.1.42 main.log_tables-big : MDEV-13408 - wrong result main.mdev-504 : MDEV-10607 - sporadic "can't connect" main.mdev375 : MDEV-10607 - sporadic "can't connect" -main.mdev_19276 : Added in 10.1.39 main.merge : MDEV-10607 - sporadic "can't connect" main.multi_update : Modified in 10.1.41 -main.multi_update_big : Added in 10.1.39 main.multi_update_debug : MDEV-20136 - Debug sync point wait timed out; added in 10.1.41 main.multi_update_innodb : Modified in 10.1.41 -main.mysql : Modified in 10.1.39 +main.myisam : Modified in 10.1.42 main.mysql_client_test : MDEV-19369 - error: 5888, status: 23, errno: 2 main.mysql_client_test_comp : MDEV-19369 - error: 5888, status: 23, errno: 2 main.mysql_client_test_nonblock : MDEV-15096 - exec failed main.mysql_upgrade_noengine : MDEV-14355 - Plugin is busy main.mysqld--help : Modified in 10.1.41 main.mysqldump : Modified in 10.1.41 -main.mysqldump-compat : Modified in 10.1.39 main.mysqlhotcopy_myisam : MDEV-10995 - test hangs on debug build main.mysqlslap : MDEV-11801 - timeout main.mysqltest : MDEV-9269 - fails on Alpha -main.olap : Modified in 10.1.39 main.old-mode : MDEV-19373 - Wrong result +main.order_by_innodb : Modified in 10.1.42 main.order_by_optimizer_innodb : MDEV-10683 - wrong execution plan -main.partition : Modified in 10.1.39 -main.partition_debug_sync : MDEV-15669 - Deadlock found when trying to get lock -main.partition_innodb : Modified in 10.1.39 +main.partition_debug_sync : MDEV-15669 - Deadlock found when trying to get lock; modified in 10.1.42 main.partition_innodb_plugin : MDEV-12901 - Valgrind warnings main.plugin : Modified in 10.1.41 main.plugin_not_embedded : Modified in 10.1.41 +main.processlist : Modified in 10.1.42 +main.processlist_notembedded : Added in 10.1.42 main.ps : MDEV-11017 - sporadic wrong Prepared_stmt_count; modified in 10.1.41 main.ps_innodb : Added in 10.1.41 main.query_cache : MDEV-12895 - Wrong result main.query_cache_debug : MDEV-15281 - Resize or similar command in progress main.range_vs_index_merge_innodb : MDEV-15283 - Server has gone away main.repair_symlink-5543 : Modified in 10.1.41 +main.selectivity : Modified in 10.1.42 main.set_statement : MDEV-13183 - Wrong result main.show_explain : MDEV-10674 - sporadic failure -main.sp : Modified in 10.1.41 +main.sp : Modified in 10.1.42 +main.sp-code : Modified in 10.1.42 main.sp-security : MDEV-10607 - sporadic "can't connect" -main.sp-ucs2 : Modified in 10.1.39 -main.sp_notembedded : MDEV-10607 - internal error; modified in 10.1.39 -main.sp_trans : Modified in 10.1.39 -main.ssl_verify_ip : Added in 10.1.39 +main.sp_notembedded : MDEV-10607 - internal error main.stat_tables : Modified in 10.1.41 main.stat_tables_par_innodb : MDEV-14155 - wrong rounding -main.statistics : Modified in 10.1.39 main.status : MDEV-8510 - sporadic wrong result -main.status2 : Modified in 10.1.39 main.subselect : Modified in 10.1.41 main.subselect_innodb : MDEV-10614 - sporadic wrong results -main.subselect_sj : Modified in 10.1.41 +main.subselect_sj : Modified in 10.1.42 main.subselect_sj_mat : Modified in 10.1.41 +main.sum_distinct-big : Modified in 10.1.42 main.tc_heuristic_recover : MDEV-15200 - wrong error on mysqld_stub_cmd -main.timezone2 : Modified in 10.1.39 main.trigger_null-8605 : Modified in 10.1.41 -main.type_bit : Modified in 10.1.39 main.type_blob : MDEV-15195 - Wrong result -main.type_date : Modified in 10.1.39 -main.type_datetime : Modified in 10.1.41 +main.type_date : Modified in 10.1.42 +main.type_datetime : Modified in 10.1.42 main.type_datetime_hires : MDEV-10687 - timeout -main.type_decimal : Modified in 10.1.39 -main.type_year : Modified in 10.1.39 -main.update_innodb : Modified in 10.1.39 -main.userstat : Modified in 10.1.39 +main.type_int : Modified in 10.1.42 +main.type_newdecimal : Modified in 10.1.42 main.view : Modified in 10.1.41 -main.view_grant : Modified in 10.1.39 main.wait_timeout : Lost connection to MySQL server during query main.xa : MDEV-11769 - lock wait timeout #----------------------------------------------------------------------- archive.archive_bitfield : MDEV-11771 - Extra warning -archive.archive_eits : Added in 10.1.39 archive.archive_symlink : MDEV-12170 - unexpected error on rmdir archive.discover : MDEV-10510 - Table is marked as crashed archive.mysqlhotcopy_archive : MDEV-14726 - Table is marked as crashed @@ -178,27 +138,26 @@ archive-test_sql_discovery.discover : MDEV-16817 - Table marked as crashed #----------------------------------------------------------------------- binlog.binlog_commit_wait : MDEV-10150 - Error: too much time elapsed -binlog.binlog_innodb_stm : Added in 10.1.39 binlog.binlog_killed : MDEV-12925 - Wrong result -binlog.binlog_mysqlbinlog2 : Modified in 10.1.39 binlog.binlog_mysqlbinlog_stop_never : Added in 10.1.41 binlog.binlog_parallel_replication_marks_row : Include file modified in 10.1.41 binlog.binlog_parallel_replication_marks_stm_mix : Include file modified in 10.1.41 -binlog.binlog_row_drop_tmp_tbl : Include file modified in 10.1.41 -binlog.binlog_stm_drop_tmp_tbl : MDEV-20188 - Unknown table on exec; include file modified in 10.1.41 +binlog.binlog_row_drop_tmp_tbl : Include file modified in 10.1.42 +binlog.binlog_stm_drop_tmp_tbl : Include file modified in 10.1.42 binlog.binlog_xa_recover : MDEV-8517 - Extra checkpoint binlog.load_data_stm_view : MDEV-16948 - Wrong result #----------------------------------------------------------------------- -binlog_encryption.binlog_xa_recover : MDEV-12908 - Extra checkpoint -binlog_encryption.encrypted_master : MDEV-12906 - Failed to sync -binlog_encryption.rpl_parallel : MDEV-10653 - Timeout -binlog_encryption.rpl_relayrotate : MDEV-15194 - Timeout -binlog_encryption.rpl_semi_sync : MDEV-11220 - Wrong result, MDEV-11673 - Valgrind warning -binlog_encryption.rpl_ssl : MDEV-14507 - Timeout on SLES 11.4 -binlog_encryption.rpl_stm_relay_ign_space : MDEV-19375 - Test assertion failed in assertion.inc -binlog_encryption.rpl_typeconv : MDEV-14362 - Lost connection to MySQL server during query +binlog_encryption.binlog_xa_recover : MDEV-12908 - Extra checkpoint +binlog_encryption.encrypted_master : MDEV-12906 - Failed to sync +binlog_encryption.rpl_parallel : MDEV-10653 - Timeout +binlog_encryption.rpl_parallel_ignored_errors : Added in 10.1.42 +binlog_encryption.rpl_relayrotate : MDEV-15194 - Timeout +binlog_encryption.rpl_semi_sync : MDEV-11220 - Wrong result, MDEV-11673 - Valgrind warning +binlog_encryption.rpl_ssl : MDEV-14507 - Timeout on SLES 11.4 +binlog_encryption.rpl_stm_relay_ign_space : MDEV-19375 - Test assertion failed in assertion.inc +binlog_encryption.rpl_typeconv : MDEV-14362 - Lost connection to MySQL server during query #----------------------------------------------------------------------- @@ -216,7 +175,6 @@ encryption.debug_key_management : MDEV-13841 - Timeout on wait con encryption.encrypt_and_grep : MDEV-13765 - Wrong result encryption.innodb-bad-key-change2 : MDEV-19118 - Can't connect through socket encryption.innodb-compressed-blob : MDEV-14728 - Unable to get certificate -encryption.innodb-encryption-alter : Modified in 10.1.39 encryption.innodb-first-page-read : MDEV-14356 - Timeout on wait condition encryption.innodb-page_encryption : MDEV-10641 - mutex problem encryption.innodb-read-only : MDEV-14728 - Unable to get certificate; MDEV-16563 - Crash on startup @@ -224,6 +182,7 @@ encryption.innodb-redo-badkey : MDEV-12898 - Server hang on star encryption.innodb-remove-encryption : MDEV-16493 - Timeout in wait condition encryption.innodb_encryption-page-compression : MDEV-12630 - crash or assertion failure encryption.innodb_encryption_discard_import : MDEV-16116 - Wrong result +encryption.innodb_encryption_is : MDEV-12898 - Server hang on startup encryption.innodb_encryption_row_compressed : MDEV-16113 - Crash encryption.innodb_first_page : MDEV-10689 - Crash encryption.innodb_scrub : MDEV-8139 - scrubbing tests need fixing @@ -253,11 +212,9 @@ federated.federatedx : MDEV-10617 - Wrong checksum, timeouts #----------------------------------------------------------------------- -funcs_1.memory_views : MDEV-11773 - timeout -funcs_1.processlist_priv_no_prot : Include file modified in 10.1.39 -funcs_1.processlist_priv_ps : Include file modified in 10.1.39 -funcs_1.processlist_val_no_prot : MDEV-11223 - Wrong result; include file modified in 10.1.39 -funcs_1.processlist_val_ps : MDEV-12175 - Wrong plan; include file modified in 10.1.39 +funcs_1.memory_views : MDEV-11773 - timeout +funcs_1.processlist_val_no_prot : MDEV-11223 - Wrong result +funcs_1.processlist_val_ps : MDEV-12175 - Wrong plan #----------------------------------------------------------------------- @@ -278,29 +235,23 @@ galera_3nodes.* : The suite has not been stabilized yet #----------------------------------------------------------------------- -innodb.alter_crash : Added in 10.1.39 innodb.binlog_consistent : MDEV-10618 - Server fails to start innodb.check_ibd_filesize : Added in 10.1.41 innodb.create_select : Added in 10.1.41 innodb.doublewrite : MDEV-12905 - Lost connection to MySQL server innodb.foreign-keys : Modified in 10.1.41 -innodb.foreign_key : Modified in 10.1.39 innodb.group_commit_crash : MDEV-11770 - Checksum mismatch innodb.group_commit_crash_no_optimize_thread : MDEV-11770 - Checksum mismatch innodb.innodb-64k-crash : MDEV-13872 - Failure and crash on startup innodb.innodb-alter-debug : MDEV-13182 - InnoDB: adjusting FSP_SPACE_FLAGS -innodb.innodb-alter-nullable : Modified in 10.1.39 innodb.innodb-alter-table : MDEV-10619 - Testcase timeout -innodb.innodb-autoinc : Modified in 10.1.41 +innodb.innodb-autoinc : Modified in 10.1.42 innodb.innodb-blob : MDEV-12053 - Client crash -innodb.innodb-corrupted-table : Modified in 10.1.39 innodb.innodb-fk : MDEV-13832 - Assertion failure on shutdown -innodb.innodb-index : Modified in 10.1.39 innodb.innodb-page_compression_default : MDEV-14121 - Assertion failure innodb.innodb-page_compression_lzma : MDEV-14353 - Wrong result on Fedora 25 innodb.innodb-page_compression_zip : MDEV-10641 - Mutex problem innodb.innodb-system-table-view : Added in 10.1.41 -innodb.innodb-truncate : Modified in 10.1.39 innodb.innodb-wl5980-debug : Added in 10.1.41 innodb.innodb_bug14147491 : MDEV-11808 - Wrong error codes innodb.innodb_bug30423 : MDEV-7311 - Wrong number of rows in the plan @@ -314,15 +265,18 @@ innodb.innodb_zip_innochecksum2 : MDEV-13882 - Warning: difficult t innodb.log_file_size : MDEV-15668 - Not found pattern innodb.recovery_shutdown : MDEV-15671 - Warning: database page corruption innodb.row_format_redundant : MDEV-15192 - Trying to access missing tablespace +innodb.stat_tables : Added in 10.1.42 innodb.table_definition_cache_debug : MDEV-14206 - Extra warning innodb.table_flags : MDEV-19374 - Server failed to restart -innodb.trx_id_future : MDEV-20138 - Table doesn't exist in engine; added in 10.1.41 -innodb.xa_debug : Added in 10.1.39 +innodb.trx_id_future : Modified in 10.1.42 innodb.xa_recovery : MDEV-15279 - mysqld got exception #----------------------------------------------------------------------- +innodb_fts.concurrent_insert : Modified in 10.1.42 +innodb_fts.crash_recovery : Modified in 10.1.42 innodb_fts.innodb_ft_aux_table : Added in 10.1.41 +innodb_fts.innodb_fts_misc : Modified in 10.1.42 innodb_fts.innodb_fts_misc_debug : MDEV-14156 - Unexpected warning #----------------------------------------------------------------------- @@ -333,12 +287,10 @@ maria.maria : MDEV-14430 - Wrong result #----------------------------------------------------------------------- -mariabackup.absolute_ibdata_paths : Modified in 10.1.39 mariabackup.apply-log-only : MDEV-20135 - Timeout mariabackup.huge_lsn : MDEV-17286 - SSL error mariabackup.incremental_encrypted : MDEV-15667 - Timeout mariabackup.mdev-14447 : MDEV-15201 - Timeout -mariabackup.page_compression_level : Added in 10.1.39 mariabackup.xb_compressed_encrypted : MDEV-14812 - Segfault mariabackup.xb_partition : MDEV-17584 - Crash on shutdown @@ -372,9 +324,12 @@ multi_source.status_vars : MDEV-4632 - failed while waiting for Slave_received_h parts.partition_alter2_2_maria : MDEV-14364 - Lost connection to MySQL server during query parts.partition_auto_increment_archive : MDEV-16491 - Table marked as crashed parts.partition_auto_increment_maria : MDEV-14430 - Wrong result -parts.partition_auto_increment_max : Added in 10.1.39 +parts.partition_debug : Modified in 10.1.42 +parts.partition_debug_innodb : Modified in 10.1.42 +parts.partition_debug_myisam : Modified in 10.1.42 parts.partition_exch_qa_10 : MDEV-11765 - wrong result parts.partition_innodb_status_file : MDEV-12901 - Valgrind +parts.reorganize_partition_innodb : Added in 10.1.42 #----------------------------------------------------------------------- @@ -397,25 +352,23 @@ perfschema_stress.* : MDEV-10996 - tests not maintained #----------------------------------------------------------------------- plugins.feedback_plugin_send : MDEV-7932 - ssl failed for url -plugins.pam : Modified in 10.1.39 plugins.server_audit : MDEV-9562 - crashes on sol10-sparc plugins.thread_pool_server_audit : MDEV-9562 - crashes on sol10-sparc #----------------------------------------------------------------------- roles.create_and_grant_role : MDEV-11772 - wrong result -roles.flush_roles-17898 : Modified in 10.1.39 #----------------------------------------------------------------------- rpl.circular_serverid0 : MDEV-19372 - ASAN heap-use-after-free -rpl.create_or_replace_mix : Include file modified in 10.1.41 +rpl.create_or_replace_mix : MDEV-20523 - Wrong result; include file modified in 10.1.41 rpl.create_or_replace_row : Include file modified in 10.1.41 -rpl.create_or_replace_statement : Include file modified in 10.1.41 +rpl.create_or_replace_statement : MDEV-20523 - Wrong result; include file modified in 10.1.41 rpl.create_select : MDEV-14121 - Assertion failure rpl.kill_race_condition : Modified in 10.1.41 rpl.last_insert_id : MDEV-10625 - warnings in error log -rpl.mdev_17588 : MDEV-20137 - Table doesn't exist; added in 10.1.41 +rpl.mdev_17588 : Modified in 10.1.42 rpl.rpl_auto_increment : MDEV-10417 - Fails on Mips rpl.rpl_auto_increment_bug45679 : MDEV-10417 - Fails on Mips rpl.rpl_auto_increment_update_failure : MDEV-10625 - warnings in error log @@ -423,6 +376,7 @@ rpl.rpl_binlog_index : MDEV-9501 - Warning: failed registerin rpl.rpl_blackhole : Modified in 10.1.41 rpl.rpl_blackhole_row_annotate : Added in 10.1.41 rpl.rpl_colSize : MDEV-16112 - Server crash +rpl.rpl_create_or_replace_fail : Added in 10.1.42 rpl.rpl_ddl : MDEV-10417 - Fails on Mips rpl.rpl_domain_id_filter_io_crash : MDEV-14357 - Wrong result rpl.rpl_domain_id_filter_master_crash : MDEV-19043 - Warnings/errors @@ -443,14 +397,17 @@ rpl.rpl_insert_id : MDEV-15197 - Wrong result rpl.rpl_insert_id_pk : MDEV-16567 - Assertion failure rpl.rpl_insert_ignore : MDEV-14365 - Lost connection to MySQL server during query rpl.rpl_invoked_features : MDEV-10417 - Fails on Mips +rpl.rpl_known_bugs_detection : Modified in 10.1.42 rpl.rpl_mariadb_slave_capability : MDEV-11018 - sporadic wrong events in binlog rpl.rpl_mdev12179 : MDEV-19043 - Warnings/errors rpl.rpl_mdev6020 : MDEV-10417 - Fails on Mips +rpl.rpl_mdev_17614 : Added in 10.1.42 rpl.rpl_mixed_mixing_engines : MDEV-14489 - Sync slave with master failed rpl.rpl_non_direct_mixed_mixing_engines : MDEV-14489 - Sync slave with master failed rpl.rpl_non_direct_row_mixing_engines : MDEV-16561 - Timeout in master pos wait rpl.rpl_non_direct_stm_mixing_engines : MDEV-14489 - Sync slave with master failed rpl.rpl_parallel : MDEV-10653 - Timeouts +rpl.rpl_parallel_ignored_errors : Added in 10.1.42 rpl.rpl_parallel_mdev6589 : MDEV-12979 - Assertion failure rpl.rpl_parallel_multilevel2 : MDEV-14723 - Timeout rpl.rpl_parallel_optimistic : MDEV-10511 - Timeout @@ -458,7 +415,6 @@ rpl.rpl_parallel_retry : MDEV-11119 - Server crash rpl.rpl_parallel_temptable : MDEV-10356 - Crash in close_thread_tables rpl.rpl_partition_innodb : MDEV-10417 - Fails on Mips rpl.rpl_password_boundaries : MDEV-11534 - Slave IO warnings -rpl.rpl_rewrt_db : Modified in 10.1.39 rpl.rpl_row_basic_11bugs : MDEV-12171 - Server failed to start rpl.rpl_row_basic_2myisam : MDEV-13875 - command "diff_files" failed rpl.rpl_row_drop_create_temp_table : MDEV-14487 - Wrong result @@ -479,15 +435,17 @@ rpl.rpl_semi_sync_wait_point : MDEV-11807 - timeout in wait condition rpl.rpl_show_slave_hosts : MDEV-10681 - server startup problem rpl.rpl_skip_replication : MDEV-9268 - Fails with timeout in sync_slave_with_master on Alpha rpl.rpl_slave_grp_exec : MDEV-10514 - Unexpected deadlock -rpl.rpl_slave_invalid_external_user : Added in 10.1.39 rpl.rpl_start_stop_slave : MDEV-13567 - Replication failure rpl.rpl_stm_mixing_engines : MDEV-14489 - Sync slave with master failed rpl.rpl_stm_relay_ign_space : MDEV-14360 - Test assertion rpl.rpl_sync : MDEV-10633 - Database page corruption +rpl.rpl_sync_with_innodb_thd_conc : Added in 10.1.42 rpl.rpl_temporary_error2 : MDEV-10634 - Wrong number of retries rpl.rpl_test_framework : MDEV-19368 - mysqltest failed but provided no output rpl.rpl_trigger : MDEV-18055 - Wrong result rpl.rpl_truncate_3innodb : MDEV-19454 - Syntax error in test +rpl.rpl_unsafe_statements : Modified in 10.1.42 +rpl.rpl_user_variables : MDEV-20522 - Wrong result rpl.sec_behind_master-5114 : MDEV-13878 - Wrong result #----------------------------------------------------------------------- @@ -531,16 +489,14 @@ stress.ddl_innodb : MDEV-10635 - Testcase timeout #----------------------------------------------------------------------- -sys_vars.autocommit_func2 : MDEV-9329 - Fails on Ubuntu/s390x -sys_vars.delayed_insert_limit_func : MDEV-17683 - Wrong result -sys_vars.innodb_ft_result_cache_limit_32 : Modified in 10.1.41 -sys_vars.keep_files_on_create_basic : MDEV-10676 - timeout -sys_vars.log_slow_admin_statements_func : MDEV-12235 - Server crash -sys_vars.rpl_init_slave_func : MDEV-10149 - wrong results -sys_vars.thread_cache_size_func : MDEV-11775 - Wrong result -sys_vars.thread_stack_basic : Modified in 10.1.39 -sys_vars.transaction_prealloc_size_bug27322 : Modified in 10.1.39 -sys_vars.wait_timeout_func : MDEV-12896 - Wrong result +sys_vars.autocommit_func2 : MDEV-9329 - Fails on Ubuntu/s390x +sys_vars.delayed_insert_limit_func : Modified in 10.1.42 +sys_vars.innodb_ft_result_cache_limit_32 : Modified in 10.1.41 +sys_vars.keep_files_on_create_basic : MDEV-10676 - timeout +sys_vars.log_slow_admin_statements_func : MDEV-12235 - Server crash +sys_vars.rpl_init_slave_func : MDEV-10149 - wrong results +sys_vars.thread_cache_size_func : MDEV-11775 - Wrong result +sys_vars.wait_timeout_func : MDEV-12896 - Wrong result #----------------------------------------------------------------------- @@ -569,8 +525,6 @@ tokudb_backup.* : MDEV-11001 - tests don't work #----------------------------------------------------------------------- -tokudb_bugs.PS-5158 : Added in 10.1.39 -tokudb_bugs.PS-5163 : Added in 10.1.39 tokudb_bugs.checkpoint_lock : MDEV-10637 - Wrong processlist output tokudb_bugs.checkpoint_lock_3 : MDEV-10637 - Wrong processlist output tokudb_bugs.frm_store : MDEV-12823 - Valgrind @@ -580,6 +534,10 @@ tokudb_bugs.xa : MDEV-11804 - Lock wait timeout #----------------------------------------------------------------------- +tokudb_parts.partition_debug_tokudb : Include file modified in 10.1.42 + +#----------------------------------------------------------------------- + tokudb_rpl.* : MDEV-11001 - tests don't work #----------------------------------------------------------------------- @@ -597,14 +555,14 @@ unit.ma_test_loghandler : MDEV-10638 - record read not ok vcol.not_supported : MDEV-10639 - Testcase timeout vcol.vcol_keys_innodb : MDEV-10639 - Testcase timeout vcol.vcol_misc : MDEV-16651 - Wrong error message -vcol.wrong_arena : Modified in 10.1.39 #----------------------------------------------------------------------- -wsrep.foreign_key : MDEV-14725 - WSREP has not yet prepared node -wsrep.mdev_6832 : MDEV-14195 - Failure upon check-testcase -wsrep.pool_of_threads : MDEV-17345 - WSREP has not yet prepared node for application use -wsrep.variables : MDEV-17585 - Deadlock +wsrep.foreign_key : MDEV-14725 - WSREP has not yet prepared node +wsrep.mdev_6832 : MDEV-14195 - Failure upon check-testcase +wsrep.mysql_tzinfo_to_sql_symlink_skip : Added in 10.1.42 +wsrep.pool_of_threads : MDEV-17345 - WSREP has not yet prepared node for application use +wsrep.variables : MDEV-17585 - Deadlock #----------------------------------------------------------------------- -- cgit v1.2.1 From 1552b254a0140e91c54394af5d06d25ae88d5a28 Mon Sep 17 00:00:00 2001 From: Elena Stepanova Date: Thu, 31 Oct 2019 20:42:08 +0200 Subject: List of unstable tests for 10.2.28 release --- mysql-test/unstable-tests | 205 ++++++++++++++++++++++------------------------ 1 file changed, 100 insertions(+), 105 deletions(-) (limited to 'mysql-test') diff --git a/mysql-test/unstable-tests b/mysql-test/unstable-tests index 556ae663b1e..1990da921ec 100644 --- a/mysql-test/unstable-tests +++ b/mysql-test/unstable-tests @@ -23,7 +23,7 @@ # ############################################################################## # -# Based on 10.2 8750df43ab94fb63c1f628b72e89e15118eb7431 +# Based on 10.2 259edb1f60b5d4e9061a81e90c5a8ec9d0741751 main.alter_table_mdev539_maria : Include file modified in 10.2.27 main.alter_table_mdev539_myisam : Include file modified in 10.2.27 @@ -38,12 +38,11 @@ main.auth_named_pipe : MDEV-14724 - System error 2 main.bootstrap : Modified in 10.2.27 main.bug13633383 : Modified in 10.2.27 main.cast : Modified in 10.2.27 -main.charset_client_win : Added in 10.2.26 +main.compare : Modified in 10.2.28 main.compound : Modified in 10.2.27 main.compress : Include file modified in 10.2.27 main.connect : MDEV-17282 - Wrong result main.connect2 : MDEV-13885 - Server crash -main.connect_debug : Modified in 10.2.26 main.constraints : Modified in 10.2.27 main.count_distinct2 : MDEV-11768 - timeout main.create : Modified in 10.2.27 @@ -53,11 +52,13 @@ main.cte_nonrecursive : Modified in 10.2.27 main.cte_recursive : Modified in 10.2.27 main.ctype_create : Modified in 10.2.27 main.ctype_latin1_de : Modified in 10.2.27 +main.ctype_uca : Include file modified in 10.2.28 +main.ctype_uca_innodb : Include file modified in 10.2.28 main.ctype_ucs : MDEV-17681 - Data too long for column; modified in 10.2.27 main.ctype_upgrade : MDEV-16945 - Error upon mysql_upgrade main.ctype_utf16 : MDEV-10675: timeout or extra warnings main.ctype_utf16_def : Configuration modified in 10.2.27 -main.ctype_utf8 : Modified in 10.2.27 +main.ctype_utf8 : Include file modified in 10.2.28 main.ctype_utf8mb4 : Modified in 10.2.27 main.ctype_utf8mb4_heap : Include file modified in 10.2.27 main.ctype_utf8mb4_innodb : Include file modified in 10.2.27 @@ -70,7 +71,8 @@ main.derived_opt : MDEV-11768 - timeout main.derived_view : Modified in 10.2.27 main.dirty_close : MDEV-19368 - mysqltest failed but provided no output main.distinct : MDEV-14194 - Crash; modified in 10.2.27 -main.drop_bad_db_type : MDEV-15676 - Wrong result +main.drop_bad_db_type : MDEV-15676 - Wrong result; modified in 10.2.28 +main.drop_debug : Modified in 10.1.42 main.dyncol : Modified in 10.2.27 main.events_1 : Modified in 10.2.27 main.events_2 : MDEV-13277 - Crash; modified in 10.2.27 @@ -82,7 +84,7 @@ main.explain_json : Modified in 10.2.27 main.flush : MDEV-19368 - mysqltest failed but provided no output main.flush2 : Modified in 10.2.27 main.func_isnull : Modified in 10.2.27 -main.func_math : Modified in 10.2.27 +main.func_math : Modified in 10.2.28 main.func_misc : Modified in 10.2.27 main.function_defaults : Modified in 10.2.27 main.gis : MDEV-13411 - wrong result on P8 @@ -99,9 +101,11 @@ main.handlersocket : Configuration added in 10.2.27 main.host_cache_size_functionality : MDEV-10606 - sporadic failure on shutdown main.index_intersect : Modified in 10.2.27 main.index_intersect_innodb : MDEV-10643 - failed with timeout -main.index_merge_innodb : MDEV-7142 - Plan mismatch +main.index_merge_innodb : MDEV-7142 - Plan mismatch; modified in 10.2.28 +main.index_merge_myisam : Modified in 10.2.28 main.information_schema : Modified in 10.2.27 main.information_schema-big : Modified in 10.2.27 +main.information_schema_db : Modified in 10.2.28 main.information_schema_parameters : Modified in 10.2.27 main.information_schema_routines : Modified in 10.2.27 main.innodb_ext_key : Modified in 10.2.27 @@ -113,13 +117,14 @@ main.join_nested_jcl6 : Modified in 10.2.27 main.join_outer : Modified in 10.2.27 main.join_outer_innodb : Modified in 10.2.27 main.join_outer_jcl6 : Modified in 10.2.27 -main.kill : Modified in 10.2.27 +main.kill : Modified in 10.2.28 main.kill-2 : MDEV-13257 - Wrong result main.kill_processlist-6619 : MDEV-10793 - Wrong result main.limit_rows_examined : Modified in 10.2.27 main.loaddata : MDEV-19368 - mysqltest failed but provided no output main.locale : MDEV-20521 - Missing warning main.log_slow : MDEV-13263 - Wrong result; modified in 10.2.27 +main.log_slow_debug : Modified in 10.2.28 main.log_tables-big : MDEV-13408 - wrong result main.mdev-504 : MDEV-15171 - warning main.mdev13607 : Modified in 10.2.27 @@ -127,7 +132,7 @@ main.mdev375 : MDEV-10607 - sporadic "can't connect" main.merge : MDEV-10607 - sporadic "can't connect"; modified in 10.2.27 main.mrr_icp_extra : Modified in 10.2.27 main.multi_update_debug : MDEV-20136 - Debug sync point wait timed out -main.myisam : Modified in 10.2.27 +main.myisam : Modified in 10.2.28 main.myisam_explain_non_select_all : Modified in 10.2.27 main.myisam_icp : Modified in 10.2.27 main.myisam_mrr : Modified in 10.2.27 @@ -139,7 +144,6 @@ main.mysql_comments : Modified in 10.2.27 main.mysql_upgrade_noengine : MDEV-14355 - Wrong result main.mysql_upgrade_ssl : MDEV-13492 - Unknown SSL error main.mysqlcheck : Modified in 10.2.27 -main.mysqld--help : Modified in 10.2.26 main.mysqldump : MDEV-14800 - Stack smashing detected; modified in 10.2.27 main.mysqldump-max : Modified in 10.2.27 main.mysqldump-nl : Modified in 10.2.27 @@ -150,8 +154,9 @@ main.named_pipe : Include file modified in 10.2.27 main.old-mode : MDEV-19373 - Wrong result main.openssl_1 : MDEV-13492 - Unknown SSL error; modified in 10.2.27 main.openssl_6975 : MDEV-17184 - Failures with OpenSSL 1.1.1 +main.order_by_innodb : Modified in 10.2.28 main.order_by_optimizer_innodb : MDEV-10683 - Wrong result -main.partition_debug_sync : MDEV-15669 - Deadlock found when trying to get lock +main.partition_debug_sync : MDEV-15669 - Deadlock found when trying to get lock; modified in 10.2.28 main.partition_example : Configuration added in 10.2.27 main.partition_innodb : Modified in 10.2.27 main.partition_innodb_plugin : MDEV-12901 - Valgrind warnings @@ -159,14 +164,14 @@ main.partition_innodb_semi_consistent : MDEV-19411 - Failed to start mysqld.1 main.partition_key_cache : Modified in 10.2.27 main.partition_pruning : Modified in 10.2.27 main.plugin : Configuration added in 10.2.27 -main.plugin_auth : Modified in 10.2.26 main.plugin_innodb : Configuration added in 10.2.27 main.plugin_load : Configuration modified in 10.2.27 main.plugin_load_option : Configuration modified in 10.2.27 main.plugin_not_embedded : Configuration added in 10.2.27 main.pool_of_threads : Modified in 10.2.27 +main.processlist : Modified in 10.2.28 +main.processlist_notembedded : Added in 10.2.28 main.ps : Configuration modified in 10.2.27 -main.ps_innodb : Added in 10.2.26 main.query_cache : MDEV-16180 - Wrong result main.query_cache_debug : MDEV-15281 - Query cache is disabled; modified in 10.2.27 main.query_cache_ps_no_prot : Modified in 10.2.27 @@ -176,10 +181,9 @@ main.range_mrr_icp : Modified in 10.2.27 main.range_vs_index_merge : Modified in 10.2.27 main.range_vs_index_merge_innodb : MDEV-15283 - Server has gone away main.repair : Modified in 10.2.27 -main.repair_symlink-5543 : Modified in 10.2.26 main.schema : Modified in 10.2.27 main.select : Modified in 10.2.27 -main.selectivity : Modified in 10.2.27 +main.selectivity : Modified in 10.2.28 main.selectivity_innodb : Modified in 10.2.27 main.selectivity_no_engine : Modified in 10.2.27 main.set_statement : MDEV-13183 - Wrong result @@ -188,7 +192,8 @@ main.shm : MDEV-12727 - Mismatch, ERROR 2013; inclu main.show_bad_definer-5553 : Modified in 10.2.27 main.show_check : Modified in 10.2.27 main.show_explain : MDEV-10674 - Wrong result code -main.sp : Modified in 10.2.27 +main.sp : Modified in 10.2.28 +main.sp-code : Modified in 10.2.28 main.sp-error : Modified in 10.2.27 main.sp-security : MDEV-10607 - sporadic "can't connect"; modified in 10.2.27 main.sp_notembedded : MDEV-10607 - internal error @@ -200,6 +205,7 @@ main.ssl_compress : Modified in 10.2.27 main.ssl_connect : MDEV-13492 - Unknown SSL error main.ssl_crl : MDEV-19119 - Wrong error code main.ssl_timeout : MDEV-11244 - Crash +main.stat_tables : Modified in 10.2.28 main.stat_tables-enospc : Modified in 10.2.27 main.stat_tables_par : MDEV-13266 - Wrong result main.stat_tables_par_innodb : MDEV-14155 - Wrong rounding @@ -215,12 +221,13 @@ main.subselect_extra : Modified in 10.2.27 main.subselect_innodb : MDEV-10614 - Sporadic wrong results main.subselect_mat_cost : Modified in 10.2.27 main.subselect_mat_cost_bugs : Modified in 10.2.27 -main.subselect_sj : Modified in 10.2.27 +main.subselect_sj : Modified in 10.2.28 main.subselect_sj2 : Modified in 10.2.27 main.subselect_sj2_mat : Modified in 10.2.27 main.subselect_sj_jcl6 : Modified in 10.2.27 main.subselect_sj_mat : Modified in 10.2.27 main.subselect_sj_nonmerged : Modified in 10.2.27 +main.sum_distinct-big : Modified in 10.2.28 main.table_options-5867 : Configuration added in 10.2.27 main.tc_heuristic_recover : MDEV-14189 - Wrong result main.trigger : Modified in 10.2.27 @@ -232,6 +239,7 @@ main.type_date : Modified in 10.2.27 main.type_datetime : Modified in 10.2.27 main.type_datetime_hires : MDEV-10687 - Timeout main.type_int : Modified in 10.2.27 +main.type_newdecimal : Modified in 10.2.28 main.type_time_6065 : Modified in 10.2.27 main.type_varchar : Configuration added in 10.2.27 main.union : Modified in 10.2.27 @@ -258,34 +266,34 @@ archive-test_sql_discovery.discover : MDEV-16817 - Table marked as crashed #----------------------------------------------------------------------- -binlog.binlog_commit_wait : MDEV-10150 - Mismatch -binlog.binlog_innodb : Configuration added in 10.2.27 -binlog.binlog_killed : MDEV-12925 - Wrong result -binlog.binlog_max_extension : MDEV-19762 - Crash on shutdown; modified in 10.2.27 -binlog.binlog_mixed_cache_stat : Configuration added in 10.2.27 -binlog.binlog_mysqlbinlog2 : Modified in 10.2.27 -binlog.binlog_mysqlbinlog_stop_never : Added in 10.2.26 -binlog.binlog_parallel_replication_marks_row : Include file modified in 10.2.26 -binlog.binlog_parallel_replication_marks_stm_mix : Include file modified in 10.2.26 -binlog.binlog_row_cache_stat : Include file modified in 10.2.27 -binlog.binlog_row_drop_tmp_tbl : Include file modified in 10.2.27 -binlog.binlog_stm_cache_stat : Include file modified in 10.2.27 -binlog.binlog_stm_drop_tmp_tbl : Include file modified in 10.2.27 -binlog.binlog_xa_recover : MDEV-8517 - Extra checkpoint -binlog.flashback-largebinlog : MDEV-19764 - Out of memory; modified in 10.2.27 -binlog.load_data_stm_view : MDEV-16948 - Wrong result +binlog.binlog_commit_wait : MDEV-10150 - Mismatch +binlog.binlog_innodb : Configuration added in 10.2.27 +binlog.binlog_killed : MDEV-12925 - Wrong result +binlog.binlog_max_extension : MDEV-19762 - Crash on shutdown; modified in 10.2.27 +binlog.binlog_mixed_cache_stat : Configuration added in 10.2.27 +binlog.binlog_mysqlbinlog2 : Modified in 10.2.27 +binlog.binlog_row_cache_stat : Include file modified in 10.2.27 +binlog.binlog_row_drop_tmp_tbl : Include file modified in 10.2.27 +binlog.binlog_stm_cache_stat : Include file modified in 10.2.27 +binlog.binlog_stm_drop_tmp_tbl : Include file modified in 10.2.27 +binlog.binlog_xa_recover : MDEV-8517 - Extra checkpoint +binlog.flashback-largebinlog : MDEV-19764 - Out of memory; modified in 10.2.27 +binlog.load_data_stm_view : MDEV-16948 - Wrong result #----------------------------------------------------------------------- +binlog_encryption.binlog_mdev_20574_old_binlog : Added in 10.2.28 binlog_encryption.binlog_xa_recover : MDEV-12908 - Extra checkpoint binlog_encryption.encrypted_master : MDEV-14201 - Extra warnings binlog_encryption.encrypted_master_switch_to_unencrypted : MDEV-14190 - Can't init tc log binlog_encryption.encryption_combo : MDEV-14199 - Table is marked as crashed +binlog_encryption.mysqlbinlog : Modified in 10.2.28 binlog_encryption.rpl_binlog_errors : MDEV-12742 - Crash binlog_encryption.rpl_checksum : MDEV-16951 - Wrong result binlog_encryption.rpl_gtid_basic : MDEV-16947 - Server failed to start binlog_encryption.rpl_loadfile : MDEV-16645 - Timeout in include binlog_encryption.rpl_parallel : MDEV-10653 - Timeout in include +binlog_encryption.rpl_parallel_ignored_errors : Added in 10.2.28 binlog_encryption.rpl_relayrotate : MDEV-15194 - Timeout binlog_encryption.rpl_semi_sync : MDEV-11673 - Valgrind binlog_encryption.rpl_skip_replication : MDEV-13571 - Unexpected warning @@ -296,13 +304,15 @@ binlog_encryption.rpl_typeconv : MDEV-14362 - Lost con #----------------------------------------------------------------------- -connect.pivot : MDEV-14803 - Failed to discover table -connect.vcol : MDEV-12374 - Fails on Windows -connect.zip : MDEV-13884 - Wrong result - -#----------------------------------------------------------------------- - -disks.disks_notembedded : Added in 10.2.26 +connect.grant : Modified in 10.2.28 +connect.grant2 : Modified in 10.2.28 +connect.ini_grant : Modified in 10.2.28 +connect.mysql_grant : Modified in 10.2.28 +connect.pivot : MDEV-14803 - Failed to discover table +connect.vcol : MDEV-12374 - Fails on Windows +connect.xml2_grant : Include file modified in 10.2.28 +connect.xml_grant : Include file modified in 10.2.28 +connect.zip : MDEV-13884 - Wrong result #----------------------------------------------------------------------- @@ -310,23 +320,23 @@ encryption.create_or_replace : MDEV-12694 - Timeout; MDEV-16115 encryption.debug_key_management : MDEV-13841 - Timeout encryption.encrypt_and_grep : MDEV-13765 - Wrong result encryption.file_creation : Added in 10.2.27 -encryption.innochecksum : MDEV-13644 - Assertion failure; modified in 10.2.26 +encryption.innochecksum : MDEV-13644 - Assertion failure encryption.innodb-bad-key-change2 : MDEV-19118 - Can't connect through socket -encryption.innodb-checksum-algorithm : MDEV-12898 - Deadlock of threads; MDEV-16896 - Server crash +encryption.innodb-checksum-algorithm : MDEV-16896 - Server crash encryption.innodb-compressed-blob : MDEV-14728 - Unable to get certificate encryption.innodb-discard-import : MDEV-19113 - Timeout -encryption.innodb-encryption-alter : MDEV-13566 - Lock wait timeout; modified in 10.2.26 +encryption.innodb-encryption-alter : MDEV-13566 - Lock wait timeout encryption.innodb-first-page-read : MDEV-14356 - Timeout in wait condition encryption.innodb-force-corrupt : MDEV-17286 - SSL error encryption.innodb-page_encryption : MDEV-10641 - mutex problem encryption.innodb-read-only : MDEV-16563 - Crash on startup -encryption.innodb-redo-badkey : MDEV-12898 - Server hang on startup +encryption.innodb-redo-badkey : Re-enabled in 10.2.28; modified in 10.2.28 encryption.innodb-remove-encryption : MDEV-16493 - Timeout in wait condition encryption.innodb-spatial-index : MDEV-13746 - Wrong result encryption.innodb_encrypt_key_rotation_age : MDEV-19763 - Timeout encryption.innodb_encrypt_log : MDEV-13725 - Wrong result encryption.innodb_encrypt_log_corruption : Configuration modified in 10.2.27 -encryption.innodb_encrypt_temporary_tables : MDEV-20142 - Wrong result; added in 10.2.26 +encryption.innodb_encrypt_temporary_tables : MDEV-20142 - Wrong result encryption.innodb_encryption : MDEV-15675 - Timeout encryption.innodb_encryption-page-compression : MDEV-12630 - crash or assertion failure encryption.innodb_encryption_discard_import : MDEV-16116 - Wrong result @@ -364,6 +374,7 @@ federated.federatedx : MDEV-10617 - Wrong checksum funcs_1.innodb_storedproc_07 : Include file modified in 10.2.27 funcs_1.innodb_storedproc_08 : Include file modified in 10.2.27 funcs_1.innodb_trig_03e : Modified in 10.2.27 +funcs_1.is_basics_mixed : Modified in 10.2.28 funcs_1.is_columns : Modified in 10.2.27 funcs_1.is_columns_innodb : Modified in 10.2.27 funcs_1.is_columns_memory : Modified in 10.2.27 @@ -417,7 +428,7 @@ gcol.gcol_select_innodb : Include file modified in 10.2.27 gcol.gcol_select_myisam : Include file modified in 10.2.27 gcol.innodb_virtual_basic : MDEV-16950 - Failing assertion; modified in 10.2.27 gcol.innodb_virtual_debug : MDEV-19114 - Assertion failure -gcol.innodb_virtual_debug_purge : MDEV-16952 - Wrong result +gcol.innodb_virtual_debug_purge : MDEV-16952 - Wrong result; modified in 10.2.28 gcol.innodb_virtual_index : Modified in 10.2.27 #----------------------------------------------------------------------- @@ -425,31 +436,23 @@ gcol.innodb_virtual_index : Modified in 10.2.27 innodb.101_compatibility : MDEV-13891 - Wrong result innodb.alter_copy : MDEV-16181 - Assertion failure; modified in 10.2.27 innodb.alter_crash : MDEV-16944 - The process cannot access the file -innodb.alter_large_dml : Added in 10.2.26 -innodb.alter_missing_tablespace : Modified in 10.2.26 innodb.auto_increment_dup : Modified in 10.2.27 innodb.autoinc_persist : MDEV-15282 - Assertion failure innodb.binlog_consistent : MDEV-10618 - Server fails to start -innodb.blob-crash : Added in 10.2.26 -innodb.check_ibd_filesize : Added in 10.2.26 -innodb.create_select : Added in 10.2.26 innodb.doublewrite : MDEV-12905 - Server crash innodb.foreign-keys : Modified in 10.2.27 innodb.foreign_key : Modified in 10.2.27 innodb.group_commit_crash : MDEV-14191 - InnoDB registration failed innodb.group_commit_crash_no_optimize_thread : MDEV-13830 - Assertion failure -innodb.ibuf_not_empty : MDEV-19021 - Wrong result -innodb.innodb-16k : Modified in 10.2.26 -innodb.innodb-32k : Modified in 10.2.26 -innodb.innodb-32k-crash : MDEV-16953 - Corrupt log record found; modified in 10.2.26 -innodb.innodb-64k-crash : MDEV-13872 - Failure and crash on startup; modified in 10.2.26 +innodb.ibuf_not_empty : MDEV-19021 - Wrong result; modified in 10.2.28 +innodb.information_schema_grants : Added in 10.2.28 +innodb.innodb-64k-crash : MDEV-13872 - Failure and crash on startup innodb.innodb-alter : Modified in 10.2.27 innodb.innodb-alter-debug : MDEV-13182 - InnoDB: adjusting FSP_SPACE_FLAGS innodb.innodb-alter-table : MDEV-10619 - Testcase timeout -innodb.innodb-alter-tempfile : MDEV-15285 - Table already exists -innodb.innodb-autoinc : Modified in 10.2.26 +innodb.innodb-autoinc : Modified in 10.2.28 innodb.innodb-blob : MDEV-12053 - Client crash -innodb.innodb-change-buffer-recovery : MDEV-19115 - Lost connection to MySQL server during query +innodb.innodb-change-buffer-recovery : MDEV-19115 - Lost connection to MySQL server during query; modified in 10.2.28 innodb.innodb-fk : MDEV-13832 - Assertion failure on shutdown innodb.innodb-fkcheck : Modified in 10.2.27 innodb.innodb-get-fk : MDEV-13276 - Server crash; modified in 10.2.27 @@ -461,13 +464,11 @@ innodb.innodb-page_compression_zip : MDEV-10641 - mutex problem innodb.innodb-read-view : Added in 10.2.27 innodb.innodb-system-table-view : Configuration modified in 10.2.27 innodb.innodb-table-online : MDEV-13894 - Wrong result -innodb.innodb-virtual-columns-debug : MDEV-20143 - Wrong result; added in 10.2.26 +innodb.innodb-virtual-columns-debug : Modified in 10.2.28 innodb.innodb-wl5522-debug : MDEV-14200 - Wrong errno; modified in 10.2.27 -innodb.innodb-wl5980-debug : Added in 10.2.26 -innodb.innodb_buffer_pool_dump_pct : MDEV-20139 - Timeout in wait_condition.inc; added in 10.2.26 +innodb.innodb_buffer_pool_dump_pct : MDEV-20139 - Timeout in wait_condition.inc innodb.innodb_buffer_pool_resize_with_chunks : MDEV-16964 - Assertion failure innodb.innodb_bug14147491 : MDEV-11808 - Index is corrupt -innodb.innodb_bug14704286 : Deleted in 10.2.27 innodb.innodb_bug30423 : MDEV-7311 - Wrong result innodb.innodb_bug47167 : MDEV-20524 - Table 'user' is marked as crashed and should be repaired innodb.innodb_bug48024 : MDEV-14352 - Assertion failure @@ -478,12 +479,14 @@ innodb.innodb_bulk_create_index_debug : Include file modified in 10.2.27 innodb.innodb_bulk_create_index_flush : Configuration added in 10.2.27 innodb.innodb_bulk_create_index_replication : MDEV-15273 - Slave failed to start innodb.innodb_defrag_stats_many_tables : MDEV-14198 - Table is full +innodb.innodb_force_recovery : Modified in 10.2.28 innodb.innodb_information_schema : MDEV-8851 - Wrong result -innodb.innodb_max_recordsize_32k : MDEV-14801 - Operation failed; modified in 10.2.26 -innodb.innodb_max_recordsize_64k : MDEV-15203 - Wrong result; modified in 10.2.26 +innodb.innodb_max_recordsize_32k : MDEV-14801 - Operation failed +innodb.innodb_max_recordsize_64k : MDEV-15203 - Wrong result innodb.innodb_monitor : MDEV-10939 - Testcase timeout -innodb.innodb_mysql : MDEV-19873 - Wrong result; modified in 10.2.26 +innodb.innodb_mysql : MDEV-19873 - Wrong result innodb.innodb_stats : MDEV-10682 - wrong result +innodb.innodb_stats_persistent : Modified in 10.2.28 innodb.innodb_stats_persistent_debug : MDEV-14801 - Operation failed innodb.innodb_sys_semaphore_waits : MDEV-10331 - Semaphore wait innodb.innodb_zip_innochecksum2 : MDEV-13882 - Warning: difficult to find free blocks @@ -492,25 +495,18 @@ innodb.log_corruption : MDEV-13251 - Wrong result innodb.log_data_file_size : MDEV-14204 - Server failed to start innodb.log_file_name : MDEV-14193 - Exception innodb.log_file_size : MDEV-15668 - Not found pattern -innodb.max_record_size : Added in 10.2.26 -innodb.missing_tablespaces : Added in 10.2.26 innodb.monitor : MDEV-16179 - Wrong result -innodb.page_id_innochecksum : Added in 10.2.26 -innodb.purge : Added in 10.2.26 innodb.purge_secondary : MDEV-15681 - Wrong result -innodb.purge_secondary_mdev-16222 : Added in 10.2.26 innodb.purge_thread_shutdown : MDEV-13792 - Wrong result innodb.read_only_recovery : MDEV-13886 - Server crash innodb.recovery_shutdown : MDEV-15671 - Checksum mismatch in datafile; modified in 10.2.27 innodb.row_format_redundant : MDEV-15192 - Trying to access missing tablespace -innodb.strict_mode : Modified in 10.2.26 +innodb.stat_tables : Added in 10.2.28 innodb.table_definition_cache_debug : MDEV-14206 - Extra warning innodb.table_flags : MDEV-13572 - Wrong result; MDEV-19374 - Server failed to start -innodb.temp_table_savepoint : MDEV-16182 - Wrong result innodb.temporary_table : MDEV-13265 - Wrong result -innodb.truncate_missing : Modified in 10.2.26 -innodb.trx_id_future : Added in 10.2.26 -innodb.undo_log : Modified in 10.2.26 +innodb.temporary_table_optimization : Modified in 10.2.28 +innodb.trx_id_future : Modified in 10.1.42 innodb.undo_truncate : MDEV-17340 - Server hung innodb.undo_truncate_recover : MDEV-17679 - MySQL server has gone away; modified in 10.2.27 innodb.update_time : MDEV-14804 - Wrong result @@ -518,8 +514,9 @@ innodb.xa_recovery : MDEV-15279 - mysqld got exception #----------------------------------------------------------------------- -innodb_fts.fulltext2 : Modified in 10.2.26 -innodb_fts.innodb_fts_misc : Modified in 10.2.27 +innodb_fts.concurrent_insert : Modified in 10.2.28 +innodb_fts.crash_recovery : Modified in 10.2.28 +innodb_fts.innodb_fts_misc : Modified in 10.2.28 innodb_fts.innodb_fts_misc_debug : MDEV-14156 - Unexpected warning innodb_fts.innodb_fts_plugin : MDEV-13888 - Errors in server log innodb_fts.innodb_fts_stopword_charset : MDEV-13259 - Table crashed @@ -527,7 +524,6 @@ innodb_fts.sync : MDEV-14808 - Wrong result #----------------------------------------------------------------------- -innodb_gis.kill_server : MDEV-16941 - Checksum mismatch innodb_gis.rtree_compress2 : Modified in 10.2.27 innodb_gis.rtree_concurrent_srch : MDEV-15284 - Wrong result with embedded innodb_gis.rtree_purge : MDEV-15275 - Timeout @@ -548,11 +544,10 @@ innodb_zip.wl6501_scale_1 : MDEV-13254 - Timeout, MDEV-14104 - Error 192 #----------------------------------------------------------------------- -maria.alter : Modified in 10.2.26 maria.icp : Modified in 10.2.27 maria.insert_select : MDEV-12757 - Timeout maria.insert_select-7314 : MDEV-16492 - Timeout -maria.kill : Added in 10.2.26 +maria.lock : Modified in 10.2.28 maria.maria : MDEV-14430 - Extra warning maria.maria-big : Modified in 10.2.27 maria.maria-gis-recovery : Modified in 10.2.27 @@ -560,18 +555,19 @@ maria.maria-no-logging : Modified in 10.2.27 maria.maria-recover : Modified in 10.2.27 maria.maria-recovery : Modified in 10.2.27 maria.maria3 : Modified in 10.2.27 -maria.temporary : Added in 10.2.26 #----------------------------------------------------------------------- mariabackup.apply-log-only : MDEV-20135 - Timeout mariabackup.big_innodb_log : Added in 10.2.27 mariabackup.data_directory : MDEV-15270 - Error on exec +mariabackup.extra_lsndir_stream : Added in 10.2.28 mariabackup.full_backup : MDEV-16571 - Wrong result mariabackup.huge_lsn : MDEV-15662 - Sequence number is in the future mariabackup.incremental_encrypted : MDEV-15667 - Timeout mariabackup.mdev-14447 : MDEV-15201 - Timeout -mariabackup.missing_ibd : Modified in 10.2.26 +mariabackup.mdev-18438 : Added in 10.2.28 +mariabackup.partial : Modified in 10.2.28 mariabackup.partial_exclude : MDEV-15270 - Error on exec mariabackup.xb_compressed_encrypted : MDEV-14812 - Segmentation fault mariabackup.xb_page_compress : MDEV-14810 - status: 1, errno: 11 @@ -596,7 +592,6 @@ mroonga/wrapper.repair_table_no_index_file : MDEV-14807 - Wrong error message multi_source.gtid : MDEV-14202 - Crash multi_source.info_logs : MDEV-12629 - Valgrind, MDEV-10042 - wrong result -multi_source.mdev-8874 : Added in 10.2.26 multi_source.mdev-9544 : MDEV-19415 - AddressSanitizer: heap-use-after-free multi_source.multisource : MDEV-10417 - Fails on Mips multi_source.reset_slave : MDEV-10690 - Wrong result @@ -608,7 +603,9 @@ multi_source.status_vars : MDEV-4632 - failed while waiting for Slave_received_h parts.partition_alter2_2_maria : MDEV-14364 - Lost connection to MySQL server during query parts.partition_auto_increment_archive : MDEV-16491 - Marked as crashed and should be repaired parts.partition_auto_increment_maria : MDEV-14430 - Extra warning -parts.partition_debug_innodb : MDEV-10891 - Can't create UNIX socket; MDEV-15095 - Table doesn't exist +parts.partition_debug : Modified in 10.2.28 +parts.partition_debug_innodb : MDEV-10891 - Can't create UNIX socket; MDEV-15095 - Table doesn't exist; modified in 10.2.28 +parts.partition_debug_myisam : Modified in 10.2.28 parts.partition_exch_qa_10 : MDEV-11765 - wrong result parts.partition_exch_qa_4_innodb : Include file modified in 10.2.27 parts.partition_exch_qa_4_myisam : Include file modified in 10.2.27 @@ -628,6 +625,7 @@ parts.partition_mgm_lc2_innodb : Include file modified in 10.2.27 parts.partition_mgm_lc2_memory : Include file modified in 10.2.27 parts.partition_mgm_lc2_myisam : Include file modified in 10.2.27 parts.partition_special_innodb : MDEV-16942 - Timeout +parts.reorganize_partition_innodb : Added in 10.2.28 #----------------------------------------------------------------------- @@ -675,7 +673,7 @@ perfschema_stress.* : MDEV-10996 - Not maintained #----------------------------------------------------------------------- -plugins.feedback_plugin_load : Modified in 10.2.27 +plugins.feedback_plugin_load : Modified in 10.2.28 plugins.feedback_plugin_send : MDEV-7932, MDEV-11118 - Connection problems and such plugins.processlist : MDEV-16574 - Wrong result plugins.qc_info : Modified in 10.2.27 @@ -695,6 +693,7 @@ rocksdb.drop_index_inplace : MDEV-14162 - Crash on shutdown rocksdb.drop_table : MDEV-14308 - Timeout rocksdb.drop_table3 : MDEV-16949 - Server crash rocksdb.dup_key_update : MDEV-17284 - Wrong result +rocksdb.index_merge_rocksdb2 : Include file modified in 10.2.28 rocksdb.locking_issues : MDEV-14464 - Wrong result rocksdb.mariadb_ignore_dirs : MDEV-16639 - Server crash rocksdb.mariadb_port_fixes : MDEV-16387 - Wrong plan @@ -703,9 +702,7 @@ rocksdb.perf_context : MDEV-17285 - Wrong results rocksdb.rocksdb_cf_options : MDEV-16639 - Server crash rocksdb.rocksdb_cf_per_partition : MDEV-16636 - Wrong result rocksdb.rocksdb_parts : MDEV-13843 - Wrong result -rocksdb.ttl_primary_read_filtering : MDEV-16560 - Wrong result rocksdb.ttl_secondary : MDEV-16943 - Timeout -rocksdb.ttl_secondary_read_filtering : MDEV-16560 - Wrong result rocksdb.unique_check : MDEV-16576 - Wrong errno rocksdb.use_direct_reads_writes : MDEV-16646 - Server crash rocksdb.write_sync : MDEV-16965 - WRong result @@ -726,11 +723,9 @@ roles.show_create_database-10463 : Modified in 10.2.27 rpl.circular_serverid0 : MDEV-19372 - ASAN heap-use-after-free rpl.create_or_replace2 : MDEV-19412 - Lost connection to MySQL server -rpl.create_or_replace_mix : MDEV-20523 - Wrong result; include file modified in 10.2.26 -rpl.create_or_replace_row : Include file modified in 10.2.26 -rpl.create_or_replace_statement : MDEV-20523 - Wrong result; include file modified in 10.2.26 +rpl.create_or_replace_mix : MDEV-20523 - Wrong result +rpl.create_or_replace_statement : MDEV-20523 - Wrong result rpl.create_select : MDEV-14121 - Assertion failure -rpl.kill_race_condition : Modified in 10.2.26 rpl.last_insert_id : MDEV-10625 - warnings in error log rpl.mdev_17588 : Modified in 10.2.27 rpl.rpl_auto_increment : MDEV-10417 - Fails on Mips @@ -777,6 +772,7 @@ rpl.rpl_non_direct_row_mixing_engines : MDEV-16561 - Timeout in master_pos_wai rpl.rpl_non_direct_stm_mixing_engines : MDEV-14489 - Failed sync_slave_with_master rpl.rpl_parallel : MDEV-10653 - Timeouts rpl.rpl_parallel_conflicts : MDEV-15272 - Server crash +rpl.rpl_parallel_ignored_errors : Added in 10.2.28 rpl.rpl_parallel_mdev6589 : MDEV-12979 - Assertion failure rpl.rpl_parallel_multilevel2 : MDEV-14723 - Timeout rpl.rpl_parallel_optimistic : MDEV-15278 - Failed to sync with master @@ -789,7 +785,6 @@ rpl.rpl_row_001 : MDEV-16653 - Internal check fails rpl.rpl_row_basic_11bugs : MDEV-12171 - Server failed to start rpl.rpl_row_basic_2myisam : MDEV-13875 - command "diff_files" failed rpl.rpl_row_drop_create_temp_table : MDEV-14487 - Wrong result -rpl.rpl_row_drop_temp_table : Added in 10.2.26 rpl.rpl_row_img_blobs : MDEV-13875 - command "diff_files" failed rpl.rpl_row_img_eng_min : MDEV-13875 - diff_files failed rpl.rpl_row_img_eng_noblob : MDEV-13875 - command "diff_files" failed @@ -801,7 +796,7 @@ rpl.rpl_semi_sync : MDEV-11220 - Wrong result rpl.rpl_semi_sync_after_sync : MDEV-14366 - Wrong result rpl.rpl_semi_sync_after_sync_row : MDEV-14366 - Wrong result rpl.rpl_semi_sync_event_after_sync : MDEV-11806 - warnings -rpl.rpl_semi_sync_uninstall_plugin : MDEV-7140 - Assorted failures; modified in 10.2.26 +rpl.rpl_semi_sync_uninstall_plugin : MDEV-7140 - Assorted failures rpl.rpl_semi_sync_wait_point : MDEV-11807 - timeout in wait condition rpl.rpl_set_statement_default_master : MDEV-13258 - Extra warning rpl.rpl_show_slave_hosts : MDEV-10681 - Crash @@ -822,14 +817,13 @@ rpl.rpl_temporary_error2 : MDEV-10634 - Wrong number of retries rpl.rpl_test_framework : MDEV-19368 - mysqltest failed but provided no output rpl.rpl_trigger : MDEV-18055 - Wrong result rpl.rpl_truncate_3innodb : MDEV-19454 - Sporadic syntax error +rpl.rpl_unsafe_statements : Modified in 10.1.42 rpl.rpl_user_variables : MDEV-20522 - Wrong result rpl.sec_behind_master-5114 : MDEV-13878 - Wrong result #----------------------------------------------------------------------- -rpl-tokudb.* : MDEV-14354 - Tests fail with tcmalloc -rpl-tokudb.rpl_tokudb_row_crash_safe : Deleted in 10.2.27 -rpl-tokudb.rpl_tokudb_stm_mixed_crash_safe : Deleted in 10.2.27 +rpl-tokudb.* : MDEV-14354 - Tests fail with tcmalloc #----------------------------------------------------------------------- @@ -837,7 +831,8 @@ rpl/extra/rpl_tests.* : MDEV-10994 - Not maintained #----------------------------------------------------------------------- -sphinx.* : MDEV-10986 - Tests have not been maintained +sphinx.* : MDEV-10986 - Tests have not been maintained +sphinx.sphinx : Modified in 10.2.28 #----------------------------------------------------------------------- @@ -883,11 +878,11 @@ sys_vars.character_set_server_func : Modified in 10.2.27 sys_vars.collation_connection_basic : Modified in 10.2.27 sys_vars.collation_database_basic : Modified in 10.2.27 sys_vars.collation_server_basic : Modified in 10.2.27 -sys_vars.delayed_insert_limit_func : Modified in 10.1.42 +sys_vars.delayed_insert_limit_func : Modified in 10.2.28 sys_vars.expire_logs_days_basic : Modified in 10.2.27 sys_vars.histogram_size_basic : Modified in 10.2.27 sys_vars.innodb_buffer_pool_dump_at_shutdown_basic : MDEV-14280 - Unexpected error -sys_vars.innodb_ft_result_cache_limit : Modified in 10.2.26 +sys_vars.innodb_change_buffering_debug_basic : Modified in 10.2.28 sys_vars.innodb_max_dirty_pages_pct_basic : Modified in 10.2.27 sys_vars.innodb_max_dirty_pages_pct_lwm_basic : Modified in 10.2.27 sys_vars.innodb_read_io_threads_basic : Configuration added in 10.2.27 @@ -904,6 +899,7 @@ sys_vars.myisam_sort_buffer_size_basic : Modified in 10.2.27 sys_vars.optimizer_switch_basic : Modified in 10.2.27 sys_vars.rpl_init_slave_func : MDEV-10149 - Test assertion sys_vars.slow_query_log_func : MDEV-14273 - Wrong result +sys_vars.sysvars_innodb : Modified in 10.2.28 sys_vars.sysvars_server_embedded : Include file modified in 10.2.27 sys_vars.sysvars_server_notembedded : Include file modified in 10.2.27 sys_vars.thread_cache_size_func : MDEV-11775 - Wrong result @@ -955,11 +951,11 @@ tokudb_bugs.frm_store : MDEV-12823 - Valgrind tokudb_bugs.frm_store2 : MDEV-12823 - Valgrind tokudb_bugs.frm_store3 : MDEV-12823 - Valgrind tokudb_bugs.xa : MDEV-11804 - Lock wait timeout -tokudb_bugs.xa-3 : MDEV-16953 - Corrupt log record found #----------------------------------------------------------------------- tokudb_parts.partition_alter4_tokudb : MDEV-12640 - Lost connection +tokudb_parts.partition_debug_tokudb : Include file modified in 10.2.28 tokudb_parts.partition_exch_qa_4_tokudb : Include file modified in 10.2.27 tokudb_parts.partition_exch_qa_8_tokudb : Include file modified in 10.2.27 tokudb_parts.partition_mgm_lc0_tokudb : Include file modified in 10.2.27 @@ -991,8 +987,8 @@ unit.ma_test_loghandler : MDEV-10638 - record read not ok vcol.cross_db : Modified in 10.2.27 vcol.not_supported : MDEV-10639 - Testcase timeout vcol.update : Modified in 10.2.27 -vcol.vcol_keys_innodb : MDEV-10639 - Testcase timeout -vcol.vcol_misc : MDEV-16651 - Wrong error message; modified in 10.2.26 +vcol.vcol_keys_innodb : MDEV-10639 - Testcase timeout; modified in 10.2.28 +vcol.vcol_misc : MDEV-16651 - Wrong error message vcol.vcol_select_innodb : Modified in 10.2.27 vcol.vcol_select_myisam : Modified in 10.2.27 vcol.vcol_sql_mode : Added in 10.2.27 @@ -1006,9 +1002,8 @@ wsrep.foreign_key : MDEV-14725 - WSREP has not yet prepared wsrep.mdev_6832 : MDEV-14195 - Check testcase failed wsrep.mysql_tzinfo_to_sql_symlink_skip : Added in 10.2.27 wsrep.pool_of_threads : MDEV-17345 - WSREP has not yet prepared node for application use -wsrep.variables : MDEV-14311 - Wrong result; MDEV-17585 - Deadlock; modified in 10.2.26 +wsrep.variables : MDEV-14311 - Wrong result; MDEV-17585 - Deadlock #----------------------------------------------------------------------- -wsrep_info.* : suite.pm modified in 10.2.26 wsrep_info.plugin : MDEV-13569 - No nodes coming from prim view -- cgit v1.2.1 From 6f86150ab3c9059a9379fcc68cb90da78e59e5cb Mon Sep 17 00:00:00 2001 From: Robert Bindar Date: Thu, 10 Oct 2019 12:58:29 +0300 Subject: MDEV-17896 Assertion `pfs->get_refcount() > 0' failed Unfortunate DROP TEMPORARY..IF EXISTS on a regular table may allow subsequent CREATE TABLE statements to steal away the PFS_table_share instance from the dropped table. --- mysql-test/suite/perfschema/r/misc.result | 16 +++++++++++ mysql-test/suite/perfschema/t/misc.test | 48 +++++++++++++++++++++++++++++++ 2 files changed, 64 insertions(+) (limited to 'mysql-test') diff --git a/mysql-test/suite/perfschema/r/misc.result b/mysql-test/suite/perfschema/r/misc.result index 7a097a27576..e2b7f6fab73 100644 --- a/mysql-test/suite/perfschema/r/misc.result +++ b/mysql-test/suite/perfschema/r/misc.result @@ -134,3 +134,19 @@ truncate performance_schema.events_statements_history 0 select * from t1 3 insert into t1 select RAND()*10000 from t1 6 drop table t1; +# +# MDEV-17896 Assertion `pfs->get_refcount() > 0' failed +# in release_table_share +# +SELECT COUNT(*)<@@performance_schema_max_table_instances FROM +performance_schema.objects_summary_global_by_type WHERE OBJECT_TYPE='TABLE'; +COUNT(*)<@@performance_schema_max_table_instances +1 +CREATE TABLE t0(a INT); +SELECT * FROM t0; +a +DROP TEMPORARY TABLE IF EXISTS t0; +Warnings: +Note 1051 Unknown table 'test.t0' +FLUSH TABLE t0; +DROP TABLE t0; diff --git a/mysql-test/suite/perfschema/t/misc.test b/mysql-test/suite/perfschema/t/misc.test index c9f7dc6bfc0..80ce64f0302 100644 --- a/mysql-test/suite/perfschema/t/misc.test +++ b/mysql-test/suite/perfschema/t/misc.test @@ -222,3 +222,51 @@ insert into t1 select RAND()*10000 from t1; select sql_text, rows_examined from performance_schema.events_statements_history; drop table t1; +--echo # +--echo # MDEV-17896 Assertion `pfs->get_refcount() > 0' failed +--echo # in release_table_share +--echo # + +# There must be at least one available slot in PFS table_share_array for +# this test to be meaningful. If there are no free slots we must +# restart mysqld, it is the only way to reset PFS table_share_array +let $query= SELECT COUNT(*)<@@performance_schema_max_table_instances FROM + performance_schema.objects_summary_global_by_type WHERE OBJECT_TYPE='TABLE'; + +let $free_slots_available= `$query`; + +if (!$free_slots_available) +{ + source include/restart_mysqld.inc; +} +eval $query; + +CREATE TABLE t0(a INT); + +# TABLE_SHARE must be cached in the table definition cache. +SELECT * FROM t0; + +# Dropping t0 using DROP TEMPORARY frees up a slot in table_share_array, +# but the persistent table is not correctly dropped, i.e. TABLE_SHARE::m_psi +# still points to that slot in table_share_array. +DROP TEMPORARY TABLE IF EXISTS t0; + +# Try re-using each and every slot in PFS table_share_array. If bug is +# there, we re-use t0 slot. +# The newly created table that re-uses the t0 slot ends up +# resetting the PFS_table_share refcount. +let $i= `SELECT @@performance_schema_max_table_instances`; +disable_query_log; +while ($i) +{ + # Memory engine is here to reduce disk IO + eval CREATE TABLE t$i(a INT) ENGINE=MEMORY; + eval DROP TABLE t$i; + dec $i; +} +enable_query_log; + +# FLUSH TABLE crashes the server when PFS_table_share is found with +# an unexpected refcount. +FLUSH TABLE t0; +DROP TABLE t0; -- cgit v1.2.1 From 8afe4bba2ecd9ebc762a80598a8465a201d4feee Mon Sep 17 00:00:00 2001 From: Varun Gupta Date: Sun, 27 Oct 2019 01:48:00 +0530 Subject: MDEV-20424: New default value for optimizer_use_condition-selectivity leads to bad plan In the function prev_record_reads where one finds the different row combinations for a subset of partial join, it did not take into account the selectivity of tables involved in the subset of partial join. --- mysql-test/r/selectivity.result | 57 ++++++++++++++++++++++++++++++++++ mysql-test/r/selectivity_innodb.result | 57 ++++++++++++++++++++++++++++++++++ mysql-test/t/selectivity.test | 29 +++++++++++++++++ 3 files changed, 143 insertions(+) (limited to 'mysql-test') diff --git a/mysql-test/r/selectivity.result b/mysql-test/r/selectivity.result index d0bbb46cb0a..5fe6986e9ff 100644 --- a/mysql-test/r/selectivity.result +++ b/mysql-test/r/selectivity.result @@ -1753,4 +1753,61 @@ a 1991 set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; DROP TABLE t1; +# +# MDEV-20424: New default value for optimizer_use_condition-selectivity +# leads to bad plan +# +create table t1(a int, b int, c int, d int, key(a,b)); +insert into t1 select 50,seq-1,seq-1,seq from seq_1_to_10; +insert into t1 select seq-1,seq-1,seq-1,seq from seq_1_to_100 limit 90; +create table t2(a int, b int, c int, primary key(a)); +insert into t2 select seq-1,seq-1,seq-1 from seq_1_to_100; +create table t3(a int, b int, c int, primary key(a)); +insert into t3 select seq-1,seq-1,seq-1 from seq_1_to_100 limit 30; +set optimizer_use_condition_selectivity=1; +explain extended select t1.b,t2.a,t3.a,t3.b from t1,t2,t3 +where t1.c = t2.a AND t1.d = t3.a and t1.a = 50 and t1.b <= 100; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 range a a 10 NULL 9 100.00 Using index condition; Using where +1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t1.d 1 100.00 +1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 test.t1.c 1 100.00 Using index +Warnings: +Note 1003 select `test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b` from `test`.`t1` join `test`.`t2` join `test`.`t3` where ((`test`.`t2`.`a` = `test`.`t1`.`c`) and (`test`.`t3`.`a` = `test`.`t1`.`d`) and (`test`.`t1`.`a` = 50) and (`test`.`t1`.`b` <= 100)) +select t1.b,t2.a,t3.a,t3.b from t1,t2,t3 +where t1.c = t2.a AND t1.d = t3.a and t1.a = 50 and t1.b <= 100; +b a a b +0 0 1 1 +1 1 2 2 +2 2 3 3 +3 3 4 4 +4 4 5 5 +5 5 6 6 +6 6 7 7 +7 7 8 8 +8 8 9 9 +9 9 10 10 +set optimizer_use_condition_selectivity=2; +explain extended select t1.b,t2.a,t3.a,t3.b from t1,t2,t3 +where t1.c = t2.a AND t1.d = t3.a and t1.a = 50 and t1.b <= 100; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 range a a 10 NULL 9 9.00 Using index condition; Using where +1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t1.d 1 100.00 +1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 test.t1.c 1 100.00 Using index +Warnings: +Note 1003 select `test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b` from `test`.`t1` join `test`.`t2` join `test`.`t3` where ((`test`.`t2`.`a` = `test`.`t1`.`c`) and (`test`.`t3`.`a` = `test`.`t1`.`d`) and (`test`.`t1`.`a` = 50) and (`test`.`t1`.`b` <= 100)) +select t1.b,t2.a,t3.a,t3.b from t1,t2,t3 +where t1.c = t2.a AND t1.d = t3.a and t1.a = 50 and t1.b <= 100; +b a a b +0 0 1 1 +1 1 2 2 +2 2 3 3 +3 3 4 4 +4 4 5 5 +5 5 6 6 +6 6 7 7 +7 7 8 8 +8 8 9 9 +9 9 10 10 +set optimizer_use_condition_selectivity= @@optimizer_use_condition_selectivity; +drop table t1,t2,t3; # End of 10.1 tests diff --git a/mysql-test/r/selectivity_innodb.result b/mysql-test/r/selectivity_innodb.result index 719156a77de..70ddd5bf1a9 100644 --- a/mysql-test/r/selectivity_innodb.result +++ b/mysql-test/r/selectivity_innodb.result @@ -1763,6 +1763,63 @@ a 1991 set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; DROP TABLE t1; +# +# MDEV-20424: New default value for optimizer_use_condition-selectivity +# leads to bad plan +# +create table t1(a int, b int, c int, d int, key(a,b)); +insert into t1 select 50,seq-1,seq-1,seq from seq_1_to_10; +insert into t1 select seq-1,seq-1,seq-1,seq from seq_1_to_100 limit 90; +create table t2(a int, b int, c int, primary key(a)); +insert into t2 select seq-1,seq-1,seq-1 from seq_1_to_100; +create table t3(a int, b int, c int, primary key(a)); +insert into t3 select seq-1,seq-1,seq-1 from seq_1_to_100 limit 30; +set optimizer_use_condition_selectivity=1; +explain extended select t1.b,t2.a,t3.a,t3.b from t1,t2,t3 +where t1.c = t2.a AND t1.d = t3.a and t1.a = 50 and t1.b <= 100; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 range a a 10 NULL 11 100.00 Using index condition; Using where +1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t1.d 1 100.00 +1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 test.t1.c 1 100.00 Using index +Warnings: +Note 1003 select `test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b` from `test`.`t1` join `test`.`t2` join `test`.`t3` where ((`test`.`t2`.`a` = `test`.`t1`.`c`) and (`test`.`t3`.`a` = `test`.`t1`.`d`) and (`test`.`t1`.`a` = 50) and (`test`.`t1`.`b` <= 100)) +select t1.b,t2.a,t3.a,t3.b from t1,t2,t3 +where t1.c = t2.a AND t1.d = t3.a and t1.a = 50 and t1.b <= 100; +b a a b +0 0 1 1 +1 1 2 2 +2 2 3 3 +3 3 4 4 +4 4 5 5 +5 5 6 6 +6 6 7 7 +7 7 8 8 +8 8 9 9 +9 9 10 10 +set optimizer_use_condition_selectivity=2; +explain extended select t1.b,t2.a,t3.a,t3.b from t1,t2,t3 +where t1.c = t2.a AND t1.d = t3.a and t1.a = 50 and t1.b <= 100; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 range a a 10 NULL 11 11.00 Using index condition; Using where +1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t1.d 1 100.00 +1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 test.t1.c 1 100.00 Using index +Warnings: +Note 1003 select `test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b` from `test`.`t1` join `test`.`t2` join `test`.`t3` where ((`test`.`t2`.`a` = `test`.`t1`.`c`) and (`test`.`t3`.`a` = `test`.`t1`.`d`) and (`test`.`t1`.`a` = 50) and (`test`.`t1`.`b` <= 100)) +select t1.b,t2.a,t3.a,t3.b from t1,t2,t3 +where t1.c = t2.a AND t1.d = t3.a and t1.a = 50 and t1.b <= 100; +b a a b +0 0 1 1 +1 1 2 2 +2 2 3 3 +3 3 4 4 +4 4 5 5 +5 5 6 6 +6 6 7 7 +7 7 8 8 +8 8 9 9 +9 9 10 10 +set optimizer_use_condition_selectivity= @@optimizer_use_condition_selectivity; +drop table t1,t2,t3; # End of 10.1 tests set optimizer_switch=@save_optimizer_switch_for_selectivity_test; set @tmp_ust= @@use_stat_tables; diff --git a/mysql-test/t/selectivity.test b/mysql-test/t/selectivity.test index 0deacc390db..a93ad5efb07 100644 --- a/mysql-test/t/selectivity.test +++ b/mysql-test/t/selectivity.test @@ -1205,5 +1205,34 @@ set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivit DROP TABLE t1; +--echo # +--echo # MDEV-20424: New default value for optimizer_use_condition-selectivity +--echo # leads to bad plan +--echo # + +create table t1(a int, b int, c int, d int, key(a,b)); +insert into t1 select 50,seq-1,seq-1,seq from seq_1_to_10; +insert into t1 select seq-1,seq-1,seq-1,seq from seq_1_to_100 limit 90; + +create table t2(a int, b int, c int, primary key(a)); +insert into t2 select seq-1,seq-1,seq-1 from seq_1_to_100; + +create table t3(a int, b int, c int, primary key(a)); +insert into t3 select seq-1,seq-1,seq-1 from seq_1_to_100 limit 30; + +let $query= select t1.b,t2.a,t3.a,t3.b from t1,t2,t3 +where t1.c = t2.a AND t1.d = t3.a and t1.a = 50 and t1.b <= 100; + +set optimizer_use_condition_selectivity=1; +eval explain extended $query; +eval $query; + +set optimizer_use_condition_selectivity=2; +eval explain extended $query; +eval $query; +set optimizer_use_condition_selectivity= @@optimizer_use_condition_selectivity; + +drop table t1,t2,t3; + --echo # End of 10.1 tests -- cgit v1.2.1 From e1a2b12577680ad365d297dcf617752d9d42e110 Mon Sep 17 00:00:00 2001 From: Elena Stepanova Date: Sun, 3 Nov 2019 17:59:48 +0200 Subject: List of unstable tests for 10.3.19 release --- mysql-test/unstable-tests | 305 ++++++++++++++++++++++++---------------------- 1 file changed, 161 insertions(+), 144 deletions(-) (limited to 'mysql-test') diff --git a/mysql-test/unstable-tests b/mysql-test/unstable-tests index b3719d00057..8a8eca4dc67 100644 --- a/mysql-test/unstable-tests +++ b/mysql-test/unstable-tests @@ -23,7 +23,7 @@ # ############################################################################## # -# Based on 10.3 f80e02e043103ab4e6ca12d9efffec6eb9aa3b74 +# Based on 10.3 9c6fec88b10bfe51d87f63e6a6ea474cd18d1952 main.alter_table : Modified in 10.3.18 main.alter_table_mdev539_maria : Include file modified in 10.3.18 @@ -36,16 +36,16 @@ main.analyze_stmt_orderby : Modified in 10.3.18 main.analyze_stmt_privileges2 : Modified in 10.3.18 main.analyze_stmt_slow_query_log : MDEV-12237 - Wrong result main.auth_named_pipe : MDEV-14724 - System error 2 +main.auto_increment_ranges_innodb : Include file modified in 10.3.19 +main.auto_increment_ranges_myisam : Include file modified in 10.3.19 main.bootstrap : Modified in 10.3.18 main.bug13633383 : Modified in 10.3.18 main.cast : Modified in 10.2.27 -main.charset_client_win : Added in 10.3.17 -main.column_compression : Modified in 10.3.17 +main.compare : Modified in 10.3.19 main.compound : Modified in 10.3.18 main.compress : Include file modified in 10.3.18 main.connect : MDEV-17282 - Wrong result main.connect2 : MDEV-13885 - Server crash -main.connect_debug : Modified in 10.3.17 main.constraints : Modified in 10.3.18 main.count_distinct2 : MDEV-11768 - timeout main.create : Modified in 10.3.18 @@ -55,12 +55,14 @@ main.cte_nonrecursive : Modified in 10.3.18 main.cte_recursive : Modified in 10.3.18 main.ctype_create : Modified in 10.2.27 main.ctype_latin1_de : Modified in 10.2.27 +main.ctype_uca : Include file modified in 10.3.19 +main.ctype_uca_innodb : Include file modified in 10.3.19 main.ctype_ucs : MDEV-17681 - Data too long for column main.ctype_upgrade : MDEV-16945 - Error upon mysql_upgrade main.ctype_utf16 : MDEV-10675: timeout or extra warnings main.ctype_utf16_def : Configuration modified in 10.3.18 main.ctype_utf16le : MDEV-10675: timeout or extra warnings -main.ctype_utf8 : Modified in 10.3.18 +main.ctype_utf8 : Include file modified in 10.3.19 main.ctype_utf8mb4 : Modified in 10.3.18 main.ctype_utf8mb4_heap : Include file modified in 10.3.18 main.ctype_utf8mb4_innodb : MDEV-17744 - Timeout; MDEV-18567 - ASAN use-after-poison; include file modified in 10.3.18 @@ -75,7 +77,8 @@ main.derived_split_innodb : Modified in 10.3.18 main.derived_view : Modified in 10.3.18 main.dirty_close : MDEV-19368 - mysqltest failed but provided no output main.distinct : MDEV-14194 - Crash; modified in 10.3.18 -main.drop_bad_db_type : MDEV-15676 - Wrong result +main.drop_bad_db_type : MDEV-15676 - Wrong result; modified in 10.3.19 +main.drop_debug : Modified in 10.1.42 main.dyncol : MDEV-19455 - Extra warning; modified in 10.3.18 main.events_1 : Modified in 10.3.18 main.events_2 : MDEV-13277 - Crash; modified in 10.3.18 @@ -89,8 +92,9 @@ main.flush : MDEV-19368 - mysqltest failed but provid main.flush2 : Modified in 10.2.27 main.func_hybrid_type : Modified in 10.3.18 main.func_isnull : Modified in 10.3.18 -main.func_math : MDEV-20532 - Floating point differences; modified in 10.3.18 -main.func_misc : Modified in 10.3.18 +main.func_json : Modified in 10.3.19 +main.func_math : MDEV-20532 - Floating point differences; modified in 10.3.19 +main.func_misc : Modified in 10.3.19 main.func_str : Modified in 10.3.18 main.function_defaults : Modified in 10.3.18 main.gis : MDEV-13411 - wrong result on P8 @@ -107,9 +111,11 @@ main.handlersocket : Configuration added in 10.3.18 main.host_cache_size_functionality : MDEV-10606 - sporadic failure on shutdown main.index_intersect : Modified in 10.3.18 main.index_intersect_innodb : MDEV-10643 - failed with timeout -main.index_merge_innodb : MDEV-7142 - Plan mismatch +main.index_merge_innodb : MDEV-7142 - Plan mismatch; modified in 10.3.19 +main.index_merge_myisam : Modified in 10.3.19 main.information_schema : Modified in 10.3.18 main.information_schema-big : Modified in 10.3.18 +main.information_schema_db : Modified in 10.3.19 main.information_schema_parameters : Modified in 10.3.18 main.information_schema_routines : Modified in 10.3.18 main.innodb_ext_key : Modified in 10.3.18 @@ -120,10 +126,9 @@ main.invisible_field_debug : Modified in 10.3.18 main.join : Modified in 10.3.18 main.join_cache : MDEV-17743 - Bad address from storage engine MyISAM; modified in 10.3.18 main.join_nested_jcl6 : Modified in 10.3.18 -main.join_outer : Modified in 10.3.17 +main.join_outer : Modified in 10.2.27 main.join_outer_innodb : Modified in 10.3.18 main.join_outer_jcl6 : Modified in 10.3.18 -main.keywords : Modified in 10.3.17 main.kill : Modified in 10.3.18 main.kill-2 : MDEV-13257 - Wrong result main.kill_processlist-6619 : MDEV-10793 - Wrong result @@ -131,6 +136,7 @@ main.limit_rows_examined : Modified in 10.3.18 main.loaddata : MDEV-19368 - mysqltest failed but provided no output main.locale : MDEV-20521 - Missing warning main.log_slow : MDEV-13263 - Wrong result; modified in 10.3.18 +main.log_slow_debug : Modified in 10.3.19 main.log_tables-big : MDEV-13408 - wrong result main.mdev-504 : MDEV-15171 - warning main.mdev13607 : Modified in 10.3.18 @@ -139,7 +145,7 @@ main.merge : MDEV-10607 - sporadic "can't connect"; m main.mrr_icp_extra : Modified in 10.3.18 main.multi_update : Modified in 10.3.18 main.multi_update_debug : MDEV-20136 - Debug sync point wait timed out -main.myisam : Modified in 10.3.18 +main.myisam : Modified in 10.3.19 main.myisam_explain_non_select_all : Modified in 10.3.18 main.myisam_icp : Modified in 10.3.18 main.myisam_mrr : Modified in 10.3.18 @@ -151,13 +157,11 @@ main.mysql_comments : Modified in 10.3.18 main.mysql_upgrade_noengine : MDEV-14355 - Wrong result main.mysql_upgrade_ssl : MDEV-13492 - Unknown SSL error main.mysqlcheck : Modified in 10.3.18 -main.mysqld--help : Modified in 10.3.17 main.mysqldump : MDEV-14800 - Stack smashing detected; modified in 10.3.18 main.mysqldump-compat-102 : Modified in 10.3.18 main.mysqldump-max : Modified in 10.2.27 main.mysqldump-nl : Modified in 10.3.18 main.mysqldump-utf8mb4 : Modified in 10.3.18 -main.mysqldump_restore : Modified in 10.3.17 main.mysqlhotcopy_myisam : MDEV-10995 - Hang on debug main.mysqlslap : MDEV-11801 - timeout main.mysqltest : MDEV-13887 - Wrong result @@ -166,24 +170,27 @@ main.old-mode : MDEV-19373 - Wrong result main.openssl_1 : MDEV-13492 - Unknown SSL error; modified in 10.3.18 main.openssl_6975 : MDEV-17184 - Failures with OpenSSL 1.1.1 main.opt_tvc : Modified in 10.3.18 +main.order_by_innodb : Modified in 10.3.19 main.order_by_optimizer_innodb : MDEV-10683 - Wrong result -main.partition_debug_sync : MDEV-15669 - Deadlock found when trying to get lock +main.partition_debug_sync : MDEV-15669 - Deadlock found when trying to get lock; modified in 10.3.19 main.partition_example : Configuration added in 10.3.18 -main.partition_innodb : Modified in 10.3.18 +main.partition_innodb : Modified in 10.3.19 main.partition_innodb_plugin : MDEV-12901 - Valgrind warnings main.partition_innodb_semi_consistent : MDEV-19411 - Failed to start mysqld.1 main.partition_key_cache : Modified in 10.2.27 main.partition_pruning : Modified in 10.3.18 main.partition_range : Modified in 10.3.18 +main.partition_ucs2 : Added in 10.3.19 +main.partition_utf8 : Modified in 10.3.19 main.plugin : Configuration added in 10.3.18 -main.plugin_auth : Modified in 10.3.17 main.plugin_innodb : Configuration added in 10.3.18 main.plugin_load : Configuration modified in 10.3.18 main.plugin_load_option : Configuration modified in 10.3.18 main.plugin_not_embedded : Configuration added in 10.3.18 main.pool_of_threads : MDEV-18135 - SSL error: key too small; modified in 10.3.18 +main.processlist : Modified in 10.3.19 +main.processlist_notembedded : Added in 10.3.19 main.ps : MDEV-11017 - Sporadic wrong Prepared_stmt_count; configuration modified in 10.3.18 -main.ps_innodb : Added in 10.3.17 main.query_cache : MDEV-16180 - Wrong result main.query_cache_debug : MDEV-15281 - Query cache is disabled; modified in 10.3.18 main.query_cache_notembedded : Modified in 10.3.18 @@ -194,12 +201,11 @@ main.range_mrr_icp : Modified in 10.3.18 main.range_vs_index_merge : Modified in 10.3.18 main.range_vs_index_merge_innodb : MDEV-15283 - Server has gone away main.repair : Modified in 10.3.18 -main.repair_symlink-5543 : Modified in 10.3.17 main.schema : Modified in 10.3.18 main.select : MDEV-20532 - Floating point differences; modified in 10.3.18 main.select_jcl6 : MDEV-20532 - Floating point differences main.select_pkeycache : MDEV-20532 - Floating point differences -main.selectivity : Modified in 10.3.18 +main.selectivity : Modified in 10.3.19 main.selectivity_innodb : Modified in 10.3.18 main.selectivity_no_engine : Modified in 10.3.18 main.set_statement : MDEV-13183 - Wrong result @@ -208,8 +214,9 @@ main.shm : MDEV-12727 - Mismatch, ERROR 2013; inclu main.show_bad_definer-5553 : Modified in 10.3.18 main.show_check : Modified in 10.3.18 main.show_explain : MDEV-10674 - Wrong result code -main.sp : MDEV-7866 - Mismatch; modified in 10.3.18 +main.sp : MDEV-7866 - Mismatch; modified in 10.3.19 main.sp-anchor-type : Modified in 10.3.18 +main.sp-code : Modified in 10.3.19 main.sp-error : Modified in 10.3.18 main.sp-security : MDEV-10607 - sporadic "can't connect"; modified in 10.3.18 main.sp_notembedded : MDEV-10607 - internal error @@ -221,13 +228,13 @@ main.ssl_compress : Modified in 10.3.18 main.ssl_connect : MDEV-13492 - Unknown SSL error main.ssl_crl : MDEV-19119 - Wrong error code main.ssl_timeout : MDEV-11244 - Crash -main.stat_tables : Modified in 10.3.18 +main.stat_tables : Modified in 10.3.19 main.stat_tables-enospc : Modified in 10.3.18 main.stat_tables_par : MDEV-13266 - Wrong result main.stat_tables_par_innodb : MDEV-14155 - Wrong rounding main.statistics : Modified in 10.3.18 main.status : MDEV-13255 - Wrong result -main.subselect : Modified in 10.3.18 +main.subselect : MDEV-20551 - Valgrind failure; modified in 10.3.18 main.subselect2 : Modified in 10.3.18 main.subselect3 : Modified in 10.3.18 main.subselect3_jcl6 : Modified in 10.3.18 @@ -237,16 +244,18 @@ main.subselect_extra : Modified in 10.3.18 main.subselect_innodb : MDEV-10614 - Wrong result main.subselect_mat_cost : Modified in 10.3.18 main.subselect_mat_cost_bugs : Modified in 10.3.18 -main.subselect_sj : Modified in 10.3.18 +main.subselect_sj : Modified in 10.3.19 main.subselect_sj2 : Modified in 10.2.27 main.subselect_sj2_jcl6 : Modified in 10.3.18 main.subselect_sj2_mat : Modified in 10.3.18 main.subselect_sj_jcl6 : Modified in 10.3.18 main.subselect_sj_mat : Modified in 10.3.18 main.subselect_sj_nonmerged : Modified in 10.3.18 +main.sum_distinct-big : Modified in 10.3.19 main.system_mysql_db_fix50117 : Modified in 10.3.18 main.system_time_debug : Added in 10.3.18 main.table_options-5867 : Configuration added in 10.3.18 +main.table_value_constr : Modified in 10.3.19 main.tc_heuristic_recover : MDEV-14189 - Wrong result main.trigger : Modified in 10.3.18 main.trigger-compat : Modified in 10.3.18 @@ -258,6 +267,7 @@ main.type_datetime : Modified in 10.3.18 main.type_datetime_hires : MDEV-10687 - Timeout main.type_float : MDEV-20532 - Floating point differences main.type_int : Modified in 10.3.18 +main.type_newdecimal : Modified in 10.3.19 main.type_time_6065 : Modified in 10.3.18 main.type_varchar : Configuration added in 10.3.18 main.union : Modified in 10.3.18 @@ -286,40 +296,44 @@ archive-test_sql_discovery.discover : MDEV-16817 - Table marked as crashed #----------------------------------------------------------------------- -binlog.binlog_commit_wait : MDEV-10150 - Mismatch -binlog.binlog_innodb : Configuration added in 10.3.18 -binlog.binlog_killed : MDEV-12925 - Wrong result -binlog.binlog_max_extension : MDEV-19762 - Crash on shutdown; modified in 10.3.18 -binlog.binlog_mixed_cache_stat : Include file modified in 10.3.18 -binlog.binlog_mysqlbinlog2 : Modified in 10.2.27 -binlog.binlog_mysqlbinlog_row_innodb : MDEV-20530 - Binary files differ -binlog.binlog_mysqlbinlog_row_myisam : MDEV-20530 - Binary files differ -binlog.binlog_mysqlbinlog_stop_never : Added in 10.3.17 -binlog.binlog_parallel_replication_marks_row : Include file modified in 10.3.17 -binlog.binlog_parallel_replication_marks_stm_mix : Include file modified in 10.3.17 -binlog.binlog_row_cache_stat : Include file modified in 10.3.18 -binlog.binlog_row_drop_tmp_tbl : Include file modified in 10.3.18 -binlog.binlog_stm_cache_stat : Include file modified in 10.3.18 -binlog.binlog_stm_drop_tmp_tbl : Include file modified in 10.3.18 -binlog.binlog_xa_recover : MDEV-8517 - Extra checkpoint -binlog.flashback-largebinlog : MDEV-19764 - Out of memory; modified in 10.3.18 -binlog.load_data_stm_view : MDEV-16948 - Wrong result +binlog.binlog_commit_wait : MDEV-10150 - Mismatch +binlog.binlog_innodb : Configuration added in 10.3.18 +binlog.binlog_killed : MDEV-12925 - Wrong result +binlog.binlog_max_extension : MDEV-19762 - Crash on shutdown; modified in 10.3.18 +binlog.binlog_mixed_cache_stat : Include file modified in 10.3.18 +binlog.binlog_mysqlbinlog2 : Modified in 10.2.27 +binlog.binlog_mysqlbinlog_row : Modified in 10.3.19 +binlog.binlog_mysqlbinlog_row_innodb : MDEV-20530 - Binary files differ +binlog.binlog_mysqlbinlog_row_myisam : MDEV-20530 - Binary files differ +binlog.binlog_row_cache_stat : Include file modified in 10.3.18 +binlog.binlog_row_drop_tmp_tbl : Include file modified in 10.3.18 +binlog.binlog_stm_cache_stat : Include file modified in 10.3.18 +binlog.binlog_stm_drop_tmp_tbl : Include file modified in 10.3.18 +binlog.binlog_xa_recover : MDEV-8517 - Extra checkpoint +binlog.flashback-largebinlog : MDEV-19764 - Out of memory; modified in 10.3.18 +binlog.load_data_stm_view : MDEV-16948 - Wrong result +binlog.read_only : Added in 10.3.19 +binlog.read_only_statement : Added in 10.3.19 #----------------------------------------------------------------------- +binlog_encryption.binlog_mdev_20574_old_binlog : Added in 10.3.19 binlog_encryption.binlog_xa_recover : MDEV-12908 - Extra checkpoint binlog_encryption.encrypted_master : MDEV-14201 - Extra warnings binlog_encryption.encrypted_master_switch_to_unencrypted : MDEV-14190 - Can't init tc log binlog_encryption.encrypted_slave : MDEV-18135 - SSL error: key too small binlog_encryption.encryption_combo : MDEV-14199 - Table is marked as crashed -binlog_encryption.rpl_binlog_errors : MDEV-12742 - Crash +binlog_encryption.mysqlbinlog : Modified in 10.3.19 +binlog_encryption.rpl_binlog_errors : MDEV-12742 - Crash; include file modified in 10.3.19 binlog_encryption.rpl_checksum : MDEV-16951 - Wrong result +binlog_encryption.rpl_corruption : MDEV-20953 - Wrong error code binlog_encryption.rpl_gtid_basic : MDEV-16947 - Server failed to start binlog_encryption.rpl_loadfile : MDEV-16645 - Timeout in include binlog_encryption.rpl_parallel : MDEV-10653 - Timeout in include +binlog_encryption.rpl_parallel_ignored_errors : Added in 10.3.19 binlog_encryption.rpl_relayrotate : MDEV-15194 - Timeout binlog_encryption.rpl_semi_sync : MDEV-11673 - Valgrind -binlog_encryption.rpl_skip_replication : MDEV-13571 - Unexpected warning +binlog_encryption.rpl_skip_replication : MDEV-13571 - Unexpected warning; MDEV-20573 - Wrong result binlog_encryption.rpl_ssl : MDEV-14507 - Timeouts binlog_encryption.rpl_stm_relay_ign_space : MDEV-19375 - Test assertion failed binlog_encryption.rpl_sync : MDEV-13830 - Assertion failure @@ -327,9 +341,6 @@ binlog_encryption.rpl_typeconv : MDEV-14362 - Lost con #----------------------------------------------------------------------- -compat/oracle.column_compression : Modified in 10.3.17 -compat/oracle.keywords : Added in 10.3.17 -compat/oracle.mysqldump_restore : Added in 10.3.17 compat/oracle.sp : Modified in 10.3.18 compat/oracle.sp-package : Modified in 10.3.18 compat/oracle.sp-package-mysqldump : Modified in 10.3.18 @@ -340,43 +351,45 @@ compat/oracle.type_blob : Modified in 10.3.18 connect.alter : MDEV-18135 - SSL error: key too small connect.drop-open-error : MDEV-18135 - SSL error: key too small +connect.grant : Modified in 10.3.19 +connect.grant2 : Modified in 10.3.19 +connect.ini_grant : Modified in 10.3.19 connect.json : MDEV-18135 - SSL error: key too small +connect.mysql_grant : Modified in 10.3.19 connect.part_file : MDEV-18135 - SSL error: key too small connect.part_table : MDEV-18135 - SSL error: key too small connect.pivot : MDEV-14803 - Failed to discover table connect.secure_file_priv : MDEV-18135 - SSL error: key too small connect.vcol : MDEV-12374 - Fails on Windows +connect.xml2_grant : Include file modified in 10.3.19 +connect.xml_grant : Include file modified in 10.3.19 connect.zip : MDEV-13884 - Wrong result #----------------------------------------------------------------------- -disks.disks_notembedded : Added in 10.3.17 - -#----------------------------------------------------------------------- - encryption.create_or_replace : MDEV-12694 - Timeout; MDEV-16115 - Trying to access tablespace encryption.debug_key_management : MDEV-13841 - Timeout encryption.encrypt_and_grep : MDEV-13765 - Wrong result encryption.file_creation : Added in 10.3.18 -encryption.innochecksum : MDEV-13644 - Assertion failure; modified in 10.3.17 +encryption.innochecksum : MDEV-13644 - Assertion failure encryption.innodb-bad-key-change2 : MDEV-19118 - Can't connect to local MySQL server through socket -encryption.innodb-checksum-algorithm : MDEV-12898 - Deadlock of threads; MDEV-16896 - Server crash +encryption.innodb-checksum-algorithm : MDEV-16896 - Server crash encryption.innodb-compressed-blob : MDEV-14728 - Unable to get certificate encryption.innodb-discard-import : MDEV-19113 - Timeout -encryption.innodb-encryption-alter : MDEV-13566 - Lock wait timeout; modified in 10.3.17 +encryption.innodb-encryption-alter : MDEV-13566 - Lock wait timeout encryption.innodb-first-page-read : MDEV-14356 - Timeout in wait condition encryption.innodb-force-corrupt : MDEV-17286 - SSL error encryption.innodb-missing-key : MDEV-14728 - SSL error encryption.innodb-page_encryption : MDEV-10641 - mutex problem encryption.innodb-page_encryption_log_encryption : MDEV-17339 - Crash on restart encryption.innodb-read-only : MDEV-16563 - Crash on startup -encryption.innodb-redo-badkey : MDEV-12898 - Server hang on startup +encryption.innodb-redo-badkey : Re-enabled in 10.3.19; modified in 10.3.19 encryption.innodb-remove-encryption : MDEV-16493 - Timeout in wait condition encryption.innodb-spatial-index : MDEV-13746 - Wrong result encryption.innodb_encrypt_key_rotation_age : MDEV-19763 - Timeout encryption.innodb_encrypt_log : MDEV-13725 - Wrong result encryption.innodb_encrypt_log_corruption : Configuration modified in 10.3.18 -encryption.innodb_encrypt_temporary_tables : MDEV-20142 - Wrong result; added in 10.3.17 +encryption.innodb_encrypt_temporary_tables : MDEV-20142 - Wrong result encryption.innodb_encryption : MDEV-15675 - Timeout encryption.innodb_encryption-page-compression : MDEV-12630 - crash or assertion failure encryption.innodb_encryption_discard_import : MDEV-16116 - Wrong result @@ -410,13 +423,14 @@ federated.federated_innodb : MDEV-10617 - Wrong checksum federated.federated_partition : MDEV-10417 - Fails on Mips federated.federated_transactions : MDEV-10617 - Wrong checksum federated.federatedx : MDEV-10617 - Wrong checksum -federated.federatedx_versioning : Modified in 10.3.18 +federated.federatedx_versioning : Modified in 10.3.19 #----------------------------------------------------------------------- funcs_1.innodb_storedproc_07 : Include file modified in 10.3.18 funcs_1.innodb_storedproc_08 : Include file modified in 10.3.18 funcs_1.innodb_trig_03e : Modified in 10.3.18 +funcs_1.is_basics_mixed : Modified in 10.3.19 funcs_1.is_columns : Modified in 10.3.18 funcs_1.is_columns_innodb : Modified in 10.3.18 funcs_1.is_columns_memory : Modified in 10.3.18 @@ -470,42 +484,38 @@ gcol.gcol_select_innodb : Include file modified in 10.2.27 gcol.gcol_select_myisam : Include file modified in 10.2.27 gcol.innodb_virtual_basic : MDEV-16950 - Failing assertion; modified in 10.3.18 gcol.innodb_virtual_debug : MDEV-19114 - Assertion failure -gcol.innodb_virtual_debug_purge : MDEV-16952 - Wrong result +gcol.innodb_virtual_debug_purge : MDEV-16952 - Wrong result; modified in 10.3.19 gcol.innodb_virtual_fk_restart : MDEV-17466 - Assertion failure gcol.innodb_virtual_index : Modified in 10.3.18 -gcol.innodb_virtual_purge : Modified in 10.2.25 #----------------------------------------------------------------------- innodb.101_compatibility : MDEV-13891 - Wrong result +innodb.alter_algorithm : Modified in 10.3.19 innodb.alter_copy : MDEV-16181 - Assertion failure; modified in 10.3.18 innodb.alter_crash : MDEV-16944 - The process cannot access the file -innodb.alter_large_dml : MDEV-20148 - Debug sync point wait timed out; added in 10.3.17 -innodb.alter_missing_tablespace : Modified in 10.3.17 +innodb.alter_large_dml : MDEV-20148 - Debug sync point wait timed out innodb.auto_increment_dup : Modified in 10.3.18 innodb.autoinc_persist : MDEV-15282 - Assertion failure innodb.binlog_consistent : MDEV-10618 - Server fails to start -innodb.blob-crash : Added in 10.3.17 -innodb.check_ibd_filesize : Added in 10.3.17 -innodb.create_select : Added in 10.3.17 +innodb.blob-crash : MDEV-20481 - Crash during recovery innodb.doublewrite : MDEV-12905 - Server crash innodb.foreign-keys : Modified in 10.3.18 innodb.foreign_key : Modified in 10.3.18 innodb.group_commit_crash : MDEV-14191 - InnoDB registration failed innodb.group_commit_crash_no_optimize_thread : MDEV-13830 - Assertion failure -innodb.ibuf_not_empty : MDEV-19021 - Wrong result -innodb.innodb-16k : Modified in 10.3.17 -innodb.innodb-32k : Modified in 10.3.17 -innodb.innodb-32k-crash : MDEV-16953 - Corrupt log record found; MDEV-20194 - Extra warning; modified in 10.3.17 -innodb.innodb-64k-crash : MDEV-13872 - Failure and crash on startup; modified in 10.3.17 +innodb.ibuf_not_empty : MDEV-19021 - Wrong result; modified in 10.3.19 +innodb.information_schema_grants : Added in 10.3.19 +innodb.innodb-32k-crash : MDEV-20194 - Extra warning +innodb.innodb-64k-crash : MDEV-13872 - Failure and crash on startup innodb.innodb-alter : Modified in 10.3.18 innodb.innodb-alter-debug : MDEV-13182 - InnoDB: adjusting FSP_SPACE_FLAGS +innodb.innodb-alter-nullable : Modified in 10.3.19 innodb.innodb-alter-table : MDEV-10619 - Testcase timeout -innodb.innodb-alter-tempfile : MDEV-15285 - Table already exists -innodb.innodb-autoinc : Modified in 10.3.17 +innodb.innodb-autoinc : Modified in 10.3.19 innodb.innodb-bigblob : MDEV-18655 - ASAN unknown crash innodb.innodb-blob : MDEV-12053 - Client crash -innodb.innodb-change-buffer-recovery : MDEV-19115 - Lost connection to MySQL server during query +innodb.innodb-change-buffer-recovery : MDEV-19115 - Lost connection to MySQL server during query; modified in 10.3.19 innodb.innodb-fk : MDEV-13832 - Assertion failure on shutdown innodb.innodb-fkcheck : Modified in 10.3.18 innodb.innodb-get-fk : MDEV-13276 - Server crash; modified in 10.3.18 @@ -519,15 +529,13 @@ innodb.innodb-page_compression_zip : MDEV-10641 - mutex problem innodb.innodb-read-view : Added in 10.3.18 innodb.innodb-system-table-view : Modified in 10.3.18 innodb.innodb-table-online : MDEV-13894 - Wrong result -innodb.innodb-virtual-columns-debug : MDEV-20143 - Wrong result; added in 10.3.17 +innodb.innodb-virtual-columns-debug : Modified in 10.3.19 innodb.innodb-wl5522 : MDEV-13644 - Assertion failure innodb.innodb-wl5522-debug : MDEV-14200 - Wrong errno; modified in 10.3.18 -innodb.innodb-wl5980-debug : Added in 10.3.17 -innodb.innodb_buffer_pool_dump_pct : MDEV-20139 - Timeout in wait_condition.inc; added in 10.3.17 +innodb.innodb_buffer_pool_dump_pct : MDEV-20139 - Timeout in wait_condition.inc innodb.innodb_buffer_pool_resize : MDEV-16964 - Assertion failure innodb.innodb_buffer_pool_resize_with_chunks : MDEV-16964 - Assertion failure innodb.innodb_bug14147491 : MDEV-11808 - Index is corrupt -innodb.innodb_bug14704286 : Deleted in 10.3.18 innodb.innodb_bug30423 : MDEV-7311 - Wrong result innodb.innodb_bug47167 : MDEV-20524 - Table 'user' is marked as crashed and should be repaired innodb.innodb_bug48024 : MDEV-14352 - Assertion failure @@ -538,54 +546,48 @@ innodb.innodb_bulk_create_index_debug : Include file modified in 10.3.18 innodb.innodb_bulk_create_index_flush : Configuration added in 10.3.18 innodb.innodb_bulk_create_index_replication : MDEV-15273 - Slave failed to start innodb.innodb_defrag_stats_many_tables : MDEV-14198 - Table is full +innodb.innodb_force_recovery : Modified in 10.3.19 innodb.innodb_information_schema : MDEV-8851 - Wrong result -innodb.innodb_max_recordsize_32k : MDEV-14801 - Operation failed; modified in 10.3.17 -innodb.innodb_max_recordsize_64k : MDEV-15203 - Wrong result; modified in 10.3.17 +innodb.innodb_max_recordsize_32k : MDEV-14801 - Operation failed +innodb.innodb_max_recordsize_64k : MDEV-15203 - Wrong result innodb.innodb_monitor : MDEV-10939 - Testcase timeout -innodb.innodb_mysql : MDEV-19873 - Wrong result; modified in 10.3.17 +innodb.innodb_mysql : MDEV-19873 - Wrong result innodb.innodb_simulate_comp_failures_small : MDEV-20526 - ASAN use-after-poison innodb.innodb_stats : MDEV-10682 - wrong result -innodb.innodb_stats_persistent : MDEV-17745 - Wrong result +innodb.innodb_stats_persistent : MDEV-17745 - Wrong result; modified in 10.3.19 innodb.innodb_stats_persistent_debug : MDEV-14801 - Operation failed innodb.innodb_sys_semaphore_waits : MDEV-10331 - Semaphore wait innodb.innodb_zip_innochecksum2 : MDEV-13882 - Warning: difficult to find free blocks innodb.instant_alter : Modified in 10.3.18 -innodb.instant_alter_bugs : Modified in 10.3.17 -innodb.instant_alter_debug : Modified in 10.3.17 +innodb.instant_alter_bugs : Modified in 10.3.19 innodb.log_alter_table : Configuration added in 10.3.18 innodb.log_corruption : MDEV-13251 - Wrong result innodb.log_data_file_size : MDEV-14204 - Server failed to start innodb.log_file_name : MDEV-14193 - Exception innodb.log_file_size : MDEV-15668 - Not found pattern -innodb.max_record_size : Added in 10.3.17 -innodb.missing_tablespaces : Added in 10.3.17 innodb.monitor : MDEV-16179 - Wrong result -innodb.page_id_innochecksum : Added in 10.3.17 -innodb.purge : Added in 10.3.17 innodb.purge_secondary : MDEV-15681 - Wrong result -innodb.purge_secondary_mdev-16222 : MDEV-20528 - Debug sync point wait timed out; added in 10.3.17 +innodb.purge_secondary_mdev-16222 : MDEV-20528 - Debug sync point wait timed out innodb.purge_thread_shutdown : MDEV-13792 - Wrong result innodb.read_only_recovery : MDEV-13886 - Server crash innodb.recovery_shutdown : MDEV-15671 - Checksum mismatch in datafile; modified in 10.3.18 innodb.row_format_redundant : MDEV-15192 - Trying to access missing tablespace -innodb.strict_mode : Modified in 10.3.17 +innodb.stat_tables : Added in 10.3.19 innodb.table_definition_cache_debug : MDEV-14206 - Extra warning innodb.table_flags : MDEV-13572 - Wrong result; MDEV-19374 - Server failed to start -innodb.temp_table_savepoint : MDEV-16182 - Wrong result innodb.temporary_table : MDEV-13265 - Wrong result -innodb.temporary_table_optimization : MDEV-20531 - Wrong result -innodb.truncate_missing : Modified in 10.3.17 +innodb.temporary_table_optimization : Modified in 10.3.19 innodb.trx_id_future : Modified in 10.3.18 -innodb.undo_log : Modified in 10.3.17 -innodb.undo_truncate : MDEV-17340 - Server hung +innodb.undo_truncate : MDEV-17340 - Server hung; MDEV-20840 - Sporadic timeout innodb.undo_truncate_recover : MDEV-17679 - Server has gone away; modified in 10.3.18 innodb.update_time : MDEV-14804 - Wrong result innodb.xa_recovery : MDEV-15279 - mysqld got exception #----------------------------------------------------------------------- -innodb_fts.fulltext2 : Modified in 10.3.17 -innodb_fts.innodb_fts_misc : Modified in 10.3.18 +innodb_fts.concurrent_insert : Modified in 10.3.19 +innodb_fts.crash_recovery : Modified in 10.3.19 +innodb_fts.innodb_fts_misc : Modified in 10.3.19 innodb_fts.innodb_fts_misc_debug : MDEV-14156 - Unexpected warning innodb_fts.innodb_fts_plugin : MDEV-13888 - Errors in server log innodb_fts.innodb_fts_stopword_charset : MDEV-13259 - Table crashed @@ -595,7 +597,6 @@ innodb_fts.sync_ddl : MDEV-18654 - Assertion failure #----------------------------------------------------------------------- innodb_gis.alter_spatial_index : MDEV-13745 - Server crash -innodb_gis.kill_server : MDEV-16941 - Checksum mismatch innodb_gis.rtree_compress2 : MDEV-16269 - Wrong result; modified in 10.3.18 innodb_gis.rtree_concurrent_srch : MDEV-15284 - Wrong result with embedded innodb_gis.rtree_purge : MDEV-15275 - Timeout @@ -616,11 +617,10 @@ innodb_zip.wl6501_scale_1 : MDEV-13254 - Timeout, MDEV-14104 - Error 192 #----------------------------------------------------------------------- -maria.alter : Modified in 10.3.17 maria.icp : Modified in 10.3.18 maria.insert_select : MDEV-12757 - Timeout maria.insert_select-7314 : MDEV-16492 - Timeout -maria.kill : Added in 10.3.17 +maria.lock : Modified in 10.3.19 maria.maria : MDEV-14430 - Extra warning maria.maria-big : Modified in 10.3.18 maria.maria-gis-recovery : Modified in 10.3.18 @@ -629,7 +629,6 @@ maria.maria-recover : Modified in 10.3.18 maria.maria-recovery : Modified in 10.3.18 maria.maria3 : Modified in 10.3.18 maria.partition : Added in 10.3.18 -maria.temporary : Added in 10.3.17 #----------------------------------------------------------------------- @@ -637,12 +636,15 @@ mariabackup.absolute_ibdata_paths : MDEV-16571 - Wrong result mariabackup.apply-log-only : MDEV-20135 - Timeout mariabackup.big_innodb_log : Added in 10.3.18 mariabackup.data_directory : MDEV-15270 - Error on exec +mariabackup.extra_lsndir_stream : Added in 10.3.19 mariabackup.full_backup : MDEV-16571 - Wrong result mariabackup.huge_lsn : MDEV-15662 - Sequence number is in the future; MDEV-18569 - Table doesn't exist mariabackup.incremental_encrypted : MDEV-15667 - timeout +mariabackup.incremental_rocksdb : MDEV-20954 - Cannot access the file mariabackup.log_checksum_mismatch : MDEV-16571 - Wrong result mariabackup.mdev-14447 : MDEV-15201 - Timeout -mariabackup.missing_ibd : Modified in 10.3.17 +mariabackup.mdev-18438 : Added in 10.3.19 +mariabackup.partial : Modified in 10.3.19 mariabackup.partial_exclude : MDEV-15270 - Error on exec mariabackup.unencrypted_page_compressed : MDEV-18653 - Wrong error mariabackup.xb_compressed_encrypted : MDEV-14812 - Segmentation fault @@ -670,7 +672,7 @@ mroonga/wrapper.repair_table_no_index_file : MDEV-14807 - Wrong error message multi_source.gtid : MDEV-14202 - Crash multi_source.info_logs : MDEV-12629 - Valgrind, MDEV-10042 - wrong result -multi_source.mdev-8874 : Re-enabled in 10.3.18; added in 10.3.17 +multi_source.mdev-8874 : Re-enabled in 10.3.18 multi_source.mdev-9544 : MDEV-19415 - AddressSanitizer: heap-use-after-free multi_source.multisource : MDEV-10417 - Fails on Mips multi_source.reset_slave : MDEV-10690 - Wrong result @@ -679,14 +681,15 @@ multi_source.status_vars : MDEV-4632 - failed while waiting for Slave_received_h #----------------------------------------------------------------------- -parts.fulltext : Added in 10.3.17 parts.partition_alter1_1_2_innodb : MDEV-18655 - ASAN unknown crash parts.partition_alter1_1_innodb : MDEV-18655 - ASAN unknown crash parts.partition_alter1_2_innodb : MDEV-18655 - ASAN unknown crash parts.partition_alter2_2_maria : MDEV-14364 - Lost connection to MySQL server during query parts.partition_auto_increment_archive : MDEV-16491 - Marked as crashed and should be repaired parts.partition_auto_increment_maria : MDEV-14430 - Extra warning -parts.partition_debug_innodb : MDEV-10891 - Can't create UNIX socket; MDEV-15095 - Table doesn't exist +parts.partition_debug : Modified in 10.3.19 +parts.partition_debug_innodb : MDEV-10891 - Can't create UNIX socket; MDEV-15095 - Table doesn't exist; modified in 10.3.19 +parts.partition_debug_myisam : Modified in 10.3.19 parts.partition_exch_qa_10 : MDEV-11765 - wrong result parts.partition_exch_qa_4_innodb : Include file modified in 10.3.18 parts.partition_exch_qa_4_myisam : Include file modified in 10.3.18 @@ -706,6 +709,7 @@ parts.partition_mgm_lc2_innodb : Include file modified in 10.3.18 parts.partition_mgm_lc2_memory : Include file modified in 10.3.18 parts.partition_mgm_lc2_myisam : Include file modified in 10.3.18 parts.partition_special_innodb : MDEV-16942 - Timeout +parts.reorganize_partition_innodb : Added in 10.3.19 #----------------------------------------------------------------------- @@ -754,7 +758,7 @@ perfschema_stress.* : MDEV-10996 - Not maintained #----------------------------------------------------------------------- -plugins.feedback_plugin_load : Modified in 10.3.18 +plugins.feedback_plugin_load : Modified in 10.3.19 plugins.feedback_plugin_send : MDEV-7932, MDEV-11118 - Connection problems and such plugins.processlist : MDEV-16574 - Wrong result plugins.qc_info : Modified in 10.3.18 @@ -774,6 +778,7 @@ rocksdb.drop_index_inplace : MDEV-14162 - Crash on shutdown rocksdb.drop_table : MDEV-14308 - Timeout rocksdb.drop_table3 : MDEV-16949 - Server crash rocksdb.dup_key_update : MDEV-17284 - Wrong result +rocksdb.index_merge_rocksdb2 : Include file modified in 10.3.19 rocksdb.locking_issues : MDEV-14464 - Wrong result rocksdb.mariadb_ignore_dirs : MDEV-16639 - Server crash rocksdb.mariadb_port_fixes : MDEV-16387 - Wrong plan @@ -782,9 +787,7 @@ rocksdb.perf_context : MDEV-17285 - Wrong results rocksdb.rocksdb_cf_options : MDEV-16639 - Server crash rocksdb.rocksdb_cf_per_partition : MDEV-16636 - Wrong result rocksdb.rocksdb_parts : MDEV-13843 - Wrong result -rocksdb.ttl_primary_read_filtering : MDEV-16560 - Wrong result rocksdb.ttl_secondary : MDEV-16943 - Timeout -rocksdb.ttl_secondary_read_filtering : MDEV-16560 - Wrong result rocksdb.unique_check : MDEV-16576 - Wrong errno rocksdb.use_direct_reads_writes : MDEV-16646 - Server crash rocksdb.write_sync : MDEV-16965 - WRong result @@ -809,13 +812,12 @@ roles.show_create_database-10463 : Modified in 10.3.18 rpl.circular_serverid0 : MDEV-19372 - ASAN heap-use-after-free rpl.create_or_replace2 : MDEV-19412 - Lost connection to MySQL server -rpl.create_or_replace_mix : Include file modified in 10.3.17 -rpl.create_or_replace_row : Include file modified in 10.3.17 -rpl.create_or_replace_statement : Include file modified in 10.3.17 +rpl.create_or_replace_mix : MDEV-20523 - Wrong result +rpl.create_or_replace_statement : MDEV-20523 - Wrong result rpl.create_select : MDEV-14121 - Assertion failure -rpl.kill_race_condition : Modified in 10.3.17 rpl.last_insert_id : MDEV-10625 - warnings in error log rpl.mdev_17588 : Modified in 10.3.18 +rpl.rpl_000011 : Modified in 10.3.19 rpl.rpl_auto_increment : MDEV-10417 - Fails on Mips rpl.rpl_auto_increment_bug45679 : MDEV-10417 - Fails on Mips rpl.rpl_auto_increment_update_failure : MDEV-10625 - warnings in error log @@ -850,6 +852,8 @@ rpl.rpl_insert_id : MDEV-15197 - Wrong result rpl.rpl_insert_id_pk : MDEV-16567 - Assertion failure rpl.rpl_insert_ignore : MDEV-14365 - Lost connection to MySQL server during query rpl.rpl_invoked_features : MDEV-10417 - Fails on Mips +rpl.rpl_ip_mix : Modified in 10.3.19 +rpl.rpl_ip_mix2 : Modified in 10.3.19 rpl.rpl_ipv4_as_ipv6 : MDEV-20147 - Incorrect checksum for freed object rpl.rpl_known_bugs_detection : Modified in 10.2.27 rpl.rpl_mariadb_slave_capability : MDEV-11018 - Extra lines in binlog @@ -863,6 +867,7 @@ rpl.rpl_non_direct_stm_mixing_engines : MDEV-14489 - Failed sync_slave_with_ma rpl.rpl_parallel : MDEV-10653 - Timeouts rpl.rpl_parallel2 : MDEV-17390 - Operation cannot be performed rpl.rpl_parallel_conflicts : MDEV-15272 - Server crash +rpl.rpl_parallel_ignored_errors : Added in 10.3.19 rpl.rpl_parallel_mdev6589 : MDEV-12979 - Assertion failure rpl.rpl_parallel_multilevel2 : MDEV-14723 - Timeout rpl.rpl_parallel_optimistic : MDEV-15278 - Failed to sync with master @@ -871,11 +876,13 @@ rpl.rpl_parallel_retry : MDEV-11119 - Crash; MDEV-17109 - Timeo rpl.rpl_parallel_temptable : MDEV-10356 - Crash; MDEV-19076 - Wrong result rpl.rpl_partition_innodb : MDEV-10417 - Fails on Mips rpl.rpl_password_boundaries : MDEV-11534 - Slave IO warnings +rpl.rpl_read_only2 : Added in 10.3.19 +rpl.rpl_rotate_logs : Modified in 10.3.19 rpl.rpl_row_001 : MDEV-16653 - MTR's internal check fails rpl.rpl_row_basic_11bugs : MDEV-12171 - Server failed to start rpl.rpl_row_basic_2myisam : MDEV-13875 - command "diff_files" failed rpl.rpl_row_drop_create_temp_table : MDEV-14487 - Wrong result -rpl.rpl_row_drop_temp_table : Added in 10.3.17 +rpl.rpl_row_find_row_debug : Modified in 10.3.19 rpl.rpl_row_img_blobs : MDEV-13875 - command "diff_files" failed rpl.rpl_row_img_eng_min : MDEV-13875 - diff_files failed rpl.rpl_row_img_eng_noblob : MDEV-13875 - command "diff_files" failed @@ -887,11 +894,13 @@ rpl.rpl_semi_sync : MDEV-11220 - Wrong result rpl.rpl_semi_sync_after_sync : MDEV-14366 - Wrong result rpl.rpl_semi_sync_after_sync_row : MDEV-14366 - Wrong result rpl.rpl_semi_sync_event_after_sync : MDEV-11806 - warnings +rpl.rpl_semi_sync_slave_reply_fail : Added in 10.3.19 rpl.rpl_semi_sync_uninstall_plugin : MDEV-7140 - Assorted failures rpl.rpl_semi_sync_wait_point : MDEV-11807 - timeout in wait condition rpl.rpl_semisync_ali_issues : MDEV-16272 - Wrong result rpl.rpl_set_statement_default_master : MDEV-13258 - Extra warning rpl.rpl_show_slave_hosts : MDEV-10681 - Crash +rpl.rpl_skip_error : Modified in 10.3.19 rpl.rpl_skip_replication : MDEV-13258 - Extra warning rpl.rpl_slave_grp_exec : MDEV-10514 - Deadlock rpl.rpl_slave_load_tmpdir_not_exist : MDEV-14203 - Extra warning @@ -909,6 +918,7 @@ rpl.rpl_temporary_error2 : MDEV-10634 - Wrong number of retries rpl.rpl_test_framework : MDEV-19368 - mysqltest failed but provided no output rpl.rpl_trigger : MDEV-18055 - Wrong result rpl.rpl_truncate_3innodb : MDEV-19454 - Syntax error +rpl.rpl_unsafe_statements : Modified in 10.1.42 rpl.rpl_user_variables : MDEV-20522 - Wrong result rpl.rpl_variables : MDEV-20150 - Server crash rpl.sec_behind_master-5114 : MDEV-13878 - Wrong result @@ -916,11 +926,9 @@ rpl.show_status_stop_slave_race-7126 : MDEV-17438 - Timeout #----------------------------------------------------------------------- -rpl-tokudb.* : MDEV-14354 - Tests fail with tcmalloc -rpl-tokudb.rpl_deadlock_tokudb : MDEV-20529 - mysqltest failed but provided no output -rpl-tokudb.rpl_tokudb_commit_after_flush : MDEV-16966 - Server crash -rpl-tokudb.rpl_tokudb_row_crash_safe : Deleted in 10.2.27 -rpl-tokudb.rpl_tokudb_stm_mixed_crash_safe : Deleted in 10.2.27 +rpl-tokudb.* : MDEV-14354 - Tests fail with tcmalloc +rpl-tokudb.rpl_deadlock_tokudb : MDEV-20529 - mysqltest failed but provided no output +rpl-tokudb.rpl_tokudb_commit_after_flush : MDEV-16966 - Server crash #----------------------------------------------------------------------- @@ -928,8 +936,12 @@ rpl/extra/rpl_tests.* : MDEV-10994 - Not maintained #----------------------------------------------------------------------- -sphinx.* : MDEV-10986 - Tests have not been maintained -sphinx.sphinx : MDEV-10986 - Sporadic failures +sequence.group_by : Modified in 10.3.19 + +#----------------------------------------------------------------------- + +sphinx.* : MDEV-10986 - Tests have not been maintained; suite.pm modified in 10.3.19 +sphinx.sphinx : MDEV-10986 - Sporadic failures; modified in 10.3.19 sphinx.union-5539 : MDEV-10986 - Sporadic failures #----------------------------------------------------------------------- @@ -951,11 +963,16 @@ spider/bg.vp_fixes : MDEV-9329 - Fails on Ubuntu/s390x #----------------------------------------------------------------------- +spider/bugfix.select_by_null : Added in 10.3.19 + +#----------------------------------------------------------------------- + spider/handler.* : MDEV-10987, MDEV-10990 - Tests have not been maintained #----------------------------------------------------------------------- sql_sequence.concurrent_create : MDEV-16635 - Server crash +sql_sequence.other : Modified in 10.3.19 #----------------------------------------------------------------------- @@ -980,10 +997,11 @@ sys_vars.character_set_server_func : Modified in 10.3.18 sys_vars.collation_connection_basic : Modified in 10.3.18 sys_vars.collation_database_basic : Modified in 10.3.18 sys_vars.collation_server_basic : Modified in 10.3.18 +sys_vars.delayed_insert_limit_func : Modified in 10.3.19 sys_vars.expire_logs_days_basic : Modified in 10.2.27 sys_vars.histogram_size_basic : Modified in 10.2.27 sys_vars.innodb_buffer_pool_dump_at_shutdown_basic : MDEV-14280 - Unexpected error -sys_vars.innodb_ft_result_cache_limit : Modified in 10.2.26 +sys_vars.innodb_change_buffering_debug_basic : Modified in 10.3.19 sys_vars.innodb_max_dirty_pages_pct_basic : Modified in 10.3.18 sys_vars.innodb_max_dirty_pages_pct_lwm_basic : Modified in 10.3.18 sys_vars.innodb_read_io_threads_basic : Configuration added in 10.3.18 @@ -1057,11 +1075,11 @@ tokudb_bugs.frm_store : MDEV-12823 - Valgrind tokudb_bugs.frm_store2 : MDEV-12823 - Valgrind tokudb_bugs.frm_store3 : MDEV-12823 - Valgrind tokudb_bugs.xa : MDEV-11804 - Lock wait timeout -tokudb_bugs.xa-3 : MDEV-16953 - Corrupt log record found #----------------------------------------------------------------------- tokudb_parts.partition_alter4_tokudb : MDEV-12640 - Lost connection +tokudb_parts.partition_debug_tokudb : Include file modified in 10.3.19 tokudb_parts.partition_exch_qa_4_tokudb : Include file modified in 10.3.18 tokudb_parts.partition_exch_qa_8_tokudb : Include file modified in 10.3.18 tokudb_parts.partition_mgm_lc0_tokudb : Include file modified in 10.3.18 @@ -1087,14 +1105,15 @@ unit.conc_ps_bugs : MDEV-13252 - not ok 44 test_bug4236 unit.ma_pagecache_consist_64kRD : MDEV-19367 - AddressSanitizer CHECK failed unit.ma_pagecache_consist_64kWR : MDEV-19367 - AddressSanitizer CHECK failed unit.ma_test_loghandler : MDEV-10638 - record read not ok +unit.mf_iocache : MDEV-20952 - ASAN stack-buffer-overflow #----------------------------------------------------------------------- vcol.cross_db : Modified in 10.3.18 vcol.not_supported : MDEV-10639 - Testcase timeout vcol.update : Modified in 10.3.18 -vcol.vcol_keys_innodb : MDEV-10639 - Testcase timeout -vcol.vcol_misc : MDEV-16651 - Wrong error message; modified in 10.3.17 +vcol.vcol_keys_innodb : MDEV-10639 - Testcase timeout; modified in 10.3.19 +vcol.vcol_misc : MDEV-16651 - Wrong error message vcol.vcol_select_innodb : Modified in 10.3.18 vcol.vcol_select_myisam : Modified in 10.3.18 vcol.vcol_sql_mode : Added in 10.3.18 @@ -1104,38 +1123,36 @@ vcol.vcol_trigger_sp_myisam : Include file modified in 10.3.18 #----------------------------------------------------------------------- -versioning.alter : Modified in 10.3.18 -versioning.auto_increment : Include file modified in 10.3.18 -versioning.commit_id : Include file modified in 10.3.18 -versioning.create : Modified in 10.3.18 +versioning.alter : Modified in 10.3.19 +versioning.auto_increment : Include file modified in 10.3.19 +versioning.commit_id : Include file modified in 10.3.19 +versioning.create : Modified in 10.3.19 versioning.cte : Modified in 10.3.18 -versioning.delete : Modified in 10.3.18 +versioning.delete : Modified in 10.3.19 versioning.derived : Modified in 10.3.18 -versioning.foreign : Modified in 10.3.18 -versioning.insert : Include file modified in 10.3.18 -versioning.online : Modified in 10.3.18 -versioning.partition : Modified in 10.3.18 -versioning.partition_innodb : Modified in 10.3.18 -versioning.replace : Modified in 10.3.18 -versioning.select : Modified in 10.3.18 -versioning.select2 : Include file modified in 10.3.18 -versioning.simple : Modified in 10.3.17 -versioning.truncate : Modified in 10.3.18 -versioning.trx_id : Modified in 10.3.18 -versioning.update : Include file modified in 10.3.18 -versioning.update-big : Modified in 10.3.18 -versioning.view : Modified in 10.3.18 +versioning.foreign : Modified in 10.3.19 +versioning.insert : Include file modified in 10.3.19 +versioning.key_type : Combinations added in 10.3.19 +versioning.online : Modified in 10.3.19 +versioning.partition : Modified in 10.3.19 +versioning.partition_innodb : Modified in 10.3.19 +versioning.replace : Modified in 10.3.19 +versioning.select : Include file modified in 10.3.19 +versioning.select2 : Include file modified in 10.3.19 +versioning.truncate : Include file modified in 10.3.19 +versioning.trx_id : Modified in 10.3.19 +versioning.update : MDEV-20955 - Wrong result code; modified in 10.3.19 +versioning.update-big : Modified in 10.3.19 +versioning.view : Modified in 10.3.19 #----------------------------------------------------------------------- -wsrep.* : suite.pm modified in 10.3.17 wsrep.foreign_key : MDEV-14725 - WSREP has not yet prepared node wsrep.mdev_6832 : MDEV-14195 - Check testcase failed wsrep.mysql_tzinfo_to_sql_symlink_skip : Added in 10.3.18 wsrep.pool_of_threads : MDEV-17345 - WSREP has not yet prepared node for application use -wsrep.variables : MDEV-14311 - Wrong result; MDEV-17585 - Deadlock; modified in 10.3.17 +wsrep.variables : MDEV-14311 - Wrong result; MDEV-17585 - Deadlock; modified in 10.3.19 #----------------------------------------------------------------------- -wsrep_info.* : suite.pm modified in 10.3.17 wsrep_info.plugin : MDEV-13569 - No nodes coming from prim view -- cgit v1.2.1 From 5c3bbbd845fe38a125553c62976c1165b2d9b8d7 Mon Sep 17 00:00:00 2001 From: Thirunarayanan Balathandayuthapani Date: Wed, 6 Nov 2019 10:20:32 +0530 Subject: MDEV-20987 InnoDB fails to start when fts table has FK relation InnoDB: Assertion failure in file .../dict/dict0dict.cc line ... InnoDB: Failing assertion: table->can_be_evicted This fixes a regression that was caused by the fix of MDEV-20621 (commit a41d429765c7ddb528b9b438c68b25ff55d3bd55). MySQL 5.6 (and MariaDB 10.0) introduced eviction of tables from the InnoDB data dictionary cache. Tables that are connected to FOREIGN KEY constraints or FULLTEXT INDEX are exempt of the eviction. With the problematic change, a table that would already be exempt from eviction due to FOREIGN KEY would cause the problem if there also was a FULLTEXT INDEX defined on it. dict_load_table(): Only prevent eviction if table->can_be_evicted holds. --- .../suite/innodb_fts/r/innodb_fts_misc.result | 21 +++++++------------ mysql-test/suite/innodb_fts/t/innodb_fts_misc.test | 24 ++++++++-------------- 2 files changed, 15 insertions(+), 30 deletions(-) (limited to 'mysql-test') diff --git a/mysql-test/suite/innodb_fts/r/innodb_fts_misc.result b/mysql-test/suite/innodb_fts/r/innodb_fts_misc.result index 71eded74be4..a2a73840723 100644 --- a/mysql-test/suite/innodb_fts/r/innodb_fts_misc.result +++ b/mysql-test/suite/innodb_fts/r/innodb_fts_misc.result @@ -1,4 +1,3 @@ -drop table if exists t1; CREATE TABLE t1 ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, a VARCHAR(200), @@ -415,7 +414,6 @@ AGAINST ('"following database"@10' IN BOOLEAN MODE); id 105 DROP TABLE t1; -drop table if exists t50; set names utf8; "----------Test1---------" create table t50 (s1 varchar(60) character set utf8 collate utf8_bin) engine = innodb; @@ -670,9 +668,6 @@ s1 ŁŁŁŁ LLLL ŁŁŁŁ ŁŁŁŁ -DROP TABLE if EXISTS t2; -Warnings: -Note 1051 Unknown table 'test.t2' CREATE TABLE t2 (s1 VARCHAR(60) CHARACTER SET UTF8 COLLATE UTF8_POLISH_CI) ENGINE = InnoDB; CREATE FULLTEXT INDEX i ON t2 ( s1); Warnings: @@ -739,7 +734,12 @@ ALTER TABLE t2 DROP a; SET @@autocommit=0; CREATE FULLTEXT INDEX i ON t1 (char_column); INSERT INTO t1 values (1,'aaa'); -"restart server..." +CREATE TABLE mdev20987_1(f1 INT NOT NULL, PRIMARY KEY(f1))ENGINE=InnoDB; +CREATE TABLE mdev20987_2(f1 INT NOT NULL, f2 CHAR(100), +FULLTEXT(f2), +FOREIGN KEY(f1) REFERENCES mdev20987_1(f1))ENGINE=InnoDB; +INSERT INTO mdev20987_1 VALUES(1); +INSERT INTO mdev20987_2 VALUES(1, 'mariadb'); SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( @@ -747,12 +747,8 @@ t2 CREATE TABLE `t2` ( PRIMARY KEY (`FTS_DOC_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DELETE FROM t1 WHERE MATCH(char_column) AGAINST ('bbb'); -SET @@autocommit=1; -DROP TABLE t1, t2; +DROP TABLE t1, t2, mdev20987_2, mdev20987_1; "----------Test28---------" -drop table if exists `fts_test`; -Warnings: -Note 1051 Unknown table 'test.fts_test' create table `fts_test`(`a` text,fulltext key(`a`))engine=innodb; set session autocommit=0; insert into `fts_test` values (''); @@ -942,9 +938,6 @@ id title body 2 How To Use MySQL Well After you went through a ... 3 Optimizing MySQL In this tutorial we will show ... DROP TABLE articles; -drop table if exists t1; -Warnings: -Note 1051 Unknown table 'test.t1' create table t1 (FTS_DOC_ID bigint unsigned auto_increment not null primary key, title varchar(200),body text,fulltext(title,body)) engine=innodb; insert into t1 set body='test'; diff --git a/mysql-test/suite/innodb_fts/t/innodb_fts_misc.test b/mysql-test/suite/innodb_fts/t/innodb_fts_misc.test index e226b276966..2e8ff4ea48e 100644 --- a/mysql-test/suite/innodb_fts/t/innodb_fts_misc.test +++ b/mysql-test/suite/innodb_fts/t/innodb_fts_misc.test @@ -5,10 +5,6 @@ let collation=UTF8_UNICODE_CI; --source include/have_collation.inc ---disable_warnings -drop table if exists t1; ---enable_warnings - # Create FTS table CREATE TABLE t1 ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, @@ -401,10 +397,6 @@ DROP TABLE t1; #------------------------------------------------------------------------------ # More FTS test from peter's testing #------------------------------------------------------------------------------ ---disable_warnings -drop table if exists t50; ---enable_warnings - set names utf8; @@ -606,7 +598,6 @@ CREATE FULLTEXT INDEX i ON t1 (s1); INSERT INTO t1 VALUES ('a'),('b'),('c'),('d'),('ŁŁŁŁ'),('LLLL'),(NULL),('ŁŁŁŁ ŁŁŁŁ'),('LLLLLLLL'); SELECT * FROM t1 WHERE MATCH(s1) AGAINST ('LLLL' COLLATE UTF8_UNICODE_520_CI); -DROP TABLE if EXISTS t2; CREATE TABLE t2 (s1 VARCHAR(60) CHARACTER SET UTF8 COLLATE UTF8_POLISH_CI) ENGINE = InnoDB; CREATE FULLTEXT INDEX i ON t2 ( s1); INSERT INTO t2 VALUES @@ -672,16 +663,19 @@ ALTER TABLE t2 DROP a; SET @@autocommit=0; CREATE FULLTEXT INDEX i ON t1 (char_column); INSERT INTO t1 values (1,'aaa'); -echo "restart server..."; -# Restart the server + +CREATE TABLE mdev20987_1(f1 INT NOT NULL, PRIMARY KEY(f1))ENGINE=InnoDB; +CREATE TABLE mdev20987_2(f1 INT NOT NULL, f2 CHAR(100), + FULLTEXT(f2), + FOREIGN KEY(f1) REFERENCES mdev20987_1(f1))ENGINE=InnoDB; +INSERT INTO mdev20987_1 VALUES(1); +INSERT INTO mdev20987_2 VALUES(1, 'mariadb'); --source include/restart_mysqld.inc SHOW CREATE TABLE t2; DELETE FROM t1 WHERE MATCH(char_column) AGAINST ('bbb'); -SET @@autocommit=1; -DROP TABLE t1, t2; +DROP TABLE t1, t2, mdev20987_2, mdev20987_1; --echo "----------Test28---------" -drop table if exists `fts_test`; create table `fts_test`(`a` text,fulltext key(`a`))engine=innodb; set session autocommit=0; insert into `fts_test` values (''); @@ -870,8 +864,6 @@ DROP TABLE articles; # Test for Bug 13940669 - 64901: INNODB: ASSERTION FAILURE IN # THREAD 34387022112 IN FILE REM0CMP.CC LINE 5 -drop table if exists t1; - create table t1 (FTS_DOC_ID bigint unsigned auto_increment not null primary key, title varchar(200),body text,fulltext(title,body)) engine=innodb; -- cgit v1.2.1 From d7a2401750bb29dfdb45929a536539b9f17b347f Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Marko=20M=C3=A4kel=C3=A4?= Date: Wed, 6 Nov 2019 08:24:48 +0200 Subject: MDEV-20934 Infinite loop on innodb_fast_shutdown=0 with inconsistent change buffer Due to a data corruption bug that may have occurred a long time earlier (possibly involving physical backup and MySQL Bug #69122, which was addressed in commit f166ec71b78fdf7a08ba413509cf00ad9e003b3c) it seems possible that the InnoDB change buffer might end up containing entries, while no buffered changes exist according to the change buffer bitmap pages in the .ibd files. ibuf_delete_recs(): New function, to be invoked on slow shutdown only. Remove all buffered changes for a specific page. ibuf_merge_or_delete_for_page(): If the change buffer bitmap is clean and a slow shutdown is in progress, invoke ibuf_delete_recs(). We do not want to do that during normal operation, due to the additional overhead that is involved. The bitmap page should be consistent with the change buffer in the first place. --- mysql-test/suite/innodb/r/ibuf_not_empty.result | 1 + mysql-test/suite/innodb/t/ibuf_not_empty.test | 30 ++++++++++++++++++++++++- 2 files changed, 30 insertions(+), 1 deletion(-) (limited to 'mysql-test') diff --git a/mysql-test/suite/innodb/r/ibuf_not_empty.result b/mysql-test/suite/innodb/r/ibuf_not_empty.result index 2c898b8916d..7c61e74850b 100644 --- a/mysql-test/suite/innodb/r/ibuf_not_empty.result +++ b/mysql-test/suite/innodb/r/ibuf_not_empty.result @@ -22,4 +22,5 @@ check table t1; Table Op Msg_type Msg_text test.t1 check Warning InnoDB: Index 'b' contains #### entries, should be 4096. test.t1 check error Corrupt +SET GLOBAL innodb_fast_shutdown=0; DROP TABLE t1; diff --git a/mysql-test/suite/innodb/t/ibuf_not_empty.test b/mysql-test/suite/innodb/t/ibuf_not_empty.test index 9ee0b180f44..8b16d197e03 100644 --- a/mysql-test/suite/innodb/t/ibuf_not_empty.test +++ b/mysql-test/suite/innodb/t/ibuf_not_empty.test @@ -40,15 +40,43 @@ INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; +let MYSQLD_DATADIR=`select @@datadir`; +let PAGE_SIZE=`select @@innodb_page_size`; + +--source include/shutdown_mysqld.inc + +# Corrupt the change buffer bitmap, to claim that pages are clean +perl; +do "$ENV{MTR_SUITE_DIR}/include/crc32.pl"; +my $file = "$ENV{MYSQLD_DATADIR}/test/t1.ibd"; +open(FILE, "+<$file") || die "Unable to open $file"; +binmode FILE; +my $ps= $ENV{PAGE_SIZE}; +my $page; +sysseek(FILE, $ps, 0) || die "Unable to seek $file\n"; +die "Unable to read $file" unless sysread(FILE, $page, $ps) == $ps; +# Clean the change buffer bitmap. +substr($page,38,$ps - 38 - 8) = chr(0) x ($ps - 38 - 8); +my $polynomial = 0x82f63b78; # CRC-32C +my $ck= pack("N",mycrc32(substr($page, 4, 22), 0, $polynomial) ^ + mycrc32(substr($page, 38, $ps - 38 - 8), 0, $polynomial)); +substr($page,0,4)=$ck; +substr($page,$ps-8,4)=$ck; +sysseek(FILE, $ps, 0) || die "Unable to rewind $file\n"; +syswrite(FILE, $page, $ps)==$ps || die "Unable to write $file\n"; +close(FILE) || die "Unable to close $file"; +EOF --let $restart_parameters= --innodb-force-recovery=6 --innodb-change-buffer-dump ---source include/restart_mysqld.inc +--source include/start_mysqld.inc --replace_regex /contains \d+ entries/contains #### entries/ check table t1; --let $restart_parameters= --source include/restart_mysqld.inc +SET GLOBAL innodb_fast_shutdown=0; +--source include/restart_mysqld.inc # Cleanup DROP TABLE t1; -- cgit v1.2.1 From 352e7667877ec6603aff5234c003ef8c11885cd8 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Marko=20M=C3=A4kel=C3=A4?= Date: Wed, 6 Nov 2019 17:56:56 +0200 Subject: MDEV-20934: Make the test more robust Due to MDEV-12288, the slow shutdown in MariaDB 10.3 will include resetting the DB_TRX_ID for all inserted records. This might cause the 60-second shutdown_server timeout to be exceeded. Let us wait for the purge to complete before initiating slow shutdown. --- mysql-test/suite/innodb/r/ibuf_not_empty.result | 2 ++ mysql-test/suite/innodb/t/ibuf_not_empty.test | 6 ++++++ 2 files changed, 8 insertions(+) (limited to 'mysql-test') diff --git a/mysql-test/suite/innodb/r/ibuf_not_empty.result b/mysql-test/suite/innodb/r/ibuf_not_empty.result index 7c61e74850b..ed2db836c06 100644 --- a/mysql-test/suite/innodb/r/ibuf_not_empty.result +++ b/mysql-test/suite/innodb/r/ibuf_not_empty.result @@ -22,5 +22,7 @@ check table t1; Table Op Msg_type Msg_text test.t1 check Warning InnoDB: Index 'b' contains #### entries, should be 4096. test.t1 check error Corrupt +SET GLOBAL innodb_purge_rseg_truncate_frequency=1; +InnoDB 0 transactions not purged SET GLOBAL innodb_fast_shutdown=0; DROP TABLE t1; diff --git a/mysql-test/suite/innodb/t/ibuf_not_empty.test b/mysql-test/suite/innodb/t/ibuf_not_empty.test index 33118ad6bf5..d0264e85678 100644 --- a/mysql-test/suite/innodb/t/ibuf_not_empty.test +++ b/mysql-test/suite/innodb/t/ibuf_not_empty.test @@ -77,6 +77,12 @@ check table t1; --let $restart_parameters= --source include/restart_mysqld.inc + +# Ensure that the slow shutdown will not time out due to running purge. +SET GLOBAL innodb_purge_rseg_truncate_frequency=1; +--source include/wait_all_purged.inc +# The change buffer merge for the injected corruption must complete +# without exceeding the 60-second shutdown_server timeout. SET GLOBAL innodb_fast_shutdown=0; --source include/restart_mysqld.inc -- cgit v1.2.1