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

Server crashes in Query_arena::set_query_arena upon CREATE VIEW

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
    • 10.5, 10.6
    • Server, Views
    • None

    Description

      CREATE TABLE t1 (a INT, b BLOB DEFAULT '');
      CREATE VIEW v1 AS SELECT * FROM t1;
      CREATE VIEW v2 AS SELECT DEFAULT(b) && a FROM v1;
       
      # Cleanup
      DROP VIEW v2, v1;
      DROP TABLE t1;
      

      10.2 7331c661d

      #3  <signal handler called>
      #4  0x000055f56c562b32 in Query_arena::set_query_arena (this=0x7f4ec0000b18, set=0x0) at /data/src/10.2/sql/sql_class.cc:3485
      #5  0x000055f56c562f77 in THD::set_n_backup_active_arena (this=0x7f4ec0000b00, set=0x0, backup=0x7f4ed1586ed0) at /data/src/10.2/sql/sql_class.cc:3574
      #6  0x000055f56c7f17dd in Field::set_default (this=0x7f4ec0016e40) at /data/src/10.2/sql/field.cc:2356
      #7  0x000055f56c84d4b8 in Item_default_value::calculate (this=0x7f4ec0012c70) at /data/src/10.2/sql/item.cc:8916
      #8  0x000055f56c84d578 in Item_default_value::val_int (this=0x7f4ec0012c70) at /data/src/10.2/sql/item.cc:8934
      #9  0x000055f56c86b91c in Item_cond::fix_fields (this=0x7f4ec0012e70, thd=0x7f4ec0000b00, ref=0x7f4ec0012fa8) at /data/src/10.2/sql/item_cmpfunc.cc:4619
      #10 0x000055f56c53f4ef in setup_fields (thd=0x7f4ec0000b00, ref_pointer_array=..., fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x7f4ec0016218, pre_fix=0x7f4ec0004f58, allow_sum_func=true) at /data/src/10.2/sql/sql_base.cc:7160
      #11 0x000055f56c5e6f4d in JOIN::prepare (this=0x7f4ec0015ef8, tables_init=0x7f4ec0013018, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f4ec0004e18, unit_arg=0x7f4ec00046e0) at /data/src/10.2/sql/sql_select.cc:814
      #12 0x000055f56c68f7d0 in st_select_lex_unit::prepare (this=0x7f4ec00046e0, thd_arg=0x7f4ec0000b00, sel_result=0x0, additional_options=0) at /data/src/10.2/sql/sql_union.cc:598
      #13 0x000055f56c69ce9a in mysql_create_view (thd=0x7f4ec0000b00, views=0x7f4ec0012558, mode=VIEW_CREATE_NEW) at /data/src/10.2/sql/sql_view.cc:534
      #14 0x000055f56c5af6a8 in mysql_execute_command (thd=0x7f4ec0000b00) at /data/src/10.2/sql/sql_parse.cc:6052
      #15 0x000055f56c5b4f51 in mysql_parse (thd=0x7f4ec0000b00, rawbuf=0x7f4ec0012448 "CREATE VIEW v2 AS SELECT DEFAULT(b) && a FROM v1", length=48, parser_state=0x7f4ed1588200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8015
      #16 0x000055f56c5a288b in dispatch_command (command=COM_QUERY, thd=0x7f4ec0000b00, packet=0x7f4ec008c471 "CREATE VIEW v2 AS SELECT DEFAULT(b) && a FROM v1", packet_length=48, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1826
      #17 0x000055f56c5a11e2 in do_command (thd=0x7f4ec0000b00) at /data/src/10.2/sql/sql_parse.cc:1379
      #18 0x000055f56c6f3ccd in do_handle_one_connection (connect=0x55f56ef059e0) at /data/src/10.2/sql/sql_connect.cc:1335
      #19 0x000055f56c6f3a5a in handle_one_connection (arg=0x55f56ef059e0) at /data/src/10.2/sql/sql_connect.cc:1241
      #20 0x000055f56cb1997c in pfs_spawn_thread (arg=0x55f56ee69050) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #21 0x00007f4ed8f83494 in start_thread (arg=0x7f4ed1589700) at pthread_create.c:333
      #22 0x00007f4ed736993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      All of debug, non-debug and ASAN builds fail with SIGSEGV.
      Reproducible with at least MyISAM, Aria, InnoDB.
      Not reproducible on 10.1.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

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