Updated list of unstable tests for 10.0.29 release

1 files changed, 91 insertions, 56 deletions

diff --git a/mysql-test/unstable-tests b/mysql-test/unstable-tests
index 3e25115599f..e4c57d9f9d7 100644
--- a/mysql-test/unstable-tests
+++ b/mysql-test/unstable-tests
@@ -23,47 +23,65 @@
 #
 ##############################################################################
 
+main.count_distinct2               : MDEV-11768 - timeout
+main.create                        : Modified in 10.0.29
 main.create_delayed                : MDEV-10605 - failed with timeout
-main.ctype_utf32                   : Modified on 2016-09-27 (merge)
-main.func_group                    : Modified on 2016-08-08 (MDEV-10468)
-main.func_math                     : Modified on 2016-08-10 (merge)
-main.func_misc                     : Modified on 2016-08-10 (merge)
-main.group_min_max_innodb          : Modified on 2016-08-25 (MDEV-10595)
+main.ctype_ucs2_def                : Modified in 10.0.29
+main.ctype_ucs2_query_cache        : Modified in 10.0.29
+main.ctype_utf16_def               : Modified in 10.0.29
+main.ctype_utf8                    : Modified in 10.0.29
+main.ctype_utf8mb4                 : Modified in 10.0.29
+main.ctype_utf8mb4                 : Modified in 10.0.29 (load file changed)
+main.debug_sync                    : MDEV-10607 - internal error
+main.default                       : Modified in 10.0.29
+main.derived                       : Modified in 10.0.29
+main.derived_opt                   : MDEV-11768 - timeout
+main.derived_view                  : Modified in 10.0.29
+main.events_restart                : MDEV-11221 - Assertion failure
+main.events_slowlog                : Added in 10.0.29
+main.fulltext_charsets             : Added in 10.0.29
+main.func_time                     : Modified in 10.0.29
+main.group_by                      : Modified in 10.0.29
+main.group_by_innodb               : Modified in 10.0.29
 main.host_cache_size_functionality : MDEV-10606 - sporadic failure on shutdown
 main.index_intersect_innodb        : MDEV-10643 - failed with timeout
-main.index_merge_myisam            : Modified on 2016-09-05 (include file changed)
-main.index_merge_innodb            : Modified on 2016-09-05 (MDEV-7142)
-main.information_schema_stats      : Modified on 2016-07-25 (MDEV-10428)
+main.index_merge_innodb            : MDEV-7142 - wrong result
+main.information_schema_part       : Modified in 10.0.29
 main.innodb_mysql_lock             : MDEV-7861 - sporadic lock detection failure
-main.loaddata                      : Modified on 2016-08-10 (merge)
+main.join_cache                    : Modified in 10.0.29
+main.loaddata                      : Modified in 10.0.29
+main.log_slow                      : Modified in 10.0.29
 main.mdev-504                      : MDEV-10607 - sporadic "can't connect"
 main.mdev375                       : MDEV-10607 - sporadic "can't connect"
 main.merge                         : MDEV-10607 - sporadic "can't connect"
-main.myisam_enable_keys-10506      : New test, added on 2016-08-10 (MDEV-10506)
-main.mysqlcheck                    : Modified on 2016-08-10 (merge)
-main.mysqldump                     : MDEV-10512 - sporadic assertion failure
 main.mysqlhotcopy_myisam           : MDEV-10995 - test hangs on debug build
 main.mysqltest                     : MDEV-9269 - fails on Alpha
-main.named_pipe                    : Modified on 2016-08-02 (MDEV-10383)
-main.pool_of_threads               : MDEV-10100 - sporadic error on detecting max connections
+main.order_by                      : Modified in 10.0.29
+main.parser                        : Modified in 10.0.29
+main.pool_of_threads               : Modified in 10.0.29
 main.ps                            : MDEV-11017 - sporadic wrong Prepared_stmt_count
-main.range                         : Modified on 2016-08-10 (merge)
-main.range_mrr_icp                 : Modified on 2016-08-10 (merge)
-main.query_cache                   : MDEV-10611 - sporadic mutex problem
-main.shutdown                      : MDEV-10563 - sporadic crashes
-main.sp-prelocking                 : Modified on 2016-08-10 (merge)
+main.selectivity                   : Modified in 10.0.29
+main.signal_demo3                  : MDEV-11720 - Thread stack overrun on Solaris
+main.sp                            : Modified in 10.0.29
+main.sp_notembedded                : MDEV-10607 - internal error
+main.sp-prelocking                 : Modified in 10.0.29
 main.sp-security                   : MDEV-10607 - sporadic "can't connect"
