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

Server crashes in Time_and_counter_tracker::incr_loops

Details

    • 10.2.11

    Description

      CREATE TABLE t1 (i INT);
      CREATE VIEW v1 AS SELECT * FROM t1 WHERE RAND() > 0.5;
      CREATE FUNCTION f1() RETURNS INT RETURN ( SELECT MAX(i) FROM v1 );
       
      --error ER_NON_INSERTABLE_TABLE
      REPLACE INTO v1 VALUES (f1());
      SET @aux = f1();
       
      # Cleanup
      DROP FUNCTION f1;
      DROP VIEW v1;
      DROP TABLE t1;
      

      10.1 e3dee8376885

      #3  <signal handler called>
      #4  0x00005557badb33f2 in Time_and_counter_tracker::incr_loops (this=0x78) at /data/src/10.1/sql/sql_analyze_stmt.h:97
      #5  0x00005557bad76425 in JOIN::exec (this=0x7f1acda67848) at /data/src/10.1/sql/sql_select.cc:2510
      #6  0x00005557bb01ea20 in subselect_single_select_engine::exec (this=0x7f1acd9d5600) at /data/src/10.1/sql/item_subselect.cc:3842
      #7  0x00005557bb01497f in Item_subselect::exec (this=0x7f1acd9d54f0) at /data/src/10.1/sql/item_subselect.cc:711
      #8  0x00005557bb0163df in Item_singlerow_subselect::val_int (this=0x7f1acd9d54f0) at /data/src/10.1/sql/item_subselect.cc:1309
      #9  0x00005557baf92cab in Item::save_in_field (this=0x7f1acd9d54f0, field=0x7f1acd847048, no_conversions=false) at /data/src/10.1/sql/item.cc:6070
      #10 0x00005557bb0bd586 in sp_eval_expr (thd=0x7f1acf4d5070, result_field=0x7f1acd847048, expr_item_ptr=0x7f1acd9d5670) at /data/src/10.1/sql/sp_head.cc:449
      #11 0x00005557bb0c9f17 in sp_rcontext::set_return_value (this=0x7f1acd9e0088, thd=0x7f1acf4d5070, return_value_item=0x7f1acd9d5670) at /data/src/10.1/sql/sp_rcontext.cc:154
      #12 0x00005557bb0c4d32 in sp_instr_freturn::exec_core (this=0x7f1acd9d5640, thd=0x7f1acf4d5070, nextp=0x7f1ad88c81f4) at /data/src/10.1/sql/sp_head.cc:3540
      #13 0x00005557bb0c38d0 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f1acd9d5680, thd=0x7f1acf4d5070, nextp=0x7f1ad88c81f4, open_tables=true, instr=0x7f1acd9d5640) at /data/src/10.1/sql/sp_head.cc:2996
      #14 0x00005557bb0c4cad in sp_instr_freturn::execute (this=0x7f1acd9d5640, thd=0x7f1acf4d5070, nextp=0x7f1ad88c81f4) at /data/src/10.1/sql/sp_head.cc:3510
      #15 0x00005557bb0bf726 in sp_head::execute (this=0x7f1acd9ce088, thd=0x7f1acf4d5070, merge_da_on_success=true) at /data/src/10.1/sql/sp_head.cc:1316
      #16 0x00005557bb0c09f4 in sp_head::execute_function (this=0x7f1acd9ce088, thd=0x7f1acf4d5070, argp=0x0, argcount=0, return_value_fld=0x7f1acd847048) at /data/src/10.1/sql/sp_head.cc:1857
      #17 0x00005557bafea5b1 in Item_func_sp::execute_impl (this=0x7f1acd843338, thd=0x7f1acf4d5070) at /data/src/10.1/sql/item_func.cc:6712
      #18 0x00005557bafea340 in Item_func_sp::execute (this=0x7f1acd843338) at /data/src/10.1/sql/item_func.cc:6645
      #19 0x00005557bafed874 in Item_func_sp::val_int (this=0x7f1acd843338) at /data/src/10.1/sql/item_func.h:2130
      #20 0x00005557bafe54c1 in Item_func_set_user_var::check (this=0x7f1acd8444d8, use_result_field=false) at /data/src/10.1/sql/item_func.cc:5058
      #21 0x00005557bac8836d in set_var_user::check (this=0x7f1acd844938, thd=0x7f1acf4d5070) at /data/src/10.1/sql/set_var.cc:830
      #22 0x00005557bac87d21 in sql_set_variables (thd=0x7f1acf4d5070, var_list=0x7f1acf4d9828, free=true) at /data/src/10.1/sql/set_var.cc:689
      #23 0x00005557bad3967e in mysql_execute_command (thd=0x7f1acf4d5070) at /data/src/10.1/sql/sql_parse.cc:4323
      #24 0x00005557bad429cb in mysql_parse (thd=0x7f1acf4d5070, rawbuf=0x7f1acd843088 "SET @aux = f1()", length=15, parser_state=0x7f1ad88c95e0) at /data/src/10.1/sql/sql_parse.cc:7333
      #25 0x00005557bad315d0 in dispatch_command (command=COM_QUERY, thd=0x7f1acf4d5070, packet=0x7f1ad1ff9071 "SET @aux = f1()", packet_length=15) at /data/src/10.1/sql/sql_parse.cc:1484
      #26 0x00005557bad3036d in do_command (thd=0x7f1acf4d5070) at /data/src/10.1/sql/sql_parse.cc:1106
      #27 0x00005557bae68dd1 in do_handle_one_connection (thd_arg=0x7f1acf4d5070) at /data/src/10.1/sql/sql_connect.cc:1349
      #28 0x00005557bae68b35 in handle_one_connection (arg=0x7f1acf4d5070) at /data/src/10.1/sql/sql_connect.cc:1261
      #29 0x00005557bb221654 in pfs_spawn_thread (arg=0x7f1ad5c39ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1860
      #30 0x00007f1ad8549494 in start_thread (arg=0x7f1ad88cab00) at pthread_create.c:333
      #31 0x00007f1ad669493f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Reproducible on debug and release builds of 10.1 and 10.2, including older 10.1 releases.
      Not reproducible on 10.0.

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Oleksandr Byelkin made transition -
            Open In Progress
            39d 1h 2m 1
            Oleksandr Byelkin made transition -
            In Progress Stalled
            2h 48m 1
            Oleksandr Byelkin made transition -
            Stalled In Review
            1m 22s 1
            Oleksandr Byelkin made transition -
            Stalled In Progress
            5d 20h 40m 1
            Oleksandr Byelkin made transition -
            In Progress In Review
            1h 24m 1
            Alexander Barkov made transition -
            In Review Stalled
            1d 19h 41m 2
            Oleksandr Byelkin made transition -
            Stalled Closed
            14m 23s 1

            People

              sanja Oleksandr Byelkin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.