Description:
main.desc_index_innodb failed sometimes.
[mysql-test]$ ./mtr main.desc_index_innodb --repeat=100
Logging: ./mtr main.desc_index_innodb --repeat=100
MySQL Version 8.0.20
Checking supported features
- Binaries are debug compiled
Using 'all' suites
Collecting tests
Checking leftover processes
Removing old var directory
Creating var directory '/common_02/mtu/mysql/bin_debug/mysql-test/var'
Installing system database
Using parallel: 1
==============================================================================
TEST NAME RESULT TIME (ms) COMMENT
------------------------------------------------------------------------------
[ 1%] main.desc_index_innodb [ pass ] 7249
[ 2%] main.desc_index_innodb [ pass ] 6840
[ 3%] main.desc_index_innodb [ pass ] 7212
[ 4%] main.desc_index_innodb [ pass ] 7386
[ 5%] main.desc_index_innodb [ pass ] 7522
[ 6%] main.desc_index_innodb [ pass ] 7211
[ 7%] main.desc_index_innodb [ pass ] 6971
[ 8%] main.desc_index_innodb [ pass ] 7890
[ 9%] main.desc_index_innodb [ pass ] 7016
[ 10%] main.desc_index_innodb [ pass ] 7242
[ 11%] main.desc_index_innodb [ pass ] 7257
[ 12%] main.desc_index_innodb [ pass ] 7209
[ 13%] main.desc_index_innodb [ pass ] 6694
[ 14%] main.desc_index_innodb [ pass ] 7009
[ 15%] main.desc_index_innodb [ pass ] 6962
[ 16%] main.desc_index_innodb [ pass ] 7237
[ 17%] main.desc_index_innodb [ pass ] 7022
[ 18%] main.desc_index_innodb [ pass ] 6848
[ 19%] main.desc_index_innodb [ pass ] 7082
[ 20%] main.desc_index_innodb [ pass ] 7299
[ 21%] main.desc_index_innodb [ pass ] 7138
[ 22%] main.desc_index_innodb [ pass ] 7037
[ 23%] main.desc_index_innodb [ pass ] 7165
[ 24%] main.desc_index_innodb [ pass ] 7465
[ 25%] main.desc_index_innodb [ pass ] 7171
[ 26%] main.desc_index_innodb [ pass ] 7037
[ 27%] main.desc_index_innodb [ pass ] 7798
[ 28%] main.desc_index_innodb [ pass ] 7211
[ 28%] main.desc_index_innodb [ pass ] 7326
[ 30%] main.desc_index_innodb [ pass ] 7218
[ 31%] main.desc_index_innodb [ pass ] 7487
[ 32%] main.desc_index_innodb [ pass ] 7107
[ 33%] main.desc_index_innodb [ pass ] 7334
[ 34%] main.desc_index_innodb [ pass ] 7824
[ 35%] main.desc_index_innodb [ pass ] 7075
[ 36%] main.desc_index_innodb [ pass ] 7249
[ 37%] main.desc_index_innodb [ pass ] 7304
[ 38%] main.desc_index_innodb [ pass ] 7473
[ 39%] main.desc_index_innodb [ pass ] 7114
[ 40%] main.desc_index_innodb [ pass ] 7192
[ 41%] main.desc_index_innodb [ fail ]
Test ended at 2020-06-16 21:23:34
CURRENT_TEST: main.desc_index_innodb
--- /common_02/mtu/mysql/bin_debug/mysql-test/r/desc_index_innodb.result 2020-06-12 04:49:40.000000000 +0300
+++ /common_02/mtu/mysql/bin_debug/mysql-test/var/log/desc_index_innodb.reject 2020-06-16 16:23:33.716000000 +0300
@@ -1639,7 +1639,7 @@
EXPLAIN SELECT * FROM t1 WHERE pk IN (6,2)
OR (col_int_key >= 7 AND col_int_key < 13);
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
-1 SIMPLE t1 NULL index_merge PRIMARY,col_int_key,key1,key2 key1,col_int_key 4,5 NULL 2 100.00 Using sort_union(key1,col_int_key); Using where
+1 SIMPLE t1 NULL index PRIMARY,col_int_key,key1,key2 col_int_key 5 NULL 20 28.89 Using where; Using index
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`col_int_key` AS `col_int_key` from `test`.`t1` where ((`test`.`t1`.`pk` in (6,2)) or ((`test`.`t1`.`col_int_key` >= 7) and (`test`.`t1`.`col_int_key` < 13)))
SELECT * FROM t1 WHERE pk IN (6,2)
mysqltest: Result content mismatch
safe_process[15331]: Child process: 15332, exit: 1
How to repeat:
./mtr main.desc_index_innodb --repeat=100
Description: main.desc_index_innodb failed sometimes. [mysql-test]$ ./mtr main.desc_index_innodb --repeat=100 Logging: ./mtr main.desc_index_innodb --repeat=100 MySQL Version 8.0.20 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/common_02/mtu/mysql/bin_debug/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [ 1%] main.desc_index_innodb [ pass ] 7249 [ 2%] main.desc_index_innodb [ pass ] 6840 [ 3%] main.desc_index_innodb [ pass ] 7212 [ 4%] main.desc_index_innodb [ pass ] 7386 [ 5%] main.desc_index_innodb [ pass ] 7522 [ 6%] main.desc_index_innodb [ pass ] 7211 [ 7%] main.desc_index_innodb [ pass ] 6971 [ 8%] main.desc_index_innodb [ pass ] 7890 [ 9%] main.desc_index_innodb [ pass ] 7016 [ 10%] main.desc_index_innodb [ pass ] 7242 [ 11%] main.desc_index_innodb [ pass ] 7257 [ 12%] main.desc_index_innodb [ pass ] 7209 [ 13%] main.desc_index_innodb [ pass ] 6694 [ 14%] main.desc_index_innodb [ pass ] 7009 [ 15%] main.desc_index_innodb [ pass ] 6962 [ 16%] main.desc_index_innodb [ pass ] 7237 [ 17%] main.desc_index_innodb [ pass ] 7022 [ 18%] main.desc_index_innodb [ pass ] 6848 [ 19%] main.desc_index_innodb [ pass ] 7082 [ 20%] main.desc_index_innodb [ pass ] 7299 [ 21%] main.desc_index_innodb [ pass ] 7138 [ 22%] main.desc_index_innodb [ pass ] 7037 [ 23%] main.desc_index_innodb [ pass ] 7165 [ 24%] main.desc_index_innodb [ pass ] 7465 [ 25%] main.desc_index_innodb [ pass ] 7171 [ 26%] main.desc_index_innodb [ pass ] 7037 [ 27%] main.desc_index_innodb [ pass ] 7798 [ 28%] main.desc_index_innodb [ pass ] 7211 [ 28%] main.desc_index_innodb [ pass ] 7326 [ 30%] main.desc_index_innodb [ pass ] 7218 [ 31%] main.desc_index_innodb [ pass ] 7487 [ 32%] main.desc_index_innodb [ pass ] 7107 [ 33%] main.desc_index_innodb [ pass ] 7334 [ 34%] main.desc_index_innodb [ pass ] 7824 [ 35%] main.desc_index_innodb [ pass ] 7075 [ 36%] main.desc_index_innodb [ pass ] 7249 [ 37%] main.desc_index_innodb [ pass ] 7304 [ 38%] main.desc_index_innodb [ pass ] 7473 [ 39%] main.desc_index_innodb [ pass ] 7114 [ 40%] main.desc_index_innodb [ pass ] 7192 [ 41%] main.desc_index_innodb [ fail ] Test ended at 2020-06-16 21:23:34 CURRENT_TEST: main.desc_index_innodb --- /common_02/mtu/mysql/bin_debug/mysql-test/r/desc_index_innodb.result 2020-06-12 04:49:40.000000000 +0300 +++ /common_02/mtu/mysql/bin_debug/mysql-test/var/log/desc_index_innodb.reject 2020-06-16 16:23:33.716000000 +0300 @@ -1639,7 +1639,7 @@ EXPLAIN SELECT * FROM t1 WHERE pk IN (6,2) OR (col_int_key >= 7 AND col_int_key < 13); id select_type table partitions type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 NULL index_merge PRIMARY,col_int_key,key1,key2 key1,col_int_key 4,5 NULL 2 100.00 Using sort_union(key1,col_int_key); Using where +1 SIMPLE t1 NULL index PRIMARY,col_int_key,key1,key2 col_int_key 5 NULL 20 28.89 Using where; Using index Warnings: Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`col_int_key` AS `col_int_key` from `test`.`t1` where ((`test`.`t1`.`pk` in (6,2)) or ((`test`.`t1`.`col_int_key` >= 7) and (`test`.`t1`.`col_int_key` < 13))) SELECT * FROM t1 WHERE pk IN (6,2) mysqltest: Result content mismatch safe_process[15331]: Child process: 15332, exit: 1 How to repeat: ./mtr main.desc_index_innodb --repeat=100