← Back to team overview

maria-developers team mailing list archive

Please review MDEV-10604 Disable unstable MTR tests by default

 

Hi Sergey (Vojtovich),

Please review the patch that we've discussed at length.
Serg, FYI.

The length of the "unstable" list shouldn't scare anyone. At the end, this task should cause no change in our current procedure, the tests will still be run in buildbot and hopefully on developers' local machines (and every external user who wants to run them can do it easily). The change should mainly help those who run tests as a part of their build process.

The lists can be tuned later, now they have been created generously, to solve the most urgent issue in shortest time possible.

Please note that it's still not a 100% guarantee that nothing will fail sporadically, I've already got an absolutely new random failure after disabling all known ones, so it will still require some iterations.

Regards,
Elena

-------- Forwarded Message --------
Subject: [Commits] 5ac5050: MDEV-10604 Disable unstable MTR tests by default
Date: Mon, 22 Aug 2016 14:44:30 +0300 (EEST)
From: elenst@xxxxxxxxxxxxxxxx
Reply-To: maria-developers@xxxxxxxxxxxxxxxxxxx
To: commits@xxxxxxxxxxx

revision-id: 5ac505064a75508213d4dbce388ff5ee62d1ad56 (mariadb-10.0.26-92-g5ac5050)
parent(s): 05f61ba46046ca835071a73b9255e787dcce9255
author: Elena Stepanova
committer: Elena Stepanova
timestamp: 2016-08-22 14:38:27 +0300
message:

MDEV-10604 Disable unstable MTR tests by default

- add new syntax to disabled.def in MTR to distinguish "unstable"
  tests from disabled tests;
- allow wildcards in test names in disabled.def;
- add a new option enable-unstable and env option MTR_ENABLE_DISABLED;
- mark "unstable" tests which have failed since the beginning
  of the year in buildbot on main 10.0 branch;
- mark "unstable" tests which fail in Debian builds;
- mark "unstable" tests which have been changed during the last
  two releases

---
mysql-test/disabled.def | 67 +++++++++++++++++++-
 mysql-test/lib/mtr_cases.pm                        |   47 ++++++++++++--
 mysql-test/mysql-test-run.pl                       |   12 +++-
 mysql-test/suite/binlog/disabled.def               |   14 ++++
 mysql-test/suite/federated/disabled.def            |   15 +++++
 mysql-test/suite/funcs_1/disabled.def              |   16 ++++-
 mysql-test/suite/innodb/disabled.def               |   21 ++++++
 mysql-test/suite/parts/disabled.def                |   13 ++++
 mysql-test/suite/perfschema/disabled.def           |   24 +++++++
 mysql-test/suite/rpl/disabled.def                  |   39 ++++++++++++
 mysql-test/suite/sys_vars/disabled.def             |   14 ++++
 storage/connect/mysql-test/connect/disabled.def    |   12 ++++
 .../mysql-test/mroonga/storage/disabled.def        |   30 +++++++++
 storage/tokudb/mysql-test/rpl/disabled.def         |   26 ++++++++
 storage/tokudb/mysql-test/tokudb/disabled.def      |   29 +++++++++
 storage/tokudb/mysql-test/tokudb_bugs/disabled.def |   27 ++++++++
 .../tokudb/mysql-test/tokudb_parts/disabled.def    |   26 ++++++++
 17 files changed, 421 insertions(+), 11 deletions(-)

diff --git a/mysql-test/disabled.def b/mysql-test/disabled.def
index 5c4b742..f0cb6ec 100644
--- a/mysql-test/disabled.def
+++ b/mysql-test/disabled.def
@@ -6,17 +6,82 @@
 #
 #    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
 #
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    + <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  '*' wildcard in testcase names is supported.
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
 #  Do not use any TAB characters for whitespace.
 #

