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

trans_rollback_stmt(THD *): Assertion `! thd->in_sub_stmt' failed.

    XMLWordPrintable

Details

    • Can result in unexpected behaviour
    • Q4/2026 Server Maintenance

    Description

      Reproduce

      create table t0 (v1 datetime, v2 varbinary(6), v3 double, v4 mediumblob);
      create trigger trig_t0_insert after insert on t0 for each row binlog 'enabled';
      insert into t0 set v1 = default, v2 = 0x123456, v3 = 1.23, v4 = null on duplicate key update v1 = default, v2 = default, v3 = default;
      

      Result

      #13 __assert_fail (assertion=0x555555f52b26 "! thd->in_sub_stmt", file=0x555555e5ddad "../src/sql/transaction.cc", line=<optimized out>, function=<optimized out>) at ./assert/assert.c:37
      #14 0x0000555556cdcfa7 in trans_rollback_stmt (thd=0x7fffd4000d68) at ../src/sql/transaction.cc:555
      #15 0x0000555556cae025 in rpl_group_info::slave_close_thread_tables (this=0x7fffd41c1860, thd=0x7fffd4000d68) at ../src/sql/rpl_rli.cc:2420
      #16 0x0000555556c7dc24 in mysql_client_binlog_statement (thd=0x7fffd4000d68) at ../src/sql/sql_binlog.cc:467
      #17 0x0000555556ab2bee in mysql_execute_command (thd=0x7fffd4000d68, is_called_from_prepared_stmt=false) at ../src/sql/sql_parse.cc:5822
      #18 0x0000555556daf9d7 in sp_instr_stmt::exec_core (this=0x7fffd400cdc8, thd=0x7fffd4000d68, nextp=0x7ffff0d64118) at ../src/sql/sp_instr.cc:1194
      #19 0x0000555556dad2ee in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fffd400ce00, thd=0x7fffd4000d68, nextp=0x7ffff0d64118, open_tables=false, instr=0x7fffd400cdc8, rerun_the_same_instr=false) at ../src/sql/sp_instr.cc:350
      #20 0x0000555556dad9b1 in sp_lex_keeper::validate_lex_and_exec_core (this=0x7fffd400ce00, thd=0x7fffd4000d68, nextp=0x7ffff0d64118, open_tables=false, instr=0x7fffd400cdc8) at ../src/sql/sp_instr.cc:529
      #21 0x0000555556daecb8 in sp_instr_stmt::execute (this=0x7fffd400cdc8, thd=0x7fffd4000d68, nextp=0x7ffff0d64118) at ../src/sql/sp_instr.cc:1096
      #22 0x00005555568eb6b2 in sp_head::execute (this=0x7fffd400bd60, thd=0x7fffd4000d68, merge_da_on_success=false) at ../src/sql/sp_head.cc:1330
      #23 0x00005555568ecc9e in sp_head::execute_trigger (this=0x7fffd400bd60, thd=0x7fffd4000d68, db_name=0x7fffd403c218, table_name=0x7fffd403c228, grant_info=0x7fffd4040148) at ../src/sql/sp_head.cc:1843
      #24 0x0000555556c0ac39 in Table_triggers_list::process_triggers (this=0x7fffd403fc20, thd=0x7fffd4000d68, event=TRG_EVENT_INSERT, time_type=TRG_ACTION_AFTER, old_row_is_record1=true, skip_row_indicator=0x0, fields_in_update_stmt=0x0) at ../src/sql/sql_trigger.cc:2727
      #25 0x0000555556a67f31 in Write_record::after_ins_trg (this=0x7ffff0d64d10) at ../src/sql/sql_insert.cc:2536
      #26 0x0000555556a66a86 in Write_record::after_insert (this=0x7ffff0d64d10, inserted=0x7ffff0d647a0) at ../src/sql/sql_insert.cc:2528
      #27 0x0000555556a5b4f4 in Write_record::insert_on_duplicate_update (this=0x7ffff0d64d10, inserted=0x7ffff0d647a0, updated=0x7ffff0d64798) at ../src/sql/sql_insert.cc:2220
      #28 0x0000555556a597d9 in Write_record::write_record (this=0x7ffff0d64d10) at ../src/sql/sql_insert.cc:2422
      #29 0x0000555556a56c01 in mysql_insert (thd=0x7fffd4000d68, table_list=0x7fffd4016818, fields={...}, values_list={...}, update_fields={...}, update_values={...}, duplic=DUP_UPDATE, ignore=false, result=0x0) at ../src/sql/sql_insert.cc:1231
      #30 0x0000555556aaec46 in mysql_execute_command (thd=0x7fffd4000d68, is_called_from_prepared_stmt=false) at ../src/sql/sql_parse.cc:4511
      #31 0x0000555556aa6f0d in mysql_parse (thd=0x7fffd4000d68, rawbuf=0x7fffd4016660 "insert into t0 set v1 = default, v2 = 0x123456, v3 = 1.23, v4 = null on duplicate key update v1 = default, v2 = default, v3 = default", length=133, parser_state=0x7ffff0d670a8) at ../src/sql/sql_parse.cc:7938
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              yx yx
              Oleksandr Byelkin Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1h 28m Original Estimate - 1h 28m
                  1h 28m
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 3d 2h 40m
                  3d 2h 40m

                  Git Integration

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