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

Assertion `m_thd == __null' failed in sp_head::~sp_head

    XMLWordPrintable

Details

    Description

      CREATE table t1 (i int);
      insert into t1 values (1),(2),(3);
       
      EXECUTE IMMEDIATE "CREATE PROCEDURE p1() SELECT 1 FROM t1  PROCEDURE ANALYSE( 10, (SELECT i FROM t1));";
      drop table t1;
      

      10.4 7955e197d0ceca3108bd0d7036edaff0d7e7a9cf

      Version: '10.4.11-MariaDB-debug' 
      /10.4/src/sql/sp_head.cc:803: virtual sp_head::~sp_head(): Assertion `m_thd == __null' failed.
      191128 17:38:08 [ERROR] mysqld got signal 6 ;
       
      linux/raise.c:54(__GI_raise)[0x7f1aad83c428]
      stdlib/abort.c:91(__GI_abort)[0x7f1aad83e02a]
      assert/assert.c:92(__assert_fail_base)[0x7f1aad834bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f1aad834c82]
      sql/sp_head.cc:805(sp_head::~sp_head())[0x556d9881e63e]
      sql/sp_head.cc:832(sp_head::~sp_head())[0x556d9881e810]
      sql/sql_lex.cc:819(lex_end_stage1(LEX*))[0x556d988dbc64]
      sql/sql_prepare.cc:4085(Prepared_statement::prepare(char const*, unsigned int))[0x556d9894295b]
      sql/sql_prepare.cc:4874(Prepared_statement::execute_immediate(char const*, unsigned int))[0x556d98944fc1]
      sql/sql_prepare.cc:2922(mysql_sql_stmt_execute_immediate(THD*))[0x556d9893f67c]
      sql/sql_parse.cc:3906(mysql_execute_command(THD*))[0x556d9891610d]
      sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556d98924b4b]
      sql/sql_parse.cc:1844(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556d9890fcf8]
      sql/sql_parse.cc:1360(do_command(THD*))[0x556d9890e359]
      sql/sql_connect.cc:1412(do_handle_one_connection(CONNECT*))[0x556d98a97e4d]
      sql/sql_connect.cc:1317(handle_one_connection)[0x556d98a97b76]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f1aaed2b6ba]
      x86_64/clone.S:111(clone)[0x7f1aad90e41d]
      

      Attachments

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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