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

"InnoDB: Tablespace id 4 encrypted but encryption service not available. Can't continue opening tablespace" on server restart when there are encrypted tables

Details

    Description

      • start server on a clean datadir with all default options and 

        --plugin-load-add=file_key_management.so --file_key_management_filename=/git/10.1/mysql-test/std_data/keys.txt  --innodb-encrypt-tables=ON

      • run CREATE TABLE t1 (i INT);
      • shutdown the server
      • start the server again, with the same opitons =>

      150419 19:42:42 [ERROR] InnoDB: Tablespace id 4 encrypted but encryption service not available. Can't continue opening tablespace.
      		 
       
      		 
      2015-04-19 19:42:42 7f54192db760  InnoDB: Assertion failure in thread 139999176406880 in file ha_innodb.cc line 21064
      		 
       
      		 
      #5  0x00007f5416eb83e0 in *__GI_abort () at abort.c:92
      		 
      #6  0x00007f5419bd3754 in ib_logf (level=IB_LOG_LEVEL_FATAL, format=0x7f541a2dd398 "Tablespace id %ld encrypted but encryption service not available. Can't continue opening tablespace.\n") at 10.1/storage/xtradb/handler/ha_innodb.cc:21064
      		 
      #7  0x00007f5419e1a360 in fil_read_first_page (data_file=15, one_read_already=0, flags=0x7ffc003ec728, space_id=0x7ffc003ec720, min_flushed_lsn=0x7ffc003ec718, max_flushed_lsn=0x7ffc003ec718, orig_space_id=4, crypt_data=0x7ffc003ec738) at 10.1/storage/xtradb/fil/fil0fil.cc:2041
      		 
      #8  0x00007f5419e1d64b in fil_open_single_table_tablespace (validate=true, fix_dict=true, id=4, flags=0, tablename=0x7f53fab6f778 "test/t1", path_in=0x0) at 10.1/storage/xtradb/fil/fil0fil.cc:3740
      		 
      #9  0x00007f5419df7c05 in dict_check_tablespaces_and_store_max_id (dict_check=DICT_CHECK_NONE_LOADED) at 10.1/storage/xtradb/dict/dict0load.cc:1171
      		 
      #10 0x00007f5419d1bcc8 in innobase_start_or_create_for_mysql () at 10.1/storage/xtradb/srv/srv0start.cc:2597
      		 
      #11 0x00007f5419bb6772 in innobase_init (p=0x7f541654f070) at 10.1/storage/xtradb/handler/ha_innodb.cc:4083
      		 
      #12 0x00007f5419a098b4 in ha_initialize_handlerton (plugin=0x7f541653c6e8) at 10.1/sql/handler.cc:512
      		 
      #13 0x00007f54197f1bd8 in plugin_initialize (tmp_root=0x7ffc003f0dd0, plugin=0x7f541653c6e8, argc=0x7f541aac5950, argv=0x7f541641e6a0, options_only=false) at 10.1/sql/sql_plugin.cc:1403
      		 
      #14 0x00007f54197f27aa in plugin_init (argc=0x7f541aac5950, argv=0x7f541641e6a0, flags=2) at 10.1/sql/sql_plugin.cc:1676
      		 
      #15 0x00007f5419714627 in init_server_components () at 10.1/sql/mysqld.cc:5041
      		 
      #16 0x00007f5419715768 in mysqld_main (argc=14, argv=0x7f541641e6a0) at 10.1/sql/mysqld.cc:5631
      		 
      #17 0x00007f541970b340 in main (argc=14, argv=0x7ffc003f1b18) at 10.1/sql/main.cc:25

      A variation of the same problem:
      Bootstrap cannot be run with encryption. If it is, the system InnoDB tables are created encrypted, and the server cannot start anymore.

      See also MDEV-8011 for another scenario causing the same error.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8011 Table encryption issues

          • Major - Major loss of function.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.