-main.ssl_compress                  : MDEV-11110 - valgrind failures
 main.stat_tables_par_innodb        : MDEV-10515 - sporadic wrong results
+main.subselect                     : Modified in 10.0.29
+main.subselect2                    : Modified in 10.0.29
+main.subselect4                    : Modified in 10.0.29
 main.subselect_innodb              : MDEV-10614 - sporadic wrong results
-main.type_date                     : Modified on 2016-08-10 (merge)
-main.type_uint                     : Modified on 2016-09-27 (merge)
-main.view                          : Modified on 2016-08-10 (merge)
-main.xtradb_mrr                    : Modified on 2016-08-04 (MDEV-9946)
+main.subselect_sj2_jcl6            : MDEV-11766 - unexpected warnings
+main.type_bit_innodb               : MDEV-11766 - unexpected warnings
+main.type_decimal                  : Modified in 10.0.29
+main.union                         : Modified in 10.0.29
+main.view                          : Modified in 10.0.29
+main.xa                            : MDEV-11769 - lock wait timeout
 
 #----------------------------------------------------------------
 
 archive.archive-big          : MDEV-10615 - table is marked as crashed
+archive.archive_bitfield     : MDEV-11771 - table is marked as crashed
 archive.discover             : MDEV-10510 - table is marked as crashed
 archive.mysqlhotcopy_archive : MDEV-10995 - test hangs on debug build
 
@@ -74,6 +92,8 @@ binlog.binlog_xa_recover                  : MDEV-8517 - Extra checkpoint
 
 #----------------------------------------------------------------
 
+connect.jdbc            : re-enabled in 10.0.29
+connect.jdbc_new        : re-enabled in 10.0.29
 connect.tbl             : MDEV-9844, MDEV-10179 - sporadic crashes, valgrind warnings, wrong results
 
 #----------------------------------------------------------------
@@ -82,10 +102,6 @@ engines/rr_trx.* : MDEV-10998 - tests not maintained
 
 #----------------------------------------------------------------
 
-extra/binlog_tests.database : Modified on 2016-10-21 (Upstream MIPS test fixes)
-
-#----------------------------------------------------------------
-
 federated.federatedx             : MDEV-10617 - Wrong checksum, timeouts
 federated.federated_innodb       : MDEV-10617, MDEV-10417 - Wrong checksum, timeouts, fails on Mips
 federated.federated_partition    : MDEV-10417 - Fails on Mips
@@ -93,19 +109,23 @@ federated.federated_transactions : MDEV-10617, MDEV-10417 - Wrong checksum, time
 
 #----------------------------------------------------------------
 
-funcs_2/charset.* : MDEV-10999 - test not maintained
+funcs_1.memory_views : MDEV-11773 - timeout
+funcs_2/charset.*    : MDEV-10999 - test not maintained
 
 #----------------------------------------------------------------
 
 innodb.binlog_consistent              : MDEV-10618 - Server fails to start 
+innodb.group_commit_crash_no_optimize_thread : MDEV-11770 - checksum mismatch
 innodb.innodb-alter-table             : MDEV-10619 - Testcase timeout
-innodb.innodb-alter-tempfile          : Modified on 2016-08-09 (MDEV-10469)
 innodb.innodb_bug30423                : MDEV-7311 - Wrong number of rows in the plan
-innodb.innodb_bug54044                : Modified on 2016-09-27 (merge)
+innodb.innodb_bug53290                : MDEV-11767 - timeout
+innodb.innodb_bug56143                : MDEV-11766 - unexpected warnings
 innodb.innodb_monitor                 : MDEV-10939 - Testcase timeout
-innodb.innodb-wl5522                  : rdiff file modified on 2016-08-10 (merge)
-innodb.innodb-wl5522-debug-zip        : MDEV-10427 - Warning: database page corruption
-innodb.system_tables                  : Added on 2016-09-23 (MDEV-10775)
+innodb.innodb-wl5522-debug-zip        : Modified in 10.0.29
+innodb.table_index_statistics         : Modified in 10.0.29
+
+innodb_fts.innodb_fts_misc            : MDEV-11767 - timeout
+innodb_fts.innodb_fts_plugin          : MDEV-11766 - unexpected warnings
 
 #----------------------------------------------------------------
 
@@ -125,29 +145,41 @@ multi_source.status_vars : MDEV-4632 - failed while waiting for Slave_received_h
 
 #----------------------------------------------------------------
 
+parts.partition_exch_qa_10   : MDEV-11765 - wrong result
 parts.partition_float_myisam : MDEV-10621 - Testcase timeout
 parts.partition_int_myisam   : MDEV-10621 - Testcase timeout
 
 #----------------------------------------------------------------
 
