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

Assertion `*type >= TRX_UNDO_RENAME_TABLE' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

        --source include/have_innodb.inc
        --source include/have_sequence.inc
        --source include/have_debug.inc
        CREATE TABLE t1 (a INT PRIMARY KEY, b INT, KEY(b)) ENGINE=InnoDB STATS_PERSISTENT=0;
        CREATE TABLE t2 (a INT PRIMARY KEY, c VARBINARY(4000)) ENGINE=InnoDB STATS_PERSISTENT=0;
        INSERT INTO t1 VALUES (1,1),(2,2);
        INSERT INTO t2 SELECT seq, REPEAT(x'0808', 2000) FROM seq_1_to_12;
        UPDATE t1 SET b=b+1;
        --connect con1,localhost,root
        BEGIN;
        UPDATE t1 SET b=b+1;
        --connection default
        SET GLOBAL innodb_max_purge_lag_wait=0;
        UPDATE t2 SET c='x' WHERE a<=4;
        UPDATE t2 SET c='x' WHERE a BETWEEN 5 AND 8;
        UPDATE t2 SET c='x' WHERE a>8;
        --let $shutdown_timeout= 0
        --let $restart_parameters= --innodb-log-recovery-target=18446744073709551615
        --source include/restart_mysqld.inc
        --disconnect con1
        CHECK TABLE t1 EXTENDED;
        --let $shutdown_timeout=
        --let $restart_parameters=
        --source include/restart_mysqld.inc
        DROP TABLE t1, t2;
      

      Leads to:

      INFO: no cores found at data*/core nor at node*/core, and no *SAN or Valgrind report found in the error log

      CS 13.0.2 620a4b5624222048fece7fe1789978ae0675cae2 (Debug, Clang 22.1.8-20260621) Build 25/09/2026

      mariadbd: /test/13.0_dbg/storage/innobase/trx/trx0rec.cc:515: const byte *trx_undo_rec_get_pars(const trx_undo_rec_t *, byte *, byte *, bool *, undo_no_t *, table_id_t *): Assertion `*type >= TRX_UNDO_RENAME_TABLE' failed.
      

      CS 13.0.2 620a4b5624222048fece7fe1789978ae0675cae2 (Debug, Clang 22.1.8-20260621) Build 25/09/2026

      Core was generated by `/test/MD250926-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 3649951)]
      (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  0x00007a367a04527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007a367a0288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007a367a02881b in __assert_fail_base (fmt=0x7a367a1d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x59fd4eceac69 "*type >= TRX_UNDO_RENAME_TABLE", file=file@entry=0x59fd4eceac3a "/test/13.0_dbg/storage/innobase/trx/trx0rec.cc", line=line@entry=515, function=function@entry=0x59fd4eceac88 "const byte *trx_undo_rec_get_pars(const trx_undo_rec_t *, byte *, byte *, bool *, undo_no_t *, table_id_t *)")at ./assert/assert.c:96
      #6  0x00007a367a03b517 in __assert_fail (assertion=0x59fd4eceac69 "*type >= TRX_UNDO_RENAME_TABLE", file=0x59fd4eceac3a "/test/13.0_dbg/storage/innobase/trx/trx0rec.cc", line=515, function=0x59fd4eceac88 "const byte *trx_undo_rec_get_pars(const trx_undo_rec_t *, byte *, byte *, bool *, undo_no_t *, table_id_t *)")at ./assert/assert.c:105
      #7  0x000059fd4e5be40c in trx_undo_rec_get_pars (undo_rec=0x7236540ac110 '\b' <repeats 200 times>..., type=0x7a3678429697 "\bp\227Bx6z", cmpl_info=0x7a3678429696 "", updated_extern=0x7a3678429695, undo_no=0x7a3678429688, table_id=0x7a3678429680)at /test/13.0_dbg/storage/innobase/trx/trx0rec.cc:515
      #8  0x000059fd4e5c6ab0 in trx_undo_prev_version (rec=0x72359002af4e "\200", index=0x59fd7c092d68, offsets=0x7235900082a8, heap=0x72359002b280, old_vers=0x7a3678429c58, check=@0x7a3678429770: {latch = purge_sys_t::view_guard::END_VIEW}, v_status=0, v_heap=0x0, vrow=0x0, undo_rec=0x7236540ac110 '\b' <repeats 200 times>...)at /test/13.0_dbg/storage/innobase/trx/trx0rec.cc:2221
      #9  0x000059fd4e5c66d3 in trx_undo_prev_version_build (rec=0x72359002af4e "\200", index=0x59fd7c092d68, offsets=0x7235900082a8, heap=0x72359002b280, old_vers=0x7a3678429c58, mtr=0x7a367842a498, v_status=0, v_heap=0x0, vrow=0x0)at /test/13.0_dbg/storage/innobase/trx/trx0rec.cc:2198
      #10 0x000059fd4e56bc0c in row_check_index (prebuilt=0x7235900298e8, n_rows=0x7a367842a8e8)at /test/13.0_dbg/storage/innobase/row/row0sel.cc:6632
      #11 0x000059fd4e344c20 in ha_innobase::check (this=0x723590032e10, thd=0x723590000d60, check_opt=0x723590006638)at /test/13.0_dbg/storage/innobase/handler/ha_innodb.cc:15573
      #12 0x000059fd4df5fbb9 in handler::ha_check (this=0x723590032e10, thd=0x723590000d60, check_opt=0x723590006638)at /test/13.0_dbg/sql/handler.cc:5757
      #13 0x000059fd4dd32c3a in mysql_admin_table (thd=0x723590000d60, tables=0x7235900195b0, check_opt=0x723590006638, operator_name=0x59fd4f433cd8 <msg_check>, lock_type=TL_READ_NO_INSERT, org_open_for_modify=false, no_errors_from_open=false, extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(class handler * const, class THD *, HA_CHECK_OPT *)) 0x59fd4df5fa20 <handler::ha_check(THD*, st_ha_check_opt*)>, view_operator_func=0x59fd4dcae700 <view_check(THD*, TABLE_LIST*, st_ha_check_opt*)>, is_cmd_replicated=false) at /test/13.0_dbg/sql/sql_admin.cc:949
      #14 0x000059fd4dd356b3 in Sql_cmd_check_table::execute (this=0x723590019d00, thd=0x723590000d60) at /test/13.0_dbg/sql/sql_admin.cc:1702
      #15 0x000059fd4db56974 in mysql_execute_command (thd=0x723590000d60, is_called_from_prepared_stmt=false) at /test/13.0_dbg/sql/sql_parse.cc:5892
      #16 0x000059fd4db47ba8 in mysql_parse (thd=0x723590000d60, rawbuf=0x7235900194c0 "CHECK TABLE t1 EXTENDED", length=23, parser_state=0x7a367842d9f0) at /test/13.0_dbg/sql/sql_parse.cc:7930
      #17 0x000059fd4db4538e in dispatch_command (command=COM_QUERY, thd=0x723590000d60, packet=0x72359000b6d1 "", packet_length=23, blocking=true) at /test/13.0_dbg/sql/sql_parse.cc:1903
      #18 0x000059fd4db4862a in do_command (thd=0x723590000d60, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1437
      #19 0x000059fd4dd1b20e in do_handle_one_connection (connect=0x59fd7c1c4100, put_in_cache=true) at /test/13.0_dbg/sql/sql_connect.cc:1514
      #20 0x000059fd4dd1aff1 in handle_one_connection (arg=0x59fd7c1c4100)at /test/13.0_dbg/sql/sql_connect.cc:1426
      #21 0x00007a367a09cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #22 0x00007a367a129ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.11  dbg  250926  307a82c97316ea0ed3fde318d19c0770ab898d89  No bug found                  
      CS  10.11  opt  250926  307a82c97316ea0ed3fde318d19c0770ab898d89  Assert: no error log(s) found - exiting
      CS  11.4   dbg  250926  511d7527eb356aab52fa183456333c5ba9741bcf  No bug found                  
      CS  11.4   opt  250926  511d7527eb356aab52fa183456333c5ba9741bcf  Assert: no error log(s) found - exiting
      CS  11.8   dbg  250926  e87b958d2e411af8e088d1716f99d06534e932f3  No bug found                  
      CS  11.8   opt  250926  e87b958d2e411af8e088d1716f99d06534e932f3  Assert: no error log(s) found - exiting
      CS  12.3   dbg  250926  881b64e8add374802e1871814dd0a3a673a9b3e6  No bug found                  
      CS  12.3   opt  250926  881b64e8add374802e1871814dd0a3a673a9b3e6  Assert: no error log(s) found - exiting
      CS  13.0   dbg  250926  620a4b5624222048fece7fe1789978ae0675cae2  *type >= TRX_UNDO_RENAME_TABLE|SIGABRT|trx_undo_rec_get_pars|trx_undo_prev_version|trx_undo_prev_version_build|row_check_index
      CS  13.0   opt  250926  620a4b5624222048fece7fe1789978ae0675cae2  Assert: no error log(s) found - exiting
      CS  13.2   dbg  250926  45717ef4c736a6a92e0acf49399ce677bfcaea89  *type >= TRX_UNDO_RENAME_TABLE|SIGABRT|trx_undo_rec_get_pars|trx_undo_prev_version|trx_undo_prev_version_build|row_check_index
      CS  13.2   opt  250926  45717ef4c736a6a92e0acf49399ce677bfcaea89  Assert: no error log(s) found - exiting
      ES  10.6   dbg  250926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  No bug found                  
      ES  10.6   opt  250926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  Assert: no error log(s) found - exiting
      ES  11.4   dbg  250926  5fa1ee1c7342644dda74ff137ff55c4df79939cf  No bug found                  
      ES  11.4   opt  250926  5fa1ee1c7342644dda74ff137ff55c4df79939cf  Assert: no error log(s) found - exiting
      ES  11.8   dbg  250926  1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61  No bug found                  
      ES  11.8   opt  250926  1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61  Assert: no error log(s) found - exiting
      ES  12.3   dbg  250926  f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d  No bug found                  
      ES  12.3   opt  250926  f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d  Assert: no error log(s) found - exiting
      

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              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 - 2.2h
                  2.2h

                  Git Integration

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