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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4(EOL), 10.5
    • N/A
    • N/A

    Description

      create procedure sp() select 1 procedure analyse((select 1),100);
      

      10.5 ccbe6bb6fc3cbe31e744

      mariadbd: /10.5/sql/sp_head.cc:878: virtual sp_head::~sp_head(): Assertion `m_thd == __null' failed.
      200922 16:33:40 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.5.6-MariaDB-debug-log
       
      linux/raise.c:51(__GI_raise)[0x7fa7652947bb]
      stdlib/abort.c:81(__GI_abort)[0x7fa76527f535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fa76527f40f]
      ??:0(__assert_fail)[0x7fa76528d102]
      sql/sp_head.cc:880(sp_head::~sp_head())[0x55931e304b1c]
      sql/sp_head.cc:521(sp_head::destroy(sp_head*))[0x55931e302fa4]
      sql/sql_lex.cc:1355(lex_end_stage1(LEX*))[0x55931e3c5e85]
      sql/sql_lex.cc:1326(lex_end(LEX*))[0x55931e3c5d11]
      sql/sql_class.cc:3850(THD::end_statement())[0x55931e38c482]
      sql/sql_parse.cc:8017(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55931e40f894]
      sql/sql_parse.cc:1870(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55931e3fbb1b]
      sql/sql_parse.cc:1348(do_command(THD*))[0x55931e3fa251]
      sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55931e59f665]
      sql/sql_connect.cc:1314(handle_one_connection)[0x55931e59f3ce]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55931eadb8cd]
      nptl/pthread_create.c:487(start_thread)[0x7fa765d4dfa3]
      x86_64/clone.S:97(clone)[0x7fa7653564cf]
       
      Query (0x7fa744014040): create procedure sp() select 1 procedure analyse((select 1),100)
      
      

      non-debug returns error "PROCEDURE does not support subqueries or stored functions"

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              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.