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

Assertion `thd->active_stmt_arena_to_use()-> is_stmt_prepare_or_first_stmt_execute() || thd->active_stmt_arena_to_use()-> is_conventional() || thd->active_stmt_arena_to_use()->state == Query_arena::STMT_SP_QUERY_ARGUMENTS' failed

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (id char(10) ) DEFAULT CHARSET=utf8;
      insert into t1 values (1),(2);
       
      prepare stmt from "SELECT group_concat(@a := NULL, 1) FROM t1 WHERE @a := id GROUP BY (@a := 0) ;";
       
      execute stmt;
      execute stmt;
      

      mariadbd: /11.6/src/sql/item_sum.cc:4310: virtual bool Item_func_group_concat::fix_fields(THD*, Item**): Assertion `thd->active_stmt_arena_to_use()-> is_stmt_prepare_or_first_stmt_execute() || thd->active_stmt_arena_to_use()-> is_conventional() || thd->active_stmt_arena_to_use()->state == Query_arena::STMT_SP_QUERY_ARGUMENTS' failed.
      240913 18:09:43 [ERROR] mysqld got signal 6 ;
       
      Server version: 11.6.2-MariaDB-debug-log source revision: 19cea738342737503f47cfe6ff67d5248b0a0961
       
      sql/item_sum.cc:4316(Item_func_group_concat::fix_fields(THD*, Item**))[0x556ea8f021a7]
      sql/item.h:1167(Item::fix_fields_if_needed(THD*, Item**))[0x556ea7f72621]
      sql/item.h:1176(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x556ea7f7265b]
      sql/sql_base.cc:8096(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool))[0x556ea809f99c]
      sql/sql_select.cc:1567(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x556ea8341aaa]
      sql/sql_select.cc:5320(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x556ea836987c]
      sql/sql_select.cc:628(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x556ea833814c]
      sql/sql_parse.cc:6154(execute_sqlcom_select(THD*, TABLE_LIST*))[0x556ea8256ada]
      sql/sql_parse.cc:3954(mysql_execute_command(THD*, bool))[0x556ea82468e3]
      sql/sql_prepare.cc:5050(Prepared_statement::execute(String*, bool))[0x556ea82f8247]
      sql/sql_prepare.cc:4427(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x556ea82f2fec]
      sql/sql_prepare.cc:3447(mysql_sql_stmt_execute(THD*))[0x556ea82ec120]
      sql/sql_parse.cc:3971(mysql_execute_command(THD*, bool))[0x556ea8246928]
      sql/sql_parse.cc:7876(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556ea8261ee0]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556ea8238839]
      sql/sql_parse.cc:1405(do_command(THD*, bool))[0x556ea823555a]
      sql/sql_connect.cc:1448(do_handle_one_connection(CONNECT*, bool))[0x556ea8731816]
      sql/sql_connect.cc:1352(handle_one_connection)[0x556ea8731173]
      perfschema/pfs.cc:2200(pfs_spawn_thread)[0x556ea93e9e4c]
      nptl/pthread_create.c:478(start_thread)[0x7f7cf3baf609]
       
      Query (0x629000109340): SELECT group_concat(@a := NULL, 1) FROM t1 WHERE @a := id GROUP BY (@a := 0)
      

      Attachments

        Activity

          People

            shulga Dmitry Shulga
            alice Alice Sherepa
            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.