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

[Draft] Server crashes in cleanup_empty_jtbm_semi_joins on 2nd execution of SP

    XMLWordPrintable

Details

    Description

      10.3 f2c418079deff5fc0b460961094d8b833b4e30b4

      #3  <signal handler called>
      #4  0x00005636a71ce5c9 in cleanup_empty_jtbm_semi_joins (join=0x7f89945b5b40, join_list=0x7f89943217e0) at /home/travis/src/sql/opt_subselect.cc:5609
      #5  0x00005636a706c9f5 in JOIN::cleanup (this=0x7f89945b5b40, full=true) at /home/travis/src/sql/sql_select.cc:12749
      #6  0x00005636a7055733 in JOIN::destroy (this=0x7f89945b5b40) at /home/travis/src/sql/sql_select.cc:4035
      #7  0x00005636a70fdbe5 in st_select_lex::cleanup (this=0x7f8994321640) at /home/travis/src/sql/sql_union.cc:1952
      #8  0x00005636a7055db3 in mysql_select (thd=0x7f8994000c70, tables=0x7f89942c7a58, wild_num=0, fields=..., conds=0x7f8994327010, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903563520, result=0x7f8994328e60, unit=0x7f8994320ed0, select_lex=0x7f8994321640) at /home/travis/src/sql/sql_select.cc:4220
      #9  0x00005636a7047e53 in handle_select (thd=0x7f8994000c70, lex=0x7f8994320e08, result=0x7f8994328e60, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382
      #10 0x00005636a701282b in execute_sqlcom_select (thd=0x7f8994000c70, all_tables=0x7f89942c7a58) at /home/travis/src/sql/sql_parse.cc:6541
      #11 0x00005636a7008f45 in mysql_execute_command (thd=0x7f8994000c70) at /home/travis/src/sql/sql_parse.cc:3764
      #12 0x00005636a6f34fdc in sp_instr_stmt::exec_core (this=0x7f8994322ce8, thd=0x7f8994000c70, nextp=0x7f89f0d186c4) at /home/travis/src/sql/sp_head.cc:3593
      #13 0x00005636a6f34441 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f8994322d38, thd=0x7f8994000c70, nextp=0x7f89f0d186c4, open_tables=false, instr=0x7f8994322ce8) at /home/travis/src/sql/sp_head.cc:3321
      #14 0x00005636a6f34bc2 in sp_instr_stmt::execute (this=0x7f8994322ce8, thd=0x7f8994000c70, nextp=0x7f89f0d186c4) at /home/travis/src/sql/sp_head.cc:3499
      #15 0x00005636a6f2e9ba in sp_head::execute (this=0x7f89942c69e8, thd=0x7f8994000c70, merge_da_on_success=true) at /home/travis/src/sql/sp_head.cc:1353
      #16 0x00005636a6f31355 in sp_head::execute_procedure (this=0x7f89942c69e8, thd=0x7f8994000c70, args=0x7f8994005880) at /home/travis/src/sql/sp_head.cc:2293
      #17 0x00005636a700697d in do_execute_sp (thd=0x7f8994000c70, sp=0x7f89942c69e8) at /home/travis/src/sql/sql_parse.cc:2945
      #18 0x00005636a70074f2 in Sql_cmd_call::execute (this=0x7f8994013b88, thd=0x7f8994000c70) at /home/travis/src/sql/sql_parse.cc:3187
      #19 0x00005636a7011719 in mysql_execute_command (thd=0x7f8994000c70) at /home/travis/src/sql/sql_parse.cc:6279
      #20 0x00005636a701673a in mysql_parse (thd=0x7f8994000c70, rawbuf=0x7f8994013a18 "CALL stored_proc_23496 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 61671 CON_ID 15 */", length=88, parser_state=0x7f89f0d1a600, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8076
      #21 0x00005636a7003a4f in dispatch_command (command=COM_QUERY, thd=0x7f8994000c70, packet=0x7f899400b251 "CALL stored_proc_23496 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 61671 CON_ID 15 */ ", packet_length=89, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1847
      #22 0x00005636a7002480 in do_command (thd=0x7f8994000c70) at /home/travis/src/sql/sql_parse.cc:1392
      #23 0x00005636a71689d7 in do_handle_one_connection (connect=0x5636aa228530) at /home/travis/src/sql/sql_connect.cc:1402
      #24 0x00005636a716875b in handle_one_connection (arg=0x5636aa228530) at /home/travis/src/sql/sql_connect.cc:1308
      #25 0x00007f89f4f95184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #26 0x00007f89f44a1ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      travis-workarounds c1710043b35269d4bae46f892bfccc02cd7cf2e2

      perl /home/travis/rqg/runall-new.pl --vardir=/home/travis/logs/vardir --basedir=/home/travis/server --duration=350 --threads=6 --seed=1529134669 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/replication/replication.yy --gendata=conf/replication/replication-5.1.zz --skip-gendata --gendata-advanced --vcols --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice
      

      Not reproducible so far.
      Stack traces are attached.
      Coredump, datadir etc. are available.

      Attachments

        1. test_case.sql
          0.6 kB
        2. threads
          53 kB
        3. threads_full
          137 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.