##############################################################################
+
tablespace : disabled in MariaDB (no TABLESPACE table attribute) events_time_zone : Test is not predictable as it depends on precise timing. read_many_rows_innodb : Bug#11748886 2010-11-15 mattiasj report already exists log_tables-big : Bug#11756699 2010-11-15 mattiasj report already exists mysql_embedded : Bug#12561297 2011-05-14 Anitha Dependent on PB2 changes - eventum#41836 -#show_explain : Psergey: random timeout in range-checked-for-each record query.
 ssl_crl_clients_valid    : broken upstream
 ssl_crl                  : broken upstream
 ssl_crl_clrpath          : broken upstream
 file_contents            : MDEV-6526 these files are not installed anymore
lowercase_fs_on : lower_case_table_names=0 is not an error until 10.1
+
+##########################
+
++ bootstrap                     : Modified on 2016-06-18 (MDEV-9969)
++ create_delayed                : MDEV-10605 - failed with timeout
++ create_or_replace             : Modified on 2016-06-23 (MDEV-9728)
++ ctype_recoding                : Modified on 2016-06-10 (MDEV-10181)
++ ctype_utf8                    : Modified on 2016-06-21 (merge)
++ ctype_utf8mb4                 : Modified on 2016-06-21 (merge)
++ events_1                      : Modified on 2016-06-21 (MDEV-9524)
++ func_group                    : Modified on 2016-08-08 (MDEV-10468)
++ func_in                       : Modified on 2016-06-20 (MDEV-10020)
++ func_math                     : Modified on 2016-08-10 (merge)
++ func_misc                     : Modified on 2016-08-10 (merge)
++ grant2                        : Modified on 2016-07-18 (MDEV-8569)
++ help                          : Modified on 2016-06-21 (MDEV-9524)
++ host_cache_size_functionality : MDEV-10606 - sporadic failure on shutdown
++ index_intersect_innodb        : MDEV-10643 - failed with timeout
++ index_merge_innodb : MDEV-7142 - sporadic wrong execution plan
++ information_schema_stats      : Modified on 2016-07-25 (MDEV-10428)
++ innodb_mysql_lock : MDEV-7861 - sporadic lock detection failure ++ insert_innodb : Modified on 2016-06-14 (merge from upstream)
++ loaddata                      : Modified on 2016-08-10 (merge)
++ locale                        : Modified on 2016-06-21 (merge)
++ mdev-504                      : MDEV-10607 - sporadic "can't connect"
++ mdev375                       : MDEV-10607 - sporadic "can't connect"
++ merge                         : MDEV-10607 - sporadic "can't connect"
++ multi_update                  : Modified on 2016-06-20 (MDEV-5973)
++ myisam_enable_keys-10506      : Added on 2016-08-10 (MDEV-10506)
++ mysqlcheck                    : Modified on 2016-08-10 (merge)
++ mysqldump                     : MDEV-10512 - sporadic assertion failure
++ mysqltest                     : MDEV-9269  - fails on Alpha
++ named_pipe                    : Modified on 2016-08-02 (MDEV-10383)
++ openssl_1                     : Modified on 2016-07-11 (MDEV-10211)
++ parser                        : Modified on 2016-06-21 (merge)
++ pool_of_threads : MDEV-10100 - sporadic error on detecting max connections
++ ps_1general                   : Modified on 2016-07-12 (merge)
++ range                         : Modified on 2016-08-10 (merge)
++ range_mrr_icp                 : Modified on 2016-08-10 (merge)
++ query_cache                   : MDEV-10611 - sporadic mutex problem
++ shutdown                      : MDEV-10612 - sporadic crashes
++ sp-prelocking                 : Modified on 2016-08-10 (merge)
++ sp-security                   : MDEV-10607 - sporadic "can't connect"
++ ssl : MDEV-10211 - different ciphers on some platforms
++ ssl_ca                        : Modified on 2016-07-11 (MDEV-10211)
++ ssl_compress                  : Modified on 2016-07-11 (MDEV-10211)
++ ssl_timeout                   : Modified on 2016-07-11 (MDEV-10211)
++ stat_tables_par_innodb        : MDEV-10515 - sporadic wrong results
++ status_user                   : Modified on 2016-06-20 (MDEV-8633)
++ subselect_innodb              : MDEV-10614 - sporadic wrong results
++ temp_table                    : Modified on 2016-06-18 (MDEV-8569)
++ type_date                     : Modified on 2016-08-10 (merge)
++ type_datetime                 : Modified on 2016-06-16 (MDEV-9374)
++ view                          : Modified on 2016-08-10 (merge)
++ xtradb_mrr                    : Modified on 2016-08-04 (MDEV-9946)
diff --git a/mysql-test/lib/mtr_cases.pm b/mysql-test/lib/mtr_cases.pm
index b76b10d..886e5a6 100644
--- a/mysql-test/lib/mtr_cases.pm
+++ b/mysql-test/lib/mtr_cases.pm
@@ -36,6 +36,7 @@ our $do_test;
 our $skip_test;
 our $binlog_format;
 our $enable_disabled;
