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

Encryption loading fails while running the suite

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Cannot Reproduce
    • 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
    • N/A
    • Platform FreeBSD, Tests

    Description

      In 10.6, encryption suite test case fails with Test requires plugin

      encryption.innodb-compressed-blob '16k,cbc,crc32,innodb' [ skipped ]  Test requires file_key_management plugin
      		 
      line
      		 
      2021-02-09 18:35:21 0 [ERROR] InnoDB: cannot enable encryption, encryption plugin is not available
      		 
      2021-02-09 18:35:21 0 [ERROR] Plugin 'InnoDB' init function returned error.
      		 
      2021-02-09 18:35:21 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      		 
      ^ Found warnings in /home/thiru/mariarepo/10.6/10.6-test/bld_sample-debug/mysql-test/var/log/mysqld.1.err
      		 
      ok
      		 
       
      		 
      encryption.innodb-checksum-algorithm '4k,cbc,innodb' w2 [ skipped ]  Test requires file_key_management plugin
      		 
      encryption.innodb-checksum-algorithm '8k,cbc,innodb' w4 [ skipped ]  Test requires file_key_management plugin
      		 
      encryption.innochecksum '8k,cbc,innodb,strict_crc32' w6 [ skipped ]  Test requires file_key_management plugin
      		 
      encryption.innochecksum '16k,cbc,innodb,strict_full_crc32' w4 [ skipped ]  Test requires file_key_management plugin
      		 
      encryption.innochecksum '4k,cbc,innodb,strict_full_crc32' w6 [ skipped ]  Test requires file_key_management plugin

      It fails only in 10.6. I debugged further to understand what went wrong.

      mtr tool doesn't start the server with file_key_management.so. I used the verbose command to find out what went wrong.

      > Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/include/have_innodb.combinations
      		 
      > Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/suite/encryption/include/have_file_key_management_plugin.combinations
      		 
      > Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/include/innodb_page_size_small.combinations
      		 
      > Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/include/innodb_checksum_algorithm.combinations
      		 
       
      		 
      worker[1] > mysqld_start:  [' --innodb-checksum-algorithm=crc32', '--innodb-page-size=16K', '--skip-innodb-read-only-compressed', '--innodb', '--innodb-cmpmem', '--innodb-cmp-per-index', '--innodb-trx', '--innodb-locks', '--innodb-lock-waits', '--innodb-metrics', '--innodb-buffer-pool-stats', '--innodb-buffer-page', '--innodb-buffer-page-lru', '--innodb-sys-columns', '--innodb-sys-fields', '--innodb-sys-foreign', '--innodb-sys-foreign-cols', '--innodb-sys-indexes', '--innodb-sys-tables', '--innodb-sys-virtual ']

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          View 8 older comments
          elenst Elena Stepanova added a comment -

          It is not the same as the original problem(s). example_key_management plugin is a test plugin. It has been disabled in the FreeBSD port builds, so it's not there. Disabled not by us, by FreeBSD.

          elenst Elena Stepanova added a comment - It is not the same as the original problem(s). example_key_management plugin is a test plugin. It has been disabled in the FreeBSD port builds, so it's not there. Disabled not by us, by FreeBSD.
          serg Sergei Golubchik added a comment - - edited

          doesn't seem to happen anymore. Or, at least, it's totally masked by

          encryption.innodb-compressed-blob '8k,ctr,innodb' w1 [ fail ]  Found warnings/errors in server log file!
          		 
                  Test ended at 2022-10-21 15:02:59
          		 
          line
          		 
          2022-10-21 15:02:55 0 [ERROR] [FATAL] InnoDB: IO Error: 125 during async write of 1277952 bytes, for file 12, returned 0

          Please, reopen, if it'll start showing up again

          serg Sergei Golubchik added a comment - - edited doesn't seem to happen anymore. Or, at least, it's totally masked by encryption.innodb-compressed-blob '8k,ctr,innodb' w1 [ fail ] Found warnings/errors in server log file! Test ended at 2022-10-21 15:02:59 line 2022-10-21 15:02:55 0 [ERROR] [FATAL] InnoDB: IO Error: 125 during async write of 1277952 bytes, for file 12, returned 0 Please, reopen, if it'll start showing up again
          marko Marko Mäkelä added a comment -

          11.0 6cf776b68d2671bd78c012b8dd9f55623144652e

          		 
          mariabackup.xb_compressed_encrypted '8k,innodb' w14 [ fail ]
          		 
                  Test ended at 2023-11-13 22:59:11
          		 
           
          		 
          CURRENT_TEST: mariabackup.xb_compressed_encrypted
          		 
          mysqltest: At line 4: query 'CREATE TABLE t1(c1 INT, b VARCHAR(2400), index(b(100),c1))
          		 
          ENGINE=INNODB ROW_FORMAT=compressed ENCRYPTED=YES' failed: ER_UNKNOWN_STORAGE_ENGINE (1286): Unknown storage engine 'INNODB'

          https://buildbot.mariadb.org/#/builders/318/builds/18055

          This is the very first SQL statement in the test file:

          --source include/innodb_page_size_small.inc
          		 
          --source include/have_file_key_management.inc
          		 
           
          		 
          CREATE TABLE t1(c1 INT, b VARCHAR(2400), index(b(100),c1))
          		 
          ENGINE=INNODB ROW_FORMAT=compressed ENCRYPTED=YES;

          marko Marko Mäkelä added a comment - 11.0 6cf776b68d2671bd78c012b8dd9f55623144652e mariabackup.xb_compressed_encrypted '8k,innodb' w14 [ fail ] Test ended at 2023-11-13 22:59:11   CURRENT_TEST: mariabackup.xb_compressed_encrypted mysqltest: At line 4: query 'CREATE TABLE t1(c1 INT, b VARCHAR(2400), index(b(100),c1)) ENGINE=INNODB ROW_FORMAT=compressed ENCRYPTED=YES' failed: ER_UNKNOWN_STORAGE_ENGINE (1286): Unknown storage engine 'INNODB' https://buildbot.mariadb.org/#/builders/318/builds/18055 This is the very first SQL statement in the test file: --source include/innodb_page_size_small.inc --source include/have_file_key_management.inc   CREATE TABLE t1(c1 INT , b VARCHAR (2400), index (b(100),c1)) ENGINE=INNODB ROW_FORMAT=compressed ENCRYPTED=YES;
          marko Marko Mäkelä added a comment -

          The "Error: 125" (MDEV-29610) should not cause test failures anymore, after MDEV-27593 was fixed.

          marko Marko Mäkelä added a comment - The "Error: 125" ( MDEV-29610 ) should not cause test failures anymore, after MDEV-27593 was fixed.
          serg Sergei Golubchik added a comment -

          doesn't seem to happen anymore. Please, reopen, if it'll start showing up again

          serg Sergei Golubchik added a comment - doesn't seem to happen anymore. Please, reopen, if it'll start showing up again

          People

            serg Sergei Golubchik
            thiru Thirunarayanan Balathandayuthapani
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.