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

Crash getByteOrder@SHA512 during restore of encrypted backup with FULLTEXT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • N/A
    • Backup
    • None

    Description

      I am getting following crash occasionally while restore encrypted backup with (empty) FULLTEXT index:

      161205 11:52:04 [01] Copying ./test/film_text.ibd to F:/git/mysql-test/var/tmp/backup/test/film_text.ibd
      161205 11:52:04 [01] ...done
      161205 11:52:04 [01] Copying ./test/fts_0000000000000014_000000000000001e_index_1.ibd to F:/git/mysql-test/var/tmp/backup/test/fts_0000000000000014_000000000000001e_index_1.ibd
      161205 11:52:04 [01] ...done
      161205 11:52:04 [01] Copying ./test/fts_0000000000000014_000000000000001e_index_2.ibd to F:/git/mysql-test/var/tmp/backup/test/fts_0000000000000014_000000000000001e_index_2.ibd
      161205 11:52:04 [01] ...done
      161205 11:52:04 [01] Copying ./test/fts_0000000000000014_000161205 11:52:04 [ERROR] mysqld got exception 0x80000003 ;
      ...
      xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
      ucrtbase.DLL!abort()
      xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
      xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
      xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
      xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
      xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
      xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
      KERNEL32.DLL!BaseThreadInitThunk()
      ntdll.dll!RtlInitializeExceptionChain()
      ntdll.dll!RtlInitializeExceptionChain()

      Mtr test below reproduces the problem (I added two more FULLTEXT indexes to increase chance of crash, but it crashes with single first index as well - just with smaller probability):

      .opt file:
      --plugin-load-add=$FILE_KEY_MANAGEMENT_SO
      --innodb_strict_mode
      --innodb_file_per_table
      --innodb-encrypt-log=ON
      --innodb-encryption-rotate-key-age=2
      --innodb-encryption-threads=4
      --innodb-tablespaces-encryption
      --innodb-encrypt-tables=FORCE
      --loose-file-key-management
      --loose-file-key-management-filename=$MYSQL_TEST_DIR/std_data/logkey.txt

      .test file:

      CREATE TABLE film_text (
      film_id SMALLINT NOT NULL,
      title VARCHAR(255) NOT NULL,
      description TEXT,
      PRIMARY KEY (film_id),
      FULLTEXT KEY idx_title_description (title,description),
      FULLTEXT KEY (description),
      FULLTEXT KEY (title)
      )ENGINE=InnoDB DEFAULT CHARSET=utf8;

      let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
      exec $XTRABACKUP --innobackupex --defaults-file=$MYSQLTEST_VARDIR/my.cnf --no-timestamp $targetdir;

      exec $XTRABACKUP --innobackupex --apply-log --rebuild-indexes --rebuild-threads=2 $targetdir;
      – source include/restart_and_restore.inc

      Attachments

        Activity

          People

            anikitin Andrii Nikitin (Inactive)
            anikitin Andrii Nikitin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.