+our $enable_unstable;
 our $default_storage_engine;
 our $opt_with_ndbcluster_only;
 @@ -313,6 +314,9 @@ sub combinations_from_file($$)
 }
  our %disabled;
+our %disabled_wildcards;
+our %unstable;
+our %unstable_wildcards;
 sub parse_disabled {
   my ($filename, $suitename) = @_;
 @@ -321,10 +325,21 @@ sub parse_disabled {
       chomp;
       next if /^\s*#/ or /^\s*$/;
       mtr_error("Syntax error in $filename line $.")
- unless /^\s*(?:([-0-9A-Za-z_\/]+)\.)?([-0-9A-Za-z_]+)\s*:\s*(.*?)\s*$/; + unless /^\s*(\+)?\s*(?:([-0-9A-Za-z_\/]+)\.)?([-0-9A-Za-z_\*]+)\s*:\s*(.*?)\s*$/;
       mtr_error("Wrong suite name in $filename line $.")
-        if defined $1 and defined $suitename and $1 ne $suitename;
-      $disabled{($1 || $suitename || '') . ".$2"} = $3;
+        if defined $2 and defined $suitename and $2 ne $suitename;
+      $suitename= $2 || $suitename || '';
+      my ($casename, $unstable_flag, $text)= ($3, $1, $4);
+
+      if ($casename =~ /\*/) {
+        # Wildcard
+        $disabled_wildcards{"$casename"}= $text;
+        $unstable_wildcards{"$casename"}= 1 if defined $unstable_flag;
+      }
+      else {
+        $disabled{$suitename . ".$casename"}= $text;
+        $unstable{$suitename . ".$casename"}= 1 if defined $unstable_flag;
+      }
     }
     close DISABLED;
   }