+percona.percona_xtradb_bug317074             : MDEV-11767 - timeout
+
+#----------------------------------------------------------------
+
 perfschema.func_file_io                      : MDEV-5708 - fails for s390x
 perfschema.func_mutex                        : MDEV-5708 - fails for s390x
 perfschema.hostcache_ipv6_ssl                : MDEV-10696 - crash on shutdown
+perfschema.table_name                        : MDEV-11764 - wrong result
 perfschema.socket_summary_by_event_name_func : MDEV-10622 - Socket summary tables do not match
 
 perfschema_stress.* : MDEV-10996 - tests not maintained
 
 #----------------------------------------------------------------
 
-plugins.feedback_plugin_send     : MDEV-7932 - ssl failed for url, MDEV-11112 - valgrind warnings
-plugins.pam                      : Modified on 2016-08-03 (MDEV-7329)
-plugins.pam_cleartext            : Modified on 2016-08-03
+plugins.feedback_plugin_send     : MDEV-7932 - ssl failed for url, MDEV-11118 - wrong result
 plugins.server_audit             : MDEV-9562 - crashes on sol10-sparc
 plugins.thread_pool_server_audit : MDEV-9562 - crashes on sol10-sparc
 
+
+#----------------------------------------------------------------
+
+roles.create_and_drop_role            : Modified in 10.0.29
+roles.create_and_grant_role           : MDEV-11772 - wrong result
+roles.role_case_sensitive-10744       : Added in 10.0.29
+
 #----------------------------------------------------------------
 
 rpl.last_insert_id                    : MDEV-10625 - warnings in error log
+rpl.rpl_alter_extra_persistent        : Added in 10.0.29
 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
@@ -155,29 +187,31 @@ rpl.rpl_binlog_index                  : MDEV-9501 - Warning: failed registering
 rpl.rpl_checksum_cache                : MDEV-10626 - Testcase timeout
 rpl.rpl_circular_for_4_hosts          : MDEV-10627 - Testcase timeout
 rpl.rpl_ddl                           : MDEV-10417 - Fails on Mips
-rpl.rpl_drop_db                       : Modified on 2016-10-21 (Upstream MIPS test fixes)
 rpl.rpl_gtid_crash                    : MDEV-9501 - Warning: failed registering on master
 rpl.rpl_gtid_master_promote           : MDEV-10628 - Timeout in sync_with_master
 rpl.rpl_gtid_stop_start               : MDEV-10629 - Crash on shutdown
 rpl.rpl_gtid_until                    : MDEV-10625 - warnings in error log
+rpl.rpl_heartbeat_basic               : MDEV-11668 - Wrong result
 rpl.rpl_innodb_bug30888               : MDEV-10417 - Fails on Mips
 rpl.rpl_insert                        : MDEV-9329 - Fails on Ubuntu/s390x
 rpl.rpl_insert_delayed                : MDEV-9329 - Fails on Ubuntu/s390x
 rpl.rpl_invoked_features              : MDEV-10417 - Fails on Mips
+rpl.rpl_mdev10863                     : Added in 10.0.29
 rpl.rpl_mdev6020                      : MDEV-10630, MDEV-10417 - Timeouts, fails on Mips
 rpl.rpl_mdev6386                      : MDEV-10631 - Wrong result on slave
 rpl.rpl_parallel                      : MDEV-10632, MDEV-10653 - Failures to sync, timeouts
 rpl.rpl_parallel_temptable            : MDEV-10356 - Crash in close_thread_tables
 rpl.rpl_partition_innodb              : MDEV-10417 - Fails on Mips
 rpl.rpl_row_drop_create_temp_table    : MDEV-10626 - Testcase timeout
+rpl.rpl_row_mysqlbinlog               : Modified in 10.0.29
 rpl.rpl_row_sp001                     : MDEV-9329 - Fails on Ubuntu/s390x
 rpl.rpl_semi_sync_uninstall_plugin    : MDEV-7140 - Wrong plugin status
 rpl.rpl_slave_grp_exec                : MDEV-10514 - Unexpected deadlock
-rpl.rpl_switch_stm_row_mixed          : MDEV-10611 - Wrong usage of mutex
+rpl.rpl_special_charset               : Modified in 10.0.29
 rpl.rpl_sync                          : MDEV-10633 - Database page corruption
 rpl.rpl_temporary_error2              : MDEV-10634 - Wrong number of retries
-rpl.sec_behind_master-5114            : MDEV-8518 - Wrong value of Seconds_Behind_Master
 rpl.rpl_skip_replication              : MDEV-9268 - Fails with timeout in sync_slave_with_master on Alpha
