summaryrefslogtreecommitdiff
path: root/mysql-test/unstable-tests
blob: 6c84d8d3ba636796e3b01508c7e4442cd6c0ea3a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
##############################################################################
#
#  List the test cases which, unlike tests from disabled.def files,
#  can still be run on the current tree meaningfully, but are known 
#  or suspected to fail sporadically on different reasons.
#
#  Most common reasons are either test failures observed in buildbot,
#  or recent modifications to the tests which make their stability 
#  unknown. 
#
#  Tests included due to recent modifications are later removed from the 
#  list, if during a certain period they do not fail (and are not 
#  modified again). Tests included due to intermittent failures are 
#  removed when corresponding bug reports are closed. 
#
#  Separate the test case name and the comment with ':'.
#
#    <suitename>.<testcasename> : MDEV-xxxxx - <comment>
#
#  '*' wildcard in testcase names is supported.
#
#  To use the list, run MTR with --skip-test-list=unstable-tests option. 
#
##############################################################################

main.alter_table                   : Modified in 10.0.30
main.count_distinct2               : MDEV-11768 - timeout
main.create_delayed                : MDEV-10605 - failed with timeout
main.debug_sync                    : MDEV-10607 - internal error
main.derived                       : Modified in 10.0.30
main.derived_opt                   : MDEV-11768 - timeout
main.events_restart                : MDEV-11221 - assertion failure
main.grant                         : Modified in 10.0.30
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 result
main.innodb_mysql_lock             : MDEV-7861 - sporadic lock detection failure
main.join_nested                   : Modified in 10.0.30
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.mysqldump                     : Modified in 10.0.30
main.mysqlhotcopy_myisam           : MDEV-10995 - test hangs on debug build
main.mysqltest                     : MDEV-9269 - fails on Alpha
main.partition_innodb              : Modified in 10.0.30
main.partition_myisam              : Modified in 10.0.30
main.ps                            : MDEV-11017 - sporadic wrong Prepared_stmt_count
main.range_vs_index_merge          : Modified in 10.0.30
main.repair_symlink-5543           : Modified in 10.0.30
main.show_explain                  : MDEV-10674 - wrong result
main.signal_demo3                  : MDEV-11720 - Thread stack overrun on Solaris
main.sp                            : Modified in 10.0.30
main.sp_notembedded                : MDEV-10607 - internal error
main.sp-security                   : MDEV-10607 - sporadic "can't connect"
main.subselect_innodb              : MDEV-10614 - sporadic wrong results
main.symlink-aria-11902            : Added in 10.0.30
main.symlink-myisam-11902          : Added in 10.0.30
main.table_elim                    : Modified in 10.0.30
main.view                          : Modified in 10.0.30
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.archive_symlink      : MDEV-12170 - unexpected error on rmdir
archive.discover             : MDEV-10510 - table is marked as crashed
archive.mysqlhotcopy_archive : MDEV-10995 - test hangs on debug build

#----------------------------------------------------------------

binlog.binlog_commit_wait                 : MDEV-10150 - Error: too much time elapsed
binlog.binlog_max_binlog_stmt_cache_size  : Added in 10.0.30
binlog.binlog_xa_recover                  : MDEV-8517 - Extra checkpoint

#----------------------------------------------------------------

connect.tbl             : MDEV-9844, MDEV-10179 - sporadic crashes, valgrind warnings, wrong results
connect.xml             : Uses xsample2.xml modified in 10.0.30
connect.xml_zip         : Added in 10.0.30
connect.zip             : Added in 10.0.30

#----------------------------------------------------------------

engines/rr_trx.* : MDEV-10998 - tests not maintained

#----------------------------------------------------------------

federated_bug_35333              : Modified in 10.0.30
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
federated.federated_transactions : MDEV-10617, MDEV-10417 - Wrong checksum, timeouts, fails on Mips

#----------------------------------------------------------------

