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

virtual int ha_innobase::truncate(): Assertion `!err' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      CREATE TEMPORARY TABLE t (c INT PRIMARY KEY);
      SET debug_dbug='+d,ib_create_table_fail_at_create_index';
      TRUNCATE TABLE t;
      

      Leads to:

      CS 13.2.0 c894d97781b54fbf074677c9d67f81cd60a162ac (Debug, Clang 22.1.8-20260621) Build 26/10/2026

      mariadbd: /test/13.1_dbg/storage/innobase/handler/ha_innodb.cc:14217: virtual int ha_innobase::truncate(): Assertion `!err' failed.
      

      CS 13.2.0 c894d97781b54fbf074677c9d67f81cd60a162ac (Debug, Clang 22.1.8-20260621) Build 26/10/2026

      Core was generated by `/test/MD261026-mariadb-13.2.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.
      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 3182386)]
      (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  0x00007d420544527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007d42054288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007d420542881b in __assert_fail_base (fmt=0x7d42055d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5c5d5d078c6e "!err", file=file@entry=0x5c5d5d1eb9e5 "/test/13.1_dbg/storage/innobase/handler/ha_innodb.cc", line=line@entry=14217, function=function@entry=0x5c5d5d1ee7dd "virtual int ha_innobase::truncate()") at ./assert/assert.c:96
      #6  0x00007d420543b517 in __assert_fail (assertion=0x5c5d5d078c6e "!err", file=0x5c5d5d1eb9e5 "/test/13.1_dbg/storage/innobase/handler/ha_innodb.cc", line=14217, function=0x5c5d5d1ee7dd "virtual int ha_innobase::truncate()")at ./assert/assert.c:105
      #7  0x00005c5d5c873a25 in ha_innobase::truncate (this=0x7540ec02b570)at /test/13.1_dbg/storage/innobase/handler/ha_innodb.cc:14217
      #8  0x00005c5d5c483e01 in handler::ha_truncate (this=0x7540ec02b570)at /test/13.1_dbg/sql/handler.cc:5931
      #9  0x00005c5d5c26fb3f in Sql_cmd_truncate_table::handler_truncate (this=0x7540ec01acb0, thd=0x7540ec000d60, table_ref=0x7540ec01a550, is_tmp_table=true) at /test/13.1_dbg/sql/sql_truncate.cc:252
      #10 0x00005c5d5c27048f in Sql_cmd_truncate_table::truncate_table (this=0x7540ec01acb0, thd=0x7540ec000d60, table_ref=0x7540ec01a550)at /test/13.1_dbg/sql/sql_truncate.cc:470
      #11 0x00005c5d5c2708a7 in Sql_cmd_truncate_table::execute (this=0x7540ec01acb0, thd=0x7540ec000d60)at /test/13.1_dbg/sql/sql_truncate.cc:604
      #12 0x00005c5d5c06a6c9 in mysql_execute_command (thd=0x7540ec000d60, is_called_from_prepared_stmt=false) at /test/13.1_dbg/sql/sql_parse.cc:5947
      #13 0x00005c5d5c05b718 in mysql_parse (thd=0x7540ec000d60, rawbuf=0x7540ec01a460 "TRUNCATE TABLE t", length=16, parser_state=0x7d420404d9c0) at /test/13.1_dbg/sql/sql_parse.cc:8005
      #14 0x00005c5d5c058ece in dispatch_command (command=COM_QUERY, thd=0x7540ec000d60, packet=0x7540ec00b691 "TRUNCATE TABLE t", packet_length=16, blocking=true) at /test/13.1_dbg/sql/sql_parse.cc:1903
      #15 0x00005c5d5c05c19a in do_command (thd=0x7540ec000d60, blocking=true)at /test/13.1_dbg/sql/sql_parse.cc:1437
      #16 0x00005c5d5c2370ce in do_handle_one_connection (connect=0x5c5d734b2f40, put_in_cache=true) at /test/13.1_dbg/sql/sql_connect.cc:1514
      #17 0x00005c5d5c236eb1 in handle_one_connection (arg=0x5c5d7344b8f0)at /test/13.1_dbg/sql/sql_connect.cc:1426
      #18 0x00007d420549cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #19 0x00007d4205529ecc 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  261026  6a063120d4d3d451bff3ea84b3ffbee288b33be8  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      CS  10.11  opt  261026  6a063120d4d3d451bff3ea84b3ffbee288b33be8  No bug found
      CS  11.4   dbg  261026  b6406d42c8e26be3d86a4a743180f6b415a4559b  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      CS  11.4   opt  261026  b6406d42c8e26be3d86a4a743180f6b415a4559b  No bug found
      CS  11.8   dbg  261026  274dd0d8d90bc773090d13303b8d5e36d2390241  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      CS  11.8   opt  261026  274dd0d8d90bc773090d13303b8d5e36d2390241  No bug found
      CS  12.3   dbg  261026  788a07c52132d9f42b6991e599510c62d1625c0f  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      CS  12.3   opt  261026  788a07c52132d9f42b6991e599510c62d1625c0f  No bug found
      CS  13.0   dbg  261026  620a4b5624222048fece7fe1789978ae0675cae2  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      CS  13.0   opt  261026  620a4b5624222048fece7fe1789978ae0675cae2  No bug found
      CS  13.2   dbg  261026  c894d97781b54fbf074677c9d67f81cd60a162ac  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      CS  13.2   opt  261026  c894d97781b54fbf074677c9d67f81cd60a162ac  No bug found
      ES  10.6   dbg  261026  45fbb1583d8cdcc7da5a123a844b3bf512f31c9d  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      ES  10.6   opt  261026  45fbb1583d8cdcc7da5a123a844b3bf512f31c9d  No bug found
      ES  11.4   dbg  261026  6b2ae48e6e2488060adfdd02a7114bb60d4d150c  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      ES  11.4   opt  261026  6b2ae48e6e2488060adfdd02a7114bb60d4d150c  No bug found
      ES  11.8   dbg  261026  6e6ba60bdc2b3f478513c5afa3faa062d8e73736  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      ES  11.8   opt  261026  6e6ba60bdc2b3f478513c5afa3faa062d8e73736  No bug found
      ES  12.3   dbg  261026  781803ca9943d806ecb4b3b3fb39264dfafe1cf0  !err|SIGABRT|ha_innobase::truncate|handler::ha_truncate|Sql_cmd_truncate_table::handler_truncate|Sql_cmd_truncate_table::truncate_table
      ES  12.3   opt  261026  781803ca9943d806ecb4b3b3fb39264dfafe1cf0  No bug found
      

      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 - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.15d
                  0.15d

                  Git Integration

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