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

After upgrade to 10.7.3-1 with enabled data-at-rest encryption unable to restore dump file.

Details

    Description

      After an upgrade from 10.6.7 to 10.7.3 we have attempted to export and import a dump. This fails on import with errors like "ERROR 2013 (HY000) at line 13654: Lost connection to server during query". The mariadb crashed on import (error log attached). We than upgraded to 10.7.4 and the import fails too.

      This issue has only manifested with data-at-rest encryption enabled and key checks settings in dump file on an table with more than 58254 table rows (example dump attached).

      Data at rest encryption was enabled with:

      File Key Management

      plugin_load_add = file_key_management
      file_key_management_filename = /etc/mysql/enc/keys.enc
      file_key_management_filekey = FILE:/etc/mysql/enc/.key
      file_key_management_encryption_algorithm = aes_cbc

      InnoDB/XtraDB Encryption

      encrypt_binlog            = ON
      encrypt_tmp_disk_tables   = ON
      encrypt_tmp_files         = ON
      innodb_encrypt_log        = ON
      innodb_encrypt_tables     = ON
      innodb_encryption_threads = 2

      Attachments

        1. crash.sql
          502 kB
        2. error.log
          70 kB

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            1h 7m 1
            Thirunarayanan Balathandayuthapani made transition -
            Confirmed In Progress
            51d 22h 31m 1
            Thirunarayanan Balathandayuthapani made transition -
            In Progress In Review
            29s 1
            Marko Mäkelä made transition -
            In Review Stalled
            7d 3h 28m 1
            Thirunarayanan Balathandayuthapani made transition -
            Stalled Closed
            19h 11m 1

            People

              thiru Thirunarayanan Balathandayuthapani
              cmaehler Christopher Mähler
              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.