funcs_1.memory_views       : MDEV-11773 - timeout
funcs_1.processlist_val_ps : MDEV-12175 - Wrong result

funcs_2/charset.*          : MDEV-10999 - test not maintained

#----------------------------------------------------------------

innodb.alter_key_block_size-11757            : Added in 10.0.30
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_blob_unrecoverable_crash       : Modified in 10.0.30
innodb.innodb_bug14676111                    : Modified in 10.0.30
innodb.innodb_bug30423                       : MDEV-7311 - Wrong number of rows in the plan
innodb.innodb_bug59641                       : Modified in 10.0.30
innodb.innodb-get-fk                         : Modified in 10.0.30
innodb.innodb_monitor                        : MDEV-10939 - Testcase timeout
innodb.log_file_size                         : Added in 10.0.30
innodb.read_only_recovery                    : Added in 10.0.30
innodb.xa_recovery                           : Modified in 10.0.30

innodb_fts.create                            : Added in 10.0.30
innodb_fts.innodb_fts_stopword_charset       : MDEV-12052 - Crash on shutdown

#----------------------------------------------------------------

mroonga/storage.column_datetime_32bit_2038                         : Wrong result on Alpha
mroonga/storage.column_datetime_32bit_before_unix_epoch            : Wrong result on Alpha
mroonga/storage.column_datetime_32bit_max                          : Wrong result on Alpha
mroonga/storage.column_datetime_32bit_out_of_range                 : Wrong result on Alpha
mroonga/storage.index_multiple_column_unique_date_32bit_equal      : Wrong result on Alpha
mroonga/storage.index_multiple_column_unique_date_order_32bit_desc : Wrong result on Alpha

#----------------------------------------------------------------

multi_source.gtid        : MDEV-10417 - Fails on Mips
multi_source.multisource : MDEV-10417 - Fails on Mips
multi_source.simple      : MDEV-4633 - Wrong slave status output
multi_source.status_vars : MDEV-4632 - failed while waiting for Slave_received_heartbeats


#----------------------------------------------------------------

oqgraph.regression_mdev6282 : Modified in 10.0.30
oqgraph.regression_mdev6345 : Modified in 10.0.30

#----------------------------------------------------------------

parts.partition_bigint_innodb    : Added in 10.0.30
parts.partition_bigint_myisam    : Added in 10.0.30
parts.partition_double_innodb    : Added in 10.0.30
parts.partition_double_myisam    : Added in 10.0.30
parts.partition_exch_qa_10       : MDEV-11765 - wrong result
parts.partition_float_innodb     : Modified in 10.0.30
parts.partition_float_myisam     : Modified in 10.0.30
parts.partition_int_innodb       : Modified in 10.0.30
parts.partition_int_myisam       : Modified in 10.0.30
parts.partition_mediumint_innodb : Added in 10.0.30
parts.partition_mediumint_myisam : Added in 10.0.30
parts.partition_smallint_innodb  : Added in 10.0.30
parts.partition_smallint_myisam  : Added in 10.0.30
parts.partition_tinyint_innodb   : Added in 10.0.30
parts.partition_tinyint_myisam   : Added in 10.0.30

#----------------------------------------------------------------

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.socket_summary_by_event_name_func : MDEV-10622 - Socket summary tables do not match
perfschema.stage_mdl_procedure               : MDEV-11545 - Wrong result
perfschema.threads_mysql                     : MDEV-12177 - Wrong result

perfschema_stress.* : MDEV-10996 - tests not maintained

#----------------------------------------------------------------

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_grant_role           : MDEV-11772 - wrong result

#----------------------------------------------------------------

