summaryrefslogtreecommitdiff
path: root/mysql-test/unstable-tests
blob: 868a6c9068546dca1b642bb07de756a4c5fa1493 (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
282
283
284
285
286
287
288
##############################################################################
#
#  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_online            : Modified in 10.0.32
main.binary_to_hex                 : Modified in 10.0.32
main.bootstrap                     : Modified in 10.0.32
main.count_distinct                : Modified in 10.0.32
main.count_distinct2               : MDEV-11768 - timeout
main.create_delayed                : MDEV-10605 - failed with timeout
main.ctype_ucs                     : Modified in 10.0.32
main.debug_sync                    : MDEV-10607 - internal error
main.derived_opt                   : MDEV-11768 - timeout
main.engine_error_in_alter-8453    : Added in 10.0.32
main.events_slowlog                : MDEV-12821 - wrong result
main.func_concat                   : Modified in 10.0.32
main.func_crypt                    : Modified in 10.0.32
main.func_regexp_pcre              : MDEV-13412 - crash, wrong result; modified in 10.0.32
main.gis                           : MDEV-13411 - wrong result on P8; modified in 10.0.32
main.gis-alter_table_online        : Added in 10.0.32
main.gis-rt-precise                : Modified in 10.0.32
main.group_by                      : Modified in 10.0.32
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_outer                    : Modified in 10.0.32
main.loadxml                       : Data file modified in 10.0.32
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.merge                         : MDEV-10607 - sporadic "can't connect"
main.mysql                         : Modified in 10.0.32
main.mysqlhotcopy_myisam           : MDEV-10995 - test hangs on debug build
main.mysqltest                     : MDEV-9269 - fails on Alpha; modified in 10.0.32
main.mysql_upgrade                 : Modified in 10.0.32
main.ps                            : MDEV-11017 - sporadic wrong Prepared_stmt_count
main.read_only                     : Modified in 10.0.32
main.show_explain                  : MDEV-10674 - wrong result
main.sp_notembedded                : MDEV-10607 - internal error
main.sp-security                   : MDEV-10607 - sporadic "can't connect"
main.subselect                     : Modified in 10.0.32
main.subselect_innodb              : MDEV-10614 - sporadic wrong results
main.subselect_mat_cost_bugs       : Modified in 10.0.32
main.subselect_nulls               : Modified in 10.0.32
main.subselect_sj2_mat             : Modified in 10.0.32
main.subselect_sj_mat              : MOdified in 10.0.32
main.symlink-aria-11902            : MDEV-12215 - Wrong error number
main.symlink-myisam-11902          : MDEV-12215 - Wrong error number
main.union                         : Modified in 10.0.32
main.view                          : Modified in 10.0.32
main.xa                            : MDEV-11769 - lock wait timeout

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

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_unsafe               : Modified in 10.0.32
binlog.binlog_xa_recover           : MDEV-8517 - Extra checkpoint

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

connect.drop-open-error  : Added in 10.0.32
connect.grant2           : Modified in 10.0.32
connect.infoschema-9739  : Added in 10.0.32
connect.json             : Sporadic wrong result, tentative fix in 10.0.32
connect.mysql_new        : Modified in 10.0.32
connect.odbc_firebird    : Added in 10.0.32
connect.secure_file_priv : Modified in 10.0.32
connect.tbl              : MDEV-9844, MDEV-10179 - sporadic crashes, valgrind warnings, wrong results
connect.zip              : Sporadic wrong result, tentative fix expected in 10.0.32

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

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

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

federated.federatedx             : MDEV-10617 - Wrong checksum, timeouts
federated.federated_bug_35333    : MDEV-13410 - Wrong result
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.binlog_consistent                     : MDEV-10618 - Server fails to start
innodb.drop_table_background                 : MDEV-13407 - Tablespace exists; added in 10.0.32
innodb.group_commit_crash_no_optimize_thread : MDEV-11770 - checksum mismatch
innodb.innodb-alter-debug                    : Modified in 10.0.32
innodb.innodb-alter-discard                  : Modified in 10.0.32
innodb.innodb-alter-nullable                 : Modified in 10.0.32
innodb.innodb-alter-table                    : MDEV-10619 - Testcase timeout; modified in 10.0.32
innodb.innodb-alter-tempfile                 : Modified in 10.0.32
innodb.innodb_bug30423                       : MDEV-7311 - Wrong number of rows in the plan
innodb.innodb-get-fk                         : Modified in 10.0.32
innodb.innodb_monitor                        : MDEV-10939 - Testcase timeout
innodb.log_file_size                         : Modified in 10.0.32
innodb.row_format_redundant                  : Added in 10.0.32
innodb.table_flags                           : Added in 10.0.32

innodb_zip.innodb_bug36169                   : Modified in 10.0.32
innodb_zip.innodb_bug36172                   : Modified in 10.0.32
innodb_zip.innodb_bug52745                   : Modified in 10.0.32
innodb_zip.innodb_bug53591                   : Modified in 10.0.32
innodb_zip.innodb_bug56680                   : Modified in 10.0.32
innodb_zip.innodb-create-options             : Modified in 10.0.32
innodb_zip.innodb-zip                        : Modified in 10.0.32

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

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.info_logs   : MDEV-10042 - Wrong result
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

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

parts.longname                   : Added in 10.0.32
parts.partition_exch_qa_10       : MDEV-11765 - wrong result
parts.quoting                    : Added in 10.0.32

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

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_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
roles.current_role_view-12666         : Added in 10.0.32
roles.show_create_database-10463      : Added in 10.0.32

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

rpl.circular_serverid0                : Added in 10.0.32
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_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_parallel                      : MDEV-10653 - Timeouts
rpl.rpl_parallel_mdev6589             : MDEV-12979 - Assertion failure
rpl.rpl_parallel_temptable            : MDEV-10356 - Crash in close_thread_tables
rpl.rpl_partition_innodb              : MDEV-10417 - Fails on Mips
rpl.rpl_reset_slave_fail              : Added in 10.0.32
rpl.rpl_row_basic_11bugs              : MDEV-12171 - Server failed to start
rpl.rpl_row_index_choice              : MDEV-13409 - Server crash
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_sched_priority_cleaner_basic : Modified in 10.0.32
sys_vars.thread_cache_size_func            : MDEV-11775 - wrong result

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

tokudb.change_column_all_1000_10     : MDEV-12640 - Lost connection during query
tokudb.change_column_bin             : MDEV-12640 - Lost connection during query
tokudb.change_column_char            : MDEV-12822 - Lost connection during query
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 : MDEV-12823 - Valgrind
tokudb.hotindex-update-1             : MDEV-12640 - Lost connection during query
tokudb.locks-select-update-1         : MDEV-13406 - Lock wait timeout
tokudb.rows-32m-rand-insert          : MDEV-12640 - Lost connection during query
tokudb.rows-32m-seq-insert           : MDEV-12640 - Lost connection during query

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.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_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

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

vcol.not_supported    : MDEV-10639 - Testcase timeout
vcol.vcol_keys_innodb : MDEV-10639 - Testcase timeout

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