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

mariabackup: error: The log was only applied up to LSN 6960795, instead of 6960845

    XMLWordPrintable

Details

    • Can result in data loss

    Description

      Seeing mariabackup error during incremental backup (prepare phase) on MDEV-37949 branch
      Please check if this issue is related to developement branch or else we can treat this as a seperate issue .

      origin/MDEV-37949 e4549fe1fe4e961d4c71b5fa30e79dacc4e8b5a6

      # 2026-03-30T08:15:25 [2181718] | [00] 2026-03-30 08:15:25 mariabackup: error: The log was only applied up to LSN 6960795, instead of 6960845
      

      Steps to repro

      cd /tmp/repro_crash
       
      # Cleanup
      rm -rf backup_*
       
      # Copy backups (0 → 10)
      for i in {0..10}; do
        cp -r /data/results/1774850766/TBR-2398/1/backup_before_prepare_$i ./backup_$i
      done
       
      # Step 1: Prepare full backup
      /Server_bin/MDEV-37949D_debug_Og/bin/mariadb-backup \
        --prepare --target-dir=./backup_0
       
      # Step 2+: Apply incrementals (expected error here)
      for i in {1..10}; do
        echo "👉 Applying incremental $i"
        /Server_bin/MDEV-37949D_debug_Og/bin/mariadb-backup \
          --prepare --target-dir=./backup_0 --incremental-dir=./backup_$i
      done
      
      

      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_dml.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=--lock-wait-timeout=15 \
      # --mysqld=--innodb-lock-wait-timeout=10 \
      # --mysqld=--sql_mode=traditional \
      # --mysqld=--innodb_file_per_table=1 \
      # --mysqld=--loose-innodb_read_only_compressed=OFF \
      # --mysqld=--loose-innodb-sync-debug \
      # --mysqld=--innodb_stats_persistent=off \
      # --mysqld=--innodb_adaptive_hash_index=on \
      # --mysqld=--innodb_random_read_ahead=ON \
      # --mysqld=--innodb_read_ahead_threshold=0 \
      # --mysqld=--log-bin \
      # --mysqld=--sync-binlog=1 \
      # --mysqld=--loose-innodb_evict_tables_on_commit_debug=off \
      # --mysqld=--loose-max-statement-time=30 \
      # --threads=1 \
      # --rr=Extended \
      # --rr_options=--wait \
      # --mysqld=--innodb_undo_log_truncate=OFF \
      # --mysqld=--innodb_undo_tablespaces=16 \
      # --mysqld=--innodb_rollback_on_timeout=OFF \
      # --mysqld=--innodb_page_size=16K \
      # --mysqld=--innodb-buffer-pool-size=8M \
      # --vardir_type=fast \
      # --no_mask \
      # --batch \
      # --basedir1=/Server_bin/MDEV-37949D_debug_Og \
      # --basedir2=/Server_bin/MDEV-37949D_debug_Og \
      # --script_debug=_nix_ \
      # --major_runid=1774850766 \
      # --minor_runid=147
      

      RR trace is present on SDP:-
      /data/results/1774850766/TBR-2398/1/rr_prepare_10

      Attachments

        Issue Links

          Activity

            People

              saahil Saahil Alam
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.