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

Assertion `argp[arg_no]->fixed()' failed in sp_head::execute_function

    XMLWordPrintable

Details

    • Bug
    • Status: In Review (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 13.2
    • 13.2
    • Triggers
    • Not for Release Notes
    • Q4/2026 Server Development

    Description

      CREATE TABLE t1 (a INT);
      CREATE FUNCTION f(r ROW(a INT)) RETURNS INT RETURN 1;
      CREATE TRIGGER tr BEFORE INSERT OR UPDATE ON t1 FOR EACH ROW DO f(OLD);
      INSERT INTO t1 VALUES (1);
      

      Leads to

      MDEV-34723 CS 13.2.0 89cc41d5c46e1e322148d861e2b13527a7dd6306 (Debug, Clang 18.1.3-11) Build 22/10/2026

      mariadbd: /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_head.cc:2039: bool sp_head::execute_function(THD *, Item **, uint, Field *, sp_rcontext **, Query_arena *): Assertion `argp[arg_no]->fixed()' failed.
      

      MDEV-34723 CS 13.2.0 89cc41d5c46e1e322148d861e2b13527a7dd6306 (Debug, Clang 18.1.3-11) Build 22/10/2026

      Core was generated by `/test/mtest/MDEV-34723/MD221026-mariadb-13.2.0-linux-x86_64-dbg/bin/mariadbd --'.
      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 2294884)]
      (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  0x00007ad14a24527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007ad14a2288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007ad14a22881b in __assert_fail_base (fmt=0x7ad14a3d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x57cf8dea5485 "argp[arg_no]->fixed()", file=file@entry=0x57cf8dea4b95 "/test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_head.cc", line=line@entry=2039, function=function@entry=0x57cf8dea549b "bool sp_head::execute_function(THD *, Item **, uint, Field *, sp_rcontext **, Query_arena *)")at ./assert/assert.c:96
      #6  0x00007ad14a23b517 in __assert_fail (assertion=0x57cf8dea5485 "argp[arg_no]->fixed()", file=0x57cf8dea4b95 "/test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_head.cc", line=2039, function=0x57cf8dea549b "bool sp_head::execute_function(THD *, Item **, uint, Field *, sp_rcontext **, Query_arena *)") at ./assert/assert.c:105
      #7  0x000057cf8cbe9ce8 in sp_head::execute_function (this=0x72d0140690b0, thd=0x72d014000d60, argp=0x72d014054a10, argcount=1, return_value_fld=0x72d014054d20, func_ctx=0x72d014054aa8, call_arena=0x72d014065ac0)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_head.cc:2039
      #8  0x000057cf8d1c45c0 in Item_sp::execute_impl (this=0x72d014054a40, thd=0x72d014000d60, args=0x72d014054a10, arg_count=1)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/item.cc:3179
      #9  0x000057cf8d1c3e84 in Item_sp::execute (this=0x72d014054a40, thd=0x72d014000d60, null_value=0x72d0140549f6, args=0x72d014054a10, arg_count=1)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/item.cc:3029
      #10 0x000057cf8d2575a8 in Item_func_sp::execute (this=0x72d014054980)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/item_func.cc:6791
      #11 0x000057cf8d262db5 in Item_func_sp::update_null_value (this=0x72d014054980)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/item_func.h:4437
      #12 0x000057cf8cb88f4d in Item_func::is_null (this=0x72d014054980)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/item_func.h:248
      #13 0x000057cf8d3e57b7 in mysql_do (thd=0x72d014000d60, values=@0x72d014054b30: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x72d014054b50, last = 0x72d014054b50, elements = 1}, <No data fields>})at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_do.cc:37
      #14 0x000057cf8cd23b38 in mysql_execute_command (thd=0x72d014000d60, is_called_from_prepared_stmt=false)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_parse.cc:4067
      #15 0x000057cf8cfffeb7 in sp_instr_stmt::exec_core (this=0x72d014054b70, thd=0x72d014000d60, nextp=0x7ad12428c428)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_instr.cc:1306
      #16 0x000057cf8cffd316 in sp_lex_keeper::reset_lex_and_exec_core (this=0x72d014054bb0, thd=0x72d014000d60, nextp=0x7ad12428c428, open_tables=false, instr=0x72d014054b70, rerun_the_same_instr=false)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_instr.cc:420
      #17 0x000057cf8cffdafc in sp_lex_keeper::validate_lex_and_exec_core (this=0x72d014054bb0, thd=0x72d014000d60, nextp=0x7ad12428c428, open_tables=false, instr=0x72d014054b70)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_instr.cc:624
      #18 0x000057cf8cfff129 in sp_instr_stmt::execute (this=0x72d014054b70, thd=0x72d014000d60, nextp=0x7ad12428c428)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_instr.cc:1208
      #19 0x000057cf8cbe6aec in sp_head::execute (this=0x72d014053400, thd=0x72d014000d60, merge_da_on_success=false)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_head.cc:1347
      #20 0x000057cf8cbe8a17 in sp_head::execute_trigger (this=0x72d014053400, thd=0x72d014000d60, db_name=0x72d014031838, table_name=0x72d014031848, grant_info=0x72d01405a5d8)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sp_head.cc:1863
      #21 0x000057cf8ce8181c in Table_triggers_list::process_triggers (this=0x72d01405a030, thd=0x72d014000d60, event=TRG_EVENT_INSERT, time_type=TRG_ACTION_BEFORE, old_row_is_record1=true, skip_row_indicator=0x7ad12428cf2f, fields_in_update_stmt=0x0)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_trigger.cc:2918
      #22 0x000057cf8cc5c5bd in fill_record_n_invoke_before_triggers (thd=0x72d014000d60, table=0x72d014029c20, ptr=0x72d014059d40, values=@0x72d01401b230: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x72d01401b2f0, last = 0x72d01401b2f0, elements = 1}, <No data fields>}, ignore_errors=false, event=TRG_EVENT_INSERT, skip_row_indicator=0x7ad12428cf2f)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_base.cc:9946
      #23 0x000057cf8ccb4734 in mysql_insert (thd=0x72d014000d60, table_list=0x72d01401a5d0, fields=@0x72d0140062d0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x57cf8ebc6da0 <end_of_list>, last = 0x72d0140062d0, elements = 0}, <No data fields>}, values_list=@0x72d014006318: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x72d01401b300, last = 0x72d01401b300, elements = 1}, <No data fields>}, update_fields=@0x72d014006300: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x57cf8ebc6da0 <end_of_list>, last = 0x72d014006300, elements = 0}, <No data fields>}, update_values=@0x72d0140062e8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x57cf8ebc6da0 <end_of_list>, last = 0x72d0140062e8, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_insert.cc:1193
      #24 0x000057cf8cd25f3b in mysql_execute_command (thd=0x72d014000d60, is_called_from_prepared_stmt=false)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_parse.cc:4549
      #25 0x000057cf8cd1ba84 in mysql_parse (thd=0x72d014000d60, rawbuf=0x72d01401a4d0 "INSERT INTO t1 VALUES (1)", length=25, parser_state=0x7ad12428ea80)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_parse.cc:8005
      #26 0x000057cf8cd18e4d in dispatch_command (command=COM_QUERY, thd=0x72d014000d60, packet=0x72d01400b701 "INSERT INTO t1 VALUES (1)", packet_length=25, blocking=true)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_parse.cc:1903
      #27 0x000057cf8cd1c633 in do_command (thd=0x72d014000d60, blocking=true)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_parse.cc:1437
      #28 0x000057cf8cf22d29 in do_handle_one_connection (connect=0x57cfa75e83b0, put_in_cache=true)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_connect.cc:1514
      #29 0x000057cf8cf22ace in handle_one_connection (arg=0x57cfa76d1be0)at /test/mtest/MDEV-34723/bb-MDEV-34723-rucha_dbg/sql/sql_connect.cc:1426
      #30 0x00007ad14a29cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #31 0x00007ad14a329ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Attachments

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              ramesh Ramesh Sivaraman
              Rucha Deodhar Rucha Deodhar
              Dmitry Shulga Dmitry Shulga
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

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

                  Git Integration

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