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

binlog_storage_engine=innodb conflicts with innodb_log_recovery_target

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      --source include/have_innodb_binlog.inc
      --source include/not_valgrind.inc
      CREATE TABLE t(a INT) ENGINE=InnoDB;
      INSERT INTO t VALUES (1);
      --let $lsn=`SELECT variable_value FROM information_schema.global_status WHERE variable_name='innodb_lsn_current'`
      --source include/kill_mysqld.inc
      --let $restart_parameters=--innodb-log-recovery-target=$lsn
      --source include/start_mysqld.inc
      SELECT @@binlog_storage_engine;
      SELECT * FROM t;
      --let $restart_parameters=
      --source include/restart_mysqld.inc
      DROP TABLE t;
      

      Leads to:

      CS 13.0.2 b2c4e675049e23ce8c7346985f40840fcd4e583f (Debug, Clang 22.1.8-20260621) Build 09/09/2026

      mariadbd: /test/13.0_dbg/storage/innobase/mtr/mtr0mtr.cc:552: void mtr_t::commit(): Assertion `!recv_sys.rpo' failed.
      

      CS 13.0.2 b2c4e675049e23ce8c7346985f40840fcd4e583f (Debug, Clang 22.1.8-20260621) Build 09/09/2026

      Core was generated by `/test/MD090926-mariadb-13.0.2-linux-x86_64-dbg/bin/mariadbd --defaults-group-su'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 3865770)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x000078eaa7c4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x000078eaa7c288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000078eaa7c2881b in __assert_fail_base (fmt=0x78eaa7dd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6187193737ff "!recv_sys.rpo", file=file@entry=0x618719334d9c "/test/13.0_db
      g/storage/innobase/mtr/mtr0mtr.cc", line=line@entry=552, function=function@entry=0x6187193350ce "void mtr_t::commit()")at ./assert/assert.c:96
      #6  0x000078eaa7c3b517 in __assert_fail (assertion=0x6187193737ff "!recv_sys.rpo", file=0x618719334d9c "/test/13.0_dbg/storage/innobase/mtr/mtr0mtr.cc", line=552, function=0x6187193350ce "void mtr_t::commit()")at 
      ./assert/assert.c:105
      #7  0x0000618718ad1bb4 in mtr_t::commit (this=0x7ffde615dab8)at /test/13.0_dbg/storage/innobase/mtr/mtr0mtr.cc:552
      #8  0x0000618718a2e8bc in innobase_binlog_write_direct_ordered (cache=0x7ffde615dee0, binlog_info=0x7ffde615de90, gtid=0x0)at /test/13.0_dbg/storage/innobase/handler/innodb_binlog.cc:4455
      #9  0x0000618718764ed0 in MYSQL_BIN_LOG::open_engine (this=0x618719eb91b8 <mysql_bin_log>, hton=0x61873aa18ec0, max_size=262144, dir=0x0) at /test/13.0_dbg/sql/log.cc:5074
      #10 0x0000618718009456 in init_server_components ()at /test/13.0_dbg/sql/mysqld.cc:5834
      #11 0x000061871800546e in mysqld_main (argc=164, argv=0x61873a758cb0)at /test/13.0_dbg/sql/mysqld.cc:6258
      #12 0x00006187180026b2 in main (argc=27, argv=0x7ffde6160e98)at /test/13.0_dbg/sql/main.cc:34
      

      Attachments

        Issue Links

          Activity

            People

              knielsen Kristian Nielsen
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1.75h
                  1.75h

                  Git Integration

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