rpl.last_insert_id                    : MDEV-10625 - warnings in error log
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
rpl.rpl_binlog_index                  : MDEV-9501 - Warning: failed registering on master
rpl.rpl_checksum_cache                : MDEV-12173 - InnoDB error
rpl.rpl_ddl                           : MDEV-10417 - Fails on Mips
rpl.rpl_gtid_crash                    : MDEV-9501 - Warning: failed registering on 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               : Modified in 10.0.30
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_mdev6020                      : MDEV-10630, MDEV-10417 - Timeouts, fails on Mips
rpl.rpl_mdev6386                      : Modified in 10.0.30
rpl.rpl_parallel                      : MDEV-10653 - Timeouts
rpl.rpl_parallel_temptable            : MDEV-10356 - Crash in close_thread_tables
rpl.rpl_partition_innodb              : MDEV-10417 - Fails on Mips
rpl.rpl_row_basic_11bugs              : MDEV-12171 - Server failed to start
rpl.rpl_row_sp001                     : MDEV-9329 - Fails on Ubuntu/s390x
rpl.rpl_semi_sync                     : MDEV-11220 - Wrong result
rpl.rpl_semi_sync_uninstall_plugin    : MDEV-7140 - Wrong plugin status
rpl.rpl_show_slave_hosts              : MDEV-12171 - Server failed to start
rpl.rpl_slave_grp_exec                : MDEV-10514 - Unexpected deadlock
rpl.rpl_sync                          : MDEV-10633 - Database page corruption
rpl.rpl_temporary_error2              : MDEV-10634 - Wrong number of retries
rpl.rpl_skip_replication              : MDEV-9268 - Fails with timeout in sync_slave_with_master on Alpha

rpl/extra/rpl_tests.*                 : MDEV-10994 - tests not maintained

#----------------------------------------------------------------

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
spider/bg.vp_fixes              : MDEV-9329 - Fails on Ubuntu/s390x

#----------------------------------------------------------------

sphinx.* : MDEV-10986 - sphinx tests fail in buildbot and outside

#----------------------------------------------------------------

stress.ddl_innodb : MDEV-10635 - Testcase timeout

#----------------------------------------------------------------

sys_vars.autocommit_func2                  : MDEV-9329 - Fails on Ubuntu/s390x
sys_vars.innodb_buffer_pool_dump_pct_basic : MDEV-10651 - sporadic failure on file_exists
sys_vars.innodb_force_recovery_crash_basic : Modified in 10.0.30
sys_vars.innodb_stats_include_delete_marked_basic : Added in 10.0.30
sys_vars.innodb_status_output_basic        : MDEV-12174 - Timeout
sys_vars.secure_file_priv                  : Modified in 10.0.30
sys_vars.thread_cache_size_func            : MDEV-11775 - wrong result

#----------------------------------------------------------------

tokudb.cluster_filter_unpack_varchar : MDEV-10636 - Wrong execution plan
tokudb.dir_per_db                    : MDEV-11537 - wrong result
tokudb.dir_per_db_rename_to_nonexisting_schema : Added in 10.0.30
tokudb.gap_lock_error                : Added in 10.0.30
tokudb.locks-select-update-3         : Modified in 10.0.30
tokudb.percona_kill_idle_trx_tokudb  : Added in 10.0.30

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.xa                       : MDEV-11804 - Lock wait timeout

tokudb_rpl.*                         : MDEV-11001 - tests don't work
tokudb_sys_vars.*                    : MDEV-11001 - tests don't work

rpl-tokudb.rpl_extra_col_slave_tokudb : Result file modified in 10.0.30

#----------------------------------------------------------------

unit.ma_test_loghandler : MDEV-10638 - record read not ok
unit.pfs                : MySQL:84457 - unittest pft-t failing

#----------------------------------------------------------------

vcol.not_supported    : MDEV-10639 - Testcase timeout
vcol.vcol_keys_innodb : MDEV-10639 - Testcase timeout
vcol.vcol_misc              : Modified in 10.0.30
vcol.vcol_select_myisam     : Modified in 10.0.30
vcol.vcol_trigger_sp_innodb : Include file modified in 10.0.30
vcol.vcol_trigger_sp_myisam : Include file modified in 10.0.30
vcol.wrong_arena            : Added in 10.0.30

#----------------------------------------------------------------