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

InnoDB: Failing assertion: key_version != ENCRYPTION_KEY_VERSION_INVALID

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      Assertion during prepare in incremental backup

      origin/10.11 fb42ef5a7fe6f898ac9f96e13491503bea0f2061

      # 2026-03-25T10:36:23 [3327730] | 2026-03-25 10:36:10 0 [ERROR] InnoDB: Unable to apply log to corrupted page 3 in file cool_down/t5.ibd
      # 2026-03-25T10:36:23 [3327730] | 2026-03-25 10:36:10 0 [Note] InnoDB: Set innodb_force_recovery=1 to ignore corrupted pages.
      # 2026-03-25T10:36:23 [3327730] | [00] 2026-03-25 10:36:10 mariadb-backup: srv_start() returned 37 (Data structure corruption).
      # 2026-03-25T10:36:23 [3327730] | ^G/Server_bin/10.11K_debug_Og/bin/mariadb-backup: Warning: 0 files and 3 streams is left open
      # 2026-03-25T10:36:23 [3327730] | 
      # 2026-03-25T10:36:23 [3327730] | 2026-03-25 10:36:10 0x75fc31e006c0  InnoDB: Assertion failure in file /data/Server/10.11K/storage/innobase/fil/fil0crypt.cc line 521
      # 2026-03-25T10:36:23 [3327730] | InnoDB: Failing assertion: key_version != ENCRYPTION_KEY_VERSION_INVALID
      

      Steps to repro

      cd /tmp/repro_crash
      rm -rf *
       
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_0  ./backup_0
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_1  ./backup_1
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_2  ./backup_2
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_3  ./backup_3
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_4  ./backup_4
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_5  ./backup_5
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_6  ./backup_6
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_7  ./backup_7
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_8  ./backup_8
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_9  ./backup_9
      cp -r /data/results/1774444031/TBR-2396/1/backup_before_prepare_10 ./backup_10
       
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0
       
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_1
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_2
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_3
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_4
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_5
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_6
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_7
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_8
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_9
      /Server_bin/10.11K_debug_Og/bin/mariadb-backup --prepare --target-dir=/tmp/repro_crash/backup_0 --incremental-dir=/tmp/repro_crash/backup_10
      
      

      RQG startup options

       # $RQG_HOME/rqg.pl \
      # --gendata=conf/mariadb/table_stress.zz \
      # --gendata_sql=conf/mariadb/table_stress.sql \
      # --grammar=conf/mariadb/table_stress_innodb_nocopy1.yy \
      # --reporters=MariabackupIncremental_linux \
      # --mysqld=--loose-innodb-log-file-size=300M \
      # --mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \
      # --mysqld=--loose-idle_write_transaction_timeout=0 \
      # --mysqld=--loose-idle_transaction_timeout=0 \
      # --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      # --mysqld=--connect_timeout=60 \
      # --mysqld=--interactive_timeout=28800 \
      # --mysqld=--slave_net_timeout=60 \
      # --mysqld=--net_read_timeout=30 \
      # --mysqld=--net_write_timeout=60 \
      # --mysqld=--loose-table_lock_wait_timeout=50 \
      # --mysqld=--wait_timeout=28800 \
      # --no_mask \
      # --queries=10000000 \
      # --seed=random \
      # --reporters=None \
      # --reporters=ErrorLog \
      # --reporters=Deadlock \
      # --validators=None \
      # --mysqld=--log_output=none \
      # --mysqld=--log_bin_trust_function_creators=1 \
      # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      # --engine=InnoDB \
      # --restart_timeout=240 \
      # --mysqld=--plugin-load-add=file_key_management.so \
      # --mysqld=--loose-file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \
      # --mysqld=--plugin-load-add=provider_lzo.so \
      # --mysqld=--plugin-load-add=provider_bzip2.so \
      # --mysqld=--plugin-load-add=provider_lzma.so \
      # --mysqld=--plugin-load-add=provider_snappy.so \
      # --mysqld=--plugin-load-add=provider_lz4.so \
      # --mysqld=--loose-innodb_compression_level=1 \
      # --duration=300 \
      # --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
      # --mysqld=--loose-innodb_data_file_path=ibdata1:1M:autoextend:autoshrink \
      # --mysqld=--lock-wait-timeout=86400 \
      # --mysqld=--innodb-lock-wait-timeout=50 \
      # --mysqld=--loose-innodb_fast_shutdown=0 \
      # --mysqld=--sql_mode=traditional \
      # --mysqld=--loose-innodb_read_only_compressed=OFF \
      # --mysqld=--loose-innodb-sync-debug \
      # --mysqld=--innodb_stats_persistent=on \
      # --mysqld=--innodb_adaptive_hash_index=off \
      # --mysqld=--innodb_sort_buffer_size=65536 \
      # --mysqld=--innodb_random_read_ahead=OFF \
      # --mysqld=--innodb-open-files=10 \
      # --mysqld=--log-bin \
      # --mysqld=--sync-binlog=1 \
      # --mysqld=--loose-innodb_evict_tables_on_commit_debug=on \
      # --mysqld=--loose-max-statement-time=30 \
      # --threads=3 \
      # --rr=Extended \
      # --rr_options=--wait \
      # --mysqld=--innodb_undo_log_truncate=OFF \
      # --mysqld=--innodb_undo_tablespaces=3 \
      # --mysqld=--innodb_rollback_on_timeout=OFF \
      # --mysqld=--innodb_page_size=64K \
      # --mysqld=--innodb-buffer-pool-size=29M \
      # --vardir_type=slow \
      # --no_mask \
      # --batch \
      # --basedir1=/Server_bin/10.11K_debug_Og \
      # --basedir2=/Server_bin/10.11K_debug_Og \
      # --script_debug=_nix_ \
      # --major_runid=1774444031 \
      # --minor_runid=29
      #--------
      # rqg_rr_add="--innodb-use-native-aio=0" "--loose-innodb-write-io-threads=2" "--loose-innodb-read-io-threads=1" "--loose-gdb" "--loose-debug-gdb" "--innodb_flush_method=fsync"
      # vardir=/data/rqg/1774444031/29 fs_type=ext4
      

      Log files are present on SDP:-
      /data/results/1774444031/TBR-2396

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.