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

Segmentation fault

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Optimizer
    • None
    • Can result in hang or crash

    Description

      Issue:
      ---------
      Signal 11 seen while testing MDEV-39014

      Version:

      ----------------
      Branch : 13.2-mdev-39014-full-join-p2
      commit : 95ab071bead67a564f7a8fbcb0a6fc3b377efbe2
      Version : 13.0.1

      How to Repro:

      ---------------

      create table t1(pk int not null,primary key(pk));
      create table t2(pk int);
      SELECT t1.pk FROM ( t1 FULL JOIN t2 ON (1 ) ) WHERE ( EXISTS ( SELECT t2.pk FROM ( t1 RIGHT JOIN t2  ON (t2.pk = t1.pk ) ) ) ) ;
      

      Stack trace:

      #0  __pthread_kill_implementation (no_tid=0, signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=11) at ./nptl/pthread_kill.c:89
      #3  my_write_core (sig=11) at /home/ppandith/wl-39014/mysys/stacktrace.c:424
      #4  handle_fatal_signal (sig=11) at /home/ppandith/wl-39014/sql/signal_handler.cc:298
      #5  <signal handler called>
      #6  alloc_full_join_duplicate_filters (join=, start_tab=, count=2) at /home/ppandith/wl-39014/sql/sql_select.cc:24934
      #7  do_select (join=, procedure=) at /home/ppandith/wl-39014/sql/sql_select.cc:25101
      #8  JOIN::exec_inner (this=) at /home/ppandith/wl-39014/sql/sql_select.cc:5244
      #9  JOIN::exec (this=) at /home/ppandith/wl-39014/sql/sql_select.cc:5032
      #10 subselect_single_select_engine::exec (this=) at /home/ppandith/wl-39014/sql/item_subselect.cc:4201
      #11 Item_subselect::exec (this=) at /home/ppandith/wl-39014/sql/item_subselect.cc:813
      #12 Item_exists_subselect::val_bool (this=) at /home/ppandith/wl-39014/sql/item_subselect.cc:1918
      #13 Item_in_optimizer::val_bool (this=) at /home/ppandith/wl-39014/sql/item_cmpfunc.cc:1714
      #14 Item::eval_const_cond (this=) at /home/ppandith/wl-39014/sql/item.h:1742
      #15 Item::remove_eq_conds (this=, thd=, cond_value=, top_level_arg=true) at /home/ppandith/wl-39014/sql/sql_select.cc:22106
      #16 optimize_cond (join=, conds=, join_list=, ignore_on_conds=false, cond_value=, cond_equal=, flags=1)
          at /home/ppandith/wl-39014/sql/sql_select.cc:21648
      #17 JOIN::optimize_inner (this=) at /home/ppandith/wl-39014/sql/sql_select.cc:2597
      #18 JOIN::optimize (this=) at /home/ppandith/wl-39014/sql/sql_select.cc:2132
      #19 mysql_select (thd=, tables=, fields=..., conds=, og_num=0, order=, group=, having=, proc_param=, select_options=2164525824, 
          result=, unit=, select_lex=) at /home/ppandith/wl-39014/sql/sql_select.cc:5544
      #20 handle_select (thd=, lex=, result=, setup_tables_done_option=0) at /home/ppandith/wl-39014/sql/sql_select.cc:752
      #21 execute_sqlcom_select (thd=, all_tables=) at /home/ppandith/wl-39014/sql/sql_parse.cc:6213
      #22 mysql_execute_command (thd=, is_called_from_prepared_stmt=false) at /home/ppandith/wl-39014/sql/sql_parse.cc:3989
      #23 mysql_parse (thd=, 
          rawbuf="SELECT t1.pk FROM ( t1 FULL JOIN t2 ON (1 ) ) WHERE ( EXISTS ( SELECT t2.pk FROM ( t1 RIGHT JOIN t2  ON (t2.pk = t1.pk ) ) ) )", length=126, parser_state=) at /home/ppandith/wl-39014/sql/sql_parse.cc:7941
      #24 dispatch_command (command=COM_QUERY, thd=, 
          packet="SELECT t1.pk FROM ( t1 FULL JOIN t2 ON (1 ) ) WHERE ( EXISTS ( SELECT t2.pk FROM ( t1 RIGHT JOIN t2  ON (t2.pk = t1.pk ) ) ) )", packet_length=126, blocking=true) at /home/ppandith/wl-39014/sql/sql_parse.cc:1898
      #25 do_command (thd=, blocking=true) at /home/ppandith/wl-39014/sql/sql_parse.cc:1432
      #26 do_handle_one_connection (connect=, put_in_cache=true) at /home/ppandith/wl-39014/sql/sql_connect.cc:1503
      #27 handle_one_connection (arg=) at /home/ppandith/wl-39014/sql/sql_connect.cc:1415
      #28 pfs_spawn_thread (arg=) at /home/ppandith/wl-39014/storage/perfschema/pfs.cc:2198
      #29 start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      #30 clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Attachments

        Issue Links

          Activity

            People

              Gosselin Dave Gosselin
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.