@@ -721,16 +736,36 @@ sub collect_one_test_case {
   # Check for disabled tests
   # ----------------------------------------------------------------------
   my $disable = $disabled{".$tname"} || $disabled{$name};
+  if (not $disable) {
+    foreach my $w (keys %disabled_wildcards) {
+      if ($tname =~ /^$w/) {
+        $disable= $disabled_wildcards{$w};
+        last;
+      }
+    }
+  }
+  my $unstable = $unstable{".$tname"} || $unstable{$name};
+  if (not $unstable) {
+    foreach my $w (keys %unstable_wildcards) {
+      if ($tname =~ /^$w/) {
+        $unstable= $unstable_wildcards{$w};
+        last;
+      }
+    }
+  }
   if (not defined $disable and $suite->{parent}) {
     $disable = $disabled{$suite->{parent}->{name} . ".$tname"};
   }
+  if (not defined $unstable and $suite->{parent}) {
+    $unstable = $unstable{$suite->{parent}->{name} . ".$tname"};
+  }
   if (defined $disable)
   {
     $tinfo->{comment}= $disable;
-    if ( $enable_disabled )
+    if ( $enable_disabled or ( $enable_unstable and $unstable ) )
     {
-      # User has selected to run all disabled tests
- mtr_report(" - $tinfo->{name} wil be run although it's been disabled\n",
+      # User has selected to run disabled tests
+ mtr_report(" - $tinfo->{name} will be run although it's been disabled" . ($unstable ? " as unstable\n" : "\n"),
 		 "  due to '$disable'");
     }
     else
diff --git a/mysql-test/mysql-test-run.pl b/mysql-test/mysql-test-run.pl
index 5af19c8..82e84ec 100755
--- a/mysql-test/mysql-test-run.pl
+++ b/mysql-test/mysql-test-run.pl
@@ -1203,6 +1203,7 @@ sub command_line_setup {
 	     'force-restart'            => \$opt_force_restart,
              'reorder!'                 => \$opt_reorder,
              'enable-disabled'          => \&collect_option,
+             'enable-unstable'          => \&collect_option,
              'verbose+'                 => \$opt_verbose,
              'verbose-restart'          => \&report_option,
              'sleep=i'                  => \$opt_sleep,
@@ -1597,6 +1598,14 @@ sub command_line_setup {
   $ENV{'STAGING_RUN'}= $opt_staging_run;
# --------------------------------------------------------------------------
+  # Unstable tests
+ # --------------------------------------------------------------------------
+   if ( $ENV{'MTR_ENABLE_UNSTABLE'} )
+   {
+     collect_option('enable-unstable',1);
+   }
+
+ # --------------------------------------------------------------------------
   # Gcov flag
# --------------------------------------------------------------------------
   if ( ($opt_gcov or $opt_gprof) and ! $source_dist )
@@ -6455,7 +6464,8 @@ Options to control what test suites or cases to run
                         twice to run only "big" tests.
staging-run Run a limited number of tests (no slow tests). Used
                         for running staging trees with valgrind.
-  enable-disabled       Run also tests marked as disabled
+  enable-disabled       Run also tests marked as disabled or unstable
+  enable-unstable       Run also tests marked as unstable
print-testcases Don't run the tests but print details about all the
                         selected tests, in the order they would be run.
skip-test-list=FILE Skip the tests listed in FILE. Each line in the file diff --git a/mysql-test/suite/binlog/disabled.def b/mysql-test/suite/binlog/disabled.def
index 424e554..7a42685 100644
--- a/mysql-test/suite/binlog/disabled.def
+++ b/mysql-test/suite/binlog/disabled.def
@@ -6,8 +6,22 @@
 #
 #    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
 #
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
 #  Do not use any TAB characters for whitespace.
 #

##############################################################################
binlog_truncate_innodb : BUG#11764459 2010-10-20 anitha Originally disabled due to BUG#42643. Product bug fixed, but test changes needed binlog_spurious_ddl_errors : BUG#11761680 2013-01-18 astha Fixed on mysql-5.6 and trunk
+
+##########################
+
++ binlog_commit_wait : sporadic failures: MDEV-10150
++ binlog_dmls_on_tmp_tables_readonly : Added on 2016-05-04 (upstream)
++ binlog_xa_recover  : sporadic failures: MDEV-8517
diff --git a/mysql-test/suite/federated/disabled.def b/mysql-test/suite/federated/disabled.def
index bb2e4dd..279947b 100644
--- a/mysql-test/suite/federated/disabled.def
+++ b/mysql-test/suite/federated/disabled.def
@@ -6,6 +6,21 @@
 #
 #    <testcasename> : BUG#<xxxx> <comment>
 #
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
 #  Do not use any TAB characters for whitespace.
 #

##############################################################################
+
+##########################
+
++ federatedx             : sporadic failures: MDEV-10617
++ federated_innodb       : sporadic failures: MDEV-10617, MDEV-8691
++ federated_transactions : sporadic failures: MDEV-10617, MDEV-8691
++ federated_innodb       : sporadic failures: MDEV-8691
diff --git a/mysql-test/suite/funcs_1/disabled.def b/mysql-test/suite/funcs_1/disabled.def
index 9bfe956..3cdc1c6 100644
--- a/mysql-test/suite/funcs_1/disabled.def
+++ b/mysql-test/suite/funcs_1/disabled.def
@@ -1,12 +1,22 @@

##############################################################################
 #
-#  List the test cases that are to be disabled temporarely.
+#  List the test cases that are to be disabled temporarily.
 #
 #  Separate the test case name and the comment with ':'.
 #
-#      <testcasename>  : Comment test
+#    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
 #
-#  Don't use any TAB characters for whitespace.
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
+#  Do not use any TAB characters for whitespace.
 #

##############################################################################
 ++ processlist_priv_no_prot : Include file modified on 2016-07-12 (merge)
++ processlist_priv_ps      : Include file modified on 2016-07-12 (merge)
diff --git a/mysql-test/suite/innodb/disabled.def b/mysql-test/suite/innodb/disabled.def
index 8cae44a..49e87c4 100644
--- a/mysql-test/suite/innodb/disabled.def
+++ b/mysql-test/suite/innodb/disabled.def
@@ -6,7 +6,28 @@
 #
 #    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
 #
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
 #  Do not use any TAB characters for whitespace.
 #

##############################################################################
 +##########################
+
++ innodb.binlog_consistent       : sporadic failures: MDEV-10618
++ innodb.innodb-alter-table      : sporadic failures: MDEV-10619
++ innodb.innodb-wl5522-debug-zip : sporadic failures: MDEV-10427
++ innodb.innodb_bug30423         : sporadic failures: MDEV-7311
++ innodb-alter-table             : Modified on 2016-08-11 (MDEV-10535)
++ innodb-alter-tempfile          : Modified on 2016-08-09 (MDEV-10469)
++ innodb-fk-warnings             : Modified on 2016-07-18 (MDEV-8569)
++ innodb-fkcheck                 : Modified on 2016-06-13 (MDEV-10083)
++ innodb-wl5522 : rdiff file modified on 2016-08-10 (merge)
++ innodb_corrupt_bit             : Modified on 2016-06-21 (merge)
+
diff --git a/mysql-test/suite/parts/disabled.def b/mysql-test/suite/parts/disabled.def
index abbdbf7..17e2855 100644
--- a/mysql-test/suite/parts/disabled.def
+++ b/mysql-test/suite/parts/disabled.def
@@ -6,6 +6,14 @@
 #
 #    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
 #
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
 #  Do not use any TAB characters for whitespace.
 #

##############################################################################
@@ -15,3 +23,8 @@ parts.partition_mgm_lc1_archive : MDEV-5077 2013-09-27 svoj Cannot exchange part parts.partition_exchange_archive: MDEV-5077 2013-09-27 svoj Cannot exchange partition with archive table parts.partition_mgm_lc0_archive : MDEV-5077 2013-09-27 svoj Cannot exchange partition with archive table parts.partition_mgm_lc2_archive : MDEV-5077 2013-09-27 svoj Cannot exchange partition with archive table
+
+##########################
+
++ partition_float_myisam : sporadic failures: MDEV-10621
++ partition_int_myisam   : sporadic failures: MDEV-10621
diff --git a/mysql-test/suite/perfschema/disabled.def b/mysql-test/suite/perfschema/disabled.def
index d9e9e5b..8b4e222 100644
--- a/mysql-test/suite/perfschema/disabled.def
+++ b/mysql-test/suite/perfschema/disabled.def
@@ -6,6 +6,16 @@
 #
 #    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
 #
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  '*' wildcard in testcase names is supported.
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
 #  Do not use any TAB characters for whitespace.
 #

##############################################################################
@@ -22,3 +32,17 @@ binlog_edge_stmt: needs slave_relay_log_info
 binlog_ok_mix: needs slave_relay_log_info
 binlog_ok_row: needs slave_relay_log_info
 binlog_ok_stmt: needs slave_relay_log_info
+
+##########################
+
++ digest_table_full                 : Modified on 2016-06-21 (merge)
++ func_file_io                      : MDEV-5708 - fails for s390x
++ func_mutex                        : MDEV-5708 - fails for s390x
++ rpl_gtid_func                     : Modified on 2016-06-21 (merge)
++ sizing_low                        : Modified on 2016-04-26 (5.6.30 merge)
++ socket_summary_by_event_name_func : sporadic failures: MDEV-10622
++ start_server_low_digest           : Modified on 2016-06-21 (merge)
++ statement_digest                  : Modified on 2016-06-21 (merge)
++ statement_digest_consumers        : Modified on 2016-06-21 (merge)
++ statement_digest_long_query       : Modified on 2016-06-21 (merge)
++ table_name                        : Added on 2016-04-26 (5.6.30 merge)
diff --git a/mysql-test/suite/rpl/disabled.def b/mysql-test/suite/rpl/disabled.def
index de3091a..1d68be9 100644
--- a/mysql-test/suite/rpl/disabled.def
+++ b/mysql-test/suite/rpl/disabled.def
@@ -6,6 +6,14 @@
 #
 #    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
 #
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
 #  Do not use any TAB characters for whitespace.
 #

##############################################################################
@@ -13,3 +21,34 @@
rpl_spec_variables : BUG#11755836 2009-10-27 jasonh rpl_spec_variables fails on PB2 hpux rpl_get_master_version_and_clock : Bug#11766137 Jan 05 2011 joro Valgrind warnings rpl_get_master_version_and_clock rpl_partition_archive : MDEV-5077 2013-09-27 svoj Cannot exchange partition with archive table
+
+##########################
+
++ last_insert_id                    : sporadic failures: MDEV-10625
++ rpl_auto_increment                : sporadic failures: MDEV-8691
++ rpl_auto_increment_bug45679       : sporadic failures: MDEV-8691
++ rpl_auto_increment_update_failure : sporadic failures: MDEV-10625
++ rpl_binlog_index                  : sporadic failures: MDEV-9501
++ rpl_checksum_cache                : sporadic failures: MDEV-10626
++ rpl_circular_for_4_hosts          : sporadic failures: MDEV-10627
++ rpl_gtid_crash                    : sporadic failures: MDEV-9501
++ rpl_gtid_master_promote           : sporadic failures: MDEV-10628
++ rpl_gtid_stop_start               : sporadic failures: MDEV-10629
++ rpl_gtid_until                    : sporadic failures: MDEV-10625
++ rpl_ignore_table                  : Modified on 2016-06-22
++ rpl_insert                        : sporadic failures: MDEV-9329
++ rpl_insert_delayed                : sporadic failures: MDEV-9329
++ rpl_invoked_features              : sporadic failures: MDEV-8691
++ rpl_mdev6020                      : sporadic failures: MDEV-1630
++ rpl_mdev6386                      : sporadic failures: MDEV-10631
++ rpl_parallel                      : sporadic failures: MDEV-10632
++ rpl_parallel_temptable            : sporadic failures: MDEV-10356
++ rpl_row_drop_create_temp_table    : sporadic failures: MDEV-10626
++ rpl_row_sp001                     : sporadic failures: MDEV-9329
++ rpl_semi_sync_uninstall_plugin    : sporadic failures: MDEV-7140
++ rpl_slave_grp_exec                : sporadic failures: MDEV-10514
++ rpl_switch_stm_row_mixed          : sporadic failures: MDEV-10611
++ rpl_sync                          : sporadic failures: MDEV-10633
++ rpl_temporary_error2              : sporadic failures: MDEV-10634
++ sec_behind_master-5114            : sporadic failures: MDEV-8518
++ rpl_skip_replication              : sporadic failures: MDEV-9268
diff --git a/mysql-test/suite/sys_vars/disabled.def b/mysql-test/suite/sys_vars/disabled.def
index 7582152..06c394c 100644
--- a/mysql-test/suite/sys_vars/disabled.def
+++ b/mysql-test/suite/sys_vars/disabled.def
@@ -6,9 +6,23 @@
 #
 #    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
 #
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
 #  Do not use any TAB characters for whitespace.
 #

##############################################################################
  innodb_flush_checkpoint_debug_basic: removed from XtraDB-26.0
 table_open_cache_instances_basic: no such variable in MariaDB
+
+##########################
+
++ autocommit_func2          : sporadic failures: MDEV-9329
++ general_log_file_basic    : Modified on 2016-08-09 (MDEV-10465)
++ slow_query_log_file_basic : Modified on 2016-08-09 (MDEV-10465)
diff --git a/storage/connect/mysql-test/connect/disabled.def b/storage/connect/mysql-test/connect/disabled.def
index 9b45709..0ce6169 100644
--- a/storage/connect/mysql-test/connect/disabled.def
+++ b/storage/connect/mysql-test/connect/disabled.def
@@ -6,6 +6,14 @@
 #
 #    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
 #
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
 #  Do not use any TAB characters for whitespace.
 #

##############################################################################
@@ -14,3 +22,7 @@ jdbc : Variable settings depend on machine configuration
 jdbc_new        : Variable settings depend on machine configuration
 jdbc_oracle     : Variable settings depend on machine configuration
 jdbc_postgresql : Variable settings depend on machine configuration
+
+##########################
+
++ tbl : MDEV-9844, MDEV-10179 - sporadic crashes, valgrind warnings, wrong results diff --git a/storage/mroonga/mysql-test/mroonga/storage/disabled.def b/storage/mroonga/mysql-test/mroonga/storage/disabled.def
index 6866adc..c5c44db 100644
--- a/storage/mroonga/mysql-test/mroonga/storage/disabled.def
+++ b/storage/mroonga/mysql-test/mroonga/storage/disabled.def
@@ -1,3 +1,25 @@
+##############################################################################
+#
+#  List the test cases that are to be disabled temporarily.
+#
+#  Separate the test case name and the comment with ':'.
+#
+#    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  '*' wildcard in testcase names is supported.
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
+#  Do not use any TAB characters for whitespace.
+#
+##############################################################################
+
alter_table_add_index_token_filters_one_token_filter : Bundled Mroonga does not support token filter yet. alter_table_change_token_filter : Bundled Mroonga does not support token filter yet. fulltext_token_filters_skip : Bundled Mroonga does not support token filter yet. @@ -8,3 +30,11 @@ create_table_token_filters_table_comment_one_token_filter : Bundled Mroonga does
 foreign_key_create : Bundled Mroonga does not support this test yet.
 partition_insert : Bundled Mroonga does not support this test yet.
 +##########################
+
++ column_datetime_32bit_2038 : sporadic failures: MDEV-9270 ++ column_datetime_32bit_before_unix_epoch : sporadic failures: MDEV-9270 ++ column_datetime_32bit_max : sporadic failures: MDEV-9270 ++ column_datetime_32bit_out_of_range : sporadic failures: MDEV-9270 ++ index_multiple_column_unique_date_32bit_equal : sporadic failures: MDEV-9270 ++ index_multiple_column_unique_date_order_32bit_desc : sporadic failures: MDEV-9270 diff --git a/storage/tokudb/mysql-test/rpl/disabled.def b/storage/tokudb/mysql-test/rpl/disabled.def
index 4c1a9a3..c58408e 100644
--- a/storage/tokudb/mysql-test/rpl/disabled.def
+++ b/storage/tokudb/mysql-test/rpl/disabled.def
@@ -1,3 +1,25 @@
+##############################################################################
+#
+#  List the test cases that are to be disabled temporarily.
+#
+#  Separate the test case name and the comment with ':'.
+#
+#    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    + <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  '*' wildcard in testcase names is supported.
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
+#  Do not use any TAB characters for whitespace.
+#
+##############################################################################
+
 rpl_tokudb_delete_pk: unreliable, uses timestamp differences
 rpl_tokudb_delete_pk_lookup1: unreliable, uses timestamp differences
 rpl_tokudb_update_pk_uc0_lookup0: unreliable, uses timestamp differences
@@ -13,3 +35,7 @@ rpl_tokudb_write_unique_uc1: unreliable, uses timestamp differences
 rpl_tokudb_read_only_ff: unreliable, uses timestamp differences
 rpl_tokudb_read_only_tf: unreliable, uses timestamp differences
 rpl_tokudb_read_only_tt: unreliable, uses timestamp differences
+
+##########################
+
++ * : MDEV-9891 - massive crashes on shutdown
diff --git a/storage/tokudb/mysql-test/tokudb/disabled.def b/storage/tokudb/mysql-test/tokudb/disabled.def
index c98a8aa..3545544 100644
--- a/storage/tokudb/mysql-test/tokudb/disabled.def
+++ b/storage/tokudb/mysql-test/tokudb/disabled.def
@@ -1,3 +1,25 @@
+##############################################################################
+#
+#  List the test cases that are to be disabled temporarily.
+#
+#  Separate the test case name and the comment with ':'.
+#
+#    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  '*' wildcard in testcase names is supported.
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
+#  Do not use any TAB characters for whitespace.
+#
+##############################################################################
+
 fast_update_binlog_mixed: No UPSERT in MariaDB 5.5
 fast_update_binlog_row: No UPSERT in MariaDB 5.5
 fast_update_binlog_statement: No UPSERT in MariaDB 5.5
@@ -28,3 +50,10 @@ type_timestamp_explicit:
 cluster_key_part: engine options on partitioned tables
 i_s_tokudb_lock_waits_released: unstable, race conditions
 i_s_tokudb_locks_released: unstable, race conditions
+
+##########################
+
++ background_job_manager        : sporadic failures: MDEV-10327
++ cluster_filter_unpack_varchar : sporadic failures: MDEV-10636
+
++ * : MDEV-9891 - massive crashes on shutdown
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/disabled.def b/storage/tokudb/mysql-test/tokudb_bugs/disabled.def
index d0d1a47..6554b9a 100644
--- a/storage/tokudb/mysql-test/tokudb_bugs/disabled.def
+++ b/storage/tokudb/mysql-test/tokudb_bugs/disabled.def
@@ -1,2 +1,29 @@
+##############################################################################
+#
+#  List the test cases that are to be disabled temporarily.
+#
+#  Separate the test case name and the comment with ':'.
+#
+#    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    +<testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
+#  Do not use any TAB characters for whitespace.
+#
+##############################################################################
+
 5585: times out, too many huge insert...selects
 db233: different execution path in mariadb, debug_sync point is not hit
+
+##########################
+
++ checkpoint_lock   : sporadic failures: MDEV-10637
++ checkpoint_lock_3 : sporadic failures: MDEV-10637
+
++ * : MDEV-9891 - massive crashes on shutdown
diff --git a/storage/tokudb/mysql-test/tokudb_parts/disabled.def b/storage/tokudb/mysql-test/tokudb_parts/disabled.def
index 3252a46..7df2ac7 100644
--- a/storage/tokudb/mysql-test/tokudb_parts/disabled.def
+++ b/storage/tokudb/mysql-test/tokudb_parts/disabled.def
@@ -1,3 +1,25 @@
+##############################################################################
+#
+#  List the test cases that are to be disabled temporarily.
+#
+#  Separate the test case name and the comment with ':'.
+#
+#    <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  To mark a test as unstable, put '+' in front of the testcase name:
+#    + <testcasename> : BUG#<xxxx> <date disabled> <disabler> <comment>
+#
+#  '*' wildcard in testcase names is supported.
+#
+# The difference between disabled and unstable tests is that the former +# have to be skipped (either fail always, or are not applicable), +# while the latter fail sporadically, but can still have value. +# Importantly, unstable tests will be run in buildbot. +#
+#  Do not use any TAB characters for whitespace.
+#
+##############################################################################
+
 partition_max_parts_hash_tokudb: 5.6 test not merged yet
 partition_max_parts_inv_tokudb: 5.6 test not merged yet
 partition_max_parts_key_tokudb: 5.6 test not merged yet
@@ -7,3 +29,7 @@ partition_max_sub_parts_key_list_tokudb: 5.6 test not merged yet
 partition_max_sub_parts_key_range_tokudb: 5.6 test not merged yet
 partition_max_sub_parts_list_tokudb: 5.6 test not merged yet
 partition_max_sub_parts_range_tokudb: 5.6 test not merged yet
+
+##########################
+
++ * : MDEV-9891 - massive crashes on shutdown
_______________________________________________
commits mailing list
commits@xxxxxxxxxxx
https://lists.askmonty.org/cgi-bin/mailman/listinfo/commits


Follow ups