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

exec_REDO_LOGREC_REDO_REPAIR_TABLE: Assertion `maria_tmpdir' failed

    XMLWordPrintable

Details

    • Can result in hang or crash
    • Hide
      Fixed bug in maria-backup where maria-backup would crash during the 'maria_recovery' part.
      This could happen if server was doing repair or creating indexes while the
      backup was running.
      Show
      Fixed bug in maria-backup where maria-backup would crash during the 'maria_recovery' part. This could happen if server was doing repair or creating indexes while the backup was running.

    Description

      Non-deterministically reproducible (once in a few attempts), needs a better test case

      randgen 7b7cc15dfc4a671ebcb6905a149a9043fdfe7029

      perl ./run.pl --compatibility=110499 --mysqld=--loose-aria_pagecache_segments=1 --vcols=STORED --variator=ExecuteAsView --variator=SelectOption --mysqld=--aria_recover_options=FORCE --mysqld=--strict_password_validation=OFF --mysqld=--explicit-defaults-for-timestamp=on --mysqld=--transaction-isolation=READ-COMMITTED --mysqld=--standard_compliant_cte=OFF --scenario=MariaBackupFull --grammar=conf/yy/information_schema.yy --grammar=conf/yy/optimizer_subquery_semijoin.yy --gendata=simple --grammar=conf/yy/bulk_insert.yy --grammar=conf/yy/all_selects.yy:0.0001 --mysqld=--character-set-server=cp1250 --mysqld=--collation-server=cp1250_croatian_ci --filter=conf/ff/restrict_dynamic_vars.ff --engine=Aria --mysqld=--default-storage-engine=Aria  --queries=1000000 --reporters=Backtrace,Deadlock,MemoryUsage,FeatureUsage --mysqld=--plugin-maturity=experimental --gendata=conf/zz/many_indexes.zz --gendata=advanced --duration=250 --mysqld=--max-statement-time=25 --mysqld=--lock-wait-timeout=12 --mysqld=--innodb-lock-wait-timeout=10 --threads=6 --base-port=14000 --basedir=/data/bld/11.4  --vardir=/dev/shm/var-rqg3 --seed=1747885645 --trials=10
      

      11.4 da5a4d05b9da58705498a42b6ffa5d9211f446af

      /data/bld/11.4/bin/mariabackup: Deprecated program name. It will be removed in a future release, use '/share8t/bld/11.4-asan-ubsan/extra/mariabackup/mariadb-backup' instead
      /data/bld/11.4/bin/mariabackup based on MariaDB server 11.4.6-MariaDB Linux (x86_64)
      [00] 2025-05-22 18:19:26 cd to /dev/shm/var-rqg3/trial.1/s1/backup_1/
      [00] 2025-05-22 18:19:26 open files limit requested 0, set to 1024
      [00] 2025-05-22 18:19:26 This target seems to be not prepared yet.
      [00] 2025-05-22 18:19:26 mariabackup: using the following InnoDB configuration for recovery:
      [00] 2025-05-22 18:19:26 innodb_data_home_dir = .
      [00] 2025-05-22 18:19:26 innodb_data_file_path = ibdata1:12M:autoextend
      [00] 2025-05-22 18:19:26 innodb_log_group_home_dir = .
      [00] 2025-05-22 18:19:26 InnoDB: Using liburing
      [00] 2025-05-22 18:19:26 Starting InnoDB instance for recovery.
      [00] 2025-05-22 18:19:26 mariabackup: Using 268435456 bytes for buffer pool (set by --use-memory parameter)
      2025-05-22 18:19:27 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
      2025-05-22 18:19:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
      2025-05-22 18:19:27 0 [Note] InnoDB: Number of transaction pools: 1
      2025-05-22 18:19:27 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2025-05-22 18:19:27 0 [Note] InnoDB: Using liburing
      2025-05-22 18:19:27 0 [Note] InnoDB: innodb_buffer_pool_size_max=256m, innodb_buffer_pool_size=256m
      2025-05-22 18:19:27 0 [Note] InnoDB: Completed initialization of buffer pool
      2025-05-22 18:19:27 0 [Note] InnoDB: Memory-mapped log (block size=512 bytes)
      2025-05-22 18:19:27 0 [Note] InnoDB: End of log at LSN=59759
      2025-05-22 18:19:27 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
      [00] 2025-05-22 18:19:27 Last binlog file , position 0
      recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80%mariabackup: /data/bld/11.4-asan-ubsan/storage/maria/ma_recovery.c:1213: exec_REDO_LOGREC_REDO_REPAIR_TABLE: Assertion `maria_tmpdir' failed.
      250522 18:19:44 [ERROR] /data/bld/11.4/bin/mariabackup got signal 6 ;
      Sorry, we probably made a mistake, and this is a bug.
       
      Your assistance in bug reporting will enable us to fix this for the next release.
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
      a bug on https://jira.mariadb.org/.
       
      Please include the information from the server start above, to the end of the
      information below.
       
      Server version: 11.4.6-MariaDB-asan-debug source revision: da5a4d05b9da58705498a42b6ffa5d9211f446af
       
      The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
      contains instructions to obtain a better version of the backtrace below.
      Following these instructions will help MariaDB developers provide a fix quicker.
       
      Attempting backtrace. Include this in the bug report.
      (note: Retrieving this information may fail)
       
      Thread pointer: 0x0
      stack_bottom = 0x0 thread_stack 0xb00000
      sanitizer_common/sanitizer_common_interceptors.inc:4277(__interceptor_backtrace.part.0)[0x7f8206c51f31]
      mysys/stacktrace.c:215(my_print_stacktrace)[0x55c8c2137ab3]
      sql/signal_handler.cc:227(handle_fatal_signal)[0x55c8c01a1e29]
      libc_sigaction.c:0(__restore_rt)[0x7f820585b050]
      nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7f82058a9ebc]
      posix/raise.c:27(__GI_raise)[0x7f820585afb2]
      stdlib/abort.c:81(__GI_abort)[0x7f8205845472]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f8205845395]
      /lib/x86_64-linux-gnu/libc.so.6(+0x34eb2)[0x7f8205853eb2]
      maria/ma_recovery.c:1215(exec_REDO_LOGREC_REDO_REPAIR_TABLE)[0x55c8c0ca0ee6]
      maria/ma_recovery.c:606(display_and_apply_record)[0x55c8c0c9569a]
      maria/ma_recovery.c:2787(run_redo_phase)[0x55c8c0ca2a27]
      maria/ma_recovery.c:353(maria_apply_log)[0x55c8c0cadcad]
      maria/ma_recovery.c:240(maria_recovery_from_log)[0x55c8c0caed05]
      mariabackup/aria_backup_client.cc:1002(aria::prepare(char const*))[0x55c8be466516]
      mariabackup/xtrabackup.cc:6997(xtrabackup_prepare_func(char**))[0x55c8be372428]
      mariabackup/xtrabackup.cc:7823(main_low(char**))[0x55c8be37c0b8]
      mariabackup/xtrabackup.cc:7617(main)[0x55c8be37c69c]
      x86/libc-start.c:74(__libc_start_call_main)[0x7f820584624a]
      csu/libc-start.c:128(call_init)[0x7f8205846305]
      /data/bld/11.4/bin/mariabackup(_start+0x21)[0x55c8be340b81]
      Writing a core file...
      Working directory at /dev/shm/var-rqg3/trial.1/s1/backup_1
      Resource Limits (excludes unlimited resources):
      Limit                     Soft Limit           Hard Limit           Units     
      Max stack size            8388608              unlimited            bytes     
      Max core file size        0                    unlimited            bytes     
      Max processes             514196               514196               processes 
      Max open files            1024                 1048576              files     
      Max locked memory         16854077440          16854077440          bytes     
      Max pending signals       514196               514196               signals   
      Max msgqueue size         819200               819200               bytes     
      Max nice priority         0                    0                    
      Max realtime priority     0                    0                    
      Core pattern: core
       
      Kernel version: Linux version 6.1.0-27-amd64 (debian-kernel@lists.debian.org) (gcc-12 (Debian 12.2.0-14) 12.2.0, GNU ld (GNU Binutils for Debian) 2.40) #1 SMP PREEMPT_DYNAMIC Debian 6.1.115-1 (2024-11-01)
      

      The non-deterministic part is creating a backup. Once the "right" one is created, prepare fails apparently deterministically.

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            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.