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

Re-bootstrap the server if InnoDB options are incompatible (Make InnoDB tests run with all --mysqld=--innodb-page-size)

    Details

      Description

      Currently buildbot only runs the InnoDB tests with the default innodb_page_size=16k.

      We have 3 classes of test failures when running with non-default page size:

      1. Result differences (for example, different statistics)
      2. Failing operations (for example, too large KEY_BLOCK_SIZE, or attempt to use ROW_FORMAT=COMPRESSED with innodb_page_size larger than 16k)
      3. Bugs revealed by the tests: for example, MDEV-11828 was revealed by running innodb.innodb-64k.

      I did two test runs on 10.2 to see how many tests are affected. Not that many:

      ./mtr --parallel=auto --force --retry=0 --max-test-fail=0 --suite=innodb,innodb_fts,innodb_gis,encryption --mysqld=--innodb-page-size=64k --mysqld=innodb-buffer-pool-size=24M;
      ./mtr --parallel=auto --force --retry=0 --max-test-fail=0 --suite=innodb,innodb_fts,innodb_gis,encryption,innodb_zip  --mysqld=--innodb-page-size=4k
      

      There could be some more failures with 8k or 32k, but I thought that it would be better to look at the extremes first:

      innodb_page_size=64k test failures

      encryption.innodb_encryption_tables innodb.innodb-64k encryption.innodb-log-encrypt encryption.innodb-page_encryption_log_encryption encryption.innodb_encryption_row_compressed innodb.innodb_uninstall innodb_zip.innodb_cmp_drop_table encryption.innochecksum encryption.innodb-discard-import encryption.create_or_replace innodb.innodb_defragment encryption.innodb-page_encryption encryption.innodb_encryption_discard_import encryption.innodb_page_encryption_key_change innodb.innodb_defrag_stats encryption.innodb_onlinealter_encryption innodb.innodb_simulate_comp_failures_small innodb_zip.innodb_bug36169 innodb.binlog_consistent innodb.innodb_defrag_concurrent innodb.innodb_simulate_comp_failures innodb.innodb_trx_weight innodb.innodb-page_compression_zip innodb.innodb-wl5522-debug innodb.temporary_table innodb.strict_mode innodb_zip.innodb_bug53591 innodb_zip.innodb-zip innodb_fts.innodb_fts_misc_1 innodb_zip.innodb_bug56680 innodb_zip.innodb_bug36172 innodb_zip.innodb_bug52745 innodb.innodb_defrag_binlog

      innodb_page_size=4k test failures

      innodb.innodb_mysql innodb.innodb_uninstall innodb_zip.innodb_cmp_drop_table innodb.innodb_defrag_concurrent innodb.innodb_defrag_stats innodb.innodb_simulate_comp_failures_small encryption.innodb_lotoftables innodb.innodb_defrag_stats_many_tables innodb.binlog_consistent innodb.innodb_simulate_comp_failures innodb.innodb_trx_weight innodb.innodb-change-buffer-recovery innodb_zip.4k innodb.innodb-page_compression_zip innodb.innodb-wl5522-debug innodb.innodb_prefix_index_restart_server innodb_zip.wl6501_crash_4 innodb.strict_mode innodb_zip.index_large_prefix_4k innodb.innodb_defrag_binlog innodb_gis.rt_precise

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                elenst Elena Stepanova
                Reporter:
                marko Marko Mäkelä
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: