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

Assertion failure in Diagnostics_area::set_error_status / Reprepare_observer::report_error

Details

    Description

      CREATE TABLE t (a INT);
      		 
      PREPARE stmt FROM " DELETE FROM t LIMIT ?";
      		 
      ALTER TABLE t FORCE;
      		 
      EXECUTE stmt USING DEFAULT;
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t;

      10.3 0ca3aaa7

      		 
      /src/sql/sql_error.cc:445: void Diagnostics_area::set_error_status(uint, const char*, const char*, const Sql_user_condition_identity&, const Sql_condition*): Assertion `! is_set() || m_can_overwrite_status' failed.
      		 
       
      		 
      #7  0x00007fb215bde662 in __GI___assert_fail (assertion=0x5633e9349be0 "! is_set() || m_can_overwrite_status", file=0x5633e9349540 "/src/sql/sql_error.cc", line=445, function=0x5633e9349c40 "void Diagnostics_area::set_error_status(uint, const char*, const char*, const Sql_user_condition_identity&, const Sql_condition*)") at assert.c:101
      		 
      #8  0x00005633e767136c in Diagnostics_area::set_error_status (this=0x62a0000657e8, sql_errno=1615, message=0x5633e9650c20 "Prepared statement needs to be re-prepared", sqlstate=0x5633e93c6cc0 "HY000", ucid=..., error_condition=0x0) at /src/sql/sql_error.cc:445
      		 
      #9  0x00005633e76710ef in Diagnostics_area::set_error_status (this=0x62a0000657e8, sql_errno=1615) at /src/sql/sql_error.cc:407
      		 
      #10 0x00005633e778a807 in Reprepare_observer::report_error (this=0x7fb20aff7ce0, thd=0x62a000060208) at /src/sql/sql_prepare.cc:3882
      		 
      #11 0x00005633e75b8cd9 in check_and_update_table_version (thd=0x62a000060208, tables=0x62b000032af0, table_share=0x61a000017aa8) at /src/sql/sql_base.cc:2745
      		 
      #12 0x00005633e75bd862 in open_and_process_table (thd=0x62a000060208, tables=0x62b000032af0, counter=0x7fb20aff5640, flags=0, prelocking_strategy=0x7fb20aff5750, has_prelocking_list=false, ot_ctx=0x7fb20aff5530) at /src/sql/sql_base.cc:3795
      		 
      #13 0x00005633e75bf936 in open_tables (thd=0x62a000060208, options=..., start=0x7fb20aff5650, counter=0x7fb20aff5640, flags=0, prelocking_strategy=0x7fb20aff5750) at /src/sql/sql_base.cc:4208
      		 
      #14 0x00005633e75c48ed in open_and_lock_tables (thd=0x62a000060208, options=..., tables=0x62b000032af0, derived=true, flags=0, prelocking_strategy=0x7fb20aff5750) at /src/sql/sql_base.cc:5148
      		 
      #15 0x00005633e752b967 in open_and_lock_tables (thd=0x62a000060208, tables=0x62b000032af0, derived=true, flags=0) at /src/sql/sql_base.h:503
      		 
      #16 0x00005633e82bc348 in mysql_delete (thd=0x62a000060208, table_list=0x62b000032af0, conds=0x0, order_list=0x62b000031d30, limit=0, options=0, result=0x0) at /src/sql/sql_delete.cc:303
      		 
      #17 0x00005633e772cfdc in mysql_execute_command (thd=0x62a000060208) at /src/sql/sql_parse.cc:4708
      		 
      #18 0x00005633e779338a in Prepared_statement::execute (this=0x619000081188, expanded_query=0x7fb20aff7d80, open_cursor=false) at /src/sql/sql_prepare.cc:5029
      		 
      #19 0x00005633e778e7ef in Prepared_statement::execute_loop (this=0x619000081188, expanded_query=0x7fb20aff7d80, open_cursor=false, packet=0x0, packet_end=0x0) at /src/sql/sql_prepare.cc:4457
      		 
      #20 0x00005633e77889dc in mysql_sql_stmt_execute (thd=0x62a000060208) at /src/sql/sql_prepare.cc:3545
      		 
      #21 0x00005633e7727717 in mysql_execute_command (thd=0x62a000060208) at /src/sql/sql_parse.cc:3887
      		 
      #22 0x00005633e7742efe in mysql_parse (thd=0x62a000060208, rawbuf=0x62b000000228 "EXECUTE stmt USING DEFAULT", length=26, parser_state=0x7fb20aff9950, is_com_multi=false, is_next_command=false) at /src/sql/sql_parse.cc:7855
      		 
      #23 0x00005633e771a59c in dispatch_command (command=COM_QUERY, thd=0x62a000060208, packet=0x6290000eb209 "EXECUTE stmt USING DEFAULT", packet_length=26, is_com_multi=false, is_next_command=false) at /src/sql/sql_parse.cc:1852
      		 
      #24 0x00005633e7717154 in do_command (thd=0x62a000060208) at /src/sql/sql_parse.cc:1398
      		 
      #25 0x00005633e7adaf88 in do_handle_one_connection (connect=0x608000000ca8) at /src/sql/sql_connect.cc:1404
      		 
      #26 0x00005633e7ada884 in handle_one_connection (arg=0x608000000ca8) at /src/sql/sql_connect.cc:1309
      		 
      #27 0x00005633e9088375 in pfs_spawn_thread (arg=0x615000004e08) at /src/storage/perfschema/pfs.cc:1869
      		 
      #28 0x00007fb215d89ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      		 
      #29 0x00007fb215ca9aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      Non-debug produces ER_INVALID_DEFAULT_PARAM

      query 'EXECUTE stmt USING DEFAULT' failed: 4032: Default/ignore value is not supported for such parameter usage

      Attachments

        Activity

          alice Alice Sherepa added a comment - 

           
          		 
          mysqld: /11.5/sql/sql_error.cc:457: void Diagnostics_area::set_error_status(uint, const char*, const char*, const Sql_user_condition_identity&, const Sql_condition*): Assertion `! is_set() || m_can_overwrite_status' failed.
          		 
          240923 18:09:26 [ERROR] mysqld got signal 6 ;
          		 
           
          		 
          Server version: 11.5.0-MariaDB-debug-log source revision: 08bd74e8860f473896b49ad7b42f4343de8dfc82
          		 
           
          		 
          intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f289af1840f]
          		 
          /lib/x86_64-linux-gnu/libc.so.6(+0x301a2)[0x7f289af261a2]
          		 
          sql/sql_error.cc:460(Diagnostics_area::set_error_status(unsigned int, char const*, char const*, Sql_user_condition_identity const&, Sql_condition const*))[0x555f7b2b2d94]
          		 
          sql/sql_error.cc:424(Diagnostics_area::set_error_status(unsigned int))[0x555f7b2b2b0f]
          		 
          sql/sql_prepare.cc:3818(Reprepare_observer::report_error(THD*))[0x555f7b4368ef]
          		 
          sql/sql_base.cc:3079(check_and_update_table_version(THD*, TABLE_LIST*, TABLE_SHARE*))[0x555f7b1dd6bb]
          		 
          sql/sql_base.cc:4223(open_and_process_table(THD*, TABLE_LIST*, unsigned int*, unsigned int, Prelocking_strategy*, bool, Open_table_context*))[0x555f7b1e34bf]
          		 
          sql/sql_base.cc:4654(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x555f7b1e5d2a]
          		 
          sql/sql_base.h:272(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x555f7b1cca3f]
          		 
          sql/sql_base.cc:5768(open_tables_for_query(THD*, TABLE_LIST*, unsigned int*, unsigned int, DML_prelocking_strategy*))[0x555f7b1ebc61]
          		 
          sql/sql_select.cc:33492(Sql_cmd_dml::prepare(THD*))[0x555f7b577848]
          		 
          sql/sql_select.cc:33554(Sql_cmd_dml::execute(THD*))[0x555f7b577b88]
          		 
          sql/sql_parse.cc:4392(mysql_execute_command(THD*, bool))[0x555f7b396488]
          		 
          sql/sp_instr.cc:956(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x555f7ba52573]
          		 
          sql/sp_instr.cc:296(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*, bool))[0x555f7ba4e4e7]
          		 
          sql/sp_instr.cc:476(sp_lex_keeper::validate_lex_and_exec_core(THD*, unsigned int*, bool, sp_lex_instr*))[0x555f7ba4f703]
          		 
          sql/sp_instr.cc:862(sp_instr_stmt::execute(THD*, unsigned int*))[0x555f7ba51cdc]
          		 
          sql/sp_head.cc:1286(sp_head::execute(THD*, bool))[0x555f7b1238bf]
          		 
          sql/sp_head.cc:1796(sp_head::execute_trigger(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_grant_info*))[0x555f7b126a04]
          		 
          sql/sql_trigger.cc:2525(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool))[0x555f7b6d7f56]
          		 
          sql/sql_base.cc:9235(fill_record_n_invoke_before_triggers(THD*, TABLE*, List<Item>&, List<Item>&, bool, trg_event_type))[0x555f7b201ff5]
          		 
          sql/sql_insert.cc:4280(select_insert::store_values(List<Item>&))[0x555f7b2e2b79]
          		 
          sql/sql_insert.cc:4217(select_insert::send_data(List<Item>&))[0x555f7b2e1fc0]
          		 
          sql/sql_class.h:6064(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x555f7b583701]
          		 
          sql/sql_select.cc:24911(end_send(JOIN*, st_join_table*, bool))[0x555f7b53a499]
          		 
          sql/sql_select.cc:23837(evaluate_join_record(JOIN*, st_join_table*, int))[0x555f7b5322e0]
          		 
          sql/sql_select.cc:32571(AGGR_OP::end_send())[0x555f7b572348]
          		 
          sql/sql_select.cc:23282(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x555f7b52f53e]
          		 
          sql/sql_select.cc:23537(sub_select(JOIN*, st_join_table*, bool))[0x555f7b53006d]
          		 
          sql/sql_select.cc:23117(do_select(JOIN*, Procedure*))[0x555f7b52e56b]
          		 
          sql/sql_select.cc:4988(JOIN::exec_inner())[0x555f7b4ad81f]
          		 
          sql/sql_select.cc:4774(JOIN::exec())[0x555f7b4aaca8]
          		 
          sql/sql_select.cc:5304(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*))[0x555f7b4af2b7]
          		 
          sql/sql_select.cc:630(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x555f7b47e72c]
          		 
          sql/sql_parse.cc:4598(mysql_execute_command(THD*, bool))[0x555f7b39854f]
          		 
          sql/sql_parse.cc:7815(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x555f7b3ae48c]
          		 
          sql/sql_parse.cc:1895(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x555f7b385e83]
          		 
          sql/sql_parse.cc:1406(do_command(THD*, bool))[0x555f7b382b41]
          		 
          sql/sql_connect.cc:1437(do_handle_one_connection(CONNECT*, bool))[0x555f7b856827]
          		 
          sql/sql_connect.cc:1341(handle_one_connection)[0x555f7b85617d]
          		 
          perfschema/pfs.cc:2203(pfs_spawn_thread)[0x555f7c551e5d]
          		 
          nptl/pthread_create.c:487(start_thread)[0x7f289b3e5fa3]
          		 
          x86_64/clone.S:97(clone)[0x7f289afef06f]
          		 
           
          		 
          Query (0x6250001ba9a8): UPDATE v1 SET `col_int_key` = 4

          alice Alice Sherepa added a comment -   mysqld: /11.5/sql/sql_error.cc:457: void Diagnostics_area::set_error_status(uint, const char*, const char*, const Sql_user_condition_identity&, const Sql_condition*): Assertion `! is_set() || m_can_overwrite_status' failed. 240923 18:09:26 [ERROR] mysqld got signal 6 ;   Server version: 11.5.0-MariaDB-debug-log source revision: 08bd74e8860f473896b49ad7b42f4343de8dfc82   intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f289af1840f] /lib/x86_64-linux-gnu/libc.so.6(+0x301a2)[0x7f289af261a2] sql/sql_error.cc:460(Diagnostics_area::set_error_status(unsigned int, char const*, char const*, Sql_user_condition_identity const&, Sql_condition const*))[0x555f7b2b2d94] sql/sql_error.cc:424(Diagnostics_area::set_error_status(unsigned int))[0x555f7b2b2b0f] sql/sql_prepare.cc:3818(Reprepare_observer::report_error(THD*))[0x555f7b4368ef] sql/sql_base.cc:3079(check_and_update_table_version(THD*, TABLE_LIST*, TABLE_SHARE*))[0x555f7b1dd6bb] sql/sql_base.cc:4223(open_and_process_table(THD*, TABLE_LIST*, unsigned int*, unsigned int, Prelocking_strategy*, bool, Open_table_context*))[0x555f7b1e34bf] sql/sql_base.cc:4654(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x555f7b1e5d2a] sql/sql_base.h:272(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x555f7b1cca3f] sql/sql_base.cc:5768(open_tables_for_query(THD*, TABLE_LIST*, unsigned int*, unsigned int, DML_prelocking_strategy*))[0x555f7b1ebc61] sql/sql_select.cc:33492(Sql_cmd_dml::prepare(THD*))[0x555f7b577848] sql/sql_select.cc:33554(Sql_cmd_dml::execute(THD*))[0x555f7b577b88] sql/sql_parse.cc:4392(mysql_execute_command(THD*, bool))[0x555f7b396488] sql/sp_instr.cc:956(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x555f7ba52573] sql/sp_instr.cc:296(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*, bool))[0x555f7ba4e4e7] sql/sp_instr.cc:476(sp_lex_keeper::validate_lex_and_exec_core(THD*, unsigned int*, bool, sp_lex_instr*))[0x555f7ba4f703] sql/sp_instr.cc:862(sp_instr_stmt::execute(THD*, unsigned int*))[0x555f7ba51cdc] sql/sp_head.cc:1286(sp_head::execute(THD*, bool))[0x555f7b1238bf] sql/sp_head.cc:1796(sp_head::execute_trigger(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_grant_info*))[0x555f7b126a04] sql/sql_trigger.cc:2525(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool))[0x555f7b6d7f56] sql/sql_base.cc:9235(fill_record_n_invoke_before_triggers(THD*, TABLE*, List<Item>&, List<Item>&, bool, trg_event_type))[0x555f7b201ff5] sql/sql_insert.cc:4280(select_insert::store_values(List<Item>&))[0x555f7b2e2b79] sql/sql_insert.cc:4217(select_insert::send_data(List<Item>&))[0x555f7b2e1fc0] sql/sql_class.h:6064(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x555f7b583701] sql/sql_select.cc:24911(end_send(JOIN*, st_join_table*, bool))[0x555f7b53a499] sql/sql_select.cc:23837(evaluate_join_record(JOIN*, st_join_table*, int))[0x555f7b5322e0] sql/sql_select.cc:32571(AGGR_OP::end_send())[0x555f7b572348] sql/sql_select.cc:23282(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x555f7b52f53e] sql/sql_select.cc:23537(sub_select(JOIN*, st_join_table*, bool))[0x555f7b53006d] sql/sql_select.cc:23117(do_select(JOIN*, Procedure*))[0x555f7b52e56b] sql/sql_select.cc:4988(JOIN::exec_inner())[0x555f7b4ad81f] sql/sql_select.cc:4774(JOIN::exec())[0x555f7b4aaca8] sql/sql_select.cc:5304(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*))[0x555f7b4af2b7] sql/sql_select.cc:630(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x555f7b47e72c] sql/sql_parse.cc:4598(mysql_execute_command(THD*, bool))[0x555f7b39854f] sql/sql_parse.cc:7815(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x555f7b3ae48c] sql/sql_parse.cc:1895(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x555f7b385e83] sql/sql_parse.cc:1406(do_command(THD*, bool))[0x555f7b382b41] sql/sql_connect.cc:1437(do_handle_one_connection(CONNECT*, bool))[0x555f7b856827] sql/sql_connect.cc:1341(handle_one_connection)[0x555f7b85617d] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x555f7c551e5d] nptl/pthread_create.c:487(start_thread)[0x7f289b3e5fa3] x86_64/clone.S:97(clone)[0x7f289afef06f]   Query (0x6250001ba9a8): UPDATE v1 SET `col_int_key` = 4

          People

            rucha174 Rucha Deodhar
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.