+rpl.sec_behind_master-5114            : Modified in 10.0.29
 
 rpl/extra/rpl_tests.*                 : MDEV-10994 - tests not maintained
 
@@ -187,6 +221,8 @@ spider.* : MDEV-9329 - tests are too memory-consuming
 
 spider/bg.direct_aggregate      : MDEV-7098 - Trying to unlock mutex that wasn't locked
 spider/bg.direct_aggregate_part : MDEV-7098 - Trying to unlock mutex that wasn't locked
+spider/bg.spider3_fixes         : MDEV-7098 - Trying to unlock mutex that wasn't locked
+spider/bg.spider_fixes_part     : MDEV-7098 - Trying to unlock mutex that wasn't locked
 spider/bg.ha                    : MDEV-7914, MDEV-9329 - Crash, failures on s390x
 spider/bg.ha_part               : MDEV-9329 - Fails on Ubuntu/s390x
 spider/bg.spider_fixes          : MDEV-7098, MDEV-9329 - Mutex problem, failures on s390x
@@ -194,7 +230,7 @@ spider/bg.vp_fixes              : MDEV-9329 - Fails on Ubuntu/s390x
 
 #----------------------------------------------------------------
 
-sphinx.* : MDEV-10747 - tests are not run in buildbot, they can't be stable
+sphinx.* : MDEV-10986 - sphinx tests fail in buildbot and outside
 
 #----------------------------------------------------------------
 
@@ -203,34 +239,33 @@ stress.ddl_innodb : MDEV-10635 - Testcase timeout
 #----------------------------------------------------------------
 
 sys_vars.autocommit_func2                  : MDEV-9329 - Fails on Ubuntu/s390x
-sys_vars.general_log_file_basic            : Modified on 2016-08-09 (MDEV-10465)
-sys_vars.slow_query_log_file_basic         : Modified on 2016-08-09 (MDEV-10465)
 sys_vars.innodb_buffer_pool_dump_pct_basic : MDEV-10651 - sporadic failure on file_exists
+sys_vars.replicate_do_db_basic             : Modified in 10.0.29
+sys_vars.replicate_do_table_basic          : Modified in 10.0.29
+sys_vars.replicate_ignore_db_basic         : Modified in 10.0.29
+sys_vars.replicate_ignore_table_basic      : Modified in 10.0.29
+sys_vars.replicate_wild_do_table_basic     : Modified in 10.0.29
+sys_vars.replicate_wild_ignore_table_basic : Modified in 10.0.29
+sys_vars.thread_cache_size_func            : MDEV-11775 - wrong result
 
 #----------------------------------------------------------------
 
-tokudb.background_job_manager        : MDEV-10327 - Assertion failure on server shutdown
 tokudb.cluster_filter_unpack_varchar : MDEV-10636 - Wrong execution plan
-tokudb.*                             : MDEV-9891 - massive crashes on shutdown
-tokudb_alter_table.*                 : MDEV-9891 - massive crashes on shutdown
+tokudb.dir_per_db                    : MDEV-11537 - wrong result
+tokudb.locks-select-update-3         : MDEV-11774 - lock wait timeout
+tokudb.table_index_statistics        : Added in 10.0.29
+
 tokudb_backup.*                      : MDEV-11001 - tests don't work
 tokudb_bugs.checkpoint_lock          : MDEV-10637 - Wrong processlist output
 tokudb_bugs.checkpoint_lock_3        : MDEV-10637 - Wrong processlist output
-tokudb_bugs.*                        : MDEV-9891 - massive crashes on shutdown
-tokudb_parts.*                       : MDEV-9891 - massive crashes on shutdown
-tokudb_rpl_suites.*                  : MDEV-11001 - tests don't work
-tokudb_sys_vars.*                    : MDEV-11001 - tests don't work
-rpl-tokudb.*                         : MDEV-9891 - massive crashes on shutdown
-tokudb/tokudb_add_index.*            : MDEV-9891 - massive crashes on shutdown
-tokudb/tokudb_backup.*               : MDEV-9891 - massive crashes on shutdown
-tokudb/tokudb_mariadb.*              : MDEV-9891 - massive crashes on shutdown
-tokudb/tokudb_sys_vars.*             : MDEV-9891 - massive crashes on shutdown
-tokudb/tokudb_rpl.*                  : MDEV-9891 - massive crashes on shutdown
 
+tokudb_rpl.*                         : MDEV-11001 - tests don't work
+tokudb_sys_vars.*                    : MDEV-11001 - tests don't work
 
 #----------------------------------------------------------------
 
 unit.ma_test_loghandler : MDEV-10638 - record read not ok
+unit.pfs                : MySQL:84457 - unittest pft-t failing
 
 #----------------------------------------------------------------