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

Assertion `(mem_root->flags & 4) == 0' failed in main.ps_4heap main.ps_5merge main.ps_3innodb main.ps_2myisam with WITH_PROTECT_STATEMENT_MEMROOT=ON

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 11.6
    • N/A
    • Server
    • None

    Description

      In 11.6 10b885907a970d84f26373aec474202832201b71, but not 11.5. git bisect says the first bad commit is

      commit 36eba98817339f53cc57f1d4884ace3efb38db8d
      Author: Alexander Barkov <bar@mariadb.com>
      Date:   Tue May 28 09:08:51 2024 +0400
          MDEV-19123 Change default charset from latin1 to utf8mb4
          
          Changing the default server character set from latin1 to utf8mb4.
      

      trace (main.ps_3innodb):

       0 in __GI___assert_fail of ./assert/assert.c:101
       1 in alloc_root of /home/ycp/source/mariadb-server/11.6/src/mysys/my_alloc.c:275
       2 in Item::operator new of /home/ycp/source/mariadb-server/11.6/src/sql/item.h:862
       3 in Type_std_attributes::agg_item_set_converter of /home/ycp/source/mariadb-server/11.6/src/sql/item.cc:2736
       4 in Item_func_or_sum::agg_arg_charsets_for_comparison of /home/ycp/source/mariadb-server/11.6/src/sql/item.h:5673
       5 in Arg_comparator::set_cmp_func_string of /home/ycp/source/mariadb-server/11.6/src/sql/item_cmpfunc.cc:631
       6 in Type_handler_string_result::set_comparator_func of /home/ycp/source/mariadb-server/11.6/src/sql/sql_type.cc:4491
       7 in Arg_comparator::set_cmp_func of /home/ycp/source/mariadb-server/11.6/src/sql/item_cmpfunc.cc:564
       8 in Arg_comparator::set_cmp_func of /home/ycp/source/mariadb-server/11.6/src/sql/item_cmpfunc.h:104
       9 in Item_bool_rowready_func2::fix_length_and_dec_generic of /home/ycp/source/mariadb-server/11.6/src/sql/item_cmpfunc.h:584
      10 in Type_handler::Item_bool_rowready_func2_fix_length_and_dec of /home/ycp/source/mariadb-server/11.6/src/sql/sql_type.cc:5822
      11 in Item_bool_rowready_func2::fix_length_and_dec of /home/ycp/source/mariadb-server/11.6/src/sql/item_cmpfunc.cc:531
      12 in Item_func::fix_fields of /home/ycp/source/mariadb-server/11.6/src/sql/item_func.cc:370
      13 in Item::fix_fields_if_needed of /home/ycp/source/mariadb-server/11.6/src/sql/item.h:1167
      14 in Item::fix_fields_if_needed_for_scalar of /home/ycp/source/mariadb-server/11.6/src/sql/item.h:1176
      15 in Item::fix_fields_if_needed_for_bool of /home/ycp/source/mariadb-server/11.6/src/sql/item.h:1180
      16 in setup_conds of /home/ycp/source/mariadb-server/11.6/src/sql/sql_base.cc:8923
      17 in setup_without_group of /home/ycp/source/mariadb-server/11.6/src/sql/sql_select.cc:952
      18 in JOIN::prepare of /home/ycp/source/mariadb-server/11.6/src/sql/sql_select.cc:1574
      19 in Sql_cmd_delete::prepare_inner of /home/ycp/source/mariadb-server/11.6/src/sql/sql_delete.cc:1748
      20 in Sql_cmd_dml::prepare of /home/ycp/source/mariadb-server/11.6/src/sql/sql_select.cc:33706
      21 in Sql_cmd_dml::execute of /home/ycp/source/mariadb-server/11.6/src/sql/sql_select.cc:33759
      22 in mysql_execute_command of /home/ycp/source/mariadb-server/11.6/src/sql/sql_parse.cc:4403
      23 in Prepared_statement::execute of /home/ycp/source/mariadb-server/11.6/src/sql/sql_prepare.cc:5050
      24 in Prepared_statement::execute_loop of /home/ycp/source/mariadb-server/11.6/src/sql/sql_prepare.cc:4427
      25 in mysql_sql_stmt_execute of /home/ycp/source/mariadb-server/11.6/src/sql/sql_prepare.cc:3446
      26 in mysql_execute_command of /home/ycp/source/mariadb-server/11.6/src/sql/sql_parse.cc:3970
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ycp Yuchen Pei
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.