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

Assertion `thd->transaction->stmt.ha_list == __null || trans == &thd->transaction->stmt' failed in int ha_commit_trans(THD*, bool)

    XMLWordPrintable

Details

    Description

      Replay using CLI. The issue could not be reproduced by MTR

      DROP TABLE mysql.gtid_slave_pos;
      CREATE TABLE t (a INT KEY,b INT) ENGINE=INNODB;
      UPDATE t SET a=b;
      CREATE EVENT t_p_event ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 SECOND ON COMPLETION PRESERVE DO INSERT INTO t SELECT 1,1;
      

      Leads to

      11.5.0 e0b6db2de779320855d90a82bf56da0414de2154 (Debug)

      Core was generated by `/test/MD110424-mariadb-11.5.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --sla'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x1536e914d700 (LWP 947444))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x000015370d210859 in __GI_abort () at abort.c:79
      #2  0x000015370d210729 in __assert_fail_base (fmt=0x15370d3a6588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x56518a44f650 "thd->transaction->stmt.ha_list == __null || trans == &thd->transaction->stmt", file=0x56518a44ed68 "/test/server_dbg/sql/handler.cc", line=1721, function=<optimized out>) at assert.c:92
      #3  0x000015370d221fd6 in __GI___assert_fail (assertion=assertion@entry=0x56518a44f650 "thd->transaction->stmt.ha_list == __null || trans == &thd->transaction->stmt", file=file@entry=0x56518a44ed68 "/test/server_dbg/sql/handler.cc", line=line@entry=1721, function=function@entry=0x56518a44f888 "int ha_commit_trans(THD*, bool)") at assert.c:101
      #4  0x0000565189913f1b in ha_commit_trans (thd=thd@entry=0x15368c000f88, all=all@entry=true) at /test/server_dbg/sql/handler.cc:1721
      #5  0x000056518957c5dc in THD::commit_whole_transaction_and_close_tables (this=this@entry=0x15368c000f88) at /test/server_dbg/sql/sql_class.cc:6321
      #6  0x0000565189af7e59 in Event_db_repository::create_event (this=<optimized out>, thd=thd@entry=0x15368c000f88, parse_data=parse_data@entry=0x15368c00b130, event_already_exists=event_already_exists@entry=0x1536e914bc9f) at /test/server_dbg/sql/event_db_repository.cc:751
      #7  0x000056518973ff47 in Events::create_event (thd=thd@entry=0x15368c000f88, parse_data=0x15368c00b130) at /test/server_dbg/sql/events.cc:371
      #8  0x00005651895ed5d6 in mysql_execute_command (thd=thd@entry=0x15368c000f88, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/server_dbg/sql/sql_parse.cc:5066
      #9  0x00005651895d6f66 in mysql_parse (thd=0x15368c000f88, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1536e914c7a0) at /test/server_dbg/sql/sql_parse.cc:7815
      #10 0x0000565189aae1b7 in Query_log_event::do_apply_event (this=<optimized out>, rgi=0x1536c00271a0, query_arg=0x1536c002df67 "CREATE DEFINER=`root`@`localhost` EVENT t_p_event ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY DO INSERT INTO t SELECT 1,1", q_len_arg=127) at /test/server_dbg/sql/sql_class.h:1604
      #11 0x0000565189aaeac7 in Query_log_event::do_apply_event (this=<optimized out>, rgi=<optimized out>) at /test/server_dbg/sql/log_event_server.cc:1504
      #12 0x0000565189a9ebb1 in Log_event::apply_event (this=this@entry=0x1536c002ddf8, rgi=rgi@entry=0x1536c00271a0) at /test/server_dbg/sql/log_event.cc:3917
      #13 0x00005651894ff960 in apply_event_and_update_pos_apply (ev=ev@entry=0x1536c002ddf8, thd=thd@entry=0x15368c000f88, rgi=rgi@entry=0x1536c00271a0, reason=reason@entry=0) at /test/server_dbg/sql/slave.cc:3918
      #14 0x000056518950a0bf in apply_event_and_update_pos_for_parallel (ev=ev@entry=0x1536c002ddf8, thd=thd@entry=0x15368c000f88, rgi=rgi@entry=0x1536c00271a0) at /test/server_dbg/sql/slave.cc:4125
      #15 0x0000565189804938 in rpt_handle_event (qev=qev@entry=0x1536c0027e08, rpt=rpt@entry=0x1536c00101a8) at /test/server_dbg/sql/rpl_parallel.cc:64
      #16 0x0000565189809774 in handle_rpl_parallel_thread (arg=arg@entry=0x1536c00101a8) at /test/server_dbg/sql/rpl_parallel.cc:1541
      #17 0x0000565189bdd626 in pfs_spawn_thread (arg=0x1536c0012f58) at /test/server_dbg/storage/perfschema/pfs.cc:2201
      #18 0x000015370d721609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #19 0x000015370d30d133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.5.25 (dbg), 10.6.18 (dbg), 10.11.8 (dbg), 11.0.6 (dbg), 11.1.4 (dbg), 11.2.4 (dbg), 11.3.2 (dbg), 11.4.2 (dbg), 11.5.0 (dbg)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.4.34 (dbg), 10.4.34 (opt), 10.5.25 (opt), 10.6.18 (opt), 10.11.8 (opt), 11.0.6 (opt), 11.1.4 (opt), 11.2.4 (opt), 11.3.2 (opt), 11.4.2 (opt), 11.5.0 (opt)

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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