Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12253

Buffer pool blocks are accessed after they have been freed

Details

    • 10.2.6-2, 10.2.6-3, 10.1.23

    Description

      bpage could be referenced after it was already freed from LRU. We should remove corrupted or still encrypted pages from LRU as soon as we detect the problem and after that point page should not be anymore referenced.

      Attachments

        Issue Links

          Activity

            I need to skip your suggested test for page compressed and page compressed + encrypted tables. There is no way to "match" secondary index entry to string and replace it another using perl when that string is compressed or encrypted, encryption contents will vary based on lsn and tablespace no. Corrupting random bytes on compressed page will lead crash on:

            #6  0x0000557bb6bb1a96 in fil_decompress_page (page_buf=0x7f39bd878000 "\250\025\333\240", buf=0x7f39c33c4000 "\336\255\276\357", len=16384, write_size=0x7f39c2fa7ca8, return_error=false) at /home/jan/mysql/10.1/storage/xtradb/fil/fil0pagecompress.cc:557
            #7  0x0000557bb6b37858 in buf_page_decrypt_after_read (bpage=0x7f39c2fa7c88) at /home/jan/mysql/10.1/storage/xtradb/buf/buf0buf.cc:6435
            #8  0x0000557bb6b339bb in buf_page_io_complete (bpage=0x7f39c2fa7c88) at /home/jan/mysql/10.1/storage/xtradb/buf/buf0buf.cc:4674
            #9  0x0000557bb6bac740 in fil_aio_wait (segment=2) at /home/jan/mysql/10.1/storage/xtradb/fil/fil0fil.cc:6372
            #10 0x0000557bb6a9b26e in io_handler_thread (arg=0x557bb7e9a510 <n+16>) at /home/jan/mysql/10.1/storage/xtradb/srv/srv0start.cc:546
            #11 0x00007f39ce194424 in start_thread (arg=0x7f39c17fd700) at pthread_create.c:333
            #12 0x00007f39cba129bf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105
            

            That might be fixable but I will not take it part of this bug. I will research if I could do test with:

            • normal tables
            • row comparessed table
            • encrypted table
            • row compressed + encrypted

            These are different because they contain checksum but no promises (before I have done the test).

            jplindst Jan Lindström (Inactive) added a comment - I need to skip your suggested test for page compressed and page compressed + encrypted tables. There is no way to "match" secondary index entry to string and replace it another using perl when that string is compressed or encrypted, encryption contents will vary based on lsn and tablespace no. Corrupting random bytes on compressed page will lead crash on: #6 0x0000557bb6bb1a96 in fil_decompress_page (page_buf=0x7f39bd878000 "\250\025\333\240", buf=0x7f39c33c4000 "\336\255\276\357", len=16384, write_size=0x7f39c2fa7ca8, return_error=false) at /home/jan/mysql/10.1/storage/xtradb/fil/fil0pagecompress.cc:557 #7 0x0000557bb6b37858 in buf_page_decrypt_after_read (bpage=0x7f39c2fa7c88) at /home/jan/mysql/10.1/storage/xtradb/buf/buf0buf.cc:6435 #8 0x0000557bb6b339bb in buf_page_io_complete (bpage=0x7f39c2fa7c88) at /home/jan/mysql/10.1/storage/xtradb/buf/buf0buf.cc:4674 #9 0x0000557bb6bac740 in fil_aio_wait (segment=2) at /home/jan/mysql/10.1/storage/xtradb/fil/fil0fil.cc:6372 #10 0x0000557bb6a9b26e in io_handler_thread (arg=0x557bb7e9a510 <n+16>) at /home/jan/mysql/10.1/storage/xtradb/srv/srv0start.cc:546 #11 0x00007f39ce194424 in start_thread (arg=0x7f39c17fd700) at pthread_create.c:333 #12 0x00007f39cba129bf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 That might be fixable but I will not take it part of this bug. I will research if I could do test with: normal tables row comparessed table encrypted table row compressed + encrypted These are different because they contain checksum but no promises (before I have done the test).
            jplindst Jan Lindström (Inactive) added a comment - After second round of review comments: 10.1: https://github.com/MariaDB/server/commit/e4c2e918073188e63bd3c3ad529628d442153db0 10.2: https://github.com/MariaDB/server/commit/e721a5f59d5d72ec76793ea9ca048eb4a6504efc

            ASAN:

            10.1:

            jan@jan-laptop-asus:~/mysql/10.1-bugs/mysql-test$ ASAN_OPTIONS=abort_on_error=1 ./mtr --vardir=/dev/shm --suite=innodb,encryption,innodb_zip --force --parallel=auto --big-test
            Logging: ./mtr  --vardir=/dev/shm --suite=innodb,encryption,innodb_zip --force --parallel=auto --big-test
            vardir: /dev/shm
            Checking leftover processes...
            Removing old var directory...
            couldn't chmod(0777, /dev/shm): Operation not permitted at /usr/share/perl/5.24/File/Find.pm line 511.
            Couldn't remove directory '/dev/shm': Permission denied at /usr/share/perl/5.24/File/Find.pm line 511.
            Creating var directory '/dev/shm'...
            Checking supported features...
            MariaDB Version 10.1.23-MariaDB-debug
             - SSL connections supported
             - binaries are debug compiled
            Using suites: innodb,encryption,innodb_zip
            Collecting tests...
            Installing system database...
            Using parallel: 4
             
            ==============================================================================
             
            TEST                                  WORKER RESULT   TIME (ms) or COMMENT
            --------------------------------------------------------------------------
             
            worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
            worker[3] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
            worker[2] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059
            worker[4] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079
            encryption.innodb_scrub                  [ disabled ]  MDEV-8139 scrubbing does not work reliably
            encryption.innodb_scrub_background       [ disabled ]  MDEV-8139 scrubbing does not work reliably
            encryption.innodb_encryption-page-compression 'innodb_plugin' w1 [ pass ]  10031
            encryption.innodb_encryption-page-compression 'xtradb' w1 [ pass ]   8422
            encryption.innodb_encryption_tables 'innodb_plugin' w4 [ pass ]  36535
            encryption.innodb_encryption 'innodb_plugin' w3 [ pass ]  42387
            encryption.innodb_encryption 'xtradb'    w2 [ pass ]  45054
            innodb.innodb_bug53674 'innodb_plugin'   w2 [ pass ]     67
            innodb.innodb_bug53674 'xtradb'          w2 [ pass ]     51
            innodb.innodb 'innodb_plugin'            w4 [ pass ]  18317
            encryption.tempfiles 'cbc,xtradb'        w2 [ pass ]    288
            innodb.innodb 'xtradb'                   w3 [ pass ]  16331
            encryption.tempfiles 'ctr,xtradb'        w4 [ pass ]    161
            encryption.innodb_encryption_tables 'xtradb' w1 [ pass ]  40168
            innodb.snapshot 'innodb_plugin'          w2 [ pass ]     31
            innodb.snapshot 'xtradb'                 w3 [ pass ]     32
            innodb.group_commit_no_optimize_thread 'innodb_plugin' w2 [ pass ]     50
            innodb.group_commit_binlog_pos_no_optimize_thread 'innodb_plugin' w4 [ pass ]   2663
            innodb.group_commit_no_optimize_thread 'xtradb' w4 [ pass ]     43
            innodb.group_commit_binlog_pos_no_optimize_thread 'xtradb' w3 [ pass ]   2621
            innodb.innodb-flush-changed-page-bitmaps 'xtradb' w4 [ pass ]      5
            innodb.innodb_ctype_ldml 'innodb_plugin' w3 [ pass ]   1113
            innodb.innodb_ctype_ldml 'xtradb'        w4 [ pass ]   1159
            innodb.group_commit_crash_no_optimize_thread 'innodb_plugin' w1 [ pass ]  16143
            innodb.group_commit_crash_no_optimize_thread 'xtradb' w2 [ pass ]  15772
            innodb.innodb-autoinc-44030 'innodb_plugin' w4 [ pass ]   3966
            innodb.innodb-autoinc 'innodb_plugin'    w3 [ pass ]  13334
            innodb.innodb-autoinc-44030 'xtradb'     w4 [ pass ]   5034
            encryption.innodb-page_encryption-32k 'cbc,innodb_plugin' w4 [ skipped ]  Test requires InnoDB with 32k Page size.
            innodb.innodb-autoinc 'xtradb'           w2 [ pass ]  16245
            encryption.innodb-page_encryption-32k 'cbc,xtradb' w4 [ skipped ]  Test requires InnoDB with 32k Page size.
            encryption.innodb-page_encryption-32k 'ctr,innodb_plugin' w2 [ skipped ]  Test requires InnoDB with 32k Page size.
            encryption.innodb-page_encryption-32k 'ctr,xtradb' w4 [ skipped ]  Test requires InnoDB with 32k Page size.
            innodb.innodb-32k 'innodb_plugin'        w2 [ skipped ]  Test requires InnoDB with 32k Page size.
            innodb.innodb-32k-crash 'innodb_plugin'  w2 [ skipped ]  Test requires InnoDB with 32k Page size.
            innodb.innodb-64k 'innodb_plugin'        w2 [ skipped ]  Test requires InnoDB with 64k Page size.
            innodb.innodb-64k-crash 'innodb_plugin'  w2 [ skipped ]  Test requires InnoDB with 64k Page size.
            innodb.innodb-32k 'xtradb'               w2 [ skipped ]  Test requires InnoDB with 32k Page size.
            innodb.innodb-32k-crash 'xtradb'         w2 [ skipped ]  Test requires InnoDB with 32k Page size.
            innodb.innodb-64k 'xtradb'               w2 [ skipped ]  Test requires InnoDB with 64k Page size.
            innodb.innodb-64k-crash 'xtradb'         w2 [ skipped ]  Test requires InnoDB with 64k Page size.
            innodb.innodb-16k 'innodb_plugin'        w4 [ pass ]  14704
            encryption.innodb-log-encrypt-crash 'innodb_plugin' w4 [ skipped ]  Does not run with debug binaries
            innodb.innodb-16k 'xtradb'               w2 [ pass ]  13727
            encryption.innodb-redo-nokeys 'cbc,innodb_plugin' w2 [ pass ]  10900
            encryption.innodb-redo-badkey 'cbc,innodb_plugin' w4 [ pass ]  17658
            encryption.innodb-key-rotation-disable 'cbc,innodb_plugin' w2 [ pass ]   4294
            innodb.innodb_mysql 'innodb_plugin'      w1 [ pass ]  76481
            encryption.innodb_first_page 'cbc,innodb_plugin' w4 [ pass ]   7104
            encryption.innodb-log-encrypt 'innodb_plugin' w2 [ pass ]   4096
            innodb.innodb_mysql 'xtradb'             w3 [ pass ]  76910
            encryption.innodb-read-only 'cbc,innodb_plugin' w3 [ pass ]   9869
            encryption.innodb-page_encryption_log_encryption 'cbc,innodb_plugin' w4 [ pass ]  19786
            encryption.innodb-missing-key 'cbc,innodb_plugin' w2 [ pass ]  18249
            encryption.encrypt_and_grep 'cbc,innodb_plugin' w1 [ pass ]  31218
            encryption.innodb_encryption_row_compressed 'cbc,innodb_plugin' w3 [ pass ]   8833
            encryption.innodb_encryption_is 'cbc,innodb_plugin' w3 [ pass ]     87
            encryption.innodb-compressed-blob 'cbc,innodb_plugin' w4 [ pass ]  13170
            encryption.innodb-log-encrypt-crash 'xtradb' w4 [ skipped ]  Does not run with debug binaries
            encryption.innochecksum 'cbc,innodb_plugin' w3 [ pass ]  14912
            encryption.innodb_onlinealter_encryption 'cbc,innodb_plugin' w1 [ pass ]  25461
            encryption.innodb-redo-badkey 'cbc,xtradb' w4 [ pass ]  20092
            encryption.innodb-redo-nokeys 'cbc,xtradb' w1 [ pass ]  14231
            encryption.innodb-key-rotation-disable 'cbc,xtradb' w4 [ pass ]   4869
            encryption.innodb-bad-key-change 'cbc,innodb_plugin' w3 [ pass ]  24392
            encryption.innodb-log-encrypt 'xtradb'   w4 [ pass ]   5386
            encryption.innodb_first_page 'cbc,xtradb' w1 [ pass ]   9656
            encryption.innodb-discard-import 'cbc,innodb_plugin' w3 [ pass ]   5717
            encryption.innodb-discard-import-change 'cbc,innodb_plugin' w3 [ pass ]   2774
            encryption.innodb-encr-threads 'cbc,innodb_plugin' w3 [ pass ]     31
            encryption.create_or_replace 'cbc,innodb_plugin' w2 [ pass ]  79377
            encryption.innodb-page_encryption_log_encryption 'cbc,xtradb' w1 [ pass ]  24186
            encryption.encrypt_and_grep 'cbc,xtradb' w4 [ pass ]  35610
            encryption.innodb_encryption_filekeys 'cbc,innodb_plugin' w2 [ pass ]  23039
            encryption.innodb-encryption-alter 'cbc,innodb_plugin' w3 [ pass ]  45504
            encryption.innodb-missing-key 'cbc,xtradb' w1 [ pass ]  22768
            encryption.innodb-read-only 'cbc,xtradb' w2 [ pass ]  10878
            encryption.innodb_onlinealter_encryption 'cbc,xtradb' w4 [ pass ]  20672
            encryption.innodb-force-corrupt 'cbc,innodb_plugin' w3 [ pass ]   8360
            encryption.innodb_encryption_row_compressed 'cbc,xtradb' w1 [ pass ]  10670
            encryption.innodb_encryption_is 'cbc,xtradb' w1 [ pass ]     90
            encryption.innodb-compressed-blob 'cbc,xtradb' w2 [ pass ]  15931
            encryption.aria_tiny 'cbc'               w2 [ pass ]     20
            encryption.innochecksum 'cbc,xtradb'     w1 [ pass ]  15091
            encryption.innodb-redo-badkey 'ctr,innodb_plugin' w2 [ pass ]  20159
            encryption.innodb-redo-nokeys 'ctr,innodb_plugin' w2 [ pass ]  12631
            encryption.innodb-key-rotation-disable 'ctr,innodb_plugin' w2 [ pass ]   4897
            encryption.innodb-bad-key-change 'cbc,xtradb' w1 [ pass ]  31553
            encryption.innodb_first_page 'ctr,innodb_plugin' w2 [ pass ]   8526
            encryption.innodb-discard-import 'cbc,xtradb' w1 [ pass ]   5508
            encryption.innodb-discard-import-change 'cbc,xtradb' w1 [ pass ]   1498
            encryption.innodb-page_encryption 'cbc,innodb_plugin' w3 [ pass ]  79114
            encryption.innodb-encr-threads 'cbc,xtradb' w1 [ pass ]     28
            encryption.innodb-page_encryption_compression 'cbc,innodb_plugin' w3 [ pass ]  10165
            encryption.create_or_replace 'cbc,xtradb' w4 [ pass ]  103445
            encryption.innodb_page_encryption_key_change 'cbc,innodb_plugin' w3 [ pass ]   8720
            encryption.encrypt_and_grep 'ctr,innodb_plugin' w2 [ pass ]  30960
            encryption.innodb-encryption-alter 'cbc,xtradb' w1 [ pass ]  39392
            encryption.innodb_encryption_filekeys 'cbc,xtradb' w4 [ pass ]  20146
            encryption.innodb-page_encryption_log_encryption 'ctr,innodb_plugin' w3 [ pass ]  22478
            encryption.innodb_onlinealter_encryption 'ctr,innodb_plugin' w2 [ pass ]  23992
            encryption.innodb-force-corrupt 'cbc,xtradb' w1 [ pass ]  10940
            encryption.innodb-read-only 'ctr,innodb_plugin' w3 [ pass ]  10329
            encryption.innodb_encryption_row_compressed 'ctr,innodb_plugin' w2 [ pass ]   8910
            encryption.innodb-missing-key 'ctr,innodb_plugin' w4 [ pass ]  20026
            encryption.innodb_encryption_is 'ctr,innodb_plugin' w4 [ pass ]    104
            encryption.innodb-compressed-blob 'ctr,innodb_plugin' w3 [ pass ]  13128
            encryption.innochecksum 'ctr,innodb_plugin' w4 [ pass ]  13727
            encryption.innodb-redo-badkey 'ctr,xtradb' w3 [ pass ]  21167
            encryption.innodb-bad-key-change 'ctr,innodb_plugin' w4 [ pass ]  26997
            encryption.innodb-redo-nokeys 'ctr,xtradb' w3 [ pass ]  15062
            encryption.innodb-discard-import 'ctr,innodb_plugin' w4 [ pass ]   7062
            encryption.innodb-page_encryption 'cbc,xtradb' w1 [ pass ]  79560
            encryption.innodb-discard-import-change 'ctr,innodb_plugin' w4 [ pass ]   1753
            encryption.innodb-encr-threads 'ctr,innodb_plugin' w4 [ pass ]     31
            encryption.innodb-key-rotation-disable 'ctr,xtradb' w3 [ pass ]   6183
            encryption.innodb_first_page 'ctr,xtradb' w3 [ pass ]   9452
            encryption.innodb-page_encryption_compression 'cbc,xtradb' w1 [ pass ]  12592
            encryption.innodb_page_encryption_key_change 'cbc,xtradb' w1 [ pass ]  10595
            encryption.innodb-encryption-alter 'ctr,innodb_plugin' w4 [ pass ]  39736
            encryption.innodb-force-corrupt 'ctr,innodb_plugin' w4 [ pass ]   8394
            encryption.encrypt_and_grep 'ctr,xtradb' w3 [ pass ]  33768
            encryption.innodb-page_encryption_log_encryption 'ctr,xtradb' w1 [ pass ]  20581
            encryption.innodb_onlinealter_encryption 'ctr,xtradb' w3 [ pass ]  21992
            encryption.innodb-missing-key 'ctr,xtradb' w1 [ pass ]  22404
            encryption.create_or_replace 'ctr,innodb_plugin' w2 [ pass ]  149659
            encryption.innodb-read-only 'ctr,xtradb' w3 [ pass ]  10972
            encryption.innodb_encryption_row_compressed 'ctr,xtradb' w1 [ pass ]  10251
            encryption.innodb-page_encryption 'ctr,innodb_plugin' w4 [ pass ]  55650
            encryption.innodb_encryption_filekeys 'ctr,innodb_plugin' w2 [ pass ]  22716
            encryption.innodb-compressed-blob 'ctr,xtradb' w3 [ pass ]  15325
            encryption.innodb_encryption_is 'ctr,xtradb' w2 [ pass ]     77
            encryption.aria_tiny 'ctr'               w2 [ pass ]     15
            encryption.innodb-page_encryption_compression 'ctr,innodb_plugin' w4 [ pass ]  11031
            innodb_zip.innodb_cmp_drop_table 'innodb_plugin' w2 [ pass ]   4160
            encryption.innochecksum 'ctr,xtradb'     w3 [ pass ]  14419
            innodb.log_data_file_size 'innodb_plugin' w2 [ pass ]   2529
            encryption.innodb_page_encryption_key_change 'ctr,innodb_plugin' w4 [ pass ]   8798
            encryption.innodb-bad-key-change 'ctr,xtradb' w3 [ pass ]  31073
            encryption.innodb-discard-import 'ctr,xtradb' w3 [ pass ]   5094
            encryption.innodb-discard-import-change 'ctr,xtradb' w3 [ pass ]   1795
            innodb.innodb_defragment 'innodb_plugin' w2 [ pass ]  44240
            encryption.innodb-encr-threads 'ctr,xtradb' w3 [ pass ]     31
            innodb.innodb_defrag_concurrent 'innodb_plugin' w4 [ pass ]  52260
            innodb.innodb_defrag_stats 'innodb_plugin' w2 [ pass ]  18390
            encryption.create_or_replace 'ctr,xtradb' w1 [ pass ]  99939
            innodb.innodb_defragment_fill_factor 'innodb_plugin' w4 [ pass ]  13834
            encryption.innodb-encryption-alter 'ctr,xtradb' w3 [ pass ]  38284
            encryption.innodb-bad-key-change4 'innodb_plugin' w4 [ pass ]  12390
            encryption.encryption_force 'innodb_plugin' w4 [ pass ]    109
            encryption.innodb_encryption_filekeys 'ctr,xtradb' w1 [ pass ]  21750
            encryption.innodb-force-corrupt 'ctr,xtradb' w3 [ pass ]  10321
            encryption.debug_key_management 'innodb_plugin' w1 [ pass ]   4800
            innodb.innodb_defrag_stats_many_tables 'innodb_plugin' w2 [ pass ]  46630
            innodb.innodb_corrupt_bit 'innodb_plugin' w2 [ pass ]    527
            innodb.innodb_sys_semaphore_waits 'innodb_plugin' w2 [ pass ]  16250
            encryption.innodb_encryption_discard_import 'innodb_plugin' w4 [ pass ]  57293
            innodb.innodb_simulate_comp_failures_small 'innodb_plugin' w4 [ pass ]   4349
            encryption.innodb-page_encryption 'ctr,xtradb' w3 [ pass ]  66990
            innodb.innodb_simulate_comp_failures 'innodb_plugin' w2 [ pass ]  36790
            encryption.innodb-page_encryption_compression 'ctr,xtradb' w3 [ pass ]  10675
            innodb.innodb_mutexes 'innodb_plugin'    w2 [ pass ]   8647
            innodb.innodb_bug14676111 'innodb_plugin' w2 [ pass ]     94
            encryption.innodb_page_encryption_key_change 'ctr,xtradb' w3 [ pass ]   9887
            innodb.innodb_bug12400341 'innodb_plugin' w3 [ pass ]   1121
            innodb.innochecksum 'innodb_plugin'      w2 [ pass ]   8550
            innodb.create_isl_with_direct 'innodb_plugin' w2 [ pass ]     57
            innodb.innodb_bug14147491 'innodb_plugin' w3 [ pass ]   7508
            innodb.innodb_force_pk 'innodb_plugin'   w2 [ pass ]    127
            innodb.innodb-mdev-7408 'innodb_plugin'  w3 [ pass ]     82
            innodb.group_commit_binlog_pos 'innodb_plugin' w2 [ pass ]   2758
            innodb.binlog_consistent 'innodb_plugin' w3 [ pass ]    130
            innodb.group_commit 'innodb_plugin'      w3 [ pass ]     57
            innodb.group_commit_crash 'innodb_plugin' w2 [ pass ]  15764
            innodb.innodb_bug30919 'innodb_plugin'   w2 [ pass ]  12518
            innodb.innodb-mdev7046 'innodb_plugin'   w2 [ pass ]    432
            innodb.insert_debug 'innodb_plugin'      w2 [ pass ]    495
            innodb.multi_repair-7404 'innodb_plugin' w2 [ pass ]    191
            innodb.innodb_autoinc_lock_mode_zero 'innodb_plugin' w2 [ pass ]     62
            innodb.innodb_information_schema_buffer 'innodb_plugin' w2 [ pass ]    338
            innodb.innodb_bug42101-nonzero 'innodb_plugin' w2 [ pass ]      8
            innodb.innodb_bug60049 'innodb_plugin'   w2 [ pass ]   4333
            innodb.innodb_bug39438 'innodb_plugin'   w2 [ pass ]     53
            innodb.innodb-lock-schedule-algorithm 'innodb_plugin' w2 [ pass ]  12431
            innodb.data_types 'innodb_plugin'        w2 [ pass ]     69
            innodb.innodb-stats-modified-counter 'innodb_plugin' w2 [ pass ]    163
            innodb.innodb_information_schema_tables 'innodb_plugin' w2 [ pass ]    506
            encryption.innodb_lotoftables 'innodb_plugin' w1 [ pass ]  212071
            innodb.innodb-autoinc-56228 'innodb_plugin' w2 [ pass ]     71
            innodb.innodb_mysql_rbk 'innodb_plugin'  w1 [ pass ]   4568
            innodb.innodb_timeout_rollback 'innodb_plugin' w1 [ pass ]   3661
            innodb.innodb-consistent 'innodb_plugin' w1 [ pass ]     98
            innodb.innodb_lock_wait_timeout_1 'innodb_plugin' w2 [ pass ]  17533
            innodb.defrag_mdl-9155 'innodb_plugin'   w2 [ pass ]   1655
            innodb.innodb-semi-consistent 'innodb_plugin' w1 [ pass ]  11916
            innodb.innodb_bug60196 'innodb_plugin'   w2 [ skipped ]  Test requires: 'lowercase2'
            innodb.innodb-change-buffer-recovery 'innodb_plugin' w3 [ pass ]  125521
            innodb.innodb_bug49164 'innodb_plugin'   w3 [ pass ]    101
            innodb.innodb_bug51378 'innodb_plugin'   w3 [ pass ]    549
            innodb.innodb_bug53756 'innodb_plugin'   w1 [ pass ]   3510
            innodb.innodb_bug51920 'innodb_plugin'   w3 [ pass ]    241
            innodb.innodb_bug52199 'innodb_plugin'   w3 [ pass ]     90
            innodb.innodb-wl5522-debug 'innodb_plugin' w2 [ pass ]  29652
            innodb.innodb_bug52663 'innodb_plugin'   w3 [ pass ]  51380
            innodb.innodb_bug53046 'innodb_plugin'   w3 [ pass ]    301
            innodb.sp_temp_table 'innodb_plugin'     w2 [ pass ]  30246
            innodb_zip.innodb_prefix_index_liftedlimit 'innodb_plugin' w2 [ pass ]   9644
            encryption.innodb-bad-key-change2 'innodb_plugin' w2 [ pass ]  31749
            innodb.innodb_bug53290 'innodb_plugin'   w3 [ pass ]  47127
            innodb.innodb_bug53592 'innodb_plugin'   w3 [ pass ]    402
            innodb.innodb_bug54044 'innodb_plugin'   w3 [ pass ]     65
            innodb.innodb_bug56143 'innodb_plugin'   w3 [ pass ]   2977
            innodb.innodb_bug56716 'innodb_plugin'   w3 [ pass ]     29
            innodb.innodb_bug56947 'innodb_plugin'   w3 [ pass ]     42
            innodb.innodb_bug57252 'innodb_plugin'   w3 [ pass ]     38
            innodb.innodb_bug57255 'innodb_plugin'   w3 [ pass ]   1219
            innodb.innodb_bug57904 'innodb_plugin'   w3 [ pass ]     77
            innodb.innodb_bug59410 'innodb_plugin'   w3 [ pass ]     69
            innodb.innodb_bug59641 'innodb_plugin'   w3 [ pass ]   6844
            innodb.innodb_bug59733 'innodb_plugin'   w3 [ pass ]    955
            innodb.innodb_bug60229 'innodb_plugin'   w3 [ pass ]     71
            encryption.innodb-bad-key-change3 'innodb_plugin' w2 [ pass ]  21934
            innodb.innodb_bug68148 'innodb_plugin'   w3 [ pass ]   4151
            innodb.innodb_defragment_small 'innodb_plugin' w3 [ pass ]    195
            innodb.innodb_file_format 'innodb_plugin' w3 [ pass ]   3413
            innodb.innodb_gis 'innodb_plugin'        w3 [ pass ]    315
            innodb.innodb_information_schema 'innodb_plugin' w3 [ pass ]    436
            innodb.innodb_monitor 'innodb_plugin'    w3 [ pass ]    224
            innodb.innodb_multi_update 'innodb_plugin' w3 [ pass ]     79
            innodb.innodb_uninstall                  w1 [ pass ]  127976
            innodb.innodb_notembedded 'innodb_plugin' w3 [ pass ]    247
            innodb_zip.innodb_cmp_drop_table 'xtradb' w1 [ pass ]   5667
            encryption.innodb-encryption-disable 'innodb_plugin' w2 [ pass ]  12615
            innodb.innodb_prefix_index_restart_server 'innodb_plugin' w3 [ pass ]  12361
            innodb.innodb_stats 'innodb_plugin'      w3 [ pass ]    603
            innodb.log_data_file_size 'xtradb'       w1 [ pass ]   2588
            innodb.innodb_stats_create_on_corrupted 'innodb_plugin' w3 [ pass ]   4162
            innodb.innodb_stats_create_table 'innodb_plugin' w3 [ pass ]    120
            innodb.innodb_stats_drop_locked 'innodb_plugin' w3 [ pass ]   1659
            innodb.innodb_stats_fetch 'innodb_plugin' w3 [ pass ]    122
            innodb.101_compatibility 'innodb_plugin' w2 [ pass ]  10196
            innodb.add_constraint 'innodb_plugin'    w2 [ pass ]    305
            innodb.alter_key_block_size-11757 'innodb_plugin' w2 [ pass ]    302
            innodb.auto_increment_dup 'innodb_plugin' w2 [ pass ]     86
            innodb.blob-update-debug 'innodb_plugin' w2 [ pass ]     76
            innodb.blob_unique2pk 'innodb_plugin'    w2 [ pass ]    137
            innodb.count_distinct 'innodb_plugin'    w2 [ pass ]     54
            innodb.innodb_stats_fetch_corrupted 'innodb_plugin' w3 [ pass ]   4379
            innodb.create-index 'innodb_plugin'      w2 [ pass ]     66
            innodb.innodb_stats_fetch_nonexistent 'innodb_plugin' w3 [ pass ]     89
            innodb.innodb_stats_rename_table 'innodb_plugin' w3 [ pass ]     42
            innodb.innodb_stats_rename_table_if_exists 'innodb_plugin' w3 [ pass ]    446
            innodb.innodb_trx_weight 'innodb_plugin' w3 [ pass ]   1051
            innodb.doublewrite 'innodb_plugin'       w2 [ pass ]  25730
            innodb.dropdb 'innodb_plugin'            w2 [ pass ]      4
            innodb.foreign-keys 'innodb_plugin'      w2 [ pass ]    187
            innodb.help_url 'innodb_plugin'          w2 [ pass ]     18
            innodb.innodb-agregate 'innodb_plugin'   w2 [ pass ]     55
            innodb.innodb-alter-debug 'innodb_plugin' w2 [ pass ]    215
            innodb.innodb-alter-discard 'innodb_plugin' w2 [ pass ]   4245
            innodb.innodb-alter-nullable 'innodb_plugin' w2 [ pass ]    145
            innodb.innodb_defragment 'xtradb'        w1 [ pass ]  45038
            innodb.log_file_size 'innodb_plugin'     w3 [ pass ]  41563
            innodb.mdev-117 'innodb_plugin'          w3 [ pass ]     66
            innodb.innodb-alter-table 'innodb_plugin' w2 [ pass ]  12561
            innodb.innodb-alter-tempfile 'innodb_plugin' w2 [ pass ]   7384
            innodb.innodb-alter-timestamp 'innodb_plugin' w2 [ pass ]    152
            innodb.innodb-analyze 'innodb_plugin'    w2 [ pass ]     72
            innodb.innodb-autoinc-18274 'innodb_plugin' w2 [ pass ]     83
            innodb.read_only_recovery 'innodb_plugin' w3 [ pass ]  10399
            innodb.innodb-autoinc-61209 'innodb_plugin' w2 [ pass ]     38
            innodb.row_lock 'innodb_plugin'          w3 [ pass ]    276
            innodb.innodb-autoinc-optimize 'innodb_plugin' w2 [ pass ]     92
            innodb.strict_mode 'innodb_plugin'       w3 [ pass ]    416
            innodb.system_tables 'innodb_plugin'     w3 [ pass ]   4327
            innodb.table_index_statistics 'innodb_plugin' w3 [ pass ]    176
            innodb.tmpdir 'innodb_plugin'            w3 [ pass ]    984
            innodb.trigger 'innodb_plugin'           w3 [ pass ]    154
            innodb.innodb-blob 'innodb_plugin'       w2 [ pass ]   8960
            innodb.innodb-bug-14068765 'innodb_plugin' w2 [ pass ]    518
            innodb.innodb-bug-14084530 'innodb_plugin' w2 [ pass ]    323
            innodb.innodb-corrupted-table 'innodb_plugin' w2 [ pass ]   4429
            innodb.xa_recovery 'innodb_plugin'       w3 [ pass ]   8381
            innodb.innodb-dict 'innodb_plugin'       w2 [ pass ]   1056
            innodb_zip.innodb-create-options 'innodb_plugin' w3 [ pass ]   4182
            innodb_zip.innodb-zip 'innodb_plugin'    w3 [ pass ]   1936
            innodb_zip.innodb_bug36169 'innodb_plugin' w3 [ pass ]    707
            innodb_zip.innodb_bug36172 'innodb_plugin' w3 [ pass ]    387
            innodb_zip.innodb_bug52745 'innodb_plugin' w3 [ pass ]     62
            innodb_zip.innodb_bug53591 'innodb_plugin' w3 [ pass ]     75
            innodb_zip.innodb_bug56680 'innodb_plugin' w3 [ pass ]   5291
            innodb.innodb-fk 'innodb_plugin'         w2 [ pass ]  17063
            innodb_zip.innodb_index_large_prefix 'innodb_plugin' w3 [ pass ]   1683
            innodb.innodb-fk-warnings 'innodb_plugin' w2 [ pass ]    598
            innodb.innodb-fkcheck 'innodb_plugin'    w2 [ pass ]    171
            innodb.innodb_defrag_concurrent 'xtradb' w1 [ pass ]  58182
            innodb.innodb-get-fk 'innodb_plugin'     w2 [ pass ]  14565
            innodb.innodb-index 'innodb_plugin'      w2 [ pass ]   2943
            innodb.innodb-index_ucs2 'innodb_plugin' w2 [ pass ]     83
            innodb.innodb_defragment_fill_factor 'xtradb' w1 [ pass ]  15679
            innodb.innodb-lock 'innodb_plugin'       w2 [ pass ]   2111
            innodb.innodb_defrag_stats 'xtradb'      w3 [ pass ]  20211
            innodb.innodb-mdev-7513 'innodb_plugin'  w2 [ pass ]   4255
            encryption.innodb-bad-key-change4 'xtradb' w1 [ pass ]  14807
            encryption.encryption_force 'xtradb'     w1 [ pass ]    255
            innodb.innodb_defrag_stats_many_tables 'xtradb' w3 [ pass ]  48886
            encryption.debug_key_management 'xtradb' w3 [ pass ]   4831
            encryption.innodb_encryption_discard_import 'xtradb' w1 [ pass ]  63578
            innodb.innodb_corrupt_bit 'xtradb'       w1 [ pass ]    253
            innodb.innodb-page_compression_bzip2 'innodb_plugin' w2 [ pass ]  100974
            innodb.innodb-page_compression_default 'innodb_plugin' w2 [ pass ]   3670
            innodb.innodb_sys_semaphore_waits 'xtradb' w1 [ pass ]  15702
            innodb.innodb_simulate_comp_failures 'xtradb' w1 [ pass ]  48517
            innodb.innodb_simulate_comp_failures_small 'xtradb' w1 [ pass ]   4168
            innodb.innodb-page_compression_lz4 'innodb_plugin' w2 [ pass ]  103737
            encryption.innodb_lotoftables 'xtradb'   w3 [ pass ]  218955
            innodb.innodb_mutexes 'xtradb'           w3 [ pass ]  11301
            innodb.innodb_bug14676111 'xtradb'       w3 [ pass ]    161
            innodb.innochecksum 'xtradb'             w3 [ pass ]  11051
            innodb.innodb_bug12400341 'xtradb'       w3 [ pass ]   1187
            innodb.innodb-page_compression_lzma 'innodb_plugin' w2 [ pass ]  121084
            innodb.innodb_bug14147491 'xtradb'       w3 [ pass ]  10821
            innodb.create_isl_with_direct 'xtradb'   w3 [ pass ]     56
            innodb.innodb_force_pk 'xtradb'          w3 [ pass ]    230
            innodb.innodb-mdev-7408 'xtradb'         w3 [ pass ]     86
            innodb.group_commit_binlog_pos 'xtradb'  w3 [ pass ]   2572
            innodb.binlog_consistent 'xtradb'        w3 [ pass ]    276
            innodb.innodb-bigblob 'innodb_plugin'    w4 [ pass ]  861162
            innodb.group_commit 'xtradb'             w4 [ pass ]     94
            innodb.group_commit_crash 'xtradb'       w3 [ pass ]  16090
            innodb.innodb_bug30919 'xtradb'          w3 [ pass ]  13404
            innodb.innodb-mdev7046 'xtradb'          w3 [ pass ]    446
            innodb.innodb-page_compression_lzo 'innodb_plugin' w2 [ pass ]  82438
            innodb.insert_debug 'xtradb'             w3 [ pass ]    468
            innodb.multi_repair-7404 'xtradb'        w3 [ pass ]    196
            innodb.innodb_autoinc_lock_mode_zero 'xtradb' w3 [ pass ]     77
            innodb.innodb_information_schema_buffer 'xtradb' w3 [ pass ]    497
            innodb.innodb_bug42101-nonzero 'xtradb'  w3 [ pass ]      7
            innodb.innodb_bug60049 'xtradb'          w3 [ pass ]   5436
            innodb.innodb_bug39438 'xtradb'          w3 [ pass ]     40
            innodb.innodb-lock-schedule-algorithm 'xtradb' w3 [ pass ]  13396
            innodb.data_types 'xtradb'               w3 [ pass ]     74
            innodb.innodb-stats-modified-counter 'xtradb' w3 [ pass ]     61
            innodb.innodb_information_schema_tables 'xtradb' w3 [ pass ]    573
            innodb.innodb-autoinc-56228 'xtradb'     w3 [ pass ]    110
            innodb.innodb_mysql_rbk 'xtradb'         w3 [ pass ]   4583
            innodb.innodb_lock_wait_timeout_1 'xtradb' w3 [ pass ]  18421
            innodb.innodb_timeout_rollback 'xtradb'  w3 [ pass ]   2444
            innodb.innodb-page_compression_snappy 'innodb_plugin' w2 [ pass ]  114474
            innodb.innodb-consistent 'xtradb'        w3 [ pass ]    108
            innodb.innodb-change-buffer-recovery 'xtradb' w4 [ pass ]  149360
            innodb.innodb-semi-consistent 'xtradb'   w3 [ pass ]  11870
            innodb.defrag_mdl-9155 'xtradb'          w4 [ pass ]   1820
            innodb.innodb_bug60196 'xtradb'          w3 [ skipped ]  Test requires: 'lowercase2'
            innodb.innodb-page_compression_tables 'innodb_plugin' w2 [ pass ]  20822
            innodb.innodb_bug53756 'xtradb'          w4 [ pass ]   3080
            innodb.innodb-page_compression_default 'xtradb' w4 [ pass ]   4836
            innodb.innodb-wl5522-debug 'xtradb'      w3 [ pass ]  41262
            innodb.sp_temp_table 'xtradb'            w3 [ pass ]  30493
            innodb_zip.innodb_prefix_index_liftedlimit 'xtradb' w3 [ pass ]  10202
            innodb.innodb-page_compression_zip 'innodb_plugin' w2 [ pass ]  97592
            innodb.innodb-replace 'innodb_plugin'    w2 [ pass ]     23
            innodb.innodb-stats-initialize-failure 'innodb_plugin' w2 [ pass ]   8238
            innodb.innodb-stats-sample 'innodb_plugin' w2 [ pass ]   7266
            innodb.innodb-timeout 'innodb_plugin'    w2 [ pass ]   4335
            innodb.innodb-truncate 'innodb_plugin'   w2 [ pass ]    442
            innodb.innodb-ucs2 'innodb_plugin'       w2 [ pass ]   1010
            innodb.innodb-update-insert 'innodb_plugin' w2 [ pass ]     87
            innodb.innodb-virtual-columns 'innodb_plugin' w2 [ pass ]    424
            encryption.innodb-bad-key-change2 'xtradb' w3 [ pass ]  38702
            innodb.innodb-wl5522 'innodb_plugin'     w2 [ pass ]  14981
            innodb.innodb-page_compression_lz4 'xtradb' w4 [ pass ]  126412
            innodb.innodb-wl5522-1 'innodb_plugin'   w2 [ pass ]   5420
            encryption.innodb-bad-key-change3 'xtradb' w3 [ pass ]  26576
            innodb.innodb-wl5522-debug-zip 'innodb_plugin' w2 [ pass ]  28843
            encryption.innodb-encryption-disable 'xtradb' w3 [ pass ]  16666
            innodb.innodb-wl5522-zip 'innodb_plugin' w2 [ pass ]  14266
            innodb.innodb-xa 'innodb_plugin'         w2 [ pass ]     85
            innodb.innodb_blob_truncate 'innodb_plugin' w2 [ pass ]    224
            innodb.101_compatibility 'xtradb'        w3 [ pass ]  12071
            innodb.add_constraint 'xtradb'           w3 [ pass ]    313
            innodb.alter_key_block_size-11757 'xtradb' w3 [ pass ]    189
            innodb.auto_increment_dup 'xtradb'       w3 [ pass ]     85
            innodb.innodb_blob_unrecoverable_crash 'innodb_plugin' w2 [ pass ]   3173
            innodb.blob-update-debug 'xtradb'        w3 [ pass ]     82
            innodb.innodb_bug11754376 'innodb_plugin' w2 [ pass ]     34
            innodb.blob_unique2pk 'xtradb'           w3 [ pass ]    261
            innodb.innodb_bug12661768 'innodb_plugin' w2 [ pass ]     98
            innodb.count_distinct 'xtradb'           w3 [ pass ]     53
            innodb.create-index 'xtradb'             w3 [ pass ]     52
            innodb.innodb_bug12902967 'innodb_plugin' w2 [ pass ]   8847
            innodb.innodb_bug13510739 'innodb_plugin' w2 [ pass ]     30
            innodb.innodb_bug14007649 'innodb_plugin' w2 [ pass ]     63
            innodb.innodb_bug14704286 'innodb_plugin' w2 [ pass ]   6488
            innodb.innodb_bug21704 'innodb_plugin'   w2 [ pass ]    137
            innodb.doublewrite 'xtradb'              w3 [ pass ]  28645
            innodb.dropdb 'xtradb'                   w3 [ pass ]      6
            innodb.foreign-keys 'xtradb'             w3 [ pass ]    357
            innodb.help_url 'xtradb'                 w3 [ pass ]     28
            innodb.innodb-agregate 'xtradb'          w3 [ pass ]     55
            innodb.innodb-alter-debug 'xtradb'       w3 [ pass ]    277
            innodb.innodb-alter-discard 'xtradb'     w3 [ pass ]   4490
            innodb.innodb-alter-nullable 'xtradb'    w3 [ pass ]    238
            innodb.innodb-alter-table 'xtradb'       w3 [ pass ]  15456
            innodb.innodb-page_compression_lzma 'xtradb' w4 [ pass ]  117673
            innodb.innodb-alter-tempfile 'xtradb'    w3 [ pass ]   8592
            innodb.innodb-alter-timestamp 'xtradb'   w3 [ pass ]    175
            innodb.innodb-analyze 'xtradb'           w3 [ pass ]    124
            innodb.innodb-autoinc-18274 'xtradb'     w3 [ pass ]    116
            innodb.innodb-autoinc-61209 'xtradb'     w3 [ pass ]     40
            innodb.innodb-autoinc-optimize 'xtradb'  w3 [ pass ]     81
            innodb.innodb_bug30423 'innodb_plugin'   w2 [ pass ]  56198
            innodb.innodb_bug34053 'innodb_plugin'   w2 [ pass ]    224
            innodb.innodb_bug34300 'innodb_plugin'   w2 [ pass ]    320
            innodb.innodb_bug35220 'innodb_plugin'   w2 [ pass ]     76
            innodb.innodb_bug38231 'innodb_plugin'   w2 [ pass ]     65
            innodb.innodb_bug40360 'innodb_plugin'   w2 [ pass ]     36
            innodb.innodb_bug40565 'innodb_plugin'   w2 [ pass ]     28
            innodb.innodb-blob 'xtradb'              w3 [ pass ]   8998
            innodb.innodb_bug41904 'innodb_plugin'   w2 [ pass ]     52
            innodb.innodb-bug-14068765 'xtradb'      w3 [ pass ]    462
            innodb.innodb_bug42101 'innodb_plugin'   w2 [ pass ]      7
            innodb.innodb-bug-14084530 'xtradb'      w3 [ pass ]    372
            innodb.innodb_bug42419 'innodb_plugin'   w2 [ pass ]    277
            innodb.innodb_bug44032 'innodb_plugin'   w2 [ pass ]     47
            innodb.innodb_bug44369 'innodb_plugin'   w2 [ pass ]      6
            innodb.innodb_bug44571 'innodb_plugin'   w2 [ pass ]     85
            innodb.innodb_bug45357 'innodb_plugin'   w2 [ pass ]     61
            innodb.innodb_bug46000 'innodb_plugin'   w2 [ pass ]     50
            innodb.innodb_bug46676 'innodb_plugin'   w2 [ pass ]    199
            innodb.innodb-corrupted-table 'xtradb'   w3 [ pass ]   5593
            innodb.innodb-dict 'xtradb'              w3 [ pass ]   1056
            innodb.innodb_bug47167 'innodb_plugin'   w2 [ pass ]   3781
            innodb.innodb_bug47621 'innodb_plugin'   w2 [ pass ]    119
            innodb.innodb_bug47622 'innodb_plugin'   w2 [ pass ]    121
            innodb.innodb_bug47777 'innodb_plugin'   w2 [ pass ]     23
            innodb.innodb_bug48024 'innodb_plugin'   w2 [ pass ]    134
            innodb.innodb_bug35220 'xtradb'          w2 [ pass ]     55
            innodb.innodb_bug38231 'xtradb'          w2 [ pass ]     62
            innodb.innodb_bug40360 'xtradb'          w2 [ pass ]     35
            innodb.innodb_bug40565 'xtradb'          w2 [ pass ]     47
            innodb.innodb_bug41904 'xtradb'          w2 [ pass ]     66
            innodb.innodb_bug42101 'xtradb'          w2 [ pass ]      8
            innodb.innodb_bug42419 'xtradb'          w2 [ pass ]    271
            innodb.innodb_bug44032 'xtradb'          w2 [ pass ]     45
            innodb.innodb_bug44369 'xtradb'          w2 [ pass ]      3
            innodb.innodb_bug44571 'xtradb'          w2 [ pass ]     54
            innodb.innodb_bug45357 'xtradb'          w2 [ pass ]     32
            innodb.innodb_bug46000 'xtradb'          w2 [ pass ]     32
            innodb.innodb_bug46676 'xtradb'          w2 [ pass ]    162
            innodb.innodb-fk 'xtradb'                w3 [ pass ]  15807
            innodb.innodb-fk-warnings 'xtradb'       w3 [ pass ]    582
            innodb.innodb-fkcheck 'xtradb'           w3 [ pass ]    166
            innodb.innodb_bug47167 'xtradb'          w2 [ pass ]   4651
            innodb.innodb_bug47621 'xtradb'          w2 [ pass ]    132
            innodb.innodb_bug47622 'xtradb'          w2 [ pass ]    103
            innodb.innodb_bug47777 'xtradb'          w2 [ pass ]     26
            innodb.innodb_bug48024 'xtradb'          w2 [ pass ]    115
            innodb.innodb_bug49164 'xtradb'          w2 [ pass ]     35
            innodb.innodb_bug51378 'xtradb'          w2 [ pass ]    149
            innodb.innodb_bug51920 'xtradb'          w2 [ pass ]     35
            innodb.innodb_bug52199 'xtradb'          w2 [ pass ]     42
            innodb.innodb-get-fk 'xtradb'            w3 [ pass ]  16795
            innodb.innodb-index 'xtradb'             w3 [ pass ]   2731
            innodb.innodb-index_ucs2 'xtradb'        w3 [ pass ]    123
            innodb.innodb-lock 'xtradb'              w3 [ pass ]   2136
            innodb.innodb-page_compression_lzo 'xtradb' w4 [ pass ]  74559
            innodb.innodb-mdev-7513 'xtradb'         w3 [ pass ]   5357
            innodb.innodb_bug52663 'xtradb'          w2 [ pass ]  51089
            innodb.innodb_bug53046 'xtradb'          w2 [ pass ]     91
            innodb.innodb_bug53290 'xtradb'          w2 [ pass ]  29967
            innodb.innodb_bug53592 'xtradb'          w2 [ pass ]    271
            innodb.innodb_bug54044 'xtradb'          w2 [ pass ]     55
            innodb.innodb_bug56143 'xtradb'          w2 [ pass ]   3450
            innodb.innodb_bug56716 'xtradb'          w2 [ pass ]     20
            innodb.innodb_bug56947 'xtradb'          w2 [ pass ]     40
            innodb.innodb_bug57252 'xtradb'          w2 [ pass ]     35
            innodb.innodb_bug57255 'xtradb'          w2 [ pass ]   1012
            innodb.innodb_bug57904 'xtradb'          w2 [ pass ]     36
            innodb.innodb_bug59410 'xtradb'          w2 [ pass ]     39
            innodb.innodb_bug59641 'xtradb'          w2 [ pass ]   8124
            innodb.innodb_bug59733 'xtradb'          w2 [ pass ]   1734
            innodb.innodb_bug60229 'xtradb'          w2 [ pass ]    110
            innodb.innodb_bug68148 'xtradb'          w2 [ pass ]   5375
            innodb.innodb_defragment_small 'xtradb'  w2 [ pass ]    328
            innodb.innodb_file_format 'xtradb'       w2 [ pass ]   4825
            innodb.innodb_gis 'xtradb'               w2 [ pass ]    620
            innodb.innodb_information_schema 'xtradb' w2 [ pass ]    539
            innodb.innodb_monitor 'xtradb'           w2 [ pass ]    358
            innodb.innodb_multi_update 'xtradb'      w2 [ pass ]     95
            innodb.innodb_notembedded 'xtradb'       w2 [ pass ]    249
            innodb.innodb-page_compression_snappy 'xtradb' w4 [ pass ]  111826
            innodb.innodb-page_compression_bzip2 'xtradb' w3 [ pass ]  114595
            innodb.innodb_prefix_index_restart_server 'xtradb' w2 [ pass ]  15654
            innodb.innodb_stats 'xtradb'             w2 [ pass ]    903
            innodb.innodb_trx_weight 'xtradb'        w3 [ pass ]   1562
            innodb.innodb_stats_create_on_corrupted 'xtradb' w2 [ pass ]   5248
            innodb.innodb_stats_create_table 'xtradb' w2 [ pass ]     80
            innodb.innodb_stats_drop_locked 'xtradb' w2 [ pass ]   2586
            innodb.innodb_stats_fetch 'xtradb'       w2 [ pass ]    141
            innodb.innodb-page_compression_tables 'xtradb' w4 [ pass ]  18846
            innodb.innodb_stats_fetch_corrupted 'xtradb' w2 [ pass ]   5384
            innodb.innodb_stats_fetch_nonexistent 'xtradb' w2 [ pass ]     75
            innodb.innodb_stats_rename_table 'xtradb' w2 [ pass ]     38
            innodb.innodb_stats_rename_table_if_exists 'xtradb' w2 [ pass ]    463
            innodb.xa_recovery 'xtradb'              w2 [ pass ]   8561
            innodb_zip.innodb-create-options 'xtradb' w2 [ pass ]   3021
            innodb_zip.innodb-zip 'xtradb'           w2 [ pass ]   1861
            innodb_zip.innodb_bug36169 'xtradb'      w2 [ pass ]    662
            innodb_zip.innodb_bug36172 'xtradb'      w2 [ pass ]    257
            innodb_zip.innodb_bug52745 'xtradb'      w2 [ pass ]    113
            innodb_zip.innodb_bug53591 'xtradb'      w2 [ pass ]     41
            innodb_zip.innodb_bug56680 'xtradb'      w2 [ pass ]   5911
            innodb_zip.innodb_index_large_prefix 'xtradb' w2 [ pass ]   1457
            innodb.log_file_size 'xtradb'            w3 [ pass ]  43165
            innodb.mdev-117 'xtradb'                 w3 [ pass ]     53
            innodb.innodb-bigblob 'xtradb'           w1 [ pass ]  873476
            innodb.innodb-changed-pages 'xtradb'     w2 [ pass ]     31
            innodb.fake_changes-7000 'xtradb'        w1 [ pass ]     21
            encryption.filekeys_encfile_file 'xtradb' w2 [ pass ]     82
            innodb.read_only_recovery 'xtradb'       w3 [ pass ]  10765
            innodb.row_lock 'xtradb'                 w3 [ pass ]    111
            encryption.filekeys_encfile_badfile 'xtradb' w1 [ pass ]     59
            innodb.strict_mode 'xtradb'              w3 [ pass ]    418
            encryption.filekeys_encfile_bad 'xtradb' w2 [ pass ]     76
            encryption.filekeys_unencfile 'xtradb'   w1 [ pass ]     78
            encryption.filekeys_encfile 'xtradb'     w2 [ pass ]    220
            innodb.system_tables 'xtradb'            w3 [ pass ]   5476
            innodb.table_index_statistics 'xtradb'   w3 [ pass ]    109
            innodb.tmpdir 'xtradb'                   w3 [ pass ]    722
            innodb.trigger 'xtradb'                  w3 [ pass ]     97
            encryption.filekeys_tooshort 'xtradb'    w1 [ pass ]     37
            encryption.filekeys_encfile_no 'xtradb'  w2 [ pass ]     53
            encryption.filekeys_emptyfile 'xtradb'   w3 [ pass ]     73
            encryption.filekeys_syntax 'xtradb'      w1 [ pass ]    564
            encryption.filekeys_nofile 'xtradb'      w2 [ pass ]     57
            innodb.innodb_skip_innodb_is_tables      w3 [ pass ]     46
            innodb.innodb-replace 'xtradb'           w3 [ pass ]     70
            innodb.innodb_defrag_binlog 'row,xtradb' w2 [ pass ]   1046
            innodb.innodb_defrag_binlog 'innodb_plugin,row' w1 [ pass ]   1447
            innodb.innodb-stats-initialize-failure 'xtradb' w3 [ pass ]   7551
            innodb.innodb-truncate 'xtradb'          w3 [ pass ]    445
            innodb.innodb-ucs2 'xtradb'              w3 [ pass ]   1003
            innodb.innodb-update-insert 'xtradb'     w3 [ pass ]    126
            innodb.innodb-virtual-columns 'xtradb'   w3 [ pass ]    571
            innodb.innodb-timeout 'xtradb'           w1 [ pass ]   4916
            innodb.innodb-page_compression_zip 'xtradb' w4 [ pass ]  75896
            innodb.innodb-stats-sample 'xtradb'      w2 [ pass ]   8670
            innodb.innodb-wl5522-1 'xtradb'          w1 [ pass ]   7567
            innodb.innodb-xa 'xtradb'                w1 [ pass ]     17
            innodb.innodb_blob_truncate 'xtradb'     w1 [ pass ]    112
            innodb.innodb_blob_unrecoverable_crash 'xtradb' w1 [ pass ]   2962
            innodb.innodb_bug11754376 'xtradb'       w1 [ pass ]     20
            innodb.innodb_bug12661768 'xtradb'       w1 [ pass ]     78
            innodb.innodb-wl5522 'xtradb'            w3 [ pass ]  17740
            innodb.innodb_bug13510739 'xtradb'       w3 [ pass ]     47
            innodb.innodb_bug14007649 'xtradb'       w3 [ pass ]     73
            innodb.innodb-wl5522-zip 'xtradb'        w2 [ pass ]  15848
            innodb.innodb_bug21704 'xtradb'          w2 [ pass ]    183
            innodb.innodb_bug12902967 'xtradb'       w1 [ pass ]  10983
            innodb.innodb_bug34053 'xtradb'          w1 [ pass ]    208
            innodb.innodb_bug34300 'xtradb'          w1 [ pass ]    518
            innodb.innodb_bug14704286 'xtradb'       w3 [ pass ]   8444
            innodb.innodb-wl5522-debug-zip 'xtradb'  w4 [ pass ]  29604
            innodb.innodb_bug30423 'xtradb'          w2 [ pass ]  32161
            --------------------------------------------------------------------------
            The servers were restarted 234 times
            Spent 8595.198 of 2472 seconds executing testcases
             
            Completed: All 547 tests were successful.
             
            16 tests were skipped, 16 by the test itself.
            

            10.2:

            jplindst Jan Lindström (Inactive) added a comment - ASAN: 10.1: jan@jan-laptop-asus:~/mysql/10.1-bugs/mysql-test$ ASAN_OPTIONS=abort_on_error=1 ./mtr --vardir=/dev/shm --suite=innodb,encryption,innodb_zip --force --parallel=auto --big-test Logging: ./mtr --vardir=/dev/shm --suite=innodb,encryption,innodb_zip --force --parallel=auto --big-test vardir: /dev/shm Checking leftover processes... Removing old var directory... couldn't chmod(0777, /dev/shm): Operation not permitted at /usr/share/perl/5.24/File/Find.pm line 511. Couldn't remove directory '/dev/shm': Permission denied at /usr/share/perl/5.24/File/Find.pm line 511. Creating var directory '/dev/shm'... Checking supported features... MariaDB Version 10.1.23-MariaDB-debug - SSL connections supported - binaries are debug compiled Using suites: innodb,encryption,innodb_zip Collecting tests... Installing system database... Using parallel: 4   ==============================================================================   TEST WORKER RESULT TIME (ms) or COMMENT --------------------------------------------------------------------------   worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 worker[3] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039 worker[2] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059 worker[4] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079 encryption.innodb_scrub [ disabled ] MDEV-8139 scrubbing does not work reliably encryption.innodb_scrub_background [ disabled ] MDEV-8139 scrubbing does not work reliably encryption.innodb_encryption-page-compression 'innodb_plugin' w1 [ pass ] 10031 encryption.innodb_encryption-page-compression 'xtradb' w1 [ pass ] 8422 encryption.innodb_encryption_tables 'innodb_plugin' w4 [ pass ] 36535 encryption.innodb_encryption 'innodb_plugin' w3 [ pass ] 42387 encryption.innodb_encryption 'xtradb' w2 [ pass ] 45054 innodb.innodb_bug53674 'innodb_plugin' w2 [ pass ] 67 innodb.innodb_bug53674 'xtradb' w2 [ pass ] 51 innodb.innodb 'innodb_plugin' w4 [ pass ] 18317 encryption.tempfiles 'cbc,xtradb' w2 [ pass ] 288 innodb.innodb 'xtradb' w3 [ pass ] 16331 encryption.tempfiles 'ctr,xtradb' w4 [ pass ] 161 encryption.innodb_encryption_tables 'xtradb' w1 [ pass ] 40168 innodb.snapshot 'innodb_plugin' w2 [ pass ] 31 innodb.snapshot 'xtradb' w3 [ pass ] 32 innodb.group_commit_no_optimize_thread 'innodb_plugin' w2 [ pass ] 50 innodb.group_commit_binlog_pos_no_optimize_thread 'innodb_plugin' w4 [ pass ] 2663 innodb.group_commit_no_optimize_thread 'xtradb' w4 [ pass ] 43 innodb.group_commit_binlog_pos_no_optimize_thread 'xtradb' w3 [ pass ] 2621 innodb.innodb-flush-changed-page-bitmaps 'xtradb' w4 [ pass ] 5 innodb.innodb_ctype_ldml 'innodb_plugin' w3 [ pass ] 1113 innodb.innodb_ctype_ldml 'xtradb' w4 [ pass ] 1159 innodb.group_commit_crash_no_optimize_thread 'innodb_plugin' w1 [ pass ] 16143 innodb.group_commit_crash_no_optimize_thread 'xtradb' w2 [ pass ] 15772 innodb.innodb-autoinc-44030 'innodb_plugin' w4 [ pass ] 3966 innodb.innodb-autoinc 'innodb_plugin' w3 [ pass ] 13334 innodb.innodb-autoinc-44030 'xtradb' w4 [ pass ] 5034 encryption.innodb-page_encryption-32k 'cbc,innodb_plugin' w4 [ skipped ] Test requires InnoDB with 32k Page size. innodb.innodb-autoinc 'xtradb' w2 [ pass ] 16245 encryption.innodb-page_encryption-32k 'cbc,xtradb' w4 [ skipped ] Test requires InnoDB with 32k Page size. encryption.innodb-page_encryption-32k 'ctr,innodb_plugin' w2 [ skipped ] Test requires InnoDB with 32k Page size. encryption.innodb-page_encryption-32k 'ctr,xtradb' w4 [ skipped ] Test requires InnoDB with 32k Page size. innodb.innodb-32k 'innodb_plugin' w2 [ skipped ] Test requires InnoDB with 32k Page size. innodb.innodb-32k-crash 'innodb_plugin' w2 [ skipped ] Test requires InnoDB with 32k Page size. innodb.innodb-64k 'innodb_plugin' w2 [ skipped ] Test requires InnoDB with 64k Page size. innodb.innodb-64k-crash 'innodb_plugin' w2 [ skipped ] Test requires InnoDB with 64k Page size. innodb.innodb-32k 'xtradb' w2 [ skipped ] Test requires InnoDB with 32k Page size. innodb.innodb-32k-crash 'xtradb' w2 [ skipped ] Test requires InnoDB with 32k Page size. innodb.innodb-64k 'xtradb' w2 [ skipped ] Test requires InnoDB with 64k Page size. innodb.innodb-64k-crash 'xtradb' w2 [ skipped ] Test requires InnoDB with 64k Page size. innodb.innodb-16k 'innodb_plugin' w4 [ pass ] 14704 encryption.innodb-log-encrypt-crash 'innodb_plugin' w4 [ skipped ] Does not run with debug binaries innodb.innodb-16k 'xtradb' w2 [ pass ] 13727 encryption.innodb-redo-nokeys 'cbc,innodb_plugin' w2 [ pass ] 10900 encryption.innodb-redo-badkey 'cbc,innodb_plugin' w4 [ pass ] 17658 encryption.innodb-key-rotation-disable 'cbc,innodb_plugin' w2 [ pass ] 4294 innodb.innodb_mysql 'innodb_plugin' w1 [ pass ] 76481 encryption.innodb_first_page 'cbc,innodb_plugin' w4 [ pass ] 7104 encryption.innodb-log-encrypt 'innodb_plugin' w2 [ pass ] 4096 innodb.innodb_mysql 'xtradb' w3 [ pass ] 76910 encryption.innodb-read-only 'cbc,innodb_plugin' w3 [ pass ] 9869 encryption.innodb-page_encryption_log_encryption 'cbc,innodb_plugin' w4 [ pass ] 19786 encryption.innodb-missing-key 'cbc,innodb_plugin' w2 [ pass ] 18249 encryption.encrypt_and_grep 'cbc,innodb_plugin' w1 [ pass ] 31218 encryption.innodb_encryption_row_compressed 'cbc,innodb_plugin' w3 [ pass ] 8833 encryption.innodb_encryption_is 'cbc,innodb_plugin' w3 [ pass ] 87 encryption.innodb-compressed-blob 'cbc,innodb_plugin' w4 [ pass ] 13170 encryption.innodb-log-encrypt-crash 'xtradb' w4 [ skipped ] Does not run with debug binaries encryption.innochecksum 'cbc,innodb_plugin' w3 [ pass ] 14912 encryption.innodb_onlinealter_encryption 'cbc,innodb_plugin' w1 [ pass ] 25461 encryption.innodb-redo-badkey 'cbc,xtradb' w4 [ pass ] 20092 encryption.innodb-redo-nokeys 'cbc,xtradb' w1 [ pass ] 14231 encryption.innodb-key-rotation-disable 'cbc,xtradb' w4 [ pass ] 4869 encryption.innodb-bad-key-change 'cbc,innodb_plugin' w3 [ pass ] 24392 encryption.innodb-log-encrypt 'xtradb' w4 [ pass ] 5386 encryption.innodb_first_page 'cbc,xtradb' w1 [ pass ] 9656 encryption.innodb-discard-import 'cbc,innodb_plugin' w3 [ pass ] 5717 encryption.innodb-discard-import-change 'cbc,innodb_plugin' w3 [ pass ] 2774 encryption.innodb-encr-threads 'cbc,innodb_plugin' w3 [ pass ] 31 encryption.create_or_replace 'cbc,innodb_plugin' w2 [ pass ] 79377 encryption.innodb-page_encryption_log_encryption 'cbc,xtradb' w1 [ pass ] 24186 encryption.encrypt_and_grep 'cbc,xtradb' w4 [ pass ] 35610 encryption.innodb_encryption_filekeys 'cbc,innodb_plugin' w2 [ pass ] 23039 encryption.innodb-encryption-alter 'cbc,innodb_plugin' w3 [ pass ] 45504 encryption.innodb-missing-key 'cbc,xtradb' w1 [ pass ] 22768 encryption.innodb-read-only 'cbc,xtradb' w2 [ pass ] 10878 encryption.innodb_onlinealter_encryption 'cbc,xtradb' w4 [ pass ] 20672 encryption.innodb-force-corrupt 'cbc,innodb_plugin' w3 [ pass ] 8360 encryption.innodb_encryption_row_compressed 'cbc,xtradb' w1 [ pass ] 10670 encryption.innodb_encryption_is 'cbc,xtradb' w1 [ pass ] 90 encryption.innodb-compressed-blob 'cbc,xtradb' w2 [ pass ] 15931 encryption.aria_tiny 'cbc' w2 [ pass ] 20 encryption.innochecksum 'cbc,xtradb' w1 [ pass ] 15091 encryption.innodb-redo-badkey 'ctr,innodb_plugin' w2 [ pass ] 20159 encryption.innodb-redo-nokeys 'ctr,innodb_plugin' w2 [ pass ] 12631 encryption.innodb-key-rotation-disable 'ctr,innodb_plugin' w2 [ pass ] 4897 encryption.innodb-bad-key-change 'cbc,xtradb' w1 [ pass ] 31553 encryption.innodb_first_page 'ctr,innodb_plugin' w2 [ pass ] 8526 encryption.innodb-discard-import 'cbc,xtradb' w1 [ pass ] 5508 encryption.innodb-discard-import-change 'cbc,xtradb' w1 [ pass ] 1498 encryption.innodb-page_encryption 'cbc,innodb_plugin' w3 [ pass ] 79114 encryption.innodb-encr-threads 'cbc,xtradb' w1 [ pass ] 28 encryption.innodb-page_encryption_compression 'cbc,innodb_plugin' w3 [ pass ] 10165 encryption.create_or_replace 'cbc,xtradb' w4 [ pass ] 103445 encryption.innodb_page_encryption_key_change 'cbc,innodb_plugin' w3 [ pass ] 8720 encryption.encrypt_and_grep 'ctr,innodb_plugin' w2 [ pass ] 30960 encryption.innodb-encryption-alter 'cbc,xtradb' w1 [ pass ] 39392 encryption.innodb_encryption_filekeys 'cbc,xtradb' w4 [ pass ] 20146 encryption.innodb-page_encryption_log_encryption 'ctr,innodb_plugin' w3 [ pass ] 22478 encryption.innodb_onlinealter_encryption 'ctr,innodb_plugin' w2 [ pass ] 23992 encryption.innodb-force-corrupt 'cbc,xtradb' w1 [ pass ] 10940 encryption.innodb-read-only 'ctr,innodb_plugin' w3 [ pass ] 10329 encryption.innodb_encryption_row_compressed 'ctr,innodb_plugin' w2 [ pass ] 8910 encryption.innodb-missing-key 'ctr,innodb_plugin' w4 [ pass ] 20026 encryption.innodb_encryption_is 'ctr,innodb_plugin' w4 [ pass ] 104 encryption.innodb-compressed-blob 'ctr,innodb_plugin' w3 [ pass ] 13128 encryption.innochecksum 'ctr,innodb_plugin' w4 [ pass ] 13727 encryption.innodb-redo-badkey 'ctr,xtradb' w3 [ pass ] 21167 encryption.innodb-bad-key-change 'ctr,innodb_plugin' w4 [ pass ] 26997 encryption.innodb-redo-nokeys 'ctr,xtradb' w3 [ pass ] 15062 encryption.innodb-discard-import 'ctr,innodb_plugin' w4 [ pass ] 7062 encryption.innodb-page_encryption 'cbc,xtradb' w1 [ pass ] 79560 encryption.innodb-discard-import-change 'ctr,innodb_plugin' w4 [ pass ] 1753 encryption.innodb-encr-threads 'ctr,innodb_plugin' w4 [ pass ] 31 encryption.innodb-key-rotation-disable 'ctr,xtradb' w3 [ pass ] 6183 encryption.innodb_first_page 'ctr,xtradb' w3 [ pass ] 9452 encryption.innodb-page_encryption_compression 'cbc,xtradb' w1 [ pass ] 12592 encryption.innodb_page_encryption_key_change 'cbc,xtradb' w1 [ pass ] 10595 encryption.innodb-encryption-alter 'ctr,innodb_plugin' w4 [ pass ] 39736 encryption.innodb-force-corrupt 'ctr,innodb_plugin' w4 [ pass ] 8394 encryption.encrypt_and_grep 'ctr,xtradb' w3 [ pass ] 33768 encryption.innodb-page_encryption_log_encryption 'ctr,xtradb' w1 [ pass ] 20581 encryption.innodb_onlinealter_encryption 'ctr,xtradb' w3 [ pass ] 21992 encryption.innodb-missing-key 'ctr,xtradb' w1 [ pass ] 22404 encryption.create_or_replace 'ctr,innodb_plugin' w2 [ pass ] 149659 encryption.innodb-read-only 'ctr,xtradb' w3 [ pass ] 10972 encryption.innodb_encryption_row_compressed 'ctr,xtradb' w1 [ pass ] 10251 encryption.innodb-page_encryption 'ctr,innodb_plugin' w4 [ pass ] 55650 encryption.innodb_encryption_filekeys 'ctr,innodb_plugin' w2 [ pass ] 22716 encryption.innodb-compressed-blob 'ctr,xtradb' w3 [ pass ] 15325 encryption.innodb_encryption_is 'ctr,xtradb' w2 [ pass ] 77 encryption.aria_tiny 'ctr' w2 [ pass ] 15 encryption.innodb-page_encryption_compression 'ctr,innodb_plugin' w4 [ pass ] 11031 innodb_zip.innodb_cmp_drop_table 'innodb_plugin' w2 [ pass ] 4160 encryption.innochecksum 'ctr,xtradb' w3 [ pass ] 14419 innodb.log_data_file_size 'innodb_plugin' w2 [ pass ] 2529 encryption.innodb_page_encryption_key_change 'ctr,innodb_plugin' w4 [ pass ] 8798 encryption.innodb-bad-key-change 'ctr,xtradb' w3 [ pass ] 31073 encryption.innodb-discard-import 'ctr,xtradb' w3 [ pass ] 5094 encryption.innodb-discard-import-change 'ctr,xtradb' w3 [ pass ] 1795 innodb.innodb_defragment 'innodb_plugin' w2 [ pass ] 44240 encryption.innodb-encr-threads 'ctr,xtradb' w3 [ pass ] 31 innodb.innodb_defrag_concurrent 'innodb_plugin' w4 [ pass ] 52260 innodb.innodb_defrag_stats 'innodb_plugin' w2 [ pass ] 18390 encryption.create_or_replace 'ctr,xtradb' w1 [ pass ] 99939 innodb.innodb_defragment_fill_factor 'innodb_plugin' w4 [ pass ] 13834 encryption.innodb-encryption-alter 'ctr,xtradb' w3 [ pass ] 38284 encryption.innodb-bad-key-change4 'innodb_plugin' w4 [ pass ] 12390 encryption.encryption_force 'innodb_plugin' w4 [ pass ] 109 encryption.innodb_encryption_filekeys 'ctr,xtradb' w1 [ pass ] 21750 encryption.innodb-force-corrupt 'ctr,xtradb' w3 [ pass ] 10321 encryption.debug_key_management 'innodb_plugin' w1 [ pass ] 4800 innodb.innodb_defrag_stats_many_tables 'innodb_plugin' w2 [ pass ] 46630 innodb.innodb_corrupt_bit 'innodb_plugin' w2 [ pass ] 527 innodb.innodb_sys_semaphore_waits 'innodb_plugin' w2 [ pass ] 16250 encryption.innodb_encryption_discard_import 'innodb_plugin' w4 [ pass ] 57293 innodb.innodb_simulate_comp_failures_small 'innodb_plugin' w4 [ pass ] 4349 encryption.innodb-page_encryption 'ctr,xtradb' w3 [ pass ] 66990 innodb.innodb_simulate_comp_failures 'innodb_plugin' w2 [ pass ] 36790 encryption.innodb-page_encryption_compression 'ctr,xtradb' w3 [ pass ] 10675 innodb.innodb_mutexes 'innodb_plugin' w2 [ pass ] 8647 innodb.innodb_bug14676111 'innodb_plugin' w2 [ pass ] 94 encryption.innodb_page_encryption_key_change 'ctr,xtradb' w3 [ pass ] 9887 innodb.innodb_bug12400341 'innodb_plugin' w3 [ pass ] 1121 innodb.innochecksum 'innodb_plugin' w2 [ pass ] 8550 innodb.create_isl_with_direct 'innodb_plugin' w2 [ pass ] 57 innodb.innodb_bug14147491 'innodb_plugin' w3 [ pass ] 7508 innodb.innodb_force_pk 'innodb_plugin' w2 [ pass ] 127 innodb.innodb-mdev-7408 'innodb_plugin' w3 [ pass ] 82 innodb.group_commit_binlog_pos 'innodb_plugin' w2 [ pass ] 2758 innodb.binlog_consistent 'innodb_plugin' w3 [ pass ] 130 innodb.group_commit 'innodb_plugin' w3 [ pass ] 57 innodb.group_commit_crash 'innodb_plugin' w2 [ pass ] 15764 innodb.innodb_bug30919 'innodb_plugin' w2 [ pass ] 12518 innodb.innodb-mdev7046 'innodb_plugin' w2 [ pass ] 432 innodb.insert_debug 'innodb_plugin' w2 [ pass ] 495 innodb.multi_repair-7404 'innodb_plugin' w2 [ pass ] 191 innodb.innodb_autoinc_lock_mode_zero 'innodb_plugin' w2 [ pass ] 62 innodb.innodb_information_schema_buffer 'innodb_plugin' w2 [ pass ] 338 innodb.innodb_bug42101-nonzero 'innodb_plugin' w2 [ pass ] 8 innodb.innodb_bug60049 'innodb_plugin' w2 [ pass ] 4333 innodb.innodb_bug39438 'innodb_plugin' w2 [ pass ] 53 innodb.innodb-lock-schedule-algorithm 'innodb_plugin' w2 [ pass ] 12431 innodb.data_types 'innodb_plugin' w2 [ pass ] 69 innodb.innodb-stats-modified-counter 'innodb_plugin' w2 [ pass ] 163 innodb.innodb_information_schema_tables 'innodb_plugin' w2 [ pass ] 506 encryption.innodb_lotoftables 'innodb_plugin' w1 [ pass ] 212071 innodb.innodb-autoinc-56228 'innodb_plugin' w2 [ pass ] 71 innodb.innodb_mysql_rbk 'innodb_plugin' w1 [ pass ] 4568 innodb.innodb_timeout_rollback 'innodb_plugin' w1 [ pass ] 3661 innodb.innodb-consistent 'innodb_plugin' w1 [ pass ] 98 innodb.innodb_lock_wait_timeout_1 'innodb_plugin' w2 [ pass ] 17533 innodb.defrag_mdl-9155 'innodb_plugin' w2 [ pass ] 1655 innodb.innodb-semi-consistent 'innodb_plugin' w1 [ pass ] 11916 innodb.innodb_bug60196 'innodb_plugin' w2 [ skipped ] Test requires: 'lowercase2' innodb.innodb-change-buffer-recovery 'innodb_plugin' w3 [ pass ] 125521 innodb.innodb_bug49164 'innodb_plugin' w3 [ pass ] 101 innodb.innodb_bug51378 'innodb_plugin' w3 [ pass ] 549 innodb.innodb_bug53756 'innodb_plugin' w1 [ pass ] 3510 innodb.innodb_bug51920 'innodb_plugin' w3 [ pass ] 241 innodb.innodb_bug52199 'innodb_plugin' w3 [ pass ] 90 innodb.innodb-wl5522-debug 'innodb_plugin' w2 [ pass ] 29652 innodb.innodb_bug52663 'innodb_plugin' w3 [ pass ] 51380 innodb.innodb_bug53046 'innodb_plugin' w3 [ pass ] 301 innodb.sp_temp_table 'innodb_plugin' w2 [ pass ] 30246 innodb_zip.innodb_prefix_index_liftedlimit 'innodb_plugin' w2 [ pass ] 9644 encryption.innodb-bad-key-change2 'innodb_plugin' w2 [ pass ] 31749 innodb.innodb_bug53290 'innodb_plugin' w3 [ pass ] 47127 innodb.innodb_bug53592 'innodb_plugin' w3 [ pass ] 402 innodb.innodb_bug54044 'innodb_plugin' w3 [ pass ] 65 innodb.innodb_bug56143 'innodb_plugin' w3 [ pass ] 2977 innodb.innodb_bug56716 'innodb_plugin' w3 [ pass ] 29 innodb.innodb_bug56947 'innodb_plugin' w3 [ pass ] 42 innodb.innodb_bug57252 'innodb_plugin' w3 [ pass ] 38 innodb.innodb_bug57255 'innodb_plugin' w3 [ pass ] 1219 innodb.innodb_bug57904 'innodb_plugin' w3 [ pass ] 77 innodb.innodb_bug59410 'innodb_plugin' w3 [ pass ] 69 innodb.innodb_bug59641 'innodb_plugin' w3 [ pass ] 6844 innodb.innodb_bug59733 'innodb_plugin' w3 [ pass ] 955 innodb.innodb_bug60229 'innodb_plugin' w3 [ pass ] 71 encryption.innodb-bad-key-change3 'innodb_plugin' w2 [ pass ] 21934 innodb.innodb_bug68148 'innodb_plugin' w3 [ pass ] 4151 innodb.innodb_defragment_small 'innodb_plugin' w3 [ pass ] 195 innodb.innodb_file_format 'innodb_plugin' w3 [ pass ] 3413 innodb.innodb_gis 'innodb_plugin' w3 [ pass ] 315 innodb.innodb_information_schema 'innodb_plugin' w3 [ pass ] 436 innodb.innodb_monitor 'innodb_plugin' w3 [ pass ] 224 innodb.innodb_multi_update 'innodb_plugin' w3 [ pass ] 79 innodb.innodb_uninstall w1 [ pass ] 127976 innodb.innodb_notembedded 'innodb_plugin' w3 [ pass ] 247 innodb_zip.innodb_cmp_drop_table 'xtradb' w1 [ pass ] 5667 encryption.innodb-encryption-disable 'innodb_plugin' w2 [ pass ] 12615 innodb.innodb_prefix_index_restart_server 'innodb_plugin' w3 [ pass ] 12361 innodb.innodb_stats 'innodb_plugin' w3 [ pass ] 603 innodb.log_data_file_size 'xtradb' w1 [ pass ] 2588 innodb.innodb_stats_create_on_corrupted 'innodb_plugin' w3 [ pass ] 4162 innodb.innodb_stats_create_table 'innodb_plugin' w3 [ pass ] 120 innodb.innodb_stats_drop_locked 'innodb_plugin' w3 [ pass ] 1659 innodb.innodb_stats_fetch 'innodb_plugin' w3 [ pass ] 122 innodb.101_compatibility 'innodb_plugin' w2 [ pass ] 10196 innodb.add_constraint 'innodb_plugin' w2 [ pass ] 305 innodb.alter_key_block_size-11757 'innodb_plugin' w2 [ pass ] 302 innodb.auto_increment_dup 'innodb_plugin' w2 [ pass ] 86 innodb.blob-update-debug 'innodb_plugin' w2 [ pass ] 76 innodb.blob_unique2pk 'innodb_plugin' w2 [ pass ] 137 innodb.count_distinct 'innodb_plugin' w2 [ pass ] 54 innodb.innodb_stats_fetch_corrupted 'innodb_plugin' w3 [ pass ] 4379 innodb.create-index 'innodb_plugin' w2 [ pass ] 66 innodb.innodb_stats_fetch_nonexistent 'innodb_plugin' w3 [ pass ] 89 innodb.innodb_stats_rename_table 'innodb_plugin' w3 [ pass ] 42 innodb.innodb_stats_rename_table_if_exists 'innodb_plugin' w3 [ pass ] 446 innodb.innodb_trx_weight 'innodb_plugin' w3 [ pass ] 1051 innodb.doublewrite 'innodb_plugin' w2 [ pass ] 25730 innodb.dropdb 'innodb_plugin' w2 [ pass ] 4 innodb.foreign-keys 'innodb_plugin' w2 [ pass ] 187 innodb.help_url 'innodb_plugin' w2 [ pass ] 18 innodb.innodb-agregate 'innodb_plugin' w2 [ pass ] 55 innodb.innodb-alter-debug 'innodb_plugin' w2 [ pass ] 215 innodb.innodb-alter-discard 'innodb_plugin' w2 [ pass ] 4245 innodb.innodb-alter-nullable 'innodb_plugin' w2 [ pass ] 145 innodb.innodb_defragment 'xtradb' w1 [ pass ] 45038 innodb.log_file_size 'innodb_plugin' w3 [ pass ] 41563 innodb.mdev-117 'innodb_plugin' w3 [ pass ] 66 innodb.innodb-alter-table 'innodb_plugin' w2 [ pass ] 12561 innodb.innodb-alter-tempfile 'innodb_plugin' w2 [ pass ] 7384 innodb.innodb-alter-timestamp 'innodb_plugin' w2 [ pass ] 152 innodb.innodb-analyze 'innodb_plugin' w2 [ pass ] 72 innodb.innodb-autoinc-18274 'innodb_plugin' w2 [ pass ] 83 innodb.read_only_recovery 'innodb_plugin' w3 [ pass ] 10399 innodb.innodb-autoinc-61209 'innodb_plugin' w2 [ pass ] 38 innodb.row_lock 'innodb_plugin' w3 [ pass ] 276 innodb.innodb-autoinc-optimize 'innodb_plugin' w2 [ pass ] 92 innodb.strict_mode 'innodb_plugin' w3 [ pass ] 416 innodb.system_tables 'innodb_plugin' w3 [ pass ] 4327 innodb.table_index_statistics 'innodb_plugin' w3 [ pass ] 176 innodb.tmpdir 'innodb_plugin' w3 [ pass ] 984 innodb.trigger 'innodb_plugin' w3 [ pass ] 154 innodb.innodb-blob 'innodb_plugin' w2 [ pass ] 8960 innodb.innodb-bug-14068765 'innodb_plugin' w2 [ pass ] 518 innodb.innodb-bug-14084530 'innodb_plugin' w2 [ pass ] 323 innodb.innodb-corrupted-table 'innodb_plugin' w2 [ pass ] 4429 innodb.xa_recovery 'innodb_plugin' w3 [ pass ] 8381 innodb.innodb-dict 'innodb_plugin' w2 [ pass ] 1056 innodb_zip.innodb-create-options 'innodb_plugin' w3 [ pass ] 4182 innodb_zip.innodb-zip 'innodb_plugin' w3 [ pass ] 1936 innodb_zip.innodb_bug36169 'innodb_plugin' w3 [ pass ] 707 innodb_zip.innodb_bug36172 'innodb_plugin' w3 [ pass ] 387 innodb_zip.innodb_bug52745 'innodb_plugin' w3 [ pass ] 62 innodb_zip.innodb_bug53591 'innodb_plugin' w3 [ pass ] 75 innodb_zip.innodb_bug56680 'innodb_plugin' w3 [ pass ] 5291 innodb.innodb-fk 'innodb_plugin' w2 [ pass ] 17063 innodb_zip.innodb_index_large_prefix 'innodb_plugin' w3 [ pass ] 1683 innodb.innodb-fk-warnings 'innodb_plugin' w2 [ pass ] 598 innodb.innodb-fkcheck 'innodb_plugin' w2 [ pass ] 171 innodb.innodb_defrag_concurrent 'xtradb' w1 [ pass ] 58182 innodb.innodb-get-fk 'innodb_plugin' w2 [ pass ] 14565 innodb.innodb-index 'innodb_plugin' w2 [ pass ] 2943 innodb.innodb-index_ucs2 'innodb_plugin' w2 [ pass ] 83 innodb.innodb_defragment_fill_factor 'xtradb' w1 [ pass ] 15679 innodb.innodb-lock 'innodb_plugin' w2 [ pass ] 2111 innodb.innodb_defrag_stats 'xtradb' w3 [ pass ] 20211 innodb.innodb-mdev-7513 'innodb_plugin' w2 [ pass ] 4255 encryption.innodb-bad-key-change4 'xtradb' w1 [ pass ] 14807 encryption.encryption_force 'xtradb' w1 [ pass ] 255 innodb.innodb_defrag_stats_many_tables 'xtradb' w3 [ pass ] 48886 encryption.debug_key_management 'xtradb' w3 [ pass ] 4831 encryption.innodb_encryption_discard_import 'xtradb' w1 [ pass ] 63578 innodb.innodb_corrupt_bit 'xtradb' w1 [ pass ] 253 innodb.innodb-page_compression_bzip2 'innodb_plugin' w2 [ pass ] 100974 innodb.innodb-page_compression_default 'innodb_plugin' w2 [ pass ] 3670 innodb.innodb_sys_semaphore_waits 'xtradb' w1 [ pass ] 15702 innodb.innodb_simulate_comp_failures 'xtradb' w1 [ pass ] 48517 innodb.innodb_simulate_comp_failures_small 'xtradb' w1 [ pass ] 4168 innodb.innodb-page_compression_lz4 'innodb_plugin' w2 [ pass ] 103737 encryption.innodb_lotoftables 'xtradb' w3 [ pass ] 218955 innodb.innodb_mutexes 'xtradb' w3 [ pass ] 11301 innodb.innodb_bug14676111 'xtradb' w3 [ pass ] 161 innodb.innochecksum 'xtradb' w3 [ pass ] 11051 innodb.innodb_bug12400341 'xtradb' w3 [ pass ] 1187 innodb.innodb-page_compression_lzma 'innodb_plugin' w2 [ pass ] 121084 innodb.innodb_bug14147491 'xtradb' w3 [ pass ] 10821 innodb.create_isl_with_direct 'xtradb' w3 [ pass ] 56 innodb.innodb_force_pk 'xtradb' w3 [ pass ] 230 innodb.innodb-mdev-7408 'xtradb' w3 [ pass ] 86 innodb.group_commit_binlog_pos 'xtradb' w3 [ pass ] 2572 innodb.binlog_consistent 'xtradb' w3 [ pass ] 276 innodb.innodb-bigblob 'innodb_plugin' w4 [ pass ] 861162 innodb.group_commit 'xtradb' w4 [ pass ] 94 innodb.group_commit_crash 'xtradb' w3 [ pass ] 16090 innodb.innodb_bug30919 'xtradb' w3 [ pass ] 13404 innodb.innodb-mdev7046 'xtradb' w3 [ pass ] 446 innodb.innodb-page_compression_lzo 'innodb_plugin' w2 [ pass ] 82438 innodb.insert_debug 'xtradb' w3 [ pass ] 468 innodb.multi_repair-7404 'xtradb' w3 [ pass ] 196 innodb.innodb_autoinc_lock_mode_zero 'xtradb' w3 [ pass ] 77 innodb.innodb_information_schema_buffer 'xtradb' w3 [ pass ] 497 innodb.innodb_bug42101-nonzero 'xtradb' w3 [ pass ] 7 innodb.innodb_bug60049 'xtradb' w3 [ pass ] 5436 innodb.innodb_bug39438 'xtradb' w3 [ pass ] 40 innodb.innodb-lock-schedule-algorithm 'xtradb' w3 [ pass ] 13396 innodb.data_types 'xtradb' w3 [ pass ] 74 innodb.innodb-stats-modified-counter 'xtradb' w3 [ pass ] 61 innodb.innodb_information_schema_tables 'xtradb' w3 [ pass ] 573 innodb.innodb-autoinc-56228 'xtradb' w3 [ pass ] 110 innodb.innodb_mysql_rbk 'xtradb' w3 [ pass ] 4583 innodb.innodb_lock_wait_timeout_1 'xtradb' w3 [ pass ] 18421 innodb.innodb_timeout_rollback 'xtradb' w3 [ pass ] 2444 innodb.innodb-page_compression_snappy 'innodb_plugin' w2 [ pass ] 114474 innodb.innodb-consistent 'xtradb' w3 [ pass ] 108 innodb.innodb-change-buffer-recovery 'xtradb' w4 [ pass ] 149360 innodb.innodb-semi-consistent 'xtradb' w3 [ pass ] 11870 innodb.defrag_mdl-9155 'xtradb' w4 [ pass ] 1820 innodb.innodb_bug60196 'xtradb' w3 [ skipped ] Test requires: 'lowercase2' innodb.innodb-page_compression_tables 'innodb_plugin' w2 [ pass ] 20822 innodb.innodb_bug53756 'xtradb' w4 [ pass ] 3080 innodb.innodb-page_compression_default 'xtradb' w4 [ pass ] 4836 innodb.innodb-wl5522-debug 'xtradb' w3 [ pass ] 41262 innodb.sp_temp_table 'xtradb' w3 [ pass ] 30493 innodb_zip.innodb_prefix_index_liftedlimit 'xtradb' w3 [ pass ] 10202 innodb.innodb-page_compression_zip 'innodb_plugin' w2 [ pass ] 97592 innodb.innodb-replace 'innodb_plugin' w2 [ pass ] 23 innodb.innodb-stats-initialize-failure 'innodb_plugin' w2 [ pass ] 8238 innodb.innodb-stats-sample 'innodb_plugin' w2 [ pass ] 7266 innodb.innodb-timeout 'innodb_plugin' w2 [ pass ] 4335 innodb.innodb-truncate 'innodb_plugin' w2 [ pass ] 442 innodb.innodb-ucs2 'innodb_plugin' w2 [ pass ] 1010 innodb.innodb-update-insert 'innodb_plugin' w2 [ pass ] 87 innodb.innodb-virtual-columns 'innodb_plugin' w2 [ pass ] 424 encryption.innodb-bad-key-change2 'xtradb' w3 [ pass ] 38702 innodb.innodb-wl5522 'innodb_plugin' w2 [ pass ] 14981 innodb.innodb-page_compression_lz4 'xtradb' w4 [ pass ] 126412 innodb.innodb-wl5522-1 'innodb_plugin' w2 [ pass ] 5420 encryption.innodb-bad-key-change3 'xtradb' w3 [ pass ] 26576 innodb.innodb-wl5522-debug-zip 'innodb_plugin' w2 [ pass ] 28843 encryption.innodb-encryption-disable 'xtradb' w3 [ pass ] 16666 innodb.innodb-wl5522-zip 'innodb_plugin' w2 [ pass ] 14266 innodb.innodb-xa 'innodb_plugin' w2 [ pass ] 85 innodb.innodb_blob_truncate 'innodb_plugin' w2 [ pass ] 224 innodb.101_compatibility 'xtradb' w3 [ pass ] 12071 innodb.add_constraint 'xtradb' w3 [ pass ] 313 innodb.alter_key_block_size-11757 'xtradb' w3 [ pass ] 189 innodb.auto_increment_dup 'xtradb' w3 [ pass ] 85 innodb.innodb_blob_unrecoverable_crash 'innodb_plugin' w2 [ pass ] 3173 innodb.blob-update-debug 'xtradb' w3 [ pass ] 82 innodb.innodb_bug11754376 'innodb_plugin' w2 [ pass ] 34 innodb.blob_unique2pk 'xtradb' w3 [ pass ] 261 innodb.innodb_bug12661768 'innodb_plugin' w2 [ pass ] 98 innodb.count_distinct 'xtradb' w3 [ pass ] 53 innodb.create-index 'xtradb' w3 [ pass ] 52 innodb.innodb_bug12902967 'innodb_plugin' w2 [ pass ] 8847 innodb.innodb_bug13510739 'innodb_plugin' w2 [ pass ] 30 innodb.innodb_bug14007649 'innodb_plugin' w2 [ pass ] 63 innodb.innodb_bug14704286 'innodb_plugin' w2 [ pass ] 6488 innodb.innodb_bug21704 'innodb_plugin' w2 [ pass ] 137 innodb.doublewrite 'xtradb' w3 [ pass ] 28645 innodb.dropdb 'xtradb' w3 [ pass ] 6 innodb.foreign-keys 'xtradb' w3 [ pass ] 357 innodb.help_url 'xtradb' w3 [ pass ] 28 innodb.innodb-agregate 'xtradb' w3 [ pass ] 55 innodb.innodb-alter-debug 'xtradb' w3 [ pass ] 277 innodb.innodb-alter-discard 'xtradb' w3 [ pass ] 4490 innodb.innodb-alter-nullable 'xtradb' w3 [ pass ] 238 innodb.innodb-alter-table 'xtradb' w3 [ pass ] 15456 innodb.innodb-page_compression_lzma 'xtradb' w4 [ pass ] 117673 innodb.innodb-alter-tempfile 'xtradb' w3 [ pass ] 8592 innodb.innodb-alter-timestamp 'xtradb' w3 [ pass ] 175 innodb.innodb-analyze 'xtradb' w3 [ pass ] 124 innodb.innodb-autoinc-18274 'xtradb' w3 [ pass ] 116 innodb.innodb-autoinc-61209 'xtradb' w3 [ pass ] 40 innodb.innodb-autoinc-optimize 'xtradb' w3 [ pass ] 81 innodb.innodb_bug30423 'innodb_plugin' w2 [ pass ] 56198 innodb.innodb_bug34053 'innodb_plugin' w2 [ pass ] 224 innodb.innodb_bug34300 'innodb_plugin' w2 [ pass ] 320 innodb.innodb_bug35220 'innodb_plugin' w2 [ pass ] 76 innodb.innodb_bug38231 'innodb_plugin' w2 [ pass ] 65 innodb.innodb_bug40360 'innodb_plugin' w2 [ pass ] 36 innodb.innodb_bug40565 'innodb_plugin' w2 [ pass ] 28 innodb.innodb-blob 'xtradb' w3 [ pass ] 8998 innodb.innodb_bug41904 'innodb_plugin' w2 [ pass ] 52 innodb.innodb-bug-14068765 'xtradb' w3 [ pass ] 462 innodb.innodb_bug42101 'innodb_plugin' w2 [ pass ] 7 innodb.innodb-bug-14084530 'xtradb' w3 [ pass ] 372 innodb.innodb_bug42419 'innodb_plugin' w2 [ pass ] 277 innodb.innodb_bug44032 'innodb_plugin' w2 [ pass ] 47 innodb.innodb_bug44369 'innodb_plugin' w2 [ pass ] 6 innodb.innodb_bug44571 'innodb_plugin' w2 [ pass ] 85 innodb.innodb_bug45357 'innodb_plugin' w2 [ pass ] 61 innodb.innodb_bug46000 'innodb_plugin' w2 [ pass ] 50 innodb.innodb_bug46676 'innodb_plugin' w2 [ pass ] 199 innodb.innodb-corrupted-table 'xtradb' w3 [ pass ] 5593 innodb.innodb-dict 'xtradb' w3 [ pass ] 1056 innodb.innodb_bug47167 'innodb_plugin' w2 [ pass ] 3781 innodb.innodb_bug47621 'innodb_plugin' w2 [ pass ] 119 innodb.innodb_bug47622 'innodb_plugin' w2 [ pass ] 121 innodb.innodb_bug47777 'innodb_plugin' w2 [ pass ] 23 innodb.innodb_bug48024 'innodb_plugin' w2 [ pass ] 134 innodb.innodb_bug35220 'xtradb' w2 [ pass ] 55 innodb.innodb_bug38231 'xtradb' w2 [ pass ] 62 innodb.innodb_bug40360 'xtradb' w2 [ pass ] 35 innodb.innodb_bug40565 'xtradb' w2 [ pass ] 47 innodb.innodb_bug41904 'xtradb' w2 [ pass ] 66 innodb.innodb_bug42101 'xtradb' w2 [ pass ] 8 innodb.innodb_bug42419 'xtradb' w2 [ pass ] 271 innodb.innodb_bug44032 'xtradb' w2 [ pass ] 45 innodb.innodb_bug44369 'xtradb' w2 [ pass ] 3 innodb.innodb_bug44571 'xtradb' w2 [ pass ] 54 innodb.innodb_bug45357 'xtradb' w2 [ pass ] 32 innodb.innodb_bug46000 'xtradb' w2 [ pass ] 32 innodb.innodb_bug46676 'xtradb' w2 [ pass ] 162 innodb.innodb-fk 'xtradb' w3 [ pass ] 15807 innodb.innodb-fk-warnings 'xtradb' w3 [ pass ] 582 innodb.innodb-fkcheck 'xtradb' w3 [ pass ] 166 innodb.innodb_bug47167 'xtradb' w2 [ pass ] 4651 innodb.innodb_bug47621 'xtradb' w2 [ pass ] 132 innodb.innodb_bug47622 'xtradb' w2 [ pass ] 103 innodb.innodb_bug47777 'xtradb' w2 [ pass ] 26 innodb.innodb_bug48024 'xtradb' w2 [ pass ] 115 innodb.innodb_bug49164 'xtradb' w2 [ pass ] 35 innodb.innodb_bug51378 'xtradb' w2 [ pass ] 149 innodb.innodb_bug51920 'xtradb' w2 [ pass ] 35 innodb.innodb_bug52199 'xtradb' w2 [ pass ] 42 innodb.innodb-get-fk 'xtradb' w3 [ pass ] 16795 innodb.innodb-index 'xtradb' w3 [ pass ] 2731 innodb.innodb-index_ucs2 'xtradb' w3 [ pass ] 123 innodb.innodb-lock 'xtradb' w3 [ pass ] 2136 innodb.innodb-page_compression_lzo 'xtradb' w4 [ pass ] 74559 innodb.innodb-mdev-7513 'xtradb' w3 [ pass ] 5357 innodb.innodb_bug52663 'xtradb' w2 [ pass ] 51089 innodb.innodb_bug53046 'xtradb' w2 [ pass ] 91 innodb.innodb_bug53290 'xtradb' w2 [ pass ] 29967 innodb.innodb_bug53592 'xtradb' w2 [ pass ] 271 innodb.innodb_bug54044 'xtradb' w2 [ pass ] 55 innodb.innodb_bug56143 'xtradb' w2 [ pass ] 3450 innodb.innodb_bug56716 'xtradb' w2 [ pass ] 20 innodb.innodb_bug56947 'xtradb' w2 [ pass ] 40 innodb.innodb_bug57252 'xtradb' w2 [ pass ] 35 innodb.innodb_bug57255 'xtradb' w2 [ pass ] 1012 innodb.innodb_bug57904 'xtradb' w2 [ pass ] 36 innodb.innodb_bug59410 'xtradb' w2 [ pass ] 39 innodb.innodb_bug59641 'xtradb' w2 [ pass ] 8124 innodb.innodb_bug59733 'xtradb' w2 [ pass ] 1734 innodb.innodb_bug60229 'xtradb' w2 [ pass ] 110 innodb.innodb_bug68148 'xtradb' w2 [ pass ] 5375 innodb.innodb_defragment_small 'xtradb' w2 [ pass ] 328 innodb.innodb_file_format 'xtradb' w2 [ pass ] 4825 innodb.innodb_gis 'xtradb' w2 [ pass ] 620 innodb.innodb_information_schema 'xtradb' w2 [ pass ] 539 innodb.innodb_monitor 'xtradb' w2 [ pass ] 358 innodb.innodb_multi_update 'xtradb' w2 [ pass ] 95 innodb.innodb_notembedded 'xtradb' w2 [ pass ] 249 innodb.innodb-page_compression_snappy 'xtradb' w4 [ pass ] 111826 innodb.innodb-page_compression_bzip2 'xtradb' w3 [ pass ] 114595 innodb.innodb_prefix_index_restart_server 'xtradb' w2 [ pass ] 15654 innodb.innodb_stats 'xtradb' w2 [ pass ] 903 innodb.innodb_trx_weight 'xtradb' w3 [ pass ] 1562 innodb.innodb_stats_create_on_corrupted 'xtradb' w2 [ pass ] 5248 innodb.innodb_stats_create_table 'xtradb' w2 [ pass ] 80 innodb.innodb_stats_drop_locked 'xtradb' w2 [ pass ] 2586 innodb.innodb_stats_fetch 'xtradb' w2 [ pass ] 141 innodb.innodb-page_compression_tables 'xtradb' w4 [ pass ] 18846 innodb.innodb_stats_fetch_corrupted 'xtradb' w2 [ pass ] 5384 innodb.innodb_stats_fetch_nonexistent 'xtradb' w2 [ pass ] 75 innodb.innodb_stats_rename_table 'xtradb' w2 [ pass ] 38 innodb.innodb_stats_rename_table_if_exists 'xtradb' w2 [ pass ] 463 innodb.xa_recovery 'xtradb' w2 [ pass ] 8561 innodb_zip.innodb-create-options 'xtradb' w2 [ pass ] 3021 innodb_zip.innodb-zip 'xtradb' w2 [ pass ] 1861 innodb_zip.innodb_bug36169 'xtradb' w2 [ pass ] 662 innodb_zip.innodb_bug36172 'xtradb' w2 [ pass ] 257 innodb_zip.innodb_bug52745 'xtradb' w2 [ pass ] 113 innodb_zip.innodb_bug53591 'xtradb' w2 [ pass ] 41 innodb_zip.innodb_bug56680 'xtradb' w2 [ pass ] 5911 innodb_zip.innodb_index_large_prefix 'xtradb' w2 [ pass ] 1457 innodb.log_file_size 'xtradb' w3 [ pass ] 43165 innodb.mdev-117 'xtradb' w3 [ pass ] 53 innodb.innodb-bigblob 'xtradb' w1 [ pass ] 873476 innodb.innodb-changed-pages 'xtradb' w2 [ pass ] 31 innodb.fake_changes-7000 'xtradb' w1 [ pass ] 21 encryption.filekeys_encfile_file 'xtradb' w2 [ pass ] 82 innodb.read_only_recovery 'xtradb' w3 [ pass ] 10765 innodb.row_lock 'xtradb' w3 [ pass ] 111 encryption.filekeys_encfile_badfile 'xtradb' w1 [ pass ] 59 innodb.strict_mode 'xtradb' w3 [ pass ] 418 encryption.filekeys_encfile_bad 'xtradb' w2 [ pass ] 76 encryption.filekeys_unencfile 'xtradb' w1 [ pass ] 78 encryption.filekeys_encfile 'xtradb' w2 [ pass ] 220 innodb.system_tables 'xtradb' w3 [ pass ] 5476 innodb.table_index_statistics 'xtradb' w3 [ pass ] 109 innodb.tmpdir 'xtradb' w3 [ pass ] 722 innodb.trigger 'xtradb' w3 [ pass ] 97 encryption.filekeys_tooshort 'xtradb' w1 [ pass ] 37 encryption.filekeys_encfile_no 'xtradb' w2 [ pass ] 53 encryption.filekeys_emptyfile 'xtradb' w3 [ pass ] 73 encryption.filekeys_syntax 'xtradb' w1 [ pass ] 564 encryption.filekeys_nofile 'xtradb' w2 [ pass ] 57 innodb.innodb_skip_innodb_is_tables w3 [ pass ] 46 innodb.innodb-replace 'xtradb' w3 [ pass ] 70 innodb.innodb_defrag_binlog 'row,xtradb' w2 [ pass ] 1046 innodb.innodb_defrag_binlog 'innodb_plugin,row' w1 [ pass ] 1447 innodb.innodb-stats-initialize-failure 'xtradb' w3 [ pass ] 7551 innodb.innodb-truncate 'xtradb' w3 [ pass ] 445 innodb.innodb-ucs2 'xtradb' w3 [ pass ] 1003 innodb.innodb-update-insert 'xtradb' w3 [ pass ] 126 innodb.innodb-virtual-columns 'xtradb' w3 [ pass ] 571 innodb.innodb-timeout 'xtradb' w1 [ pass ] 4916 innodb.innodb-page_compression_zip 'xtradb' w4 [ pass ] 75896 innodb.innodb-stats-sample 'xtradb' w2 [ pass ] 8670 innodb.innodb-wl5522-1 'xtradb' w1 [ pass ] 7567 innodb.innodb-xa 'xtradb' w1 [ pass ] 17 innodb.innodb_blob_truncate 'xtradb' w1 [ pass ] 112 innodb.innodb_blob_unrecoverable_crash 'xtradb' w1 [ pass ] 2962 innodb.innodb_bug11754376 'xtradb' w1 [ pass ] 20 innodb.innodb_bug12661768 'xtradb' w1 [ pass ] 78 innodb.innodb-wl5522 'xtradb' w3 [ pass ] 17740 innodb.innodb_bug13510739 'xtradb' w3 [ pass ] 47 innodb.innodb_bug14007649 'xtradb' w3 [ pass ] 73 innodb.innodb-wl5522-zip 'xtradb' w2 [ pass ] 15848 innodb.innodb_bug21704 'xtradb' w2 [ pass ] 183 innodb.innodb_bug12902967 'xtradb' w1 [ pass ] 10983 innodb.innodb_bug34053 'xtradb' w1 [ pass ] 208 innodb.innodb_bug34300 'xtradb' w1 [ pass ] 518 innodb.innodb_bug14704286 'xtradb' w3 [ pass ] 8444 innodb.innodb-wl5522-debug-zip 'xtradb' w4 [ pass ] 29604 innodb.innodb_bug30423 'xtradb' w2 [ pass ] 32161 -------------------------------------------------------------------------- The servers were restarted 234 times Spent 8595.198 of 2472 seconds executing testcases   Completed: All 547 tests were successful.   16 tests were skipped, 16 by the test itself. 10.2:

            10.1:
            commit 765a43605a42c069ede604826ede2d93d72c4fdd
            Author: Jan Lindström <jan.lindstrom@mariadb.com>
            Date: Wed Apr 26 15:19:16 2017 +0300

            MDEV-12253: Buffer pool blocks are accessed after they have been freed

            Problem was that bpage was referenced after it was already freed
            from LRU. Fixed by adding a new variable encrypted that is
            passed down to buf_page_check_corrupt() and used in
            buf_page_get_gen() to stop processing page read.

            This patch should also address following test failures and
            bugs:

            MDEV-12419: IMPORT should not look up tablespace in
            PageConverter::validate(). This is now removed.

            MDEV-10099: encryption.innodb_onlinealter_encryption fails
            sporadically in buildbot

            MDEV-11420: encryption.innodb_encryption-page-compression
            failed in buildbot

            MDEV-11222: encryption.encrypt_and_grep failed in buildbot on P8

            Removed dict_table_t::is_encrypted and dict_table_t::ibd_file_missing
            and replaced these with dict_table_t::file_unreadable. Table
            ibd file is missing if fil_get_space(space_id) returns NULL
            and encrypted if not. Removed dict_table_t::is_corrupted field.

            Ported FilSpace class from 10.2 and using that on buf_page_check_corrupt(),
            buf_page_decrypt_after_read(), buf_page_encrypt_before_write(),
            buf_dblwr_process(), buf_read_page(), dict_stats_save_defrag_stats().

            Added test cases when enrypted page could be read while doing
            redo log crash recovery. Also added test case for row compressed
            blobs.

            btr_cur_open_at_index_side_func(),
            btr_cur_open_at_rnd_pos_func(): Avoid referencing block that is
            NULL.

            buf_page_get_zip(): Issue error if page read fails.

            buf_page_get_gen(): Use dberr_t for error detection and
            do not reference bpage after we hare freed it.

            buf_mark_space_corrupt(): remove bpage from LRU also when
            it is encrypted.

            buf_page_check_corrupt(): @return DB_SUCCESS if page has
            been read and is not corrupted,
            DB_PAGE_CORRUPTED if page based on checksum check is corrupted,
            DB_DECRYPTION_FAILED if page post encryption checksum matches but
            after decryption normal page checksum does not match. In read
            case only DB_SUCCESS is possible.

            buf_page_io_complete(): use dberr_t for error handling.

            buf_flush_write_block_low(),
            buf_read_ahead_random(),
            buf_read_page_async(),
            buf_read_ahead_linear(),
            buf_read_ibuf_merge_pages(),
            buf_read_recv_pages(),
            fil_aio_wait():
            Issue error if page read fails.

            btr_pcur_move_to_next_page(): Do not reference page if it is
            NULL.

            Introduced dict_table_t::is_readable() and dict_index_t::is_readable()
            that will return true if tablespace exists and pages read from
            tablespace are not corrupted or page decryption failed.
            Removed buf_page_t::key_version. After page decryption the
            key version is not removed from page frame. For unencrypted
            pages, old key_version is removed at buf_page_encrypt_before_write()

            dict_stats_update_transient_for_index(),
            dict_stats_update_transient()
            Do not continue if table decryption failed or table
            is corrupted.

            dict0stats.cc: Introduced a dict_stats_report_error function
            to avoid code duplication.

            fil_parse_write_crypt_data():
            Check that key read from redo log entry is found from
            encryption plugin and if it is not, refuse to start.

            PageConverter::validate(): Removed access to fil_space_t as
            tablespace is not available during import.

            Fixed error code on innodb.innodb test.

            Merged test cased innodb-bad-key-change5 and innodb-bad-key-shutdown
            to innodb-bad-key-change2. Removed innodb-bad-key-change5 test.
            Decreased unnecessary complexity on some long lasting tests.

            Removed fil_inc_pending_ops(), fil_decr_pending_ops(),
            fil_get_first_space(), fil_get_next_space(),
            fil_get_first_space_safe(), fil_get_next_space_safe()
            functions.

            fil_space_verify_crypt_checksum(): Fixed bug found using ASAN
            where FIL_PAGE_END_LSN_OLD_CHECKSUM field was incorrectly
            accessed from row compressed tables. Fixed out of page frame
            bug for row compressed tables in
            fil_space_verify_crypt_checksum() found using ASAN. Incorrect
            function was called for compressed table.

            Added new tests for discard, rename table and drop (we should allow them
            even when page decryption fails). Alter table rename is not allowed.
            Added test for restart with innodb-force-recovery=1 when page read on
            redo-recovery cant be decrypted. Added test for corrupted table where
            both page data and FIL_PAGE_FILE_FLUSH_LSN_OR_KEY_VERSION is corrupted.

            Adjusted the test case innodb_bug14147491 so that it does not anymore
            expect crash. Instead table is just mostly not usable.

            fil0fil.h: fil_space_acquire_low is not visible function
            and fil_space_acquire and fil_space_acquire_silent are
            inline functions. FilSpace class uses fil_space_acquire_low
            directly.

            recv_apply_hashed_log_recs() does not return anything.

            jplindst Jan Lindström (Inactive) added a comment - 10.1: commit 765a43605a42c069ede604826ede2d93d72c4fdd Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Wed Apr 26 15:19:16 2017 +0300 MDEV-12253 : Buffer pool blocks are accessed after they have been freed Problem was that bpage was referenced after it was already freed from LRU. Fixed by adding a new variable encrypted that is passed down to buf_page_check_corrupt() and used in buf_page_get_gen() to stop processing page read. This patch should also address following test failures and bugs: MDEV-12419 : IMPORT should not look up tablespace in PageConverter::validate(). This is now removed. MDEV-10099 : encryption.innodb_onlinealter_encryption fails sporadically in buildbot MDEV-11420 : encryption.innodb_encryption-page-compression failed in buildbot MDEV-11222 : encryption.encrypt_and_grep failed in buildbot on P8 Removed dict_table_t::is_encrypted and dict_table_t::ibd_file_missing and replaced these with dict_table_t::file_unreadable. Table ibd file is missing if fil_get_space(space_id) returns NULL and encrypted if not. Removed dict_table_t::is_corrupted field. Ported FilSpace class from 10.2 and using that on buf_page_check_corrupt(), buf_page_decrypt_after_read(), buf_page_encrypt_before_write(), buf_dblwr_process(), buf_read_page(), dict_stats_save_defrag_stats(). Added test cases when enrypted page could be read while doing redo log crash recovery. Also added test case for row compressed blobs. btr_cur_open_at_index_side_func(), btr_cur_open_at_rnd_pos_func(): Avoid referencing block that is NULL. buf_page_get_zip(): Issue error if page read fails. buf_page_get_gen(): Use dberr_t for error detection and do not reference bpage after we hare freed it. buf_mark_space_corrupt(): remove bpage from LRU also when it is encrypted. buf_page_check_corrupt(): @return DB_SUCCESS if page has been read and is not corrupted, DB_PAGE_CORRUPTED if page based on checksum check is corrupted, DB_DECRYPTION_FAILED if page post encryption checksum matches but after decryption normal page checksum does not match. In read case only DB_SUCCESS is possible. buf_page_io_complete(): use dberr_t for error handling. buf_flush_write_block_low(), buf_read_ahead_random(), buf_read_page_async(), buf_read_ahead_linear(), buf_read_ibuf_merge_pages(), buf_read_recv_pages(), fil_aio_wait(): Issue error if page read fails. btr_pcur_move_to_next_page(): Do not reference page if it is NULL. Introduced dict_table_t::is_readable() and dict_index_t::is_readable() that will return true if tablespace exists and pages read from tablespace are not corrupted or page decryption failed. Removed buf_page_t::key_version. After page decryption the key version is not removed from page frame. For unencrypted pages, old key_version is removed at buf_page_encrypt_before_write() dict_stats_update_transient_for_index(), dict_stats_update_transient() Do not continue if table decryption failed or table is corrupted. dict0stats.cc: Introduced a dict_stats_report_error function to avoid code duplication. fil_parse_write_crypt_data(): Check that key read from redo log entry is found from encryption plugin and if it is not, refuse to start. PageConverter::validate(): Removed access to fil_space_t as tablespace is not available during import. Fixed error code on innodb.innodb test. Merged test cased innodb-bad-key-change5 and innodb-bad-key-shutdown to innodb-bad-key-change2. Removed innodb-bad-key-change5 test. Decreased unnecessary complexity on some long lasting tests. Removed fil_inc_pending_ops(), fil_decr_pending_ops(), fil_get_first_space(), fil_get_next_space(), fil_get_first_space_safe(), fil_get_next_space_safe() functions. fil_space_verify_crypt_checksum(): Fixed bug found using ASAN where FIL_PAGE_END_LSN_OLD_CHECKSUM field was incorrectly accessed from row compressed tables. Fixed out of page frame bug for row compressed tables in fil_space_verify_crypt_checksum() found using ASAN. Incorrect function was called for compressed table. Added new tests for discard, rename table and drop (we should allow them even when page decryption fails). Alter table rename is not allowed. Added test for restart with innodb-force-recovery=1 when page read on redo-recovery cant be decrypted. Added test for corrupted table where both page data and FIL_PAGE_FILE_FLUSH_LSN_OR_KEY_VERSION is corrupted. Adjusted the test case innodb_bug14147491 so that it does not anymore expect crash. Instead table is just mostly not usable. fil0fil.h: fil_space_acquire_low is not visible function and fil_space_acquire and fil_space_acquire_silent are inline functions. FilSpace class uses fil_space_acquire_low directly. recv_apply_hashed_log_recs() does not return anything.

            I think that this fix is to some extent introducing MDEV-4777 for InnoDB, by trying to block all access to tables when any corruption has been noticed.

            When a page cannot be read or decrypted during crash recovery, we must spend some more effort, as noted in MDEV-12699.

            marko Marko Mäkelä added a comment - I think that this fix is to some extent introducing MDEV-4777 for InnoDB, by trying to block all access to tables when any corruption has been noticed. When a page cannot be read or decrypted during crash recovery, we must spend some more effort, as noted in MDEV-